First of all Allen thanks for your help.  When I use the text box to find
out the number of days between [completed] and [assigned] I get the correct
days, for example 11 days, but when I click on the text box I get 11.81315
days I just want 11 appearing only and without the user ...

How can I get both the text and the graphics on the command button.  For
example if I have a button to exit or leave I can have a picture of a door
closing, but I also want to have an "Exit" text appearing below the picture.
Any tips will be appreicated.  Thank you.

I have tblCity that has 200 cities listed and tblTaxi that lists the taxi
companies.  A taxi can serve many cities so I created a link table called
tblAreaServe that links both tables.  Below is an example:
tblTaxi

i have a form that has three subforms. i would like to automatically resize
the subforms so that there is no empty space around the edges.
currently, if i only have one row of data, there is empty space below the
row. if i don't resize the form on the right side, there is empty ...

Access 2000...
In a form, I have 30 controls (all labels) that I need to set various
properties.  When I do this, I make the property setting the same for each
of the 30. These 30 labels are all named Title1 through Title30.

I would like to open a table or query while in a form, and have the table or
query appear on top so I can view/edit its contents.  But when I use the
following code the forms reappear instantly and the table or query is not
visible.  Also, the app is frozen, and the user can't exit. ...

How to create a subform in datasheet view which is showing all the records
from a field in a table and four unbound fields as a checkbox format? What I
try to achieve is to show the product in one column in database view in a
subform along with four choices so that end user can ...

I developed an access 2000, win xp application at work and it works
perfectly well.  When the program is copied and brought home, on another
machine, still win xp and access 2000, I get multiple errors from the very
first. On loading the first form, I get the syntax error for the ...

Access 2000.  I have 10 laptops with an identical db.  I'm trying to export
and import files via Flashstick from the laptops to my main db. I have this
code to export files to my flashstick.  The prolem is that the drive the
flashstick is on is not always "F", it varys from ...

Could anyone help please?
I wish to load a form for a all users for them to select a report to run by
selecting a raido button/ tick box etc. The report is always the same but
with a different fiels outputr eg number of personnel at work today for

I want to create dynamic checkboxes on a form for a
Creating/Viewing/Updating a Master table record. The values for the
checkboxes would come from a simple table (cause they may increase over
time) but be stored in a "transaction type table" for the master table (or

I was working in design view and the VBA module.  When I finished and tried
to open the form, it was blank.  Everything is still there in design view,
and all the VBA code is still there, but the form opens as a blank screen.  I
made a copy, and eliminated all the code from the ...

I would like to populate a combo box on a form with all the queries in the
current database.  I've defined cboQueries as a combo box on my form, and
set the Row Source Type as Value List.  I've set the function GetQueries()
as the Row Source.  When I compile the code I get "Method ...

I have a form for ClientID (drop down is fine) and a drop down for job# that
show CliendID, job#, and taxexempt# - based off of a Taxeempt table.  I would
like when the client id is selected from the first drop down that the drop
down for the job# ONLY includes JOB # for that ...

when changing data on the form that has a sub form based on the same table
im getting a error that the data has been changed by a second user the form
is a subset of the sub form data when looking at the from im looking only at
a small part of the table but the sub form has more ...