Recent content by phishman00

Worked like a charm. All I needed was the .sql at the end of the querydef. Thanks!

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 finally figured it out. Although it won't parse, I can store the @prompt('Enter A Start Date','D') into an object and reference it throughout. Trust me this was not my idea, but I am dealing with a table that doesn't even qualify for 1st normal form. I use case statements everywhere. Total...

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...

Thanks for the offer. Although I can't find documentation for that error, I trapped for err.number = 0 specifically and it seems to take care of the problem. I have also changed the error messages to handle both situations of data validation and closing the form. Thanks for the help. Always...

Jujutsu, I have the same problem as you when it comes to reading tech books on any language. They start very slow and ramp up to super speed and loose me somewhere in between. The best advice I can give you is to develop an Access app that fits a small personal or business need. That way you...

Billpower, I ended up suppressing all error messages on the form and implementing sections of your code. I have one last bug that I can't figure out how to get around. Maybe you can help. My validation code for the data resides in the Form_BeforeUpdate event. This event will trigger if...

Appreciate the code snippets Billpower. The real problem isn't forcing the user to stay on the form, it's getting rid of that message that only appears when the "X" close button is clicked. I can't even trap the error in the Form_Error event and yet it doesn't appear to be a warning...

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...

Thanks for the tips. I modified the .netrc file per recommendation. (Installing a gui on their desktops would have required our corporate legal department to authorize the installation, too much work)

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...

Got it. Thanks for the help. Jason

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...