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...

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, 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...

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...