I want to access the value of the second column on a datasheet subform when
I click on the first column.
How do I reference that value?  I know (or believe) that the reference
should end with ".Column(1)", but I don't know how to reference the subform

I am working on several dialog boxes. I have one that I've set up called
"Available Macros" in which I have a list of macros that the user can choose
from.  These macros need the file name under the Action - "Transfer Text"
updated each time they access the macro from the list ...

I use to input parameters in a running procedure using the input function.
To be able to input mora data using lists, combo boxes and other stuff, I
would like to use a custom form instead of the input function.
Is there a way to make a form have similar behavior then the input ...

I have a combo box [Contact], which when the user types in a contact name
which is not
in the list, i want a msgbox saying "Contact not in database, please enter
now" then a pop up form [frmContacts] to open up for the user to type the

I need help to specify date criteria in a subform without using a parameter
query.  The date criteria would be a fixed date that the user could change
from time to time.  My desired subform criteria is
OrderDate between #1/1/08# and #1/1/2010#

I tried to create a function to receive optional paramter and has default
value now as date as following.
Public Function myPrepare(Optional FromDate As Date = now(), Optional ToDate
As Date= now()) As Boolean

Is there any way to open an application within an Access form?  I am working
with an emulation program and I want the program to open within a form so
that the user doesn’t have to switch between Access and the emulator.  I am
currently using the Shell function to open the ...

My form is based on a OUTER JOIN query.  The user wants a note field
(actually containing the client’s vendor preferences) based on the client_ID
which is chosen from a combo box.  The client_ID is taken from a linked table
in a SQL Server database that I’m not allowed to touch.  ...

I have a http post in the code of a form, as follows.
   Set ie = CreateObject("InternetExplorer.Application")
   smsmessage = Test%20Message
   HttpString = "http://www.abc.com.au/gateway/etc.

Is it true that on every fisrt line of our module should begin with the
"Option Explicit" in order to pruduce the correct output?
I have ever experience that calender field using the popup calender was
error with the message mismatched format" and it's ok again when I put this

I have an unbound form with several calculated fields.  These fields depend
upon the value in a combo box on the form.  However, when the form is opened
all the fields show up as errors before I can even enter the combo box value.
If I switch to Design mode and then back to Form ...

I use docmd.sendobject to send out my report by emails.
The rtf files lost my report format.
I just wonder does Access support to send out snapshot format which includes
my report format.

I have a form (frmcurrentassignments) based on a query
(qrycurrentassignments). The query filters out the projects that don’t have a
completion date.
On the form there is a control (ar_num) which is the assignment number. It

Can I take the information from the current date row and subtract a previous
dates information and display it in a text box?

I have a field in a sub-form called 'Aneurism' which is a number field. When
it's values are between 1 and 3, then I conditionally formatted the color of
the bckgrnd to be greeen, taking a red when it's > 3.
When I had initially set the field's props in form view, I set ...