The Query which is working fine in Queries section but doesn't show any
record while applied through recordset.
the Code fragment is
  Set Cn = New ADODB.Connection

I have a problem with setting references between library databases when
I move them to a different location. I thought that as long as the
relative path remained constant, the references would remain intact,
but this doesn't seem to be the case.

Thanks for the replies regarding adding fields on the fly. .. I'm now
managing that.  I can't seem to do something that ought to be more simple,
that is to give the user a list of current fields in a table!

I have 2 signed databases (Microsoft Access MDE) with digital signature
in Office 2003.
On a client machine (with security HIGH & MEDIUM) one database opens
without any problem, the other displays the message "Microsoft Office

I am very new to access and yet I have been asked to "develop" a small
program with it that has several functionalities.
I 'm going to describe the situation here, maybe someone can launch me by
telling what to do, in which order and how ? Thanks in advance.

I wonder if someone can help me please.
I have developed apps for small business on a bespoke basis for a long
time. I have usually gone along to the client to install the apps. My
client base was such that they usually had Access pre-installed on

Has anyone used this utility or know much a/b it?
http://www3.bc.sympatico.ca/starthere/findandreplace/
or the one from Rick Fisher:
http://www.rickworld.com/products.html

A2003.  This is driving me daft and from google, and, I see, others in
the past as well, in versions of Access from 97 to 2003.
I'm trying to change the tab index of controls on a form.  Actually, for
the moment, on one tab of a tab control.  I've tried:

I have an application that uses various popup forms.  All of these
forms are maximized when open.  When they open you can see the windows
start button and quicklaunch toolbar, but after a minute or so, the
popup form takes over the whole screen and the user can't get to the

I know that it is possible to generate an email letter and send it from
VBA behind a form.  I've done that.  However, is it possible to create a
DRAFT email letter and leave it in the Drafts folder (in Microsoft
Outlook)?  If it is possible, would you share the source code with me?

Non-programmer here again because my developer stinks. I'm desperately
seeking a solution to this issue:
I need something in the open event on my main form that will cause all
of the tables to delete after a set period of time (7 days).

i have a table that contains a date the record was created
after three months i want to review the record and enter a review date
(no Problem so far)
i now query the table adding a field(test) that takes the review date

A bit off topic but...
Converting an Access database to VB.NET keeping the same SQL Server
backend.
Crazy?

Hi -- I have an Access 97 application with lots of forms/reports/VBA
code.  I am in charge of maintaining it even though this is not my area
of expertise (I'm normally a .NET programmer).
So .... I have gotten an old copy of Access 97 and installed it on a

Hullo Everybody
I am trying to send a email from WITHIN Access 2000 with a report
attached that is generated WITHIN Access in the normal way, but all the
help examples I have seen uses an external file like C:\test.txt