Forms :: Ordering Database - Field Not Printing?
Mar 24, 2015
I have an Ordering database where the order form contains a subform with the order lines (Order_line_subfrm). In this subform footer I have 4 currency fields, one f which is delivery fee (default is set to zero). When I add a fee into this field on screen, everything works (i.e. adds up) and the value is there to see. When I go to print the form (paper or PDF) the delivery fee returns to zero (the database entry is still present).
View Replies
ADVERTISEMENT
Dec 7, 2006
I have a memo field which records the events that happen on a form. So for example when a user changes the assignment from one user to the next, a row is written to the memo field indicating date, time, windows logon and then a brief description
Basically I end up with :
07/12/06 11:16:34 kleaves : Assigned user changed from Joe Bloggs to John Doe
At present every new row is added to the memo field at the end, so the most recent action is at the bottom.
How can I sort this so that most recent is at the top.
View 8 Replies
View Related
May 22, 2014
How to generate prescription order form, so that I can order 10 line items at a time. I have the following tables,
Suppliers
---------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No
Order Form Header
-----------------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No
Date
Order Items
-----------
OrderID
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty
Items
-----
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty
View 2 Replies
View Related
Mar 4, 2013
I have an .accde database that will not let my print button to work. How do I print from an .accde database?
View 2 Replies
View Related
Feb 16, 2005
Hello team,
My database window is hidden.
I have a form with data about an article. When I click a button, another form opens showing a sales graph of that article.
On the form with the graph, I have put another button to print it. The code behind that button is:
Private Sub printpriceevolution_Click()
On Error GoTo Err_printpriceevolution_Click
Dim stDocName As String
Dim MyForm As Form
stDocName = "frm_priceevolution"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False
Exit_printpriceevolution_Click:
Exit Sub
Err_printpriceevolution_Click:
MsgBox Err.Description
Resume Exit_printpriceevolution_Click
End Sub
The funny thing is that after the printing (which works fine) my database window is shown, where it is supposed to be hidden.
Any idea what could trigger this? Does it have to do with pop-up dialog box settings?
Thanks
View 1 Replies
View Related
Jul 20, 2015
I want to track inventory. All our items are tubes that are stored in boxes in a 10x10 grid. So I have a single access table with columns for tube ID, box ID, and position in the box (numbered 1-100). That works fine in terms of 'where can I find tube x'. However it's also useful to be able to look at the physical box & check that there are tubes where should be tubes, and empty spaces where there should be empty spaces. So for each box in the database, I want to print out a 10x10 grid, with the appropriate tube ID's in the appropriate place. Then I can easily check the layout in the database against the layout in the actual box.
View 14 Replies
View Related
Dec 8, 2005
i have a database with 3 main tabels: customers, items being sold and orders. i am having problems with having more than one item assigned to a order. can anyone help me please? i am new to access so if anyone can help can you explain in symple steps?
thanks
mooink
View 2 Replies
View Related
Feb 22, 2006
hello i have created an ordering sheet for my company. i want to know if it is possible to automatically record the time of each order made?
If possible could someone tell me how it is done?
Also is it possible to put a clock in an Access database?
Thanks
Sean
View 2 Replies
View Related
Feb 22, 2006
hello i have created an ordering sheet for my company. i want to know if it is possible to automatically record the time of each order made?
If possible could someone tell me how it is done?
Also is it possible to put a clock in an Access database?
Thanks
Sean
View 2 Replies
View Related
Nov 25, 2005
Is there a way of , when a database administrator enters a new rocord to a database, making the new record appear at th e top of the table it is enter ed into, i.e can he prefix the entry to tell access to put the record at the top of the table
View 1 Replies
View Related
Jul 25, 2007
Hello
I have a question on date order please see attachment. I have changed the numerical value into a date abbreviation with an iif statement in design view via another crosstab query.
I am now trying find out a way to start the data with April and ending with March for my financial year. Any help would be appreciated.
Thanks
View 2 Replies
View Related
May 12, 2005
I have a database containing music library data, with fields <Composer> and <Title>. I have a form that shows a these fields as lists, but I want to add a button at the top of each list to order the data by that field. How do I do it?
View 4 Replies
View Related
Jun 9, 2005
I think this may be impossible but I am hoping it isn't :)
Have any of come across a way to Manually order a continuous form.
The way I would see it working is to have a column in the table called sort_order and two buttons on the form called move up and move down. Once clicked the sort_order value would change thus changing the order on the form.
I should imagine it would be alot more complicated than my brief description, in fact it may like I said be impossible.
If any of you have an idea how to achieve this I will be very grateful
Cheers
Paul
View 4 Replies
View Related
Nov 4, 2006
I have actually 2 questions. They are probably very easy to solve, but I have no idea where to start looking.
1) I have a form (Form1) which has a combo box. When pressing "F2", I start a second form (Form2).
On Form2 I want my records order by Name, but I always have them ordered by ID. I tried the "Order By" property on the form, but that doesn't seem to work.
2) When closing the form, I want the selected (or the newly created record) to be the current record in the Combo box on Form1. How do I do that?
Thanks.
View 2 Replies
View Related
Feb 25, 2014
I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.
This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)
So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.
So all I had to do was say:
Code:
PrintMe("Invoice","InvoiceID",iID)
and a report would print to exactly how I wanted... but it's just too slow!
See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.
Code:
Function PrinterOK(sPrinterName As String) As Boolean
Dim MyPrinter As Printer
PrinterOK = False
For Each MyPrinter In Printers
If MyPrinter.DeviceName = sPrinterName Then
PrinterOK = True
Exit Function
End If
Next
End Function
I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.
View 1 Replies
View Related
Sep 6, 2014
How does one suppress printing of a field when the field contains a value (i.e. a date).
View 2 Replies
View Related
Jan 5, 2006
Hi everyone,
I have a field in a table on Access 2000 database with takes the following information in any order and can be repeated. e.g. can have 10, etc people with contact signed, 10, etc people with PDD issued, etc.
contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.
I am designing a report in which I want to Group and order the info. in the field in the order shown above, e.g 1. contract signed, then 2. PIN issued followed by PDD issued, etc in Ascending order say and the other way round say CER's issued, EB approved, etc.
Can anyone help here? I have not much experience with designing reports but I have tried using the report Sorting and Grouping and it does it in aphabetical order, not in that order I require.
Thank you
dfuas
View 10 Replies
View Related
Jan 23, 2007
I have used the following Query statement to produce a variable that appears in a Report column:
ValueInReportColumn: IIf([Number1]=0,"NA",Val(Format([AnotherQueryName].
[Number2],"Fixed")))
Although the The Val function reconverts the text, produced by the Format function, back into a number the IIf function seems to convert back to text again. This means that in the Report, when I order the values in descending order I get:
NA 50 50 50 40 28.57 14.29 100 10 0 ...
Is there anyway round this, to order the numbers and leave the text value NA at either end?! Hope this makes sense! Any help very welcome. mcchu
View 2 Replies
View Related
Dec 10, 2014
I have created a form with many companies. each companies have 4 events in one year,but the first event in the form is the last one. How can order this events in this form chronologically?
View 5 Replies
View Related
Jan 15, 2006
Not sure if this one is possible but here goes........
I have Acrobat Distiller 5.0 installed. Having set the default printer to this I can now print single forms (Screen dumps)straight to PDF using the command.
DoCmd.PrintOut me.currentview
What I would like to do, is on a click of a button, instead of just sending the one form to PDF which results in one PDF document, I would like to send several at once, resulting in still one PDF document but this time for it to contain all the screen dumps one after the other. (Each from a seperate form)
I'll explian why I'm trying this incase someone can think of an alternative. I have a Tabbed Form (Contains a dozen tabs) of which each tab contains a number of sub forms. Each subform is a query which produces a large amount of performance data from a main table.
I need to be able to present this data as a single report in written format.
As far as I'm aware, a report is not possible due to the number of queries / subforms being used (Unless someone can tell me how to pull the data from several continuous forms tied to different queries over to a report)
I tried using a single form containing all the data to print over to PDF but ran out of room before I hit for sixth tab.
Ideally, what I would like to do is send each of the tabs to a single PDF document. Failing that, I can set up a number of single forms and send them instead.
Any suggestions, either with the PDF or an alternative way
Thanks in anticipation of your help
View 1 Replies
View Related
Jul 20, 2005
Is this possible, if using the following:
SELECT DISTINCT (Format([Month],"mmm yyyy")) FROM Table;
Adding a ORDER BY [Month]; gives a "distinct and order by" conflict...
Is there any way to alleviate this?
I want to display a "mmm yyyy" formatted combobox in order (i.e. Jan 2005, Feb 2005, Mar 2005, etc...)
TIA!
View 7 Replies
View Related
Feb 24, 2005
Hi all,
I have a simple 2-table database. the 'parent' table is tblProducts, and the 'child' table is tblDocuments. (one [products] to many [docouments] relationship)
My data entry is done using a 'documents' subform inside a 'products' parent form. The data entry works fine, except i would really like it if my products and documents would be listed in alphabetical order in their respective form/subform {makes it easier on the user, and saves me needing a find record button}. At the moment they seem to be ordered by the time in which they were added to the table. I guess Access is using the primary Key as the 'order by' parameter.
The thing that is infuriating me is that i have gone into my two tables and told access to sort the data by Product Name, and Document name in the respective tables. I can verify that this has worked by going to data view; lo and behold the data are listed in the order i specified.
Further I have gone into my form and sub form properties, into the Data...Order By property and have keyed in the name of the field i want to sort by (product name in the parent form, and document name in the sub form).
I have tried all combinations and permutations of the above processes but nothing seems to work.
It seems i am missing one crucial piece to the puzzle, as i haven't had much luck finding a solution on groups.google or anything else (maybe im using the wrong search terms). I am having this problem with all of my databases, so any help would be appreciated.
Thanks in advance.
View 2 Replies
View Related
Aug 22, 2004
hey,
i have a page, with several drop down boxes, each containing quite a few options, but they dont show in alphabetical order so its a pain trying to find the one i want. how can i order them by alphabetical order,?
thanks
Baz
View 1 Replies
View Related
Jun 12, 2014
I have a small access 2010 system. The database design was not good (replication of data all over the place) so I have been tidying up the design but have hit a few problems.I am using a form which contains amongst other things a customer name. The customer name used to be part of the enquiry table, and was picked up directly from there. I have replaced this with the key to the customer table.The only way I have managed to pick the customer name up is to change the control from a text box to either a list box or a combo box. I then have to set column count to 2 set the widths to 0 and 3 to hide the 1st one (the ID) and then set the bound column to 2 to show the customer description.
This is fine up to a point BUT the format controls on the list/combo are different from the text box so I can't replicate the back style and back colour (I had transparent and no colour respectively); the back style has disappeared and how to make the back color as "no colour".Also I end up with 2 little up and down arrows (for the list box) or ma bigger arrow for the combo.
View 1 Replies
View Related
Mar 3, 2005
I am trying to print one record displayed in a form. I also need to print one record in another form at different times. I have one form working fine. It prints out the displayed record in my report just fine by clicking the Print_report button.
I copied the report and renamed it. in this form the print button is named Print_Requested. When I open this form and click the Print_Requested button, it prints out everything except for the data.
Edit:
The reason I made a duplicate report is because it was doing the same thing when I tried to print the same report from different forms. One report is all I need, but I need to be able to print it from different forms.
Here is my code:
-----------------------------
Private Sub Print_report_Click()
On Error GoTo Err_Print_report_Click
Dim stDocName As String
stDocName = "work_order_report"
DoCmd.OpenReport "work_order_report", , , "WOnumber = " & Me.WOnumber
Exit_Print_report_Click:
Exit Sub
Err_Print_report_Click:
MsgBox Err.Description
Resume Exit_Print_report_Click
End Sub
-----------------------------
Private Sub Print_Requested_Click()
On Error GoTo Err_Print_Requested_Click
Dim stDocName As String
stDocName = "work_order_report_requested"
DoCmd.OpenReport "work_order_report_requested", , , "WOnumber = " & Me.WOnumber
Exit_Print_Requested_Click:
Exit Sub
Err_Print_Requested_Click:
MsgBox Err.Description
Resume Exit_Print_Requested_Click
End Sub
----------------------------------
Any idea what I am doing wrong??
View 1 Replies
View Related
Nov 6, 2006
Hi, Ive read all I can on forums and web and am still unable to print the current forms report using a command buttons on click. This is the code i have been playing with:
Dim strDocName As String
Dim strWhere As String
strDocName = "Home_Oxygen_Report"
1. 'strWhere = "[general_info.HospitalNumber]= Me!Home_Oxygen_Form!general_info.HospitalNumber"
2. strWhere = "[general_info.HospitalNumber]= "" & Me![general_info.HospitalNumber] & """
3. 'strWhere "[general_info.HospitalNumber]='" & Me![general_info.HospitalNumber] & "'"
DoCmd.OpenReport strDocName, acViewPreview, , strWhere
Number 3 gives the closest result but it prompts me to enter the primary key when i hit the command button but i need it to do this automatically. The primary key is a text box not number. Note that the primary key is HospitalNumeber of Table general_info (form and reports record source is query of many tables).
any help would be muchly appreciated!!
Tania
View 3 Replies
View Related
