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

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?

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

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

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

I have a print button on my form that prints inputs stored in a table. I saved my print setting so that all the columns fit into 1 page but when I go to print from my form it prints to two pages. Is there any way to fix this????

There is a Date Submitted in my form that I would like it automatically poplulated with the current date. How do I do that?

I want to create a report based on business unit information. I have a switchboard that links to the report. When the user double click to see the report I want a pop up message asking them what division he/she wants to view. Based on the division selected the report will show only those...

I'm creating a personnel planning system using Access 2003. I have a form that I developedwith a subform attached to it. I have two questions: 1) I want the user to select from a drop down menu the Band (combo box). Based on Band selected the user will then select the Job Code (combo box)...