Search results

Please help me! I currently have a return button in each form that when you click on it it automatically updates all reports. So you can have multiple people clicking on it at the same time which is causing the macro to halt and not update the reports. How can I make it so that it doesn't...

I have a table where inputs are stored. Is there an easy way to make copies of, for example 2006 data and paste to the same table but now calling it 2007. Also, as this is happening users are still entering data into 2006.

There will multiple users accessing the same database/forms at the same time. How do I ensure that all entries are saved and not overridden by each other entries? Access 2003

This is exactly what I wanted! Thank you all for helping me.

It worked! Now my next question is when the user leaves the data entry form and come back all their previous entries are not visible to them (now stored in table). I would like them to modify their previous entries. How do I make it open in "Add" mode but also allow them to see and modify...

I have a data entry form. Right now when it opens the first record populate the form. To add a new record the user would have to click "Add". This is confusing. They start modiyiing the data thinking it's a brand new entry. I would like to modify it so that when the form opens it...

I created security using the security wizards, separating admins vs. data entry users. I gave everyone a username and a password but when I reenter the database it doesn't ask me for my username or password. Does anyone know why or how can I fix it?

Does anyone know how to create a pop up message when you click on a combo box in form?

tkoh78, it worked perfectly. Thank you!

Users will be running reports via the Switchboard. After they have entered their data they will return to the Switchboard and select a report they want to see. When they select a report that where I want the report to automatically update so they see the latest data.

Does anyone know how to make a report run queries automatically? For example I want to run Report1 but it depends on three sets of queries. When I open Report1 I want it to be updated with the latest data. Access 2003

Can someone help with how to write the codes so that the macro runs invisible to the users. Right now it opens all the queries for me to run each one individually. Below are the codes. How should I modify it? Liv, when I added the code you suggested I get as syntax Update Statement message...

I have created a form and in the form users can run a macro to update their queries with their new entries which ultimately updates their reports. When I click the button to run the macro it opens each queries for me to run them. How do I make the macro run automatically without opening the...

I tried looking for it but can't find this Wizards. Is it under Tools? I'm new to this.

I have created a Switchboard where users can enter data via a form and run reports. I tried testing by entering data into the form and switched over to see my entry in the report it's not there... How do I automate it so that when the users run a report it updates it will their entries...

I'm completely lost on how to get started on security. After reading all these postings I'm more lost then ever. What is a backend and frontend security? How do you create password for each users? etc... Please help! FYI I'm using Access 2003

How do I go about doing it? I'm completely lost. Please help :-(

Is there a way to create security based on division in addition to tables, forms, etc...? I'm using Access 2003

Thank you for helping with this issue. I can't believe it was so easy. Do you know how to write a if...then statement in combo box (forms). ie. if division 1 is sellected, give me all business units related to division 1 only.

It worked!!!!! Thank you so much!