Search results for query: *

Remou, It worked!!! The only thing I had to change was the line that says: ac.Run "SetVar", CurrentDb.Name I had to change it to: ac.Run "SetVar" Of course substituted my functions name. Thanks, SELLERT If I'm not learning I must be coasting. If I am coasting I must be going down hill.

I think your "Notes" section will get it for me. i didn't think about running a function that will set my variable for me. My goal is to have all my reports and queries in the main database. I have not been able to locate a resource that could explain how I could identify the facility from...

* My machine is Windows 2000 SP4 * Some users have XP SP? * Both using Office 2003 I have 5 different databases for Facilities 1 thru 5 which are accessible by users from our Intranet website. The owner is determined to reduce the number of clicks by having links that directly open a specific...

I have a website that has a link to a database. This database has reports pecifically for different groups. I am going to separate them and provide a form for each groups reports. I would like to have a link on the website to each form in the database. Is there a way to make the link open...

Thank you all, I knew it wouldn't be easy. I feel a new Function or more coming on. Thanks, SELLERT If I'm not learning I must be coasting. If I am coasting I must be going down hill.

Greetings, I am trying to update a table with a global variable. Basically I have a form that gets the user name from the Windows environment and stores it to a global variable called "User". This part works becasue I use it to validate access to the database. I am trying to update a table...

Is there a way to make a form automatically size to match the size of the window. In other words, If a form is designed to show up in the middle of the monitor, and user expands the window to full size, I would like for the form to adjust the size and spacing of controls to fill the space so...

Thanks for the help Jerry!! Thanks, SELLERT If I'm not learning I must be coasting. If I am coasting I must be going down hill.

Greetings, I have a database that after processing an Excel file it moves the xls file to a history folder. I want the system to validate that the xls file in the working directory doesn't already exist in the history directory. I have the following code below that I used and it seemed to work...

Is there a way with on-open to check for the reference libraries that is installed on a machine and either, branching to different code suitable for the libraries installed or, displaying a message letting the user know they are missing a required library and to contact IS&T? Thanks, SELLERT...

I need to do this outside of code within the access query design view. Also, I know oder than dirt - I am using access 97. To be converted soon though. Thanks, SELLERT If I'm not learning I must be coasting. If I am coasting I must be going down hill.

I have an application that has documents, the users can add comments for a particular document, this creates a one to many relationship. Now I am trying to run a routine that will create metrics and the users want to see all of the comments. I don't want the document to be listed more than...

This would be access 97, it won't allow vbcrlf, or ASCII codes. Thanks, SELLERT If I'm not learning I must be coasting. If I am coasting I must be going down hill.

I have a query that combines remarks from different tables for a report. I want it to do a carriage return for each type of remark. Is there a way to do this in the query, or is it only possible in the report? I have tried chr(13) and vbcrlf, with no success. Thanks, SELLERT If I'm not...

Greetings All, I would like to run a macro that will disable the shift key when the database closes regardles of the method that it is closed. Is there a way to detect when someone clicks the X to exit the application and first run code to disabel the shift key prior to the database closing...

Fellow Tek-Tips Users, Thank you all for your feed back. I completely agree with AccessDB's last comments. It has indeed been an educational thread. Again, thank you and happy coding. Thanks, SELLERT If I'm not learning I must be coasting. If I am coasting I must be going down hill.

Thank you all for your help. One more thing along these lines. I am now trying to enumerate through all the tables in the database and keep getting a Run-time error 424 Object required. Bellow is my code. '******************** GENERAL NOTES ********************* 'This procedure will store...

AccessDB, Thanks for your help it worked!! Remou, I looked at those but didn't see any of the table names in it. Can you shed some light on how to use these tables? I also need the same sort of code to find what tables or queries are used for Forms and Reports. Thanks, SELLERT If I'm not...

Greetings, I have recently taken over a database which I need to clean up and relink to a different set of tables by the same definitions but slightly different names. I am trying to clean it up so I don't waste time re-linking tables that aren't even used. I suspect that there a few objects...

Does anyone know how to set up a conditional format where a cell has a Null value? I tried finding this in help as well and was not successfull. Thanks, SELLERT If I'm not learning I must be coasting. If I am coasting I must be going down hill.