I'm using the API @ http://www.mvps.org/access/api/api0001.htm? and it
displaying the files in the directory that I want.
How do I then import the Excel file the user chooses?

I need to copy all files not having an .html extension from one folder to
another folder.  What's the best/easiest way to do this?
Thanks!

Is there a shell command syntax in VBA that will close all open instances of
Adobe Acrobat?
I have a routine which prints reports to PDF.
Users then generally open the PDF's to check them.

All,
I was wondering if someone might be able to help me with how to properly reset a required date field after you've moved on to a subsequent fields.
By that I mean if you have six fields on a form:
Field1 - Memo Field

I know that I should know this, but I am having a complete dumb moment.
Here is a simple example.
I have two tables.  1st table has red, blue, green, yellow, orange
2nd table has red, green, orange

One of our users is getting the following error when she tries to send
out Auto Emails.  This error comes up at the part of code
"domSession.Initialize ("")", we use Lotus Notes 6.5.4.  The Auto Email
works on other pc's including mine.  Her actual error is as follows:

I need to break a 9000 (it might be larger later) into smaller tables
containing 700 records each. Each table would be named, say Toys, serialize,
Toys1, Toys2, etc.

Is there a way of running JetComp from a VB6 app without requiring any user
intervention?

My application extracts data from linked tables into local ones. Users take
their laptops and work disconnected on the road.
Some subform have controls (combo row source) bound to linked tables.  If PC
is disconnected from LAN, every time form opens error pops up from the linked

how can i use a more databases (in access) and see all in only one DATAGRID
of FLEXGRID
                                   thanks....

I need to define and save a 'specification name' for later use by a macro (in
my Access Project) that will import a text file every month. However, when I
am importing the prototype, the 'Import Specification' window (that opens
from the 'Advanced' button on the 'Import Text ...

In Northwind sample there are two tables called Categories and
Products. Both of which are related in One-to-many relationship - one
Category has many Products. I have a Form in which, I have two combo
boxes ComboBoxA (for Categories) and ComboBoxB (for Products).

I can debug.print a list of Query names, no problem.  But what I really want
is a list of the query decriptions I have added in.  Since Description is not
one of the optons I see on the list, anyone have a method I could use?
Thanks,

Hi
I'm using the following code to rename all Modules, the code is working good,
but I have
but I have to execute several times to change (re-name) all modules names.

I have a couple of questions.
First, with a time value is there any way via an input mask to have AM and
PM options available to the user. e.g. have it default to AM and allow them
to somehow toggle from AM to PM? Right now my only options are to force the