I have inherited an Access db that hides the menu bar.  It has a small custom
menu bar of its own, and this is seen by users only when in the db.  About 30
people regularly use this db.
For one user only, when she opens any other db in Access, or creates a new

How do i remove a message from the outbox? sent items file showsmessage sent

Im used to using Informix/Ingres SQL so sometimes the syntax in access VBA
confuses me.
With the tables below the relationship is 1 row (tblStudent) to MANY
(tblStudentDeliveryResults)

I have recently purchased Office Access 2007. I am trying to read a
MDB that I created in the prior version of Access but I'm getting a
error message "missing vsflex3.ocx"  How can I solve this problem.
If I click OK 3-4 times, I then get an error message "Undefined

Let's see if I even phrase this question correctly.  We use an Access DB to
enter appointments for our company.  There are hundreds of querys, but in
reality all the information is stored in one Table. (There are other tables
used for drop down info, etc.)  

I read a message in the discussion group eluding to the fact that DAP's were
going to be a thing of the past. At the very least, not edit supported in
Access 2007. What's the scoop? What are the alternatives? Any comments are
appreciated.

I have a report with subreports.  The join between the two is Person_id.  
This field does not appear in the report.  However when I export the report
to Word, there it is on the right hand side of the report.
It is a bit difficult to get rid of something that Access says does not

Is it possible to code a list box if 7th Column shows "e" then that line
turns yellow??
Thanks for any help...............Bob
[lstModify].[column](6)="e" then color Yellow

I deleted the switchboard that the 'wizard' created, and now I can't get a
new one to show up.  How do I get a new switchboard to show up?

I have a make table query that is truncating at the nearest hundredths place.
If I just view the query it runs fine (from the view button), but when I run
it the table only shows 2 decimal places.
Example when run in "View" mode:

I have a form that contains 6 tabs.  Each tab (table) has a relationship with
one another.  Is there a way where I can place an "Add New" record button
that clears out all fields in the 6 tabs?

I am trying to update one table that has one record for each employee(table
1) with available vacation time.  The other table records every time off
request(table 2) and how much time they want off.  I have the update query
and it works fine.  The problem is that everytime it is ...

I need to automate the creation of a table
For that I am using a make table query.
Right now I have created a query that gives me 4 of the 5 fields I
need

When ever I do a compact and repair on a database a new file is created. The
file is named db1. and each time I compact and repair a new file is created
called db2 and so on. I end up witg db1, db2, db3, db4 and son on in my
folder. Any ideas?

I have an app which does some logging when the User ends the session. I use
a switchboard and have an "Exit and Close Application" button. But if they
quit by clicking the red X (Windows application quit) or by clicking on the
Exit Access the code doesn't get executed.