Search results for query: *

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

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

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

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

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.

Greetings! I have an application where the user can start a procedure that pulls and compiles data into a spreadsheet that is used in various metrics. I want to be able to disable the Exit button based on whether or not this procedure is currently running. Exiting prematurely causes errors...

Greetings, I have a system that allows a user to select a particular metrics that they want to run. When it runs it will create a query definition based on the stored SQL statement and a date range value ented on the form. It then uses TransferSpreadsheet to export it to excel. I would like...

Greetings, I have a form that checks to see if the record already exists when the Add button is pressed. If the recored is there it checks for required data. If there is missing required data, the system will display a message saying that the record was previously added but has missing data...

I have a database that has several forms. These forms are of course tied to tables that have required fields. I am trying to capture the Error number 3314 which is generated when a new record is added and a field on the form is left blank that is tied to a required field in the table. I have...

Greetins, I have a form that has several tabs on it. Each tab has a different sub form. The tabs correspond to different work groups and some work groups should not be able to enter their data until another work group has populated their data. I need to referrence a control on the Material...

I am looking to make my forms self sufficient. I plan to hide the Access window itself so all the user sees is the form when they enter my application, I found some code that will allow me to do this. I want my forms to have the same familiar look and feel i.e. text menus with File Edit Help...