using access 2003 and Win xp pro
I have a problem with formatting a form textbox to display the the
correct number of decimals.  The text box is a calculated field that
is [grams_unit] * [quanity].  Grams_unit is in a table as field size:

This is the first time i've ever posted on this board, so bear with
me. I am trying to add data validation to one column, that checks the
value of another column in the same form, and if the value is true,
not allow a 0 to be entered in the column.

I have a login form/table that detects who the user is that is logged into
one of my projects.  I have added variables [PrjADefaultPrinter] and
[NormalPrinter] to my table with the PrjADefaultPrinter = A_IPADDRESS and
NormalPrinter = B_IPADDRESS.  

I have a module in my database that identifies the user (a function that
records their NT user ID when they log in).  Is there a way I can restrict,
say, a text box or drop down menu from being selectable or editable
(essentially, read-only access) to some users while allowing ...

I need to use a date check in conditional formatting.  I have a table of
extra info that I need to use the DLookup.
I tried to use this formula, but the change would not work:
If field is less than  Date()-dLookup([dhallexpiration],[tblExtrainfo])

I would like to control which table is used in a DLookUp based on the value
in another field on a form?

I am trying to use this function to round the difference between 2 times to
the nearest quarter hour, but if the criteria below is used for rounding,
what adjustment do I need to make to the function? (thanks)
Function:

I need a message box to appear under certain conditions when a record is
opened on a form.
I can get it to work with just one condition, as follows - if the "Paid"
control is empty, then the message pops up nicely, using this:

I've been using Stephan Lebans' mousehook.dll solution trap the
mousewheel. But sometimes when I transfer the database and .dll file
to another PC, the code can't find the .dll file. This results in the
"Sorry ... cannot find the Mousehook.dll file" message.

How can I have a command button to be deactivated by default and be active
upon clicking another button. And then have it become deactivated again upon
clicking another button (Reset button)?
Let me explain it a little better.

I have two list boxes: EndEquipmentList and ChosenList.
I would like to be able to populate data between the two list boxes in a
fashion not dissimilar to the form wizard pop-up. I was going to assign the
functionality to the doubleclick event on each list box, but would be ...

I have this form which I want to be able sort by clicking on a command button.
For instance if the button is above the "stocks" field 9textbox) - clicking
on the command button right above it would sort it descending. --- clicking
on the command button above the field "Profits" -- ...

Is it possible to set the first row in a combo box as a default selection.
The combo's list is dynamic with its list dependant on a selection made in
another combo box. To explain a little more; I select a value in combo box 1.
Combo box 2 then has its list generated. I would ...

I have a field in my database called Account#. Despite the name, there are
times when Account# is actually descriptive text. For this reason, normal
formatting or an input mask will not work to properly format the numerical
Account #'s. Formatting must be like so: @@-@@-@@ (or ...

I'm a newbie to Access would like to know if it is possible for a user to
append data to a text field in a form without being allowed to delete
previous data entries.
I.E if a member of staff records an incident another member of staff can add