how do i check to see if an excel book is in a folder?
i am automating a process for non technical users and if a workbook exists,
i want to delete so they do not have to respond to the message already exists.
i am using a generic workbook during the update process as a work area

Any can help me to correct my coding ?
**********************************************
Dim dbs As Database, rst As Recordset
Dim strSelect As String

Two problems: the first is more serious as I haven't got even a workaround at
the moment.
1.  A user is unable to open any report in preview or design mode (also
probably print mode but I haven't tried)  This happens for either an mdb file

I search around for qutie sometime and still cannot find a solution to this
problem.
I have a db that runs query reports with month and year as criteria and a
number of excel workbooks named "Report MMYY".  What I want is a code that

Hello everybody, I'm making my MP3 collection db importing xls files created
by an MP3 tag editor. I have the following code to append the xls file to my
access table and everything work fine. Since the last row of the xls file is
always "this list has been created with..." I'd ...

want to check for a specific value in col 1 and row 1. if that value is not
there, will cancel the operation.
how do i check for that value?
tried this

I use this code to get the hours in a contracts
Set rst1 = CurrentDb.OpenRecordset("Select count(PeriodNo)/2 as hours from
IERSPROD_TOFFERSLOT Where OfferCD = '" & sOfferCD & "'")
rst1.MoveFirst

Half-way through my code, the user needs to supply information from a
combo-box.
How do I pause my code while the user makes their selection? I cannot use
InputBox or MsgBox, since I need the combobox object. How do I open an

I have an unbound form with a multiple select list box (lstClass) and a
command button (cmdOK). I am trying to select row(s) from the list box and
build up a Where string and then apply that "WHERE" criteria to a Select
Query (qrySupplierTEST) to get my desired records.  Once I ...

Problem:
I have sereral files with simular names.
I would like to be able to replace part of the file name with a persons name
I want to replace the "Master" in the file name with [LastName]

In inStr function and using it has always caused me a headache.
I did the following to get the [personName] from the datafile path.  I would
like to know if there was an easier way to accomplish the same.  
------------------------------------------------------------

I'm using Access 2003 and trying to create a linked table from an AS400
database.
Here's what I have that's not working.
===========

I have a procedure which opens an Excel template, adds data, and optionally
saves the Excel file. I can sort the sheet from the Access code, but it only
works the first time Excel is opened in the current Access session. If I
close Access and Excel, then reopen Access and run the ...

I am using the code found in Access Web to automate Relinking Tables
http://www.mvps.org/access/tables/tbl0009.htm
Problem:
The backend database is password protected

Good Afternoon,
I have a question i cannot seem to answer.
I have 2 arrays and a loop that perform certain functions, and when i call
this sub, i get and error message stating: "Compile Error: byRef Argument