I'm trying to insert records in a table that has a "no duplicates"
index on two columns.
The following snippet shows where I started off...
INSERT INTO Table_A (ID_A, ID_B)

I am a rookie and am looking to create records based on a field value.
For example - I currently have sales data for three employees:
Employee 1 has sold 12 units, EE 2 has 8 and EE 3 has 10....I want to
create a table that will show 30 records instead of 3 and list the

Curerntly I have designed my table in MS Access with a column of
"RuleID"
and is set to (autonumber)
tblRule:

I have an Access 2002 application with approx 170 forms.
Security permissions are controlled via the back end tables.
In the front end (mde), the 'Users' group has access to all forms.
Yesterday, a client advised that she could not access one form. On checking,

I have some comboboxes in my DB, that has a big list of possible
choices.
I Want that the user could use the keyboard to "navigate" along the
list... for example: if i use the key A, in spite of writting the

I'm trying to build a search utility for users to find 'inquiries' in
my database that involves several tables. This is normally easy to do
with the query builder, but I have a unique situation involving a multi
select listbox. Unfortunatly, my SQL skills are somewhat limited, so

I created a database in Access 2003 (I didnt convert it to Access
2002-2003 format) with marcos and code. Now I need to run this database
on a computer with Office 2000. I can open my database but can't run
any of the macros. Is there anything can be done here except installing

I have a report and on it, a subreport control
Main Report Name:           rptInvoiceMain
Sub Report Name:            rptInvoiceSubReport
SubReport Control Name: rptInvoiceSubReportCtl

I don't always get what I want when I invoke the following
     Me!MySubFormControl.Refresh
from code running in the main form. Am I doing something
wrong here? Someone suggested that I open the subform

Apologies if this has been covered before - I couldn't find it.
I currently use ASPEmail to create and send HTML emails from an Access
database. The text is personalised and includes embedded graphics, eg
logos and even the recipients photo. Note that everything is embedded,

Can any one help me?
how can i do to a combobox keep in new records, the value choose by one
user, until he changes it?

I need to place the results of two different queries in the same result
table parallel to each other.
So if the result of the first query is
1   12

                 I have a problem which I think you people can solve.
I am having problems. I have a table which stores surveys submitted. We
have multiple types of surveys, hence a person can have multiple
surveys under his/her name. These surveys have priorities from 0 (min.)

I have been hitting my head against the wall on this problem for a day
now. I have a simple table that stores cities, on of the fields on the
table is modified_by. I am trying to write the user who modifed the
table, in to the column modified_by. Code for getting the user that i

running access 2k; adp w/ linked tables to SQL server;
I am absolutely stymied, and ticked off beyond belief - I can not
believe how much time I've wasted trying to do something that should be
comically easy!!!!!