I'm trying to find a way to search multiple tables for the same record.
Say I have 3 tables all with a name column, I need to search all 3
tables and find matching names. Is there an easy way to accomplish this?

Please can anyone guide me on how to transpose an access table where I
have many records per id eg
UserID  Question Answer
1          1       a

Aaaah. Nothing like listening to The Doors first thing in the morning
to get you going...
So, I'm about to ask a question that I sence might have lots of spark
behind it:

I have a long and complex data manipulation algorithm written in ADO that
performs about 20 different data manipulation processes sequentially.  I
intend to finalise this function (lets call it AddSessions() by setting it
to perform within a Transaction with Rollback etc.  Only ...

when settingup a label report in access using the wizard the resulting
previw and print out is not as it should be ....  example is using Avery
labels(or any other). 24 to page ...3col by 8 rows... only 7 rows
display....

I created an Access 2003 mdb on my computer and used the Access Package
Wizard to create an installation package, including the Access 2003
Runtime  This installs fine on my second computer running Windows 2000
and Office 2000, yet when I open the mdb I get an error that my

Can anyone help please
I have created a form using
Dim Frm as form
Set Frm = CreateForm()

Any way to remove the Dotted-Line in the button or field thats the first
in the Tab Order?
Thanks
DS

I have a database with the timer function set to warn the user that
arecord is due to expire. Is there a Win API that I can use so a loud
warning will go off. Not this simpel beep in access but a really,
like Virus Alert kind of warning?

I have the challenge of needing to automate table creation. It doesn't end there the tables have to be created from one table that looks something like this...
Email                           Source
at@at.com                       EB
no@no.com                       EN

Can someone tell me in simple terms why one should create an MDE file from an mdb file,
and what the adfvantages/disadvantages are? In other words, why would one wish to create
one, and what should inhibit one from creating one!
THanks

I have a form in (Access 2002 File Format) that has 61 combined Text
boxes, Combo boxes, and List boxes... 11 of those fields are in the
Form Header, the rest are in the Detail area... I also have 43 Command
Buttons in the detail area, each with a "strtextval" code to a certain

Please can someone help me here. This is probably pretty basic stuff
but i'm stuck.
I have a form that contains a list box. when i open the form i want
all the records within this list box to be automatically selected upon

Please help if you can.
I have a subform with a field on it that is set to have a required value.
The problem is that when the user does not fill out all the appropriate
information and tries to navigate to another record in the subform or main

Can I have this function look up more than one other field?  For instance, I
have a lookup now that does this:
   Me!Casting = DLookup("[Casting]", "Part# Table", "[PartID] = '" &
Me!PartID & "'")