Search results

Here goes: Attached is an image of Access 2000 options dialogue on the Edit/Find tab. Each time the database is open Access checks the box to "Confirm Action Queries". Is there a way via VB that when the main form opens it automatically deselects the check box for action queries? For example...

Sorry, I didn't mean that. What I meant was is there a code that de-selects the checkbox when a form (e.g. the main menu) is opened as access always defaults to show action queries as we are on a network.

In the options dialogue in access 2000 there is a option to disable action queries and the status bar. Is there a way of doing this via VB so it can be applied each time the database is opened. Also is there a code that can be used to disable cetain menu and toolbars (such as Menu Bar, Form...

Yes it was what you said! I've sorted it now, thanks! Aden

I'm using the simple password protection sample database in my own database and have been working on the database at home and college and all of a sudden i get compile error saying that an Ambiguous Name Detected: User is appearing and i can't use the security system. Can anybody help????

Can anybody help me? I have a table: Book and another: Copy. How can i search these two tables so when a user finds what they are looking for it show the record in a form not a table. Also is it possible to search tables which are link to the database from another database? Thanks Aden P.S. I...

Great, thanks, I managed to create the due date using the Control Source field. Now, is it possible to exclude saturdays and sundays and how do i put the due date into a field so it can be used in queries etc. Thanks Aden

I have created a library database with four tables Book, Copies, Students and Loan. What I want to be able to have is when a book is loaned out it takes the value from the Loan Period field (number of days) and adds it to the Out field in the Loan table (excluding Saturdays and Sundays). I have...

I know I've posted quite a bit today but i am making some big modifications to a big database. Basically, when a record is updated (information in the record is changed) a checkbox (Update) is automatically selected. How can i do this. Also i want to be able to click a button that will clear...

access version 2000

could you post me a sample database or something to help me to do this?

How? I'm already using the OnTimer event to refresh the page.

Somewhere i saw a post which described how to disable a database. Basically when i clicked disable in one database, it stopped other users from accessing another and displayed a message (Database disbaled). Can anyone help as i need this desperatly. Thanks

I have now done it. I have added a second "light" as Error which colours red if selected. Is it possible to make this flash between the colour red and transparent.

it doesn't work!

I would like a box to turn orange when a field in a record is entered to "yes", and when is "no" turns back to transparent. A bit like a warning light on a till! Can anybody help me as i am totally stuck? Thanks

I have a database which requires users to login. Is it possible to open two forms after login of which one is the main menu (frmmenu)and the other (frmmessage)(automatically placed at the top of the screen) is a form displaying a message.

Here is the dbase Attached is the tables. Can anyone help i'm totally stuck! Feel free to modify the database and post it back here. deliveries: where stock received is added products: where product details are stored orders: where orders are stored suppliers: where product suppliers are...

I need to update my sales database system. Basically, I need a table where i can store products, their suppliers and how much is in stock. I then need a table where i can add purchase orders which will increase the number in stock in the products table by how much was ordered and then an orders...