I have a database system of three table consisting of partly identical
information.
Now I want a few things:
-I want to select the rows from the tables that are present in all three

Hi - I have been upsizing a complex application to an ADP app (Access
2003 and SQL Server 2K) for the past few months, and have reached an
impasse that I can't just seem to get past, and am hoping for some
help. I have a form based on a view with several listboxes and subforms

Folks,
A pretty basic question... how do I set a binary field to NULL ?
Simple assignement is clearly not correct, I get the following message:
You tried to assign the Null value to a variable that is not a Variant

Does anyone have any information regarding running both db's
on 1 server?
I work in manufacturing and a current expansion project
involves 2 different vendors using these databases for their

Hi - anyone out there that can help a tormented soul??!!
I am in the process of doing my first MDB to ADP conversion, and have
come across my first sub-report which I am trying to pass parameters to
via a SP.

Most of my MDB upsized ok but I cannot figure out how to read some custom
database properties that I use.
Example
   'read version from Database, Properties, Custom

I am converting an Access 2003 app to an ADP/SQL Server app.  The
application was created by someone else.  There are several forms,
queries and reports that call a VBA function that contatenates a
person's name in a presentable format (it deals with whether they have

I read your response on upgrading Access databases to SQL 2005 Exp.
I could not find any information on the upsizing/upgrading MS Access 2003
database files to new SQL Server 2005 Express type. I am a novice in this
topic, therefore I need step by step instructions. I am using XP ...

Folks
I'm having a performance problem with an ADP project I wish to submit
to your collective wisdom...
In summary I have a search form and a detail form connected to a fairly

I keep getting the Error Message: "the data was added to the database
but the data won't be displayed in the form because it doesn't satisfy
the criteria in the underlying record source"  I am using a SQL Server
backend and Access 2003 forms.  This only happens when I am finished

I have a report in Access2002. The source of the report is a query on a SQL
server2000.
By opening the report, I want that there appears a dialog box, so the user
can type some text (for example: a title for the report). The typed text has

I have a function that checks the ADP SQL connection using:
CurrentProject.Connection.State
I trap the error and return FALSE.
I would like to present the user with some detailed information

How can I register msado21.tbl in a  access xp runtime running in windows
98.

Hi.  I have a combo box that is based on a view. The combo displays a
beginning time and an end time for a class.  I have the datetime field
converted so that it displays only the time as such: CONVERT(nchar(20),
dbo.tblClasses.BegTime, 108) AS Beg_Time.  This displays the time in

Hello. In a combo box, i show the cost for the class which is a money
column.  In the display of the combo box it shows fine: $250.00.  But,
on my form, i have an unbound text box that displays the cost after a
class is chosen from the combo box. But, it is not displaying it