I have created a form based on a query from multiple tables which I can update and the new information shows up in the underlying tables, as well as the...

Hi, I would like to know how I can set up a form (with 2 subforms) that are based on queries, but the specific query depends on the user selection from a...

I have a database that works correctly when Windows appearance is set to Windows Classic using Windows XP Home Edition. The database is Access 2003, using the...

On every form in Access2003 you have your boarder round the edge. Does anyone know the exact colour of this boarder? im wanting to create some dividing lines...

Hi, I am creating a Form for Returns. It consists of 9 lines of detail that include a fields (defined in my table) for Quantity and Unit Price (9 each). On...

If I want to calculate field3=field2*field1 before the record is saved on a form, what is the best way to do this? Thanks, Donnie

Access 2007 Our main form, which has a recordset from a query with 4 tables, about 7 subforms, about 8 combo's takes about 30 seconds to close. There is no...

Hi, I am trying to design a form for our uniform orders database. Relevant tables: Customers Orders (orderID, customerID, order date) OrderDetail...

How do you set or change a forms color. I have one form that is different than all the others but in the properties page I can see no difference between the...

I though there was an "acounting" style color for forms. Sort of a greenish blue - but I don't see it in Access 2007 - it seems to be more blue now? Or am...

I created a form based off of a query that derives information from one table and one query. In the form I've made name a combobox so that when I click...

Here is a question for you, we have a pretty simple database to gather comments and suggestions from users for improvement on things around our office, It is...

I have been running a database in 2000 and just starting it up in 2007. For now I need to leave the file format as 2000. The system works great with no...

I am trying to put a button on my forms to close a form but the button wizard is not opening. It used to pop right up but for some reason I am getting a...

hey all, i have a form in datasheet view and was wondering if i could manipulate the back color or fore color of rows base on conditions? thanks, rodchar

I have a report base on a query with date parameters (beggining date and ending date). How can I have those date show on the report? Thanks, John

Is this my bad coding or a bug with MS Access (2003) Thanks

Hi I am trying to convert one of our company paper forms to an Access form to utilize our parts database. The form would be a customer order form which would...

I have the following tables set up, (many fields are omitted for simplicity) but am confused about how to do one thing. First, tblMisconduct data is entered...

I'd like to find a way restrict my forms design to a specific pixel count so I know it will fit correctly on different display formats. Ideally, I could...