I have a main form based on a table. I would like to give the users the option to show only records with a certain field entry, records without this certain...

Morning! I have a drop down on my form that enables the user to pick a particular company they are going to send the form to (save from having to rekey over...

Hi! I have a button on my main form to run a query. This query should only be run once per record ever. I tried disabling the button after it is clicked, but...

I've looked in the posts and didn't find exactly what I was looking for, hope you can help :-). I have a form called quote. When you pull up that form I would...

Hi! I have a main form with information pertaining to one job. On my subform, I have a list of contractors who may or may not get that job. When you click a...

Hello, Is there a rule-of-thumb or some technique to size text boxes / combo boxes based on the font size and expected number of characters? For instance, I...

Hello, I import data into two tables. To ensure that the import worked, I check the sum of one of the columns, in this case the purchase order value. Right...

Hello, First, I'm not sure if this a "tables" design question or "forms" question so I'm posting in both groups. I receive a daily force / headcount report...

Hello, I have a simple database to track my CD collection -- two tables, tbl_Albums and tbl_Artists. Tbl_Artists contains one field, the artist name, and...

Hello, Let's say I've got a table that lists all fifty states and a tax rate associated with each. As would be expected, I would like a user to be able to...

I want to assign a default value based on a conditional expression. e.g. For the textbox control I want the default value to be calculated as follows: =IIf(...

How can I get a form to auto complete all the (customer information) info that is already stored in a table....so as not to create several customer numbers for...

Help !! Sorry if this is probably a bit basic, I'm a novice at Access I'm afraid. Anyway...I have been tasked with adding a form to a table which lives in...

The form I use to enter purchasing data calculates a total cost per order, but it doesn't put this info into the data table. How do I get it to do this? ...

I have a form which is used to enter information about correspondence. There are two subforms for two additional tables which are related to the...

I have a form which is used to enter information about correspondence. There are two subforms for two additional tables which are related to the...

I have a form which is used to enter information about correspondence. There are two subforms for two additional tables which are related to the...

I have a subform that needs to calculate the percentage a certain value is out of the whole. I also need to store the calculated percentage in a table. How do...

I recently converted a couple a .mdb databases from Access 97 to Access 2003 and the same forms that opened instantly in Access 97 now take 23 seconds or more...

I need to exceed the 65536 items limit for a combobox in Access 2003. Adding a filter for the combobox to reduce the number of items won't work for...