Search results for query: *

Does anyone know how to store an existing querydef into a string in VBA? I am constantly referencing existing queries but change the queries themselves fairly frequently. I do this today by cutting and pasting the SQL from the query itself but would like to know how to do something similar to...

I come from the Cognos world and am just beginning in BO. Although I have seen responses that almost answer my question, I must be missing something. In Cognos, I am able to easily store a user's input into an object that I can reference throughout the query in the where clause simply by...

Running Access 97 on NT4 SP6. I do not want users hitting the "X" to close a form, but when I try to disable it using the closebutton property or by setting the close button to "no" in the form properties with the window maximized, that little "X" is hanging...

I am trying to allow some very simple business users to FTP to a UNIX box in as simplified a way as possible to put several files in a specific directory. Their target directory is quite long, however, so I was trying to find a way to redirect them on FTP login to a different directory without...

I have an access app that I open every morning and click a single command button that checks a bunch of files for errors. Is there a way to open access through a batch file and then invoke this single command? I want to automate this process so when I arrive to work in the morning, the scan...

Does anyone know how to access a file or directory on a shared drive using the absolute address (server name) instead of the drive letter? Everytime I try to use file:///(server name)/(shared directory name)/(shared file name) I get an error "Access to the resource (server name)/(shared...

I am using IWR v.6.0.371.0. My problem is, I run a number of AIX unix scripts to build several informix tables that IWR pulls off of. If any users are running queries through IWR at the time the table is building, I get errors. Is there a way to lock out users from IWR for a temporary...

Has anyone had any experience in dealing with forms with a lot of drop-downs, but until you click on the drop down about 20 times, it refuses to drop? I have a form with multiple drop downs that I would term "sticky". Sometimes they drop down on the first click, other times it takes...