I have a form that contains columnars and a datasheet as subform.  The fields
in the columnars are the same as the fields in the datasheet.  
When I add a new record in the columnars and click Save button,  the new
data will show up in the datasheet as I use "Requery".  There is ...

I have code like this to import from excel into access:
SELECT INDEX, ...DM
FROM [Excel 8.0; Extended
Properties="";IMEX=1;HDR=Yes;DATABASE=C:\Data\Invoice.xls].[BASE$]

I am trying to use the CommonDialog control but every time I try and insert
the ActiveX control onto a form I get a message saying I dont have a license
to use the control.  Since this is a publicly available control by created
by microsoft why should I need a license?  I have ...

I am trying to write codes that when a user clicks a record in a datasheet in
a subform, and the matching record will pop up.  
I will appreciate anyone who can give me a hand.
Best regards

I'm trying to create a command button that will copy information in 2 fields
simultaneously from a form to a subform. I found an example in another
database that looks like this:
Private Sub cmdEnter_Click()

first of all, i hope to be able to explain what's on my mind...
I have a db (Access2000) for which I have builded a specific workgroup file
(wrkgrp#1), with different groups of users and different permission to each
groups. Admin user and Users group haven't any kind of ...

I am trying to return the top 10 records per grouping level.  My table is
tblScores which contains NAME, DATE, SCORE.  I am trying to return the
previous 10 scores per Name. Any idea on how I could do this.

I have a date field and want to set the field format like  "__/__/05", so
that the user does not need to type the year each time.
Thank you for your help.
Best regards,

Can someone please help me with the coding to use to find and replace a
value from a table.
I know it can be done by using the actual find and replace box but I have
looked everywhere but I cant find the coding to use in VBA to perform the

I am trying to print a report when the application start
up using the AutoExec macro.
The following line gives a Action Failed error, but the
report prints OK anyway.

How to read mac adres  and disk id from computer started Access Program

I have code that loops through some statements, previewing the same report
each time through. After the first report previews and I close it, the loop
seems to end and will not prewiew the remaining pages. If I insert a
Docmd.Close (report) in the loop, the report opens and closes ...

Who can help me with this problem.
I've got a few forms with the same subform on them.  I also use a shortmenu
on this subform.
So, If I want to open a second form after I choose an item I've got to know

Hi, I am trying to assign a variable the address of a collection object.  I
want to use one several possible collections in an argument list.  When I try
to assign the variable the address of the collection I get a compile error,
“Argument not Optional”

What I want to do is have MS Access application
automatically print a report at 8 AM every day or when
the computer is turned on.
Do I use some kind of batch file?