Is it possible to use a datagrid in Access?
regards
reidarT

Getting field from subform (datasheet) to appear in a textbox on the form.
I have a comments field with several lines of text, so its not practical to
have it shown in datasheet view on my form. I want the comments field to
appear in a text box below the datasheet subform.

Can anybody tell me the API for the references under Tools menu.
Thanks in advance
Raj.

More code from this forum:
Form Control button: Used to bypass the typical append query warnings.
"Compile error" Method or data member not found!
Highlighted is the ".SetWarnings" bits.

Dear friends and pros,
There is the control "B" in a continous form that is filled with data by the
user only if combo "A" has a specific value.
I was able to make the control "B" visible only if the value selected in

How can I Undo a new record when the user exits a text box leaving all fields
on this record empty. I want to do this automatically and not ask the user to
hit delete?
thanks

I have the following command:
recSet3.Open "SELECT * from invtiv_PRINTER where PRINTER_MODEL = '" &
ws_printer_model & "'"
However, I want the SELECT to return a record on matching TEXT, not on

Hi. Just started using the Activex Toolbar control and
was wondering if someone could help me with a problem.
I'm not sure how the reference the Button Menu(s) for
a tbrDropdown style button. Using the following code

When trying to use the following statement
If DLookup("[fldcode]", "tblReagents", "[fldcode] <> Forms![frm shelflifedialog box]!Text0")
Access always returns
Runtime Error 13 Type Mismatch.

I have a lot of presaved queries that are expressed through marcos.  Is there
a way to make a combobox that lists these Marcos and runs them when selected?
Thanks,
MarcTA

I have a combo box in my form.  I have set the tab stop to Yes and have set
the tab order.  What I want to have done is once the choice is entered (field
size is 1) in the combo box that it will advance to the next field instead of
having to tab to the next field.

I am trying to adapt Access 2000 (on XP) for my disabled child.  I have a
form with several command buttons and one of them (for instance, the correct
answer to a math question) sends him to another form.    
My problem is in getting past the "correct answer" *without* triggering ...

I have a command button on my main form.  I have a subform (lets call it
subForm) with an option group (ogOptionGroup) on it.  On the click event of
the Command button, I want to run an If statement referencing the Option
Group.  I'm not sure how to do that.  If I  use:

I want to load a combobox using recordsource.
Then add a single selection by hardcoding that will be the first selection
in the entire list.
there are different ways to attack this problem I think and could use some

Does anyone have Case Select code for this?
I have a form with buttons(for each company) on it and when clicked should
bring up another form with data records for that particular company.  Each
button represent a company set of records.  When I click on a