What is the best way to calculate the number of days between 2 dates. For
example:
current date - due date= number of days
The dates are in fields in a table, when I tried setting it up like

I have a data base where the main data entry screen is called "Data Entry"
(original eh!) This table populates a form called "Data Entry"
I have created a new table called tbl_Contract_Production and a form called
frm_Contract_Production I want certain fields (I.E Customer name, ...

How come combo boxes don't have margin settings like the ones found in text
box properties?
I noticed that when text appears in Combo Boxes, it's default left alignment
places text flush against the boxes inner line.

I want to set up my data base to have two separate text boxes called
FirstName & LastName. Currently I have only one text field called
CustomerName.
I want to chnage the setup because I want to be able to list the customer

I have two lists boxes on my form.
first list:
queries from an acces query 3 fields circuit, route, number
second list

Wanted to know about my browser setting,as some intl.organisation expect me
to bruwse on-netscape6.0&above/internet explorer 5.5with service pack
2,/int.explorer 6.0 or higher.Netscape is aviable but unable to login!Later
two i have no idea,whether aviable in my computer.how to ...

I am trying to use a listbox to append multiple records for employee training
when all selected employees have received the same training on the same day.  
I've gotten close, but my code is not working correctly.  It is appending
multiple records for the same employee, not for ...

I have obtained the directory stucture from my system and it has it in short
form?
ie. c:\abc12~1\work\werty~2\wokfi~1.xls
how can i covertvert it to show full directory names & files within my

Im still looking for a solution to this problem.  The only response I had to
previous thread did not solve the problem
tia
Terry

Its been a while since I did any work on Access so bear with me.
I have a continuous form (frmPSUA_List)  that has the following query as its
recordsource
=======================

How I close all toolbars when a form is loaded.
The reason is, I just want more space for that form.
On my pc, I check the all toolbars currently loading and close with command
DoCmd.ShowToolbar "Toolbar's Name", acToolbarNo

I have a vendor code field in multiple tables that I am using as a link.  I
have one main form which has general information and then linked forms.  I
have it linked so that the vendor code must exist in the main form before it
can be entered in any of the linked forms.

I have create a form with two combo box synchronize.
One combo box for select category
secon combo box for product in the category by setting the data source
category to = [forms]![myform]![category].  My problem this work by itself

Hello group,
I will be exporting a table from one database to another on a daily basis.
The destination database will run an Append query using the imported table.
(Its a mobile operation, transferring data from a laptop in the field to a

I have a linked excel file that lists data with one column being an
incremental number. I have a form that inserts new data into the file and i
need to increment this number and have it prefilled in in the form but only
writes it when i update the form. Any ideas?