I am trying to export a query from Access 2002 to Excel 2002 using VBA where
the query result has just under 30,000 rows. The following error message
appears -
'There are too many rows to output, based on the limitations specified by

Using Eval(Replace([fruit],X,*)
10 X 10 = 100
But how to make this
When i type 10 X 10 automatically ==> 10mm X 10mm

I have added a frame to my form and now want to find a specific record in my
Cash Reciepts table to update the proper balance.
I previously just used
rst.movefirst as this was the only account that we deposited to.  

I presently have a macro that is run via clicking a form button. I need to
automate the process by replacing someone having to manually click the button
with an input from a photo eye switch, or proximity switch. My initial
thought is for Access to constantly monitor for a 0 or 1 ...

I need access2003 to generate a unique random number that is positive and at
least 6 digits in length

I'm having problems(SYNTAX error messages or wrong text added to database
table) when I use the following UPDATE and INSERT INTO SQL statements in my
VBA code, why is this?
"INSERT INTO LogIn (UserID,PW) VALUES=(txtNewUserName.text,CurrentUser)"

Hi I have some VBA code building a query I run the code to add a new record
this works fine what I need to do is edit the a record in the same query, if
the record already exists I want to edit it if not add it.
I have been trying to use the find a bit like in DAO with findfirst ...

I know absolutely nothing about Access, but get to support it. I have a
client that was just upgraded to Access 2003. He has a database that he is
getting a runtime error on all of a sudden. It happens after the delete
confirm event. It says runtime error 2424 - the expression ...

I'm trying to test for No Current Record in a DAO recordset. It happens
when my strSQL returns a blank recordset from the db. I was trying to use
IsNull(rs(0)) or IsNull(rs.Fields(0)) but they don't work. Any suggestions?

Looking for some help, I have a report with an unlimited amount or rows. Each
row has 9 text boxes. I need to somehow write a code or expression that will
do the following for each of the nine text boxes found on a report line.
textbox 1

I have a command button on a form that I am using to open a report showing
items to be despatched on a job. I have the following code on the click event
Private Sub btnDespatchList_Click()
   Dim strWhere As String

I want my database to suggest the next working day to a user for an
appointment, excluding weekends and holidays. I have seen the code at
http://www.mvps.org/access/datetime/date0012.htm but not sure how to utilise
this?

I would like to disable access to the database window for a general user, but
allow an admin user access.
I know about the Special Access keys under start up, but my understanding is
that this is a global, rather then a user specific, setting.

How to type a control source or field or a form where they have spaces
between the words in vba?
eg codes and product
if

I would like to compile a table showing the path and db.name for all linked
tables in the db at the time it is opened. The linked table manager list
does not permit viewing the entire string and the dialog can't be stretched
to accommodate the string.