I am creating a form to enter purchase orders into the orders table. I want to pull info from the suppliers table also. I know I can use a subform to display...

Apologies I am a complete novice at Access. We use Access 2003. My member of staff needs to be able to add a large number of records into a database. I...

Hi, I had 3 tabs on a tab control and the user wanted a fourth added. No problem. However, it makes sense to place this new tab first. Any easy way to...

I would like some suggestions on how I should best design a form. Our team will be updating this project form on a weekly basis. Here are the things I need...

Hi, I have to move some controls but their labels are attached to it. Is there another way to disconnect the label from the control, other than cut and paste...

In Access 2003, the forms all displayed as little windows that you could resize. Now, they display as tabs. since the forms still show up as windows when you...

I am trying to create my first database and I am having some issues with the subforms. I created the main form using an existing table and now I want to...

I am Creating Purchase Order Scheduling Form. There are 3 tables 1) Po Master , 2) Po Details 3) Po Schedule. Table 1 is linked to 2 with O2M relation, Table...

Good day I am redoing a bad flat file (one large 100 record) single table database into one with 6-8 proposed tables because the old one had 11 tabs in one...

What is the best way to input data on a form in a many to many relationship I have three tables: Cell CellID - PK, AutoNumber Node NodeID- PK,...

I have a form that have several field that are calculated. I change the format to be Standard with 2 decimal places. I also removed each field as a tab...

I have my start up set to not display the database window but my form comes up in an access window. Is there a way to display only a form (with no access...

I have built a form in MS Access 2007 using design view but when I go to open the form in data-entry or layout views, none of the fields show up. I cannot...

Hello, I'm very new to Access, so I apologize if this question has been answered before, but I am having trouble with the button function wizard. I am...

I have a table linked with Excel, wich is updated from time to time by adding/deleting a new record of 4 fields (the update is made in Excel by saving a...

I am creating an "opportunity tracking system". I want to input key information about the opportunity on an input form and also input multiple contacts ...

I need to be able to keep Caps Lock on while typing a value into a combo box (Access 2007). It won't select the corresponding value if the caps lock is on. ...

I'm running into a problem when I try to add certain records to a subform, in that the following error messages appear: 1. You tried to assign the Null value...

I have a macro that performs many actions. One of the actions is to open a form and check to see if there are any records. If there are no records then a...

I have created a service form. The user is requested to chose the client's account number for the service requested. The service information is in the...