I have 10 data bases all with the same structure that I need to
combine.  They are large enough so that copy and append takes a great
deal of time.

At the moment my co uses a spreadsheet to note how many orders each
engineer is assigned and this is updated manually. I've thought about
transferring this to Access and have thought of two possible ways, 1 is
clearly better then the other but goes beyond my Access knowledge.

I have a form that is an application.  I am able to pull an employee up
and then print the application using the following code that is
connected to my Print Application button on the form.
DoCmd.OpenReport"EA Completed

I use A97 and do not always insert line numbers while
writing procedures. I find it necessary to go back and
add them later to aid in debugging.
Nearly 3 years ago, something was mentioned in this NG

I'm looping through controls on a form, focusing on text boxes. If the field
is null and I'd like to throw a pop up letting the user know that this
"required" textbox is not filled out.  If I show the user
"control.controlname" then I get the txtThisIsMyField and it doesn't help

I found a post on this problem from 2004, but no one at that time
replied to it- I'm hoping to have better luck than the original author!
As the subject states, I'm running into a problem where the
msaccess.exe process does not end once a user exits a database. The

I have a simple issues database in which the issue can be assigned to
an individual via e-mail. The e-mail sendobject function is working
correctly, except that the notes from the memo field are being
truncated. The memo field can have an unlimited number of characters,

Brendan Reynolds posted the following function a while back ago:
Public Function HoursMinutes( _
   dtmStart As Date, _
   dtmEnd As Date _

I would like to populate a table with the following information:
tblPropertySettings
[strFormName]
[strTextboxName]

I've got a text field in an access form (Microsoft Access 2002, SP3),
that the user has to fill out. Now I don't want the user to leave this
field (and this record) until he has filled out the field  (which is
stored in a table) correctly.

Hi,
I have a form for data entry and noticed that when i enter data and
close the form, there is no warning and it writes directly to the
table(s).

My program developed in Access 2003 includes 2 MDE files. Both of them
are signed with VeriSign certificate.
Program was installed on 2 client machines with Office 2003. One of the
machines didn't have Access, so Runtime was installed, and the other

I am trying to link an access database directly to individual polygons or
points (PGDB) in Arcmap, that is when opened the   Access link would open
Archmap and then zoom to the polygons or points individual coordinate
assigned to that link.

I have a medium sized application - data is in back end on a NT4 file
server, front end on about 15 workstations. System was Access 97 on
W2000 workstations and worked fine.
Over Xmas upgraded all workstations to XP Pro with SP2 and Office 2003

I believe I have seen this in this group in the past but my search
comes up with nothing so far.
I want to prevent our Access application from closing without some
kind of confirmation from the user.