Search results

thanks, i didnt know that...i figured out the code to print all the pdf's...now i just need to populate the forms..would you like to see the code?

Hey Guys, I changed my code up a bit. Private Sub Form_Load() Dim strName As String Dim rs As DAO.Recordset Dim currentCount As String Dim totalCount As String Dim strPath As String Dim SQL As String Set rs = CurrentDb.OpenRecordset("DebtMasters")...

Still says compile error, loop without a do.

Same error, invalid use of the Me keyword. Then I used Forms!InvoicesDue!txtNameNo.RecordsetClone, and it gives me and error at the loop saying loop without do

It says invalid use Me key word.. Ho do I set the textbox value = to the field in the db? I used a DLOOKUP

Both of you I guess...That code creates the same file the whole time.

It creates the same name, so it just keeps overwriting the same file.

yes you are..thats exactly what i want..the reason I have the Name No in the docmd.outputto command is so that its uses the number in the textbox as the name for the pdf file. keeps creating the same pdf over and over again. It might work if I can get the text box to move to the next record...

yes, but it will do this for every name number that is displayd in the textbox. So basically i want a loop that wil get the first name number from the db, display it in the textbox and create a pdf, then get the second name number from the db, display it in the textbox and created a pdf...this...

Both these codes do exactly what mine original code did...it keeps creating a PDF for the current form using the name number in the Textbox..this is correct, but i need the textbox to display each name number in the db and create a pdf for each name number. So how do I get the textbox to...

Thanks alot for your help man, but I need to save more than one file. For every NameNo the should be a PDF created with the NameNo as the name of the PDF file

Hi All, I have a form where a textbox has shows the NameNo from the NameNo column in a db. At the moment Im using a dlookup to set the textbox = to the NameNo, but obviously this is only returning the 1st value in the column. Can anyone please assist me on how to get this form to automatically...

Hi, I am trying to automate a form to create a pdf file of the form, then move on to the next naqmeno in the db and do the same for it, until the end of the file. My DoCmd.OutputTo works when I dont have it in the loop. Since I have put it in the loop it gives me Run Time Error 2487 "The...