My code creates a table for a report to use as its Record Source and I want
to delete the table when the report is closed.  I have tried the following
code:
DoCmd.DeleteObject acTable, "My Table",

How do I format a number in a query so that I left fill a number with blanks.
In other words if I have the number 22 I want 9 blanks in front of it. If I
have the number 101 I want 8 blanks in front of it. If I have the number 7 I
want 10 blanks in front of it. I'm using Access ...

Within Access I want to activate a certain application. This application is
runniing twice for different countries.
Depending on some parameters it should activate a specific language version
of the application. The problem is that the applications have the same name.

What is the difference between the Close event and the Unload event?
Thanks in advance.
DEI

I am using a subform and having users check off items in a schedule as
complete in a check box.  Afterupdate, code executes that bookmarks the
current record and scans through the list of tasks to verify which task was
the last completed item in the list.  The bookmark then ...

using access 2002, i would like to add - on opening a form - an entry to the
list of autocorrections and by closing the form, i would like to delete the
entry. anyone knows, whether this is possible by using vb code in the opening
/ closing procedure?

I'm using the MACRO to import data (Excel file) into a table.  It works fine
at
the past but found error message to "The Microsoft Jet database engine could
not find the object". Make sure the object exists and that you spell its name

I have a macro which import a dbf file in Excel. I would like to be able to
convert each row that have a format D 8 0 as a date format in Excel. It
doesn't seems possible to get the D 8 0 information when the dbf file is open
in Excel. So, I'm wondering if it's possible to open ...

I have an application that is controlled only from a commandbar and I can not
access it via VBA code.  I am use Access OLE to interface with a Visio
program and I am trying to control an Pen Ink object.  I have posted this
question on Visio for over two weeks with no reponds.  ...

How can I access the content of a given row or at least the previous one
programatically in an opened form?
What I need to do is to fill the default value of a field with the content
of this field in the previous row.

I'm building a database for managing a service department.  I'm sure Access
can look up data in Peachtree Accounting.  Can anyone provide me with
references on the internet that can help me set this up?

I'm really making some strides with this database, thanx to long hours and
everyone on this board, many thanks.
On to the new question. I have a table in my database, each record has a
"commited completion date" field and "On time" field. The requesting

Good morning,
I would like to be able to change the path of all the linked tables in the
front-end of my application so that when I deliver it to our secondary site,
it is ready to go. \

I seem to be having a little problem with a date/time field while running my
SQL in VB.  The SQL works if I remove the WHERE clause which is a date.  If I
manually run it in a query it works file, but when I run it in SQL and pass
the dates in a varible it errors.

I'm trying to use a recordset to insert values into my access table.  I can
get the insert working somewhat correctly, problem is that the inserted
records are all the same.  I believe my problem is in my loop.  it seems like
I need pointers to cycle down through my recordset ...