Search results

Hi, i have a failure in my computer and all vba code is lost in my access file and back up. All the new tables and forms are there. I have an older back up file but i don't know how to pull the full code from one file to the other? Can someone explain to me how to do it? I did try to export...

Yes, but was quite long. I did change the margins and it works. Thanks

and if I change acPreview to acNormal, then it prints the 250 records on the same pdf file

only see 1 page in the report preview

Hi, I just create a new report and use the following code to print in pdf. The problem is the pdf file show me 11 pages when I just need 1. For the record the 11 pages are the same page information repeated 11 times. I have 250 records in the database MyFileName = Me.AssemblyPartCode &...

Hi, an update. I did the reference to the same "recipe" worksheet and in the excel file I did the reference between the 2 worksheet and it worked. Maybe I did take the long way, but it works Thanks to everyone

Nothing, it doesn't show any value in any place.

Hi, I have the following part of my code If Dir(HMC_Path & Me.HMC_ID & " - " & HMC_Des & ".xlsx") = "" Then MsgBox "HMC Excel file doesn't exists in the system" & vbCrLf & _ "Contact the Design Engineer." GoTo...

Was an ex coworker in the office, so now he left and I am traying to take what he left and change as the office need to be due some production changes... So, I'm new to this, learning, and trying to understand from this code he wrote and add things required on top of my normal workload, I'm a...

Thank you very much. I didn't write this code but i have been pushed to learn and add or remove things from it. I will take all your suggestions. Thabks for your time as well. Would you recommend a course or where I can learn more about access?

Sorry Pat, Indeed I didn't understood your explanation. I'm quite new on this. I'm not looking for someone to build the solution but to give me some clarity if this is archivable. I did post the full code just to show there are not only 3 forms to print. I will try to invest more time...

This is the complete code for save pdf button (attached). The idea is from one report include the data required and then opening each form, printing creating a name referring to a work order and form and saving in a location in the drive. Opening each form takes time and makes printing one...

Hi, I have a program that prints several documents in pdf using a print button. Each report that gets printed, opens in and the close it. It take some time to do all the printing. Is there any way I can upgrade the code to make this faster and avoid opening the forms? This is an example from...

Hi, I'm quite new in access, I did some curse at Uni with visual basic and know a fundamental on using the program. I'm from UK using Access 365 I have inherited from work an Access system used to print a pack of documents needed for production. So playing a little bit with it and trying to...