Search results

I'm trying to cut the table up into tabs, not nessessarly sort them. Any idea how to do that?

I'm not sure if this is possible but here is my sitution. I have a table in access that I would like to export to Excel. Easy right? Now I'll thorw you a curve ball. There is a field in there with office locations (which can change based on what they are importing so there's no set names), that...

I'll give it another shot tonight and let you know what I find. In the meantime, does anyone know how to read my code and who might be a little bit more familiar with the "File Dialog" function so I don't have to reinvent the wheel? Thanks!

I posed my code originally and did not recieve help as to what I was doing wrong. I spent most of last night trying to get the code you posted yesterday to work and I was unable to figure it out. I decided to try and work on the code I already had since it all worked with the exception of the...

strSaveFileName = ahtCommonFileOpenSave

"438 Object doesn't support this property or method" It's possible I'm not using the code correctly. How would you use the code in my example.

No luck on that one. Any idea how to modify my current code to get it to work?:confused:

I am having some issues with updating some of my code. I currently have code to open a file dialog box, select and excel file, run it through some queries, and out put it to a selected location. How can I make a diaglog box pop up asking where I would like the file saved. The first set of...

Does anyone have a good template or tutorial on creating a form to browse for a file, select a excel file and do a transfer spreadsheet command, to a table. Right now I have it hardcoded in a macro (as to a file name, and the Transferspreadsheet command, however I would like the ability to...