I know how to append records from one table to another in the same database,
but I need to be able to append the records from all the tables in one
database into new empty tables in another database.  The tables in the
second database would have the same names as those in the ...

I have a continuous form with the following 2 fields :
Policy Number (combo-box)  ... Bound field
Customer Name (combo-box) ... UnBound
Data source for the form is a table: CashBook

I have now found that when a user, with Access 2002 Runtime, closes,
correctly, their database and then I look at Task Manager MSACCESS.exe
is still running. Unless that running process is killed the database
will not launch (i.e. Access won't allow a second version running?)

I have created two tables. Both tables have three fields in them, one
of the fields in each of the tables is a Key.  The two tables have a
1-1 relationship setup with referential integerity, cascading delete
and update enforced.

When I open a bound form like this:
   DoCmd.OpenForm "frmNotes", , , , acFormAdd
and the user runs the Spell Checker on a field in the form, the Spell
Checker automatically cycles the form to the next record when it has

Somewhat confused about which event to choose.  When moving from a Password
form to a MainMenu form should I use the  Activate, Open or Load event to
pull in the  MainMenu form.  Really not clear when to use each of these
events.

I have a form which calls up a second form for purposes of data entry.
When closing the data entry form and returning to the main form, things
don't work as expected.
When I return to the main form, I trigger the on acitvate event to run

I'm new at this stuff, so bare with me.
I have a main form which displays a client record.
The main form has 2 subforms.  The first subform has a list of Cases.
The Second subform is a list of Tasks.

My client wants to print reports that include a memo field.  Sometimes
there is just a little data there, and sometimes it is quite long.  Is
there code to resize a report control bound to a memo field, which
resizes according to the length of the text string in the memo field?

I need to return an array of string in my own split function (access 97). I
have defined the function as below but I get err on 'As String()'. What can
I do to make the function return an array of strings?
Public Function Split(ByVal strIn As String, Optional strDelimiter As ...

Is there a way in access 97 to pad a string with spaces such that the
resultant string is always x characters long?
Thanks
Regards

Is there a way to split a multi-line address field into individual lines of
address in access 97?
Thanks
Regards

Is there any widely acknowledged official international certification
you can get as an Access developer? Something well beyond the small
access componant in the MS Office cert...
I need a benchmark to shoot for!

Hello Fellow New Group Folks,
Here's today's problem.  I was called in to help convert an Access 97
database to Access 2000.  99% of all my Access Dev. work has occurred
in 2000, so I know very little about 97, however, from everything I

is there an easy way to evaluate a calculated control step by step?  i have a
lot of long expressions in a lot of my controls and if there's an error,
tracking it down is a PAIN.  excel has a built-in function for evaluating
formulas... does access?  thanks.