I can't see my posts once i've posted them

I've got an Access db that has many different relationships between
tables, for example, books <-> book_author <-> authors <->
author_institution <-> institutions.  If I do an export xml from the
toolbar, there is an option to choose which data to export, for

I'm having a little problem with this Update statement and have been
toiling away to no good.
Could anyone please correct my syntax. Here's the code:
       CurrentDb.Execute "UPDATE JVTable SET JVTable.INV_DATE = " &

This may be a really simple thing, but I haven't found the answer.
Perhaps you'll tell me my approach is all wrong. Either way, I am
stumped and need some help, please.
I have multiple, similar 'dashboard' type forms that call code, open

I'm having a problem with MS Access 2003 and its conditional
formatting.
I have textboxes on a continuous form whose left and right margins are
set to 0.03 inches.  Based on each textbox's current value, I set its

I have to build a database for Hotel on line availability.
Is there someone that know some good example of database tables design
in Access I could check before to try something on my own?
I really have, in this moment, any clue on how to organize date

I have a database in Access 2003 that was originally developed using
XP.  When the database is opened on a Vista computer, the font size in
a report or form is bigger.  (The reports/forms don't look right
anymore since the words are cut off, word wrapping etc..)  However,

I inherited an Access 2003 database with this setup:
TableOne
TableOneId    pocOne    pocTwo
1                  2             3

ms-access97 & sql server2005
two tables
    tblItem
    tblItemFeature

I don't have a great deal of experience with Access so please excuse
my ignorance.
I have two tables:  Asset details and Department details
More than one (up to five) departments may be responsible for one

I've got this supposedly easy problem of redirecting all of the linked
tables and pass-through queries from reading from production-database
to test-database. Unfortunately I'm no real access-hero.
The setup is the following: There's an access-2003 mdb-file containing

how to access the notes view programmatically

Hey Guys,
I hope I didn't miss a post on this subject already.
I am using Access 2003 through ADO.
I have query 1 (MergeThisLastSeason):

I am working on a user interface for a lab database in Access 2007.
The 9 tables with the actual data are in a back-end database and the
forms are completely separate. My forms reference local ADO
recordsets.

Is there a way to merge data to an eMail?  I have 10,000 students in
our current class registration system that we are going to shut down
in a few months.  Each student has history of the courses that they've
taken that are kept in our current system that will not be ported over