I am trying to add a command button to go to a link. If there is not link a
hyperlink value a box will pop up to insert the hyperlink.

Hi, I have 2 Forms necessarily running off the same Query. In the first Form
I want a text box to fill automatically with certain data, and it does. In
the second Form I need that text box to remain Null - but of course it fills
with automated data. I have been trying to get the ...

I have a report where at the footer I have:  =Count([WIMS_SUB_VEND])
Is there away to have the report start with the highest number of
[WIMS_SUB_VEND] first like
item 1    has 108 items

I have a main form (FormSubCategory) listing SubCategories
based on tblSubCategory
SubCatID
SubCategory

I am trying to tab from the last control on sfMother to the first control on
sfFather.  
Both sf's appear on fFamily.
Here what I am doing:

Newbie question.  Receiving a syntax error in INSERT INTO statement.  If I
create the query in the QBE it works fine with the WHERE clause hard coded
as follows;
INSERT INTO tbl_Available ( [Group] )

How can I programmatically change the value of a control default?
Thanks!
Sam

A while back I posted a message concerning an Access app I have that
requires the "Microsoft ADO Ext. 2.8 for DDL and Security" library. I
created this app running on XP and have had no problems.
However, the user of this app recently bought a new Vista pc and this app

Hi, it seems so simple but I just haven't been able to do the
following (I simplified the situation here a bit):
I have a very basic form that looks like this:
[  ] Alpha

I have a listbox that allows just one row to be selected. When a row is
unselected, I'd like the click to select the row. However, when a row is
selected, I'd like a click to turn off the selection. How do I do the latter?
Thanks.

Trying to show the number of record in txtCount using the following:
If Me.NewRecord Then
    txtCount = "0 Item(s)"
Else

Is there anyway to seperate the me.filteron property between the mainform and
subform?
My subform has a button that launches a popup form that passes back a 1:M
key that shows the multiple matching rows in the sub-form detail section.

That was a little cryptic, but the problem is this.  I have a form with a
combobox (optics) where the .enabled is set to false if a checkbox
(optics_yn) is not selected.
Me.optics.Enabled = Me.optics_yn.value

I have a main form (frmDO) with a subForm (frmDODetail) where the sub
control name is sfrmDODetail. The subform is a datasheet.
When I double click on sfrmDODetail and edit form is displayed
(frmEditDODetail).

Is there any capability to match data input with a pattern in VB code? I want
to compare user input with a pattern and return a match or not. I do not want
to do this via an input mask on a form.