I created a form and sub-form where the sub-form is a data-sheet listing of
records. When the database is in developer mode, .mdb, you can right-click on
the mouse while on the list and a short-cut menu appears where you can sort
the list and filter the list. I like this feature. ...

How to change negative value to positive?
For example i text box value is in -4 then i want to change it into 4...
How?

I have a form which will open when I press a button in a other form.
But when that form will open, it has various sum of data. That's why
the form is not automatically in right size. Sometimes it is too large
and sometimes to small. Is it possibe to make it open so that it will

Hi, everybody,
I have created a "Master" form with a "Detail" subform.  In the subform, I
have an [Add New] botton that will open the "INPUT" form to add new record as
some of the reference field is not available in the "Detail" subform.  There

I want to assign a shortcut key in a form
like when a user presses CTRL+S a code should run like
Go To Control combo1 and me.combo1.dropdwon
any way to do this?

Howdy,
   I am just starting to look at Access 2007 (having used 2002 previously).
My trial system has just one table and one form.  The form was automatically
generated from the underlying table, but I added a button called "Test" that

I have developed a database in Access 2000, and it works wonderfully
on all the computers I've tested it on... however, when I have tested
it on two computers with Access 2003 (haven't tested it on more 2003
computers yet), it gets a little buggy and I need to fix that before I

   I am trying to use the dfirst function to pick the first description of
a particular date. e.g  first instance where the description 'NEF Grant'
appears on the 04.06.07.
I have built this which doesn't seem to work.

Need some help.  I have two forms that are virtually the same with one form
that has a little more data then the other.  The question that I have is that
on one form it will allow me to add new personnel when they come into the
unit.  Then I click a button to add them to the ...

I only want a textbox to display if the control source value is not null or
not an empty string.
I set the text box can shrink property to true and then test the value in
the form load event.

I have a form that has the calendar in it and 3 buttons that represent 1st,
2nd, and 3rd shift.  We input up to 50 forms per day.  The forms may be
entered the next day.  The calendar will always go to todays date because of
the code Now() used.  How do I make the date stay at ...

How do i set the color of a combo box listing different to the actual field
cotnents color when i click the combo box button.,  i wnat the listing of
chocies to be a differnt color to the original field content?
Pat

I have a database that stores the information on books.  One of the forms in
the database is used to search for a book.  One of the fields on that form is
a contents field.  What I like to do is to have the form brings up a list of
records that meets the keyword keyed by the user ...

On a customer order form I have a List Box that lists previous delivery
address for this customer (DB is for a flower shop).
Now when I go into order history I want to be able to pull up an old order
and show the address selected as it was when the order was placed.

Using A2K3, SQL backend.
I have a bound combo box displaying 2 columns (of a possible 5).  
LimitToList is set to Yes.
I am using the following test in the Click event of a Save&Close button on