Recent content by CLOS

Help! Help! I have an access application that runs on the network server. I also have a copy of the application that resides on my local drive (c) or (d). The local application creates make-tables. (?) Is it better for me to link the tables, or import the tables to the application that...

John Ruff, Thank you for this information, it is very useful and it works. Thanks so much.

Can you give me a copy of the macro or event procedure that you're using to link tables.

Why do I need to do This? Because the POC who handles this application needs to run make-table queries once a month that creates tables with new data. Once this is done, I want to set up some type of event procedure to transfer these tables to the actual application that resides on the network...

Help! Help! Help! I have an Access database that has tables that I want to export to another Database. I tried using the "TransferDatabase" macro action but I'm not getting any results. Also, the current database and the destination databse are on two different drives. The...

I need some help or suggestions! I have 50-plus queries that makes tables. What I want to do is run these queries when the application first open up, but put out a message to the user saying that "The user tables are being loaded". Then display the splash form. How do I handle...

Need Some Expert HELP, I have some users that are complaining about when they click on the "PREVIEW" button to preview a report, the preview screen in access doesn't center the report. So, inorder for the user to view the entire report, he or she would have to click on the...

The Docmd.Printout command will print the form with record on it, but it's the first record in the table and not the record that was selected for print. I need to print out the exact record that appears on the form and not the first record in the table.

Need some expert Help, I have a very colorful form that the user would like to screen print the data found in the form. However, when they screen print the record that's found on the form, the printer uses up alot of toner. How can I change the form's color using the "Printer&quot...

[b]Jebry,[b/] Thanks so much for your Help. You are truly super.

Help! Help! Urgent Help! I have a bound textbox that I want to test to see if the user changed any of the data found in the bound textbox. In otherwords, I want to know if the data has been changed. Can somebody give me the [event procedure] code for this one, thanks!

Need some Help! I have a textbox for the user to type in data(data contains 7-chars). But, if the user only types in 4-chars and decides that (he) or (she) wants to click on the Cancel button to UNDO what they've entered. What code would I need for the Cancel button inorder to handle this...

Help! Help! Help! I'm trying to set-up a command button that will print a form and the record displayed on the form. How do I code this to make it happen? Let me reiterate. What I want to do is click on a command button that will print the form and the data record displayed in the form...

I need some expert Help with this one! I have a command button that will display a message to the user prompting them with either a 'YES' or 'NO' question to confirm a record delete. Now, if a user's response is 'YES', I want to delete the record. If a user's response is 'No', I want to...

Need some urgent HELP on this one, please! I have a form that contains a sub-form. The main form contains a single record. The sub-form contains multiple records of the single record thats displayed on the main form. Now, when the user clicks on a single record thats found on the sub-form, I...