Is there any possible way I can code my hyperlinks to open using a different
program other then Word i.e. Word Viewer

I have a function that includes an "optional" boolean parameter as the 2nd
(and last) parameter.
In one particular location, I am executing the function and have passed it a
"false" value. In every other instance where this function is executed - I

TInUse is a YesNo Checkbox that I'm trying to set to true. It doesn't
seem to work.  I'm getting a syntax Error.
The Table is called Tables and it's getting the TableNumber from TM
which is on the form running the code.

After some very helpful advice from Marsh Barton I've set up a form which
allows users to search a database using a series of If statements like so:
If Not IsNull(Me.txtb4) Then
               strWhere = strWhere & " AND textfield2 Like ""*" _

Afternoon all,
I have a command button that opens a hyperlink field that relates to a
record, if the record doesn't have a hyperlink then a message box appears
saying would you like to create one yes or no. If yes is clicked then a blank

I've got the following situation:
A user needs to export a certain real-time list of data from his Access
2003 database as an Excel file. I've got the query and I know how to
export the query manually. But I need to have a button that the user

I want to be able to enter in data in a field and have another field
automatically pull in the value based on what is entered in the first field
(i.e. I have a list of Standard Operating Procedures stored in a database.  I
have an SOP number and a title.  I want to be able to ...

hey all,
i was wondering what if i had a form and i wanted to see if a record exists
in 2nd or 3rd table would i use DLookUp or is there another way to do this?
thanks,

I have an Access 2002 form, which has several buttons a textbox and
listbox. Two of the buttons appear below the textbox when the form is
opened, while the listbox is invisible. If the user presses the browse
button (to the side of the textbox) and selects multiple files to

i am creating a database where in a table i need to divide each row based on
one of the column vaule into many rows where the rest of the columns content
are the same
currently i am adding new rows to temp file and then appending to the

I have a form I have created that is used by multi-users and is set up to
only let the CurrentUser see their records.
Within this form I have a calculation I want to set up - example below:
FY06Qtr1 * Percentage = 06Qtr1

I am having trouble trying to figure out how to export a report to a
snapshot file via command button.  I figure it would look something like
below - but it doesnt work at all...
Sub Snapshot()

how do i edit access 2003 forms ? menus,toolbars disabled at startup window

I have this form which I would like to auto populate based on a string
copied from another program.
I can't figure out how to set the value of a variable to that string from
within an access vba routine.

Currently I have a combo box on a form that a user can select from or type an
ID into.  Then the user can either click the command button or they can hit
Enter twice (which tabs to the command button and opens it).  This takes the
user to a form with data for the ID.