Hello, and thanks in advance for any iput.
I have an MS Access 2000 database that is connected to a MS SQL Server
tables via ODBC. The database displays order information depending on
the Order Number entered by the user. This database consist of a Main

Hi, I hope you can help me out.  I have a form with two tab controls on it.  
I did this to keep information separated better for me.  I placed the tab
controls on top of each other and am using buttons to select the one that is
visible or invisible at the any particular time.

  Can someone please tell me how can I change a label's caption during
runtime?
say, I have combobox and buttonA in formA.  When ButtonA is pressed, formB
will load, labelA in formB needs to have the caption of text on combox from

I have 4 tables. All have a unique primary key, and one of these tables also
has a second key. This 2nd key is assigned to a field named "RTFnumber".
This same field is also located in the 3 other tables.
OK, I created a form, which was based on a qry of the above tables, and it

I have built a database to track the responses in a questionaire.  I have
built a table with all the questions, with an autonumber field, A personal
table with an autonumber field, and a results table in which I can enter the
question number and choose agree, disagree etc.

I have a form that uses a combo box to display data from a table/query...
When I open this form, the first record of my table/query is displ;ayed... I
would like to be able to open this form with no records being displayed until
I select the data from the combo box...

I have a form that has a combo box on it.  This is the only thing on the
form.  When I select the combo box, it is supposed to put the selected value
in a table.  
There is only one record allowed.  When I change the value in the box, it

Within my subform I have a combo box that looks up fields and populates the
rest of the fields in the subform
ID
SELECT [Sales Items].[ID], [Sales Items].[ITEM], [Sales Items].[Price],

I have a simple form with some fields and a combo box. What I want to be
able to do is control a label (lblScrapped) making it visible when a field
(comboStatus) says 'Scrapped' and not visible is the same field says
'Network' or 'Standalone'.

  I have a form that displays all the fields of a table.  By default,
Access opens the form with bookmark on the 1st record.  However, I'd like to
have it to display a blank (last) record for a new entry instead.  e.g. I
have 3 records in the table. I'll like it to go into the ...

I have a form with some unbound fields and some buttons. One of them is the
'OK'-button.
I would like that the OK-button is the default button, i.e. when people hit
enter, the code in the OKbutton_onclick -event should be executed. But as it

I have a form with several comboboxes(minister, cemetery, organist,
etc).
I want the user to go through and make his choices and have those
choices populate the "todo" subform.

Is there a method for a form to realize if the computer is running another
application? Specifically a DOS application. I would like to have a msgbox
pop open to alert the user of Access that there is currently a DOS
application open.

Within Access 2000, I have created a form with a dropdown menu, how do I make
it show this dropdown menu in alphabetical order?
Please someone help

I just put a subform in my form. When I toggle it looks
like the form is in the gray datasheet view. I would like the form
to look colorful and laid out just like it did in the design view. Any help
would be appreciated.