Recent content by bholmes9

Quick update: the application.followhyperlink does work. I tested the following and it works great pulling the right number from my form as well. Private Sub Command33_Click() Dim bol As String bol = Right([AlternateKey].Value, 6) Application.FollowHyperlink ("Z:\2016-SHIPPING...

Okay so here is where I'm at, I've done some research however I cannot get the following code attempt to work. To preface, I did discover the shell way of going about this and it would work great however the issue is the subfolder isn't always the same and I don't know how to account for that...

Thanks for the reply The Doc Man, and great question! I intend to open the file in Adobe Acrobat Reader DC to simply view the document. The file does not need to be altered as it is a scanned document. I will do some research into FSO and elaborating the members of a collection to isolate just...

Yes! just did this, thanks!!

Hi Everyone, I am looking to create a button that opens a pdf document. I need some vba code because there is multiple subfolders that I need to look for and I cannot use Application.FollowHyperlink because the path is not the same for each file. So far I have a field in a form that has...

What I ended up doing to resolve this issue was put a date field on the form that updates when the big macro runs. I then created a macro that opens that form and then has a condition of [Forms]![My date field]<Date() to run the "big macro" (with all the queries). The "big macro" runs and...

"Try extracting just the date from each element of the compare." Any advice on how exactly to do that? (sorry I'm a newb)

Not sure if I did realize this, but if the table field is set to format date mm/dd/yyyy would that make it work for the append?

Hi Everyone! First post here, I am relatively new to access. I started a new job a year and a half ago and have been using access daily but now I am getting more into the development side of things. I am running access 2007 with the database saved as .mdb (2000 version) and I have come accross a...