I am attempting to create a macro that amongst other
things opens to a specific file location or even better
yet, can delete a file on a network drive.
Is this possible?

Hi,
is there a way with VBA to achieve the following:
I have a picture in an excel file, and I want to insert it into an access
table. The records of the access table look like this:

I am trying to import a text file into access.  The
problem is that it imports all of the data into one
column, opposed to the five columns that I want.  How
would I go about fixing this.

RunCode will not execute my Function in my Module.
Access reponse: The expression you entered has a function
name that Microsoft Access can't find.  I am using
Microsoft Access 2000 (9.0.2720)

I would like to know the way to control an AUTOINCREMENT value of
table..
I need to do this:
when I delete a row from the table i would like to update th

I posted this before on the programmers and got only one reply which
did not work.
Working on marathon runners race timing results. I have created two
tables, #1 has racers demographics (age,sex,bib

I need to protect all the tables and forms in a database.
But I need different login and password for each
table/form. The security function in MS Access dont work
properly. Is it possible to create this security by using

Hi,
Is it possible to cause an existing macro within an access database to run by somehow calling it from an external batch file irrespective of the database being open or not. Any help on how to do this would be greatly appreciated. Thanks

I have the following line in a module:
Dim dbsnightly As database
When I try to compile the module I get the message:
User defined type not defined.

I am using openquery to run a delete query and an insert
query. They generate messages like "You are about to
delete X records" or "you are about to insert X records"
or "Cannot add a record due to duplicate keys". Can these

I've had a look through all my books, I've scoured the excel help files
but to no avail. I am trying to make use of arrays. I want to be able to
use an array of 5 rows and 5 columns in an EXCEL sheet and then use them
to sort a big data base. BUT I can not work out how to ...

I am extracting records from an external database and I want to write the
results into MSAccess tables. I am able to do this using the following
example code:-
Dim db As Database

Can I use Macros to calculate running totals?
Example:
Qty    Cum Total
2         2

I have a MASSIVE delimited text document that basically
contains the Buys and Sells of stocks in an account.
The idea is that the buys equal the sells in quantity and
average price.

I am trying to set up a system that will automatically import an excel file into access and print a few results.  The problems that I am having
1) I want it to automatically set a field to be the primary key somehow (can be code, thats fine, i just don't know that much about code