Search results

I got it figured out!! ghudson, I figured it out, with your and Rob Denham's help! I cobbled together a sample .mdb database (Access 2000) and will try to attach it to this reply. The sample is deliberately incomplete in places, to protect some proprietary data. However, if you "walk...

I'll give it a go, and yes, I've also been looking through UtterAccess. Thanks!

ghudson, That still won't work for what I have in mind..... I'm thinking I probaby didn't explain myself clearly, so I'll try again......I've got an application that exports Access data to Excel. It works beautifully, with one little exception..... I have to have an empty Excel worksheet...

ghudson, Thanks! Sometimes the obvious things are hidden in "the forest for the trees." Have a good day!

ghudson, Your sample database is very nice. However, what I'm really interested in is something that'll let me specify the name of an output Excel file prior t actually creating the output Excel file. I other words, my project will not have a previously created file upon starting it; I want...

ghudson, Thanks for your link to your example coding..... I'll check it out tomorrow when I'm at work. And, before I posted my question, I did do a search of the forum, using keywords such as "open file," "file open", "save," "save as." "dialogs," and the like. I always try a search prior to...

???? I did not understand your reply at all..... ???? :confused: :confused:

I've got a project that takes MS Access data and puts it into an Excel worksheet. I am interested in havig a dialog window open up that will allow me to specify the folder and Excel file name to save my data into. If anyone has a way of doing ths, I wold love to hear from them...

I got it figured out. It was in the way I was selecting my rows and cells and formatting them. For some reason, if I did not exit completely from my project, something was getting "stuck" i my code, but as soon as I altered my code to use the "SELECT" for each cell, all worked!

[RESOLVED] Getting interesting error message I have an Access project that when it starts, lets you pick a folder and a file to open as input (done with VBA code), and that works beautifully. My project then processes the opened file and that works fine also. However, when I run the project a...

Jig, good morning! Thanks for your response, however, we are not usig Cold Fusion where I work and therefore, I cannot put your suggestion to use. :( I appreciate your willingness to help, though. Have a great day!

And hello again, Pat.....you are right, regarding finding the number of rows and end of the data. What I'm endeavoring to do, is a loop within a loop, so to speak. I short, a do while nnot EOF, and within that, for each month's worth of data, a do while it's the same month. Then, when the...

Hi, Pat and thanks for responding! The funny thing is, they originally had this little thingie in Excel and asked that it be put into Access, but now the new kid on the block wants it in Excel! What goes 'round, comes 'round. The hardest part is that the amount of data and number of rows...

I've been asked to export an MS Access report to Excel. I'm having trouble with including subtotals, totals, etc. in the Excel sheet. I've enclosed a picture of how my report looks in Access, and was wondering if there's a way to export everything the report has into Excel...... Can anyone...

Quckie update re: the site I mentioned.... most of the products at that site are no longer free. It was nice while it lasted.

FoFa, I agree..... it's just that users at certain levels of management refuse to believe tabs are correct if the columns don't line up. I've tried explaining 'til I'm blue in the face, but............. I appreciate your input. Have a great day!

Thanks, Pat.... will your suggestion place tabs into the output file? The program that takes my output file requires the file to have tabs between data fields.

Thanks for replying. Is there a way I can get my columns, in a tab delimited txt file, to line up? It makes it a lot easier for human readability.

I've got an access table with six fields, all of which are text fields. I have set up an export specification file in order to export the table as a tab delimited txt file. However, when I export, the output file is not lined up in columns! What I am seeing is: 1 A BB CC DD EE 2...

I don't know.... I would guess that you can. How about it, experts - can it be done?