Using Access 2K2. Experience level: beginner
I copied the Customer Phone List form and macro from the Northwinds sample
database and modified it to use as an email address filter form.  It works,
but not cleanly.

I posted this in the Forms Programming group, but no
response yet.  Maybe this is a better newsgroup for this
question.  I have a main Form with two subforms.  I want
to add two Command Buttons; one Command Button to go to a

How can I scan Macro Code with Access Basic (Access 97).
I need to check for hardcoded path settings because the customer wants to migrate to a different folder structure.
I already know how to scan modules, form code, report code. But the Scripts collection does not work this way ...

Is it possible to create a macro (or a vba sub)to export the result of
a query to a csv file.
How should I do it.
I am using Access 97.

On another matter -- apart from my previous post... is
there a way to disable the confirm boxes.  If I run a
macro to delete records, it confirms that I want to
delete and since it is on a large number of tables I have

We have CBT taining, which enters a date in a field once
you completed that training.  Because it is on the LAN
and the training officer doesn't want us to have direct
access to his Db... he exports it as a Excel

Is there a way in Access to put the user's name in a msgbox.  I know i
Excel you can just write
MsgBox "Good Afternoon " & Application.UserName & "."
However, I've found in Access it's not the same.  Any sugestions?

I would know if it's possible with a macro copy a table of my loca
database "first", in a database-copy on the net, in a ftp space.
thanks a lot
-----------------------------------------------

Is there any way at all to convert a record from a form
screen to a pdf format with a single button click??
TIA

I need to import data from a dbase 5 to a Access database. That doesnt sound like a problem, but when performing the import Access create a new table. I want it in a specified table as an update of existing data
Can anyone help me with this?

I have a form called Tickets.  There is a combo box
called ComboAssignedTo which allows me to select one of
three people.  The selections are actually their e-mail
address. There is also another combo box called

I want to be able to copy a record from one table and
place that record in another table and deleting it from
the original table in the process in a click of a button,
is this possible?

I posted a question last week, got a response, tried it,
it doesn't work.
What I'm trying to do in brief is click a button on an
access form, open Excel, download a report from my

I am simply trying to validate data in a form before updating.  I can get the macro to run on the required condition but I can't get the desired result when "Cancel" is selected in the dialog box.  Action Command - RunCode - MsgBox("Questionable entry, do you wish to save ...

Customer complaints are entered into tables.  How do I
flag the user, say via msgbox, that there have been 3
complaints for a certain product (field 1) on the same
best before date (field 2).  Either in a form when the