Ok so my text box that has the serial number is named "SerialNumber" and the form name is "DataBase". Not sure it these go where you have red or not. Sorry for being difficult.
Running Access 2007. Have a form that i would like to have a button that when clicked would save the record form to a PDF and use the unique serial number that is in one of the text boxes on the form as the file name. Not very good at macros. Thanks for any replies.
missinglinq,
I tried the RecordGoToNew instead of RecordGoToLast and when I ran it it would popup an error like the error when I tried SelectAll (see attachment). When I open my form there is 5 records showing at the bottom. 1-4 are records with data. Number 5 is a blank new record. If I add...
Thanks so much Trevor. You got me going in the right direction. I couldnt get the SelectAll to work. It kept giving me an error. So I was playing around with the different settings and came up with this for the first macro.
RunCommand (have set to SelectRecord)
RunCommand (have set to...
Ok so I looked in the macros and holy macro I have no clue what I am doing. I made a control button that duplicates the record into the same form. I thought I could go into to design mode, right click on the button and click build event. Was going to edit the button to do what I wanted but I...
I have one database called "Special Services Iron Database". On this database there are three forms. One is called "Special Services Iron Database", "PAST Iron Database" and "BLANK IRON SHEETS". I need to add a control button that when clicked on the "BLANK IRON SHEETS" form will copy the...