I am trying to improve an existing Access database The employee database is keyed on Employee ID in various tables, but none of the entry forms validate that...

Is there any way to customize the template that is used for Data Collection e-mail messages?

Never trust a wizard! The command button wizard in previous versions of access made extensive use of DoCmd.DoMenuItem which isn't available in 2007 I have...

Access 2002 I need to set up a form that can be used to enter a URL in a database. I've got the field I want to use defined as an OLE Object. If I paste a...

Hi All I am looking at the possibility of displaying the results of a query in a subform but with all the data returned appearing concatenated into one...

Ý have a little problem. Ý created a data base. There are three columns: product name, product code and price. For example: Product name: acetone extra...

Hi, I want to create a search form with lastname and first name. When the user type in Lastname and Firstname then click button Search it will looking in...

I need the correct syntax for using IIf with Or in a form. What I currently have isn't working: =IIf(.(16)="SH3700" Or...

Hello All, I have a database which is a trouble ticket system called quicksheets. I have a main form based on this table and I have some subforms based on...

I have a button on a form, that when clicked, runs a query that takes a long time. I wanted to pop up another form that would tell the user the query takes a...

Using Access 2007, I have two tables linked by the primary key "ID" in the "Minors" table and the "minors_id" foreign key in the "Guardians" table. I have a...

I am trying to create a grid like this and I would appreciate any guidence you ca give... Customer Code: (combo) Customer Name: (textbox display of...

Greetings All! I have a couple of questions about a combo box I'm using on a subform. I have a table that lists all the possible Project Managers that can...

Hello, I have an existing form in Access 2003 which is working fine. I want to change this to a tabbed form and keep all the existing fields on one tab and...

I have an existing Access 2003 database. Trying to add a new field in an existing database and wanting to add a combo box in the main form to link to the...

It's a long time since I did any Access stuff, but I have created a DB for a client's computer assets - nothing to complicated. However, I have problems adding...

Previous post below - still can't figure this out -??? We are using data to Generate Paychecks(weekly for the employees) based on their number of hours...

I have a table in which product numbers are listed. The product numbers change daily and by 30 different users who use them. In addition, we have a form that...

I am creating a database to manage medical visits to clients and when the client is first referred to me I want to enter their details and then have a series...