Howdy All,
   Quick question: if you have a two recordsets that you've defined in
memory (i.e. no connection to a database file), can you join the recordsets?  
The only way that I know to do joins is by using SQL, but SQL seems to

I am new to MS Access and needs to know how to do conditional macros in a
big hurry for my school project. Does anybody know where i can find some
internet resources for conditional macros?
Thanks in advance.

We have two computers and two programmers. One programmer for Ms Access 2000
and one programmer VB6 pro and applicartion.
Access database is large system and i not will transfer data to MDB
directly, it is second programmer work.

Hi Folks;
Is there any way I can have one macro call several other macros in
other Databases? I'm using Access 2k in Windows 2k.
It's just pain in the neck to go to all these macros to update my data

I have created a macro to close one form and load a new
one. The problem is if the user hasn't specified a number
in the primary key field it throws up an error message.
Unfortunately this field needs to be user input and so

Does anyone know how to set the Access 2003 runtime
security level (to low) to avoid all the security
questions/prompts?

Hi!!
there is excel worksheets stored in OLE field in MS Access database
(inserted & created from excel file)
In table view I can click on cell and linked excel application opens

When I use the RunApp macro action to start a Microsoft
Word Mail Merge a second copy of the Microsoft Access
database loads.  It remains open even after I close the
Microsoft Word Mail Merge document & application.

I created (well copied from a book) a macro synchronizes
two forms.
The macro "Synch" is set as "OnCurrent" for "Form1"
It has one command "OpenForm":

How do i set the following properties for a field in VBA(Primary Key, Look
Up, Row Source Type, Row Source, etc)?
I am using an ADODB connection/recorset. I have tried using  
currentdb.tabledefs(i).fields(i).property(i).value but i don't get any of the

A command-line command "C:\PROGRAM FILES\MICROSOFT
OFFICE\OFFICE\MSACCESS.EXE" C:\SQLCDD\ALL_LNKS.mdb /X
TheBuild.GenerateSnapshot_4WIN95 /CMD FD*" that has been
running until we upgraded both to a new machine and

I program VBA Macros for forms in MS Access for adapting the forms to my
needs and for setting special filters by searching with DAO through the
tables extracting data as I  need or counting specific items.
The VBA macros I access through Event Procedures like On Click or On ...

I have 2 forms, Form A to call up Form B. Form A will be minimized on open
up of Form B.
I want Form A to restore on closing of Form B. I have a code to restore Form
A on activate event, the problem is how can Form A gets activated?

Rather than re-invent the wheel, I was wondering if there was an existing
user-level logon module that I could copy and modify.  I.e.:
Login(ValidUserGUID)
+ collect username

I am trying to  display a drop down list in one field
based on a choice in another field.  I can use a macro to
display the same value, can I use it to accomplish
displaying a drop down list?  If so, how?  If not, how