I found this code and its what I need it to do except I am getting an error
(0) when I run it.  I am calling the code as follows where the file name is
loan.xls and my table in my database that I want to export is Loan1a. THANKS
Any help as to why I am getting this error would be ...

i'm still getting compile error on dim stmt below, even after setting
reference to MS Lib 11..any ideas? (access 2003)
Dim dlgOpen As FileDialog
  Set dlgOpen = Application.FileDialog( _

Does anyone have code to build a table from an excel spreadhseet.  I have to
use a date in row 1 to create a field in all table records and cells from
other cols  in subsequent  rows to build the rest of the data fields.  I will
be reading a number of spreadsheets in one pass, ...

Background
I have one table called Components. In that table I have the following
fields (and some more not relevant):
Comp_id  is Autonumber

I want to format specific cells which I exported from MS Access using
TransferSpreadsheet. Assuming I exported an entire table from Access, I now
want to format the first row in the spreadsheet with font color say "red" and
maybe have borders on certain cells etc.

Good morning:
I have a two part question. I need to manipulate a table name a bit and then
export it into a CSV file on my hardrive. I have most of the pseudo-code
figured out; these are the only (below) pieces that will be tricky for me. My

I have several queries and macros (relating to those queries) set up in
Access so that when I receive information from an email I can save the data
in Access and then click on a macro and have the information exported into
excel.  However, I would like to export three different ...

Group
Is there a way to use the DCount() function using a path statement.
Something like this numRecords1 = DCount(1, "I:\Data
Bases\DataFiles\Subdatabases Before Merging\Work in Progress WHIP.mdb

Hi, I would like to execute my Access Database.
I want it to go to switchboard directly without opening Access. So that,
nobody can change it.

I am trying to create a combo box that when a choice is made from the combo
box you can click a command button to output the selected record to a new
form. I have this working on one table but when I try to recreate it for a
separate combo box and command button it still refers ...

I am working on an existing database that has over 500 forms in the front-end
and is linked to various back-end databases (some Access, some SQL Server,
some MSDE, etc.) I have a customer who has bought the application, but wants
all the data to be entered in uppercase ...

I have a form that is used to lookup a specific record in
the underlying table based on user input in the Text1
field.  When user input does not match any record on the
table, an error window pops up detailing the error, and is

In a form, I enter a number into a field, what I have is many records, and
lots of  duplicate information.  It is a database of vehicle information.  
When filtered down to a particular Model I may get between 1 and 100 records,
what I need to do is use that entered number in the ...

I need some help.
Every time I try to compile I am getting an error message "You canceled the
previous operation" - even if it's the firs thing I"m going.
Earlier I got an error that said 'couldn't find module'. I think I deleted

I have a button on a form. When I click the button it
opens a report. What I would like to do is close the form
after the report has opened. I used the code below but the
form won't close.