Search results

Hello, I found this function ' Calculates the date of the occurrence of Weekday in the month of DateInMonth. ' ' If Occurrence is 0 or negative, the first occurrence of Weekday in the month is assumed. ' If Occurrence is 5 or larger, the last occurrence of Weekday in the month is assumed. ' '...

Hello, I'm working on Save a batch reports to pdf individual(with the tagno). Everything seems working however if I have the IF statement then it's not loop through all the records, I have a If statement like If Me.Salvage = True then do this else do this End if This If statement...

Hello, I have a question how to save multiple reports to PDF. How do I save them into individual page by order# instead save them all into one page by individual order#? I have a form that users enter Order date and Location. When I click Save Reports, if I have four order#, it save four...

Hello, I'm trying to export a form to PDF and got an error message "Can bot find the object '|1'. What does that mean? The report I tried to export is get data from 10 tables, is because that? I used this code in another forms and it works but don't know why is not working in this form. here...

Hello, I have a question, I want to able to show all the documents in a sharepoint folder to a list box in a form. These documents are in different subfolders, I'm having trouble to figure it out how to list all the documents in those subfolders inside the main folder. Attached is the DB, it's...

Hello, I'm not sure my question should post in the Form section or Module/VBA section but I would like to know if this is even possible to do it. Currently I'm working on a paperless project. We saved documents to a pdf format and the documents saved in a individual date folder. For example...

Hello, Is possible to program a button in a form to create folder and subfolders. I want to have the Button on the Main form that has the Parties's name and the case#. what I would like to do is create a folder named C1234567_Doe, John vs. Doe, Jane also create few subfolders (named Order...

Hello, Would like to use Shell "Explorer.exe " to replace HyperlinkAddress in order to open the document in File Explorer, but don't know how to use it in my coding because the HyperlinkAddress would pop up a security warning box and the Shell "Explorer.exe " will just open the document...

Hi, I have a button named View Orders in a form, the cmdViewOrders will open the SharePoint folder which is associate with the case#. The Path is C:\Users\" & Environ("UserName") & "\SharePoint\CasesDoc\" & Folder\& "\" & SPCaseName for example...

Hi, I have a Button named btnViewOrders in a frmOrder that is visible base on if there any document(s) associate with the OrderDate and OrderNo of the record. We used to saved those documents as PDF format in a network drive (Z drive). below is my code that works fine when the documents are...

I'm a new user on Access world. Nice to meet you all!