I have to create a query with many to many relationship, but I can't
break it into 2 x 1 to many, should there anyone can teach me how to
solve this problem. Thanks in advance!

Hey Folks,
Is there some sort of Microsoft Access Certification?  In the past, I
haven't really been able to find such a certificate or exam on the MS
Website (albeit i haven't checked in a while), but a few of the head hunter

I am trying to isolate the identifying area codes from postcodes and
want to extract the first one or two letters from each postcode. I have
created a query that uses:
SmallPostCode: IIf(Len([PostalCode])>=2,Left$([PostalCode],2),"")

Posted this once before but the only reply was not the answer to the problem.
I have a table with these fields:
RequestId
Account

I am real new to databases and hoping someone can help.
Main-table is a huge spreadsheet that I imported into Access
Site-table has a bunch of addresses pulled from Main-table, quite a few
overlap in some areas  and none of the fields are unique except the

Can the DROP TABLE statement be used with a select or where statement?
DROP TABLE SELECT *
FROM tblTablesImported
WHERE Import_ID Not In

Is it possible to detect which mdb 'uses' a specific codelibrary?
I would like deliver an app (mdb) with some specific code in a codelibrary (mde).
I want to be sure that this codelib is NOT used by another mdb.
Is this possible ? How ?

I currently have numerical records in a text field. The numbers are really
text! If the number I have in a record is 12345 .......  how can I somehow
edit this to place "GP-" prior to the number? Please make the answer simple.
Best regards

I've implemented the following successfully on a single form before,
but the continuous form is giving me problems.
I have 2 combo boxes, Combo 1 and Combo 2. The values in Combo 2 are
dependent on the value selected in Combo 1. I run the code:

I want to adjust the paper size in the report module to print landscape
on index cards?
Any ideas are greatly appreciated....

Hi,
I need to timestamp printed records with the printing date. According
to the customer's requests the report must be opened in preview-mode
and the user clicks on the printer button if he really want to have a

What is the best way to get a Common Dialog in Access 2000 Standard Edition?
Microsoft suggests this:
Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _
   "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long

I have a form that is open with one record in the recordset. I need to
add a record to that recordset, then requery the form. Ultimately, the
user will --from a list on another form-- one-by-one, add records to
the forms recordset. Not new records, just other existing records that

Access 2000 W98!
I have a table with numerous records in it, and am attempting to delete certain records
that have been selected from it. These are selected based on the ID number in a different
table. While I am using the tools in Access for query setup, its easier to show it on ...

I have an excel spreadsheet that I imported into Access, and there is a
Name field in the format of last name, first name. I'd like to break
this into 2 separate fields. How can I do this?
TIA!