Search results

Thank you, folks. I'll check these items and report back for others with a similar situation. I do know the network is spotty at times... so, this actually doesn't surprise me. Just wasn't thinking it had to re-ping the odbc table each time, etc.

Hello folks, I inherited a giant MS ACCDB. It has a little bit of everything in it; local tables, odbc tables, linked network XLSX data sources, zillions of macros, zillions of queries, etc. Currently, I pull the db down to my C:\ drive but all those other links are still active. When I pull...

Paul, that worked !!!!! The "THANKS" button seems insufficient. :^)))) Thank you. Now to dissect this and learn how it works.... You are a patient rock star, my friend.

This process "as is" (including purple and red line), produces the correct file names, correct data in the file, but replaces the first value in my tbl_Carrier_ID with the last value when the process completes and I close the form. :^O If I remove the line 1, it produces a .xlsx file with no...

Dear All, So close to having this functional and on my way to cannibalizing it for several processes... :^) I'm stuck on the actual loop advancement. This code runs, generates the individual EXCEL files, named for the correct client, etc. However, they are all for the same client. So, it's...

Perfect. Thank you so much for the creative solution in light of keeping the little code I already have. I also looked at TransferSpreadsheet, but that doesn't seem to fit the bill either. This forum and users are the best. Thanks again.

Dear All, Thank you in advance for any direction you may have. This is similar to my last post (looping, exporting to PDF). I'm trying to do that same thing with a query, exporting each Carrier's data into their own Excel file. The code runs. It creates separate files and they are correctly...

Sneuberg, you had the answer. :^) I had a reference in my report that was missing the underscore in Carrier_ID. I thought that reference was to my table where it was getting the looped value, which was correct. Once I fixed that and added a path that the VB liked, it ran without issue. Thank...

Alright. Thank you so much for the reply. I'll do some work on my end and maybe it doesn't like the path or something. Thank you for the advice and time.

Ok, I've incorporated all the fixes, checked the field names, etc. and still no joy. :^O Here is the code. My steps and the outcome is below the code. Thanks so much for any input. Public Sub ExportToPDF() Const Folder = "\\stlfs1\profiles$\me\Desktop\Access Loop" Const Domain =...

Thank you so much for the reply. I did some checking, it sure looks like the field name and table name are correct. I will add a few screen shots of the objects and errors, maybe that will make something obvious. Thanks again for your time and efforts.

Dear all, newbie to vba. I've spend hours cobbling this together from various sites on line. I'll gladly take the chastisement if someone can correct my mistakes. :^) Table with looped value is "tbl_Carrier_IDs". Looped field is "Carrier_ID". When I run the code I get a "Enter Parameter...