this is going to be a rather lenthy post. But I will try and explain my
problem as clearly as possible.
Firstly, I have a table(tblActions). In this table, I have several fields.
they are: ID, CATEGORY, COMMENT, CLOSED, and DATE

Is there a way to formant a textbox to make a number a negitive amout?  
Wondering if there is some code or a simpler way to do that.    Any
suggetions?
Thanks....

I had been having a great deal of difficulty attempting to define a string
to be used in a filter.  I was trying to use an unbound form to apply
filtering to a report's recordset.  In the course of doing that I defined
strComp as String, but was having problems with it expecting ...

I am having a Form, in which I list a lot of pathes to picture files. On the
Form Current Event the related pic is loaded to and displayed in a control.
This works fine. The only thing nagging me, is the - each time a pic is
loaded - message box informing me that pic soandso is ...

What is the difference between Trim() and Trim$()?
I notice that several functions can have the $ symbol at the end, what makes
them different?

After porting my application into Access 2003 from Access 2000, I get the
following error when I click the menu to open any form:
"The expression On Load you entered as the event property setting produced
the following error : A problem occured while [APP_NAME] was communicating

I have a form where I collect varibles to run a report.  One of the variables
is a list of product codes; they are stored in a table that is created when
the user opens the form.  At first, the  name of the table of product codes
was constant.  I decided to create the table with a ...

Good afternoon,
I hope some one can help.  I am working with a form which is used for
calculating lots of different values.  In order to completely maximize the
space available, I have set popup to true and used a simple maximize command

I have a FE/BE-db with the possibility to block the db for maintenance. After
the startform a hidden form will be opened which checks the table settings
for a value. If the value is yes, then the db will be closed and locked. If
it is no, then the mainform will open.

Folks,
I have a window in my database which contains 5 labels.  These labels
are used for displaying altering text, with a font of Tahoma and a Font
Size of 10.77

I have two tables, and dont want to make the relational. I need to add the
fields from each table to the form, which has two tabs. please help me~!

We have a new software package from the bank.  However we have one problem
with it!  All of the other packages we have plus the one's we wrote use
LoanNo as the name of the field containing the Loan Number.
The application we have purchased use  HMDA - LOAN NUMBER.  I want to ...

I have a subform which is a continuous form with 1 text-box and 1 check-box.
I was trying to change font color of textbox depending on value of check-box.
I tried to set in Conditional Formatting the following rule: Me.Check9=True,
and make it red-bold. - but it guess it doesnt ...

is it possilbe to change the control source of the text box depending on the
value chosen from a combo-box?
I tryed to list the control source codes in the hidden column of my combo,
and then put the below coding on the combo's "on change event"

I have a form, which is linked to a sub-form.
In the BeforeUpdate event of the form, I want to check the validity of
the values within several controls.  So, my thought was to code it as
follows: