Search results

I have created a query which search all fields in my database from one text box. Is it possible to search only records which have checkboxes ticked by ticking a checkbox on the search form/in the query. Thanks in advance

For some reason, I can no longer create snapshot files of my Access reports. I used to be able to do it on my computer. I have downloaded the recent snapshot download from microsoft.com but have had no luck. Can anyone help? Thanks

I am starting to add a list of useful Microsoft Access sites and forums to help beginners to Microsoft Access find what they need. If you have any useful links, then either post them below or send them to me via PM. I thought this would be a good place to ask as many people here know quite a...

I have a table with the fields username, password, userlevel, blocked, name. I want to be able to export the fields username and password to a text file in the format of: USERNAME1|PASSWORD1 USERNAME2|PASSWORD2 USERNAME3|PASSWORD3 USERNAME4|PASSWORD4 Can anybody help me as i am not sure on...

Is there a way via code in a module to automatically create a snapshot of a report, save it in a specifed folder location in the code and save it as the current date as the file name when a button is clicked. I'm looking on how to do this as I have many reports to create, move to an intranet...

I have built a basic database to hold details on all my computer books and software as i hundereds of them. I have built a table with text, number and memo fields which i want to be able to search. What i would like is a form where you can enter details into various fields (eg Title, Author, a...

Hi I'm have created a video database with a genre field. Is there a way that when i click a button a list is displayed of all the records which are the same genre? Thanks Aden

Hi, I have a table which contains many fields of which one is a date field. How would i create a query so that it shows every record which is between the date the query is run and two weeks from the day the query is run? Thanks

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

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

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

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

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