I am using a continuious from with a single field combobox. I would like to
set up the combobox to have a look up list that diminishes as you select
items from the list. This is so the users only have the option to select an
item once from the list. If that item is deleted from ...

My question is that I have set my text box in a report to just give me one
decimal,
but how do I set it to drop the decimal when the value is 0.
example:

I have a form with a blank textbox [RMA Number].  I also have a button
with which I want to generate a unique, sequential number in the
textbox.
The tricky part is that the format of the number is a value that must

How do make a form display calculation based results on excel? Like for
example, on a scoresheet, on various percentage parameters, I want the
final score to be displayed on the form on the basis of the inputs...I
know how to do this on excel, but was wondering if I could do this on

I am working in Access 2003
I deleted a switchboard form from the Forms Object, it is visible in the
switchboard manager, but I am unable to get the form to show up in the Forms
Object after having rebuilt it in the Switchboard manager.

Hello experts,
This is going to be tricky to explain but here goes...
I have a subform sbfrm_PDiff and the data source is tbl_PDiff.  
Here are some facts about sbfrm_PDiff:

I have created a payments entry form using the Option Group.  The Options
Group assigns 1 to the table for Cash Pmts and 2 for Check Pmts.
As a result of user error, I am creating a corrections form so that the user
can pull up all of the payments for a particular person and make ...

I want to open a query from a button on the form.   I want to set the WHERE
clause based on other information on the form.
I have generated the SQL string but:
docmd.openquery  wants the name of an existing query that does not give me

I have prepared a form from a query where I have selected certain information
available from the query.  In the form preparation I have not included the
"ID" tag as it will show all records - over 9000 and by selected the small
number or column information and running some ...

I have created several databases for use at the local hospital's ER and they
are very pleased with the results.  They now wish to distribute them to other
hospitals in the province.  Is there a convenient way to copy the database
without all of the accumulated data so that we ...

I have a continuous form which displays certain fields of info from two
tables; the form's record source is a straight-forward, simple select query.  
 At the bottom of this form, I have a delete command button.  
DoCmd.RunCommand acCmdDeleteRecord

I am working in a continuous form containing over 8,000 records, an
within the form, I have a field named “comments” which I used th
“zoom,” “on click,” and “toggle button.”  The problem I am facing is
not all of the records contain comments, and I need a way to indicat

I've searched this forum and tried several of the suggestions here to fix
this problem, but I still can't make it work. Hoping someone can help.
I have a main form (fClientFile) with several tabbed forms. One is fClient.
On fClient I have a subform called fIndustryView. I also ...

Is there a limit on how many forms should feed a query? I would like to
populate one query with two different forms. Am I headed down the path of
corruption or is this okay?
-Charles-

I'm using Access 2000.
Can I change the a tab control tab based on some criteria?
I would like to change the color of the tab if a control on the tab meets a
criteria.