I've got three columns:
first_name,
last_name,
p_picture.

I have just converted several Access97 DB's.  Now that they are converted I
can no longer use the 'F8' to step through the code when I am in the visual
basic window.  I cannot seemed to figure out why

My Access 2003 book says I can use the OLE DB Provider for Microsoft Jet to
connect to a dBASE database.  I have tried the following but get
"Unrecognised database format" error message
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source

Access2K/2003, Win XP Pro
I need to be able to:
list all files in a spcific folder.(I'd like to perhaps send a folder name
as an argument)

I'm working in Access 2002 with a database created in Access 2003.  In 2003
I used a MID function to parse a filed within a query.  When I try and run
the query in 2002 I receive the following message:
Undefined function 'Mid' in expression. (Error 3085)

I've scoured the forums for an answer to my question, but am wracking my
brain trying to get a Where Condition to work properly.
I want a report to print out records based upon a date range.  I have a
button on a form which the user clicks that launches a "report format" form.  

Does anyone know if Access VB code can be used to export a CSV file to an
anonomously secured FTP Site?
I've tried using the TransferText method, but get "Run-time error '3011':"  
The Microsoft Jet database engine could not find the object

I am creating a Supplier scorecard database which tracks the monthly scores
for each Supplier. I would like to create a drop down menu in the Main
Switchboard which will allow the user to choose a Supplier out of the
Supplier list. Once the Supplier of choice is chosen, I would ...

I have a network database that users enter information into.  I want to run
the crossmatch on the info entered and then I want to fax information back to
the customers using WinFax.  My computer is the only one with Winfax and a
modem.  

Where would I find good information on the 'proper' uses for Excel vs
Access?  I'm ready to start a project (user requirements are collected), but
not sure if I should use Access as the main source (with Excel helping out)
or vice-versa.

When I send an HTML e-mail, I must display the message, for the body to be
placed in the email. If I comment out the .display, the body of the email is
blank. I'd prefer not to display the message.
below is my code.

I have a subform showing the time and date worked for a volunteer or other
worker, within a form showing individual volunteers. Sometimes blank rows are
added to the activity table or incomplete rows are added. As an ex-mainframer
I expect all editing to occur when the enter key ...

Hello.  I am having problems with a database query in Excel.  I am using the
code given below to input data into a database using VBA.  I am storing a
number given with two decimal places (55.55) in Access as a 'Number' Data
Type with 'Single' Field Size.  I am then extracting ...

This Select Case statement isn't returing the desired results.  I'm trying
for, in case 1, when the expression evaluates to True, return "Direct Ops
Expense".  What am I doing wrong?
Function RowDesig2(AcctLvl1 As String, FuncGroup As String, Prod As String)

I need to create a form with a multi-select listbox (items are SELECT
DISTINCT from another table) which passes the user-selected items to a
make-table.  How would this be done?
thanks in advance...