When navigating forms how can I prevent users from seeing/using the export
function, under the file menu? Bearing in mind that, when I'm navigating
around the back tables that I can have full access to this and all other
functions.

I would like to have the user click the button on the form, rather than
sending them to a toolbar.

Hello;
I am using Access 2002 with XP and I am designing a Sales Tax database.  I
have a created a form with a Combo Box.  The Combo Box has 3 columns: City
Name, City Code, Sales Tax percentage and this data is pulled from a Tax

First question:
I am new to creating forms in access. I am trying to allow the user to enter
information in the first form which will then be transferred to the following
forms (after clicking on a button to close and open ththe next form). I have

I have a podiatry database. I use an embeded OLE field for each client in
which I load a diagram of the foot to draw on for illustration purposes. When
the picture is loaded it displays clearly in the OLE field, and double
clicking allows you to edit in MS Paint within the OLE ...

Sorry about the title, could not decide on a better one.
I need some guidance on the best way to solve a problem. database has
a table which lists patients and their details. One of these details
is a data of admission and a date od discharge. Problem is patients

I'm trying to refer to a control on a nested subform within Access 2003
but get a ""Type Mismatch" error from the following code:
Dim ctl As Control
Dim intYear As Integer

Form A (based on a main table) has a combo box filled with records
from a different table. The combo box's dblClick event opens up a form
(PopUp=Yes, Mod=Yes)  listing all the records for the underlying
table.

I have a report that looks great in print preview, which printed last week
just fine.
For some reason this week the conditional format (color) is not printing and
neither are the tick boxes and tick marks for the YES/NO criteria.

I hope someone can help me understand a little bit better about the
differences between a list box and a continous form with respect to load time
speed, and a way to speed it up.
I have created an application that utilizes a backend database.  To speed the

Hello, I have a report and form, on the form is a checkbox (called fip).  
When i run the report, i want a text box on it to display the letter X if the
checkbox is checked.  how do i do this? (sorry i'm new to access)

I have this in my afterupdate event for a box.  If the user enters yes
i want to go to a new record on the same subform.  If they enter no i
want to move to a different control on a different subform.
can you help.  i am new.

I have a Programs database to keep track of our recreation participants.  I
originally designed this database with a Participants Table as the main table
to hold data.  When I first designed the DB, I had tons of columns to hold
our Swim Lesson records for each participant who ...

I would like some help on my problem:
I have a database used to import periodic data from Excel on quarterly
(for example) data on a particular Fund. Each time i import data, the
fields are identical, and the data MAY or MAY NOT be different....and i

I am trying to capture the log on/off times for users. I have created a
History table with the fields autoid (autonumber), username, login
time, logout time.  I have created a form that has the following VBA
for the Open property. It captures the CurrentUser and the Login time