hi i would like to know how to open xl sheet documnet by using command botton
in access form
thank in advanced

I have posted this in the past, but no one was brave enough to take it on:
How can I build a record locator similar to the way it works in MSOutlook,
where the more characters you type, the closer it moves to your record.  And
if you type a string that doesn't exist in the table, ...

Access 2007
I'm using the following code to filter records in frmHomeInv.
Dim strAll As String
Dim strSQL As String

Anyone no where i might find some info on how to do this?
I want to click a button on my form, be prompted for a value (similar
to a parameter query prompt) and after i enter it and click "ok" it is
copied to a field.

In my form there is a combo box which has three selection "deposit",
"withdraw" and "transfer" depending upon this selection different text will
appear in next three text box, for example if the selection is " deposit"
then the text box "transfered by" should read "NA". and if ...

I am having a problem with an average calculation on my form. I have a
continuous form with a field called "Score" and that field can either have a
numerical value in it or an "NA" in it.  I have the following code in "score."
=IIf([Score]=0,"NA",[Score])

I plan to write some VBA code for a command button on an Input Form.  Can
anyone help with answers to the following questions:
1) In VBA, how do you reference the values (field names) of the fields in
the previous Input Form that was displayed?

How can i paste my screen shot here in dicussions?

I am really new to VBA,
currently I have one form were I create meetings, than another one were the
individual is inputted(frmAttendance = qryAttendan = tblAttend)  I am opening
a form(frmTravel = qryTravel = tblTravel) from  a button with in

I would like to create a report based on a selection from a combo box on a
form.  Basically, I want a user to select a value from a combo box that
corresponds to a value in a field in my main table of contacts, and the
report that is generated just shows those contacts that have ...

I use a form to enter/update info to two different tables.  I have a command
button that allows me to create a new record and code executed creates the
new record.
When I go to the table, I can see the new information is there.

I need to set up some VB code to alert the inputter that they need to
complete a couple of required fields depending on the value of a third field.
At present I have some code (below) attached to the BeforeUpdate event of the
form that checks for one of the fields but I need to ...

I  have a frame which has 2 option.Option 1 and 2.
I also have a combo box.
I want when option 1 in my frame is clicked,
my combo box row source is

I have a dropdown on an Access Form, with its RowSourceType =
ValueList, RowSource = "1;2;3", and ControlSource = "" (empty).
The value selected by the user will be used only by a VBA script; I
don't want to have it bound to anything.

I have a product details table.  If I key in the part number field, I would
like to automatically populate the description and price field in a form I am
using.  How do I do this?