Search results

I'll post what I have for the code, the variables may need to be renamed and if you need help deciphering it, go ahead and post a reply and I'll help you through it. Since I have the code for it, I will also include what I have to place a 'progress bar' on the bottom 'status' bar of Access...

closing Excel and releasing file Here is my closing/clean-up code that should allow you to delete the file when finished ... my code actually takes an XLS file, cycles through Cols and Rows and generates a comma seperated file (in the Windows Temp directory) that I run a docmd.importtext on...

form/sub-form reference in query If you are designing your query to reference the control, then I would recommend using the Build wizard (right click in the Criteria), this could also help you find the reference then plug it into VBA. RuralGuy, thanks for the clarification - I haven't used any...

This is ironic, I actually have been doing work where I am taking XLS files and converting them to CSV. I would recommend not refering the Excel.exe file directly - if someone does a custom install and has had to change the installation directory because of having to keep multiple copies of...

On_Open should work The on_open event should fire when you open the form, even when it is a sub-form. The problem may be how you are referencing the data controls. I have run across problems (especially with older versions of Access) referencing controls on a sub-form, even when the code is...