I'm trying to code an "option group" and I have run into a problem.
My option group has 3 selections (short, medium, long) where the "short"
option is 90 days or less, the "medium" option is 91 to 180 days, and the
"long" option is 181 days to 365 days.  At first I thought I could ...

I am developing a database to access telephone messages. My problem is that
when the user selects a category from a combo box,  certain fields of the
message under the category selected such as, Sender, Subject, and Date
Entered are displayed in a continous  form, in which I have ...

I need to be able to select multiple items in a list box and store them in a
field.  Can this be done? Or can I somehow use a list box with multiple
selections for a given record?
Thanks!

I'm creating a data entry form.  A lot of the entries are the same except
for certain fields.  Is there a way to speed data entry by prepopulating
the fields with the previous record??
Thanks,

I have a combo-box (#1) that looks up to a lookup table that contains a
series of Adverse Event categories.  I want a second combo box that will only
show the Adverse Events themselves based on the Category chosen in Combo Box
#1.  My thought was to have the combo box look up to ...

The following code on a button click event is causing me problems:
intX = MsgBox("Before close", vbOKOnly)
DoCmd.Close acForm, Me.Name
intX = MsgBox("After close", vbOKOnly)

If I right click on a Snap (.snp) file in an Explorer window and select
'Print', I can send the Snap file directly to a printer.
How can I emulate this action in code?

On an Access form, how do I compare two different tables for their
differences in table structure only?

I have a table which contains data and I also have a report which shows data
from the table.
I would like to create a form which will allow people to enter a date, name
or number and then press a button which will then show the record with the

I have a main form with a subform(datasheet).  The main form shows header
type fields(candidate, branch, address, etc) and the subform shows certain
other fields.
I need to be able to click or double click on a row in the "subform" to

I am coding in Access 2003 VBA using DAO. The form that I am having problems
with is bound to a table(Orders) and has a subform bound to a child
table(LineItems). This form is used to enter orders and the subform is for
entering line items. Depending on the information entered ...

I have a text box that uses the DateDiff function to
calculate the elapsed time between an initial event
and "today".  Is there a way to get this to automatically
update?

I have been working with an error messages issue and I have not actually
gotten it to work exactly as I hoped and now not at all. This is a Timer Form
and I have created a test button on the form to work with the code, that
somewhat works, without messing up the original timer ...

how do I create a text form field on a underlined line without the line
growing. I want the form to look just like the printed page while I'm typing
without altering the look . I can create a text form field with bold and
underlining but the line that the text form field ison ...

I have a long combo box of names.  Is there a way to type in a few letters
and have the list shrink to only those records that match.  I'm look for a
way similar to how EXCEL would operate.  In Excel column, if you type the
first few letters, you get a shorter list of options to ...