Using Excel Automation I am copying a range of values from worksheet1 to
worksheet2. I know the copy is working because when I print out the values
from worksheet2 the values that I copied from worksheet1 print in the
immediate window as expected. The problem that I am having is ...

I am getting an an error message with the code below.
"Compile error - Method or data member not found.
Error line  ".Edit"
I am using DAO library 3.6.

I need to find someway of entering a value (starting with 1 and then
incrementing) into a text box.
I can't use autonumber in the table as I need to be able have duplicates in
the table.  

The Access 97 Linked Table Manager was a good thing.  The replacement is
crap.  The 97 version would automatically adjust all links, if you had all of
them selected and all were found at the new location first picked.  The 2000+
version forces you to select acknowledge each one, ...

Is it possible to use code to modify references for an application?  Can I,
for example, set up some code that will run when an app is launched and, if
the user's machine has office 10 then a reference to Microsoft Office Word 10
Object Library will be selected even though the ...

i want to loop through records and assign numbers for each.  records are in
order and every group of records has one with a number 1 in "varnum".  i want
to fill in a a field, "aftervar", with the 1 and then with 2,3,4,5 and so on
until it reaches next 1, stopping when it hits ...

I'm trying to set up some tables and queries to give me the following result:
Beg_Bal   Date   Change  End_Bal  Days Share_Days
1000      1/1/07     0       1000         6     6000
1000      1/7/07    (85)     915         7      6405

Hi - I have an Access 2003 database that calculates time duration for
products that are checked-out and checked-in.  Everything works just
perfectly but then this is used in Arizona so I didn’t need to consider any
time zone changes.  Now they want to use the database in Texas.  ...

I'm using a treeview control wit several levels.
What i'm trying to do is that when i click on a node if this node has
Children>0 then clear all these children.
How can i do that?

I am having problems using an update query.  The code appears in VBA function
designed to send emails to employees.  I would like to have the query update
based on who the email was just sent to, so that i know that an email was
sent to that employee.  My code is listed below:

I am unable to run code to export data from a query to excel using
Set rs = CurrentDb.OpenRecordSet("qryLocations"), _
           dbOpenSnapshot
I am using a DAO connection in Access 2000.

In VBE|Tools|Options|Editor Format, there is a combox called indicator, what
is the function of this stuff?
Clara
thank you so much for your help

Have learned much programming here but don't yet know how to add a record to
an SQL table from Access. Here is my attempt, but am really guessing after a
certain point and would appreciate help:
Public Function InsertEpisode(PatientID As String, RefPlanNo As Integer)

I am creating a crosstab Excel worksheet from a query in Access. I would then
like to copy ranges of cells from the crosstab Excel worksheet into another
worksheet using Excel automation, but I am having a problem with the
automation commands to do this. Could you please tell me ...

I wanted to know how to write a Auto_Open macro in Microsoft Access to
automatically refresh in a excel pivot table?