Excuse my noobness.  I am managing an access database that is shared
by 4 users.  Management does not want to use any technologies outside
of access for this application (no SQL Server, etc).  I have split the
database into front end and back end databases and put the front end

Dear reader,
I make same changes via VBA in a table.
By editing the same table via a form I receive the massage:
The data has been changed.

I have a field name 'USER' in tableMAIN.
How do I replace the user names with corresponding user names. I can
do that in xl using vlookup but now I'm trying to find a way to do
that in access.

I am learning SQL from a book and one of the exercises is to
to insert multiple records in a MS Access table (Multiple-
record append query/Insert multiple records).
I am NOT using an external database.

I want to add a character to some fields I want to "push" to the end
of an alpha sort.  Anyone know what characters I can use?
Thanks,
Patrick

Does anyone have any access functions for quickbooks integration, or have a
link with access examples for some basic importing / exporting?
Many Thanks,

I'm new here and looking for some help.  I seem to have confounded the
office computer guy.
At work we are using MS Access 2000 on XP Pro Toshiba computers.  The
office programs run off a main access database with each computer

HI I'm trying to create an SQL query in access to lookup the a list of
all people together with the last date they visited. I've tried
everything I can think of but it's just not happening! Here's the jist
of what I need:

How can I reset this count?  My form is stable now and doesn't have many
controls on it, though obviously it's seen alot of deletions as the form has
evolved and this contributes to reaching the 754 limit.
I have tried exporting to another database and then importing it back with

I have a database being used by 30 people and is split between the
backend and frontend.  The database has the ability to send e-mails
through Outlook and I have even put Redemption on people's PCs as to
not get all the Outlook security prompts.  Here's the problem: Half

I am planning an Access database for a Hotel chain with several hotels
all over the UK. The required functionality is as follows:
1. A client wants to know the nearest hotel/s to a specific location.
2. The db user keys in the client's postcode and the system returns

I'm trying to create a new email message from Outlook based on a query
called Q_Email with the BCC field populated with the email address
field in the query.
When i run this code, the query ressults pop up with a message saying