I would like to know what I needed to do to use this code again for a new
database?I have never used vb or access before!
Option Compare Database
Dim db As DAO.Database

How can I determine the actual length of a string stored in a
variable?

In the code below, I am adding specific records to SQL Server table linked
via ODBC to a remote website to by Access database.
Before I add a record, I check the SQL Table that it does not exist using
the DAO Findfirst method.  This works fine when applying against the SQL

If you provide a recordsource to a subform and the query returns no records
you can basically do a record count to determine if there is at least one
record.
I need a way to determine if the recordsource has'snt even been set you.

Dear Ale
I raised a query some days ago and u satisfied me. In continuation o
tha
Still a problem

I have the need to be able to have many users open a access db that only
contains a passthru query to a sql server. I do not however want to have to
visit each machine to install a DSN entry. Is there a way to do this?
My SQL7 server is named Radical if that will help in the ...

I have a contact form that uses a table with the autonum as the primary
key.  When a new contact is created a new number is created with the
autonum.
On this contact form I have a button for notes.  I user can enter several

I have a main form that pulls up data based on the user selection in the
subform (as data has one-to-many rel.) it pulls up 5 records related to the
item selected on the main form. I was using the datasheet view and ran into
problems related to the column header widths and ...

Is there a way to run the input mask wizard from code.  I like it to run
when a feild is double-click.  I searched other newsgroups and Vb help and
could only find how to open a form, table, report, etc wizards.
Any help would be great

I have a report panel with FromDate and ToDate fields to choose date ranges
for my reports.
I have pre-defined my reports with the FromDate and ToDate on the reports.
I created a tblParm with FromDate and Todate fields in the table.  In my

I have an Access 2000 file version application that I like to design on my
Access 2003 SP1 machine.  Lately, when I open a particular (most of them
actually) form in design mode and then hit Alt-F11 to open the VBA editor,
this error message displays (the dialog box is entitled: ...

I am having a variable scope problem with mulitple instances of the same
form. I have the following code to create a new instance of a form and add it
to a global collection of forms:
--------------------

I am working on a database that 3 people will be entering data into at the
same time.  I want to save the user ID of the person who entered the record
and the date and time it was saved.  They will be filling in information
for four different tables on one form.  I have two hidden ...

Is it possible to have in Access an array without prespecifying its limit?
I can use array(0 to 1000), but I know if one day if my array goes more than
1002 elements, my program will bug
Thanks for any suggestion!

Hi. I trying to set the BackStyle property of several controls at
once and opposed to referencing each control using the On
Click of a command button. I haven't had any luck. I've tried
some examples that I thought might work but...