I have a situation where I am using an unbound dialog form to update data in
an Access 2002 split back end / front end scenario.  The data update is done
via  an ADO call (direct to the back end db) when the user clicks the save
button.  The dialog then closes and the user should be ...

I'm just getting my feet wet in Access 2003.  From what I've read so far it
sounds like I should change my day-do-day environment from 2000 to 2003.
My kneejerk is to stick with Tools|Options|Advanced|Default File Format=Access
2000 because of the backward compatability - so if I ...

I have a set of queries that I run that take some time.  I would like to
have a popup box appear while they run and then close when the queries
are done which open a second popup box.  My problem is this, if I just
open the popup form it is hollow because it does not come visible ...

I'm wanting some help on how to create a message that automatically
pops up on opening an access form, that says for example ' Remember to
.....'.  I've been able to this by assigning a macro then a command
button but need the message to be displayed as soon as the form is

Five years of development has us using a very large database (a
couple hundred screens) in one location, which is very managable.   Now
our company will be expanding to several distant states and wants a
live database throughout.

I have a form that has a Tab Control on it. On one of the tab control
pages, there are only 3 pages, is a combo box based on a field called
departments in a table.
When the user selects one of the departments from the combo box I want a

Windows XP Pro/Access2000/2.4gig chip/512meg RAM/200GigDrive.
I'm stumped.  I've been involved in other things lately, but came back to
the program I'm preparing and zipped into a report and it took FOREVER to
load and run (well, about 12 seconds, which SEEMED like "forever").  ...

Sorry if it is way to much information but I'm trying to cover all bases
Access 97
A= combobox that queries Distributor
B= combobox that limits customers by distributor in a

I apologize for cross posting, this is just driving me crazy. I have been
beating myself up all day trying to find one good example of adArray as part
of a parameter. I went this route.
Sub Test1()

I thought this was ok.... but... I get the following message: COMPILE
ERROR- EXPECTED END OF STATEMENT and the "Where" is highlighted. I'm a
bit of a novice at this so any help at all would be much appreciated!!
Thanks!

(1) I have an access form that allows users to enter data, and when
they click a button, the OnClick code that I've written uses a SQL
INSERT statement to insert the data into the database.  I come from a
web programming background, so please forgive me if there is some

I am using DAO in DB1 to copy certain parts of a table (TABLE1) from
DB2 into another table in DB1. This works fine but now I would like to
make a copy of TABLE1 in DB2 called TABLEBACKUP and then delete
TABLE1. I need to be able to manipulate the tables in DB2 from

I've been able, intermittently, to duplicate a problem a client had.
Two users editing the same field of the same record. One saves. The other
gets the 'another user has edited this record... do you want to save cancel
clipboard' message when they attempt to save

I want to insert a carriage return into a text field. I am using insert into
and \n for newline. The MYSQL database is accessed by a MS Access front end
and the text field appears with a small square where the new line should be.
It appears that the \n is interpreted in Access ...

Can anyone please tell me
How to use a select query to extract date from a Datetime field in Access 2000??
Thanks