Hi! I'm working on a database right now that has a drop- down menu of search terms. I originally had the menu in three separate text boxes so the user could...

Is it possible to filter a form by distinct values in a text field? I tried making a query and failed badly. Text field has tool names and I am trying to...

Hi, I'm very new to Access and I need some help designing forms. I have an Order Entry Form which I want to link to "Products" and "Product Categories"...

While adjusting the controls on a form, I find myself doing the same process: Size to Longest, Size to Tallest, Align to Bottom Is there a way I can write a...

When my mouse pointer goes over a row in a continous form I would like to change to back ground color of that row. Is this possible?

I want to click a button on the switchboard and have it open a form and assign the recordsource, which will be based on the selection that is made. I am having...

Hello.. I have an application in Access-97 and it has been upgraded to MS-Access 200 now. Now I converted that application to Access-2000. After that I have a...

Is there any way to change the text color of the caption of a page on a tab control (the color of the tab text itself)? Thanks, Chip

I created a form (frmStudents) whose source control is tblStudents. In the table, when I click the next record button, I can the next record number. I would...

How do I set up a form where 2 values are input and then the 3rd value is displayed on the form once the first 2 values are input----then the 3rd value is...

I am not very advanced with Access, but I have created a relatively complex form. What is the easiest way of setting it up so that when the form opens,...

I have a database which i have put a yes/no field to show when a tast has been completed. I wish to have something that will auto archive the record when...

Hello, I have a question with regard to the Shift ByPass Key MDB posted on a website by Albert D Kallal. I have used the MDB on my local drive with great...

I am trying to create a multiselect list box in a form. I have made a list box listing the 5-6 choices and have added an inidivual add and remove button, as...

I have a command button on a from that opens up a second form. Is there any way that i could add password protection to this button to stop others opening up...

I have a form where I am using record selector in Access 2K. I would like to trigger an event when I select a record, is this possible???

Hello everyone, I have created a form from a query and in the design view I can see everything. But in the form view I can only see the blank background. I am...

It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source...

I am using MS Access 97 for a Workflow Database. In some of the Computers where this database is installed Text Functions like TRIM, LEFT etc are not working...

Hi, I would like to be able to have my windows open up in the same locations each time they are used. I have heard that I do this via positioning within the...