Access 2000 SP-3
SQL Server 2000, SP unknown
I bought the book when I created my first SQL Server application in 2001,
and it saved me many times over. I've been using code to populate combo

Please bear with me, I'm still fairly new to this stuff...
I have the following code in a subreport based on a View:
' ***********************
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

How would i send an email through outlook......from an access data project (adp) file

I have 2 combo boxes on a continuous subform.  The values
in the second combo box are dependent on what they choose
in the first combo box.
The record source for both combo boxes are stored

For years I have used autonumber fields as primary keys in
access database tables and I have used those tables as the
record source for the forms I create.
Many times I create subforms that link to the primary key

I have one adp project.
I have 2 sql servers each with a database.
Both servers have there own username and passwords
I would like to connect my adp project to both servers.

I encountered a very strange problem. In a adp I try to link to a database
on SQL server through menu item: File->Get External Data-> Link table.
However this morning something strange happened: the "Link table" item
disappeared, and only thing left is "Import".

Does anyone have experience on how to recover a corrupted Access 2000
project?
When I launch my ADP, my Startup form does not open.  When I try to open
another form, the project shuts down.

I am creating a temp table dynamically, the column names
and results are built on the fly, I then need to open that
that #table in datasheet mode.

I have a form where the record source is a stored
procedure.  The sp uses 5 tables although data is only
being changed in one table.
I can't set the unique table property because none of the

In Access there used to be a Documenter under the TOOLS
menu but since we started use an Access Project (.adp
file) it seems to be gone. Is there any way to print the
code behind forms and code in the modules?

I need a way to write a view that will select all the records posted since
midnight of the current date. The table uses a datetime field that contains
the exact time a record was added.  The best I've been able to do is to pull
the last 24 hours by using;

I am creating a new view dynamically in my SQL server
database.  The connection does not see the new view, so I
cannot do a docmd.openview on it.  How do I refresh the
connection so I can execute it?  I need some kind of

Is there a way to do this with DTS or another tool? I have an Access 97 app
and I'm converting the BE to SQL2K. The upsize tools all want to convert my
Access Text fields to nvarchar, but when I link them back to A97 this causes
problems. I manually changed a field to varchar and ...

I've created a Access adp database.  As administrator I can log in and run DB, but the user I added "JT" as a "power user" cannot connect to the tables. The Access adp opens, but I get the message "MS Office Access could not log on to the server. Verify that the log on ...