I have user ID's stored in a table.  I would like to create a form with
a textbox that allows users to enter their ID's.  Once they enter their
ID into a textbox, I would like to program a command button to take the
value of the textbox, check to see if the ID is in the table.  If ...

Is there anyway to halt a program until Hyperlink has been closed e.g.
Application.FollowHyperlink "InviteToInduction.doc"
If MsgBox("Shall I mark these letters as 'SENT' today for you?", vbYesNo) =
vbYes................

I have a builder query which is sorting on the last two characters of a text
field, "Right([Fieldname],2)".  This has always worked fine in the query.  
However, I am trying to replace this query with code in a Form_Open event, as
follows:

i'm new to this, especially VBA. i have a pre-made database and am making
customized alterations for my company. there is a button (Add New) for a new
record on my main contacts form. i have changed the order of some of the
fields which i was able to rearrange the tab order for. ...

Within code, is there a way to open a combo box list to show entries up to
the limit set similar to how Access handles NotInListEvent? This event, if
left to default where Limit to List is set to 'Yes', will put out standard
error message but then, open the current list. What ...

I have a form that currently displays the date of a visit.
Currently the user can only input a date.
I would like to be able to show the text control as a Date OR a value of
'Missed Visit'.  The user needs to be able to enter a Date or 'Missed

I have a database with several tables, most of them are related to a "main"
table with a field ProjectNumber. What is the best/correct way to link
subforms based on the other tables to the main form wich is based on the
"main" table? I want the subforms to update when I change ...

I'm am a beginner at this so go easy on me. I am attempting to come up with a
validation rule in a form that must be met or the record won't be inserted in
the table. I need to know what syntax to use. Example: If field A is filled
then fields B and C (both combo dropdowns) must be ...

What is the best way to create a form that will allow users to search/query a
joined set of tables.  I would like to create a dynamic query that would
allow users basically the ability to write their own query by using a series
of drop down lists, which contain the table field ...

Background: I have a Main form frm1 which contains 2 subforms sfm1 and sfm2.
On frm1 I have a command button which opens - another form - frm2 which
allows me to add a record to the date table. The date table's data is
displayed in sfm1 on frm1.

   I am simply trying to add a field to an existing backend table using the
following code. When I get to the last line to Append idx I receive an error
message "Invalid field definition "Field1 in definition of Index or
relationship.  I think I am making this more difficult ...

I am try to hide a Tab control with underlying forms attached. When I click
on a combo box on the main form I want this Tab control to become visible.
When I use the following code I am able to hide/unhide the Tab but not able
to select the actual Tabs.

Could anyone help me out with code for copying a record in addition to its
subform contents?
Here is the info:
Main Form: Lease Inventory FORM

Hi to all,
I have build a report that is dynamic build by the user. My problem is the
Order By criteria of the report.
On my form command button to open the report I have a strSort variable that

I have a form with two dozen command buttons on it that will all perform a
similar routine. Each of the buttons click events will have its own
subroutine in the VBA code, and all the subroutines will call the same
function. To have that function perform logic specific to a given ...