I'm using Access 2000 with XP.
How can I detemine the biggest number in a text field that has both number
records and text records in it?  When I use Dmax function I get the following
error "Run time error 13: Type Mismatch"

I want to be able to delete a table and not be prompted with any
questions.
Can someone help me?

The following Insert statement gives me an error message when the last name
is Like "O'Brien". How should I change the formating to remove this error?
   sql = "insert into data_BCFP (BCFP_ID,last_name,
middle_name,First_name,birth_day,secondary_id,comm_id,Marital_status,gender ...

Using Access 2000 I am trying to export  Access query results to Excel where
I would like to create a chart. I would then like to import the chart into an
Access report.
The query and export section of the following code is working. The query

I created a crosstab query, added in the Design mode parameters and without
any problems I can open it when the form containing parameters is open. But
when I would like to start the same query using an ADO command it always
generates an error (missing parameters). Do I need to ...

Hello friends, I have a problem. I hope that you can help me.
My problem is that I need to create a connection ODBC in run-time. The
application is an Access file that runs a VB code. The code that I run is:
#If Win32 Then

Why doesn't my mouse scroll function work in MS Access code editor?

Does anyone know if there are issues using the Output method to save a report
to a snapshot file when the report you are generating is based on a parameter
query.
I am getting error messages when I try to do this and the only thing I can

When connecting to SQL Server from Access, how does one connect using Windows
Authentication rather than a login name and password? Is it possible or do I
need to have the Admin give me an account?
Thx,

I am looking for a way to change the no of columns programmatically when I am
opening a report in preview mode.  Any ideas?

I am trying to references a class module in another database
Dim da As NTier_Essentials.DataAccess
Where
NTier_Essentials = Project name

I am a newbie to VBA.
I am trying to find some code samples that would update the records in
table"a" from the records in table"b" or the title of a reference book
that would help me solve this problem.

Last week, I got an advice from this forum on how to find out the performance
bottleneck of a report.
It suggests adding a debug.print in each on_format event for each section
with this syntax:

Hi
Hope somebody can help..
I have used transferspreadsheet to export 38 queries to one excel
worksheet... by adding a4:1000 and gone up by a thousand resulting in blank

I need some assistance. My boss wants the database that I am creating to do
some automatic backup before the user actually
uses it. The user will have a form where they will input 2 dates, a start
date and end dates. Depending on that date range,