I changed the number format from integer to decimal to stop rounding, but it
still does it.  When I enter "6.50" the number that shows is "6.00" which
throws off calculations!

Hey, I have a form of records, and a listbox with all of the dates from said
records.
Anyone know a way to select one of the dates in the listbox and click a
button to edit that record. I've tried findrecord and openform with that date

In the detail view of the navigation pane in my newly converted FE/BE
database (from A97.mdb to A2K7.accdb) DATE MODIFIED is not being
updated when I change and save the design of Forms, Reports, or
Modules. It is updating when I change the design of Queries and

Me!ProjectNumber.Format = "Text"
Can I use something like this to change a combobox's format from number to
text. My problem is I get an error message in the combobox telling me that I
am trying to enter a text in a numeric field. I figured if I change the

I am running Windows Vista Ultimate. I have Office 2003 w/ SP3 installed. I
am running into an error. Please consider the following scenario.
Sometimes when I shut down Access 2003 then try to reopen Access the system
simply sits there and nothing happens. I go to Task Manager ...

I have a date field that currently has only the month, day and year.  I would
like to add the time to it as well.  The input to the append does not have
the time.  Can I format a time and have it as part of the date field?
Thanks

Is there a way to print two reports at the same time with a control
button?
The fist report have one side page and the second report have 2 side
page.

I have a table with records where one field are duplicates.  I'm able to
query to find duplicates and delete them, however what I need to do is find
the duplicates, produce a total from another field, delete the duplicates and
update the record field with the new total.

A simple question
On a form, I have a button that create a table when someone click on
it "DoCmd.open query  "
But I want to add something that will stop the code if the table

I use merge every day and usually merge to a document in a very specific
file.  Rather than going thru the various levels, how can I point the merge
to a specific folder?

Briefly: Form A being used as a "startup" form.  Form B used as a data entry
form.  Form A remains open while Form B is being used.
Question:  Could I have one unbound field (say "Field1") on Form A, and have
this value show up as part of the header of Form B?

Using A2K, I have 2 combo boxes on a continuous form, cboCompany and
cboDescription.  After I make a selection in cboCompany, I would like to have
only descriptions from cboCompany display for selection in cboDescription.  
In a query, I looked for descriptions from the form and ...

Access 2000 and SQL 2005.
Access Cant find stored Pro, but I can see them  but ;1 is now appended to
SP name ...
I have sp1a for access 2000. Owner is DBO.

MS Access has started throwing this error at the exit point of
one of my routines.
/Decompile followed with a compact/repair makes it go away; but
what's got me worried is that it's come back twice over the past

On my shipping invoices, which are reports,  I'm trying to display a line
that shows the following line: From Origin to Destination (Origin and
Destination being fields in the source query)
As the length of the Origin town varies I don't want to use fixed fields for