The hardest part of Access 97 ADO is to make the connection?
Also, is the reference to MS Object Library 2.8 OK

How do i calculate a weighted average for a range of data records

I have written a module which runs an access query and then stores
the result of the query in variables and at the end of the module I
assign those variables to a particular cell in excel. The variables
are set in a Do Until loop on an access query. What i want to be able

I would like to create a simple database for my school using. The database is
for using in my computer lab. The data should include time entering the lab
for student and teacher, and using the computer to access the web site. So
how to start to build that database.

I am using a Treeview control on a form.  This works fine.
One thing I have noticed is once all the nodes have been added to a 'branch'
my database seems to stop and think about it for a while.  This can be
anywhere between 30 seconds and 3 minutes.

I have an unbound control named INCLUSION in a report named SCHOOL_FTEs that
I want to populate with a value from a field named CountOfINCLUSION from a
query named INCLUSION_TOTALS, which is not the Record Source. I have a macro
set up to run the code listed below when the report ...

I feel like I'm so close, but somethings missing.  I have an unbound data
entry form, and when I try to add in the info (using a recordset from the
linked table) everything seems to work - except getting back the sequence
genereated PK.  I have tried this:

I want to reference text boxes on a subform from the module of the parent
form.  To make the control visible I could use the following code:
   Me.sfHolder.Form.txtLine1.Visible = True
But, how can I use a variable in place of txtLine1 so I can use a Do/Loop to

I need to export all the code from an Acces database to txt files. I know
how to do it manually, but I need to automate the process. I don't know
Access object model very well and all I could come up with was to use
CurrenProject.AllModules and OutputTo, but I need to export Form ...

I am using Access 2000.  How can I varify that a variable is not null with an
IF statement?  Seems like the following code would work but ISNOTNULL isn't
the opposite of ISNULL.  What is?
If ISNOTNULL(Variable1) then

I have recently enhanced my BrowseForFolder approach to include the
'NewDialogStyle' thus giving me the ability to show the 'Create New
Folder button'. Essentially, I am very pleased with the results but
have two areas of concern, which I will detail further on:

I Recently install a trial version of 2003 upon the end of the trial version
I tried installing my 2002 version and everything works fine but I can not
install access I keep getting a era message indicating the patch is no longer
avalaible.

Thanks for any help.
I inherited a large database, and only use a few of the tables, forms, and
queries in it, so I thought I would make a copy, and in the new version,
delete all the unnecessary stuff. Please don't laugh.

Hi
I am trying to set the property for a currency field and i am getting tpe
mismatch.
This is a part of code doing currency data type formatting

Is there a function that return the charcode of a string?
It would be a kind of reverse Chr()
Thank you