Search results
-
A
Creating a report from a drop down list
Yes I did see that in the help. But did not know where to insert or create a new event. But know I know I should insert. -
A
Creating a report from a drop down list
Changed the code and it worked. But I have a question. When I select the Reference and it creates the report it goes straight to the printer. I would like to preview the form. Private Sub ReferenceLookup_AfterUpdate() Dim stDocName As String Dim stLinkCriteria As String stDocName... -
A
Creating a report from a drop down list
I should have read it more carefully. So simple I will try that. -
A
Creating a report from a drop down list
This is the current code: Private Sub ReferenceLookup_AfterUpdate() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmShipping" stLinkCriteria = "[Reference]=" & "'" & Me![ReferenceLookup] & "'" DoCmd.Close acForm, "frmReferenceLookUp", acSaveNo... -
A
Creating a report from a drop down list
Hello All, I have a form and in that form I have a drop list and I would like to create a report to the from the reference I selected. Currently when I select the reference item it will pull up all forms with the reference that is selected (This works Great. What I would like to do is take this... -
A
Blank field no Information is displayed
Yes I want it to be currency. -
A
Blank field no Information is displayed
I know this is a simple question. I searched but could not find what I was looking for. Or it is handled in differently than what I am thinking. I have a field where I enter a dollar amount. But if I do not enter a dollar amount the field displays $0.00. How can I make this field blank if no... -
A
Link a text Box to the last modified date
I found this. Hope it helps http://office.microsoft.com/en-ca/assistance/HA010345351033.aspx -
A
Math Help
I like the ="Page " & INT(([ArtworkNumber]/24)+1) That seems to work ok but when I enter 24 into the ArtworkNumber the PageNumber display Page 2 it should be Page 1 same thing when you enter 48 it goes to Page 3 should be Page 2 when you enter 72 it goes to Page 4 should be Page 3 Goes to the... -
A
Math Help
I do not know why I would need to create a query or a macro. These are the only two fields on the form and they are unbound boxes. Field 1 name ArtworkNumber and the second field with the name of PageNumber. In the PageNumber field I entered =[ArtworkNumber]/24 but this is returning an... -
A
Math Help
Thank you for the info. I am trying to keep this pretty simple since I am some what new to access. I have field 1 with the name ArtworkNumber and the second field with the name of PageNumber What I am trying to make happen is I enter the artwork number in the ArtworkNumber field and it... -
A
Math Help
I have an artwork book which I am cataloging. Each page of the book contains 24 pices of artwork. What I need to do is display a page number to whatever record number I enter into the field. Example 2: I enter any record number from 1140 and the field will display 48 for the page the artwork is...