How would I go about pulling text out of a long string?  The length will
vary, but I know exactly what will preceed the text I need, and also the
length of the text I need to extract.  For example, I have the following
string returned to me:

Howdy! I'm stumped!
Here's the scenario...
I've got a form where the user inputs an account number into a text box. I
then use that number as a parameter in a dynamic pass-through query (query

Dim ws As DAO.Workspace
 Dim db As DAO.Database
Set ws = DBEngine(0)
Set db = ws(0)

I am trying to do a multiplication expression but it is not working right.
I want a value from my main form to multiply from my subform. the end value
is also in my subform.
The equation I came up with is

I would like have a link table to a link table. I am not sure that does
Access support this?
Should link table to a physical tables or could be a link table link a link
table?

I have
Table1 PK Survey_ID
Table2 PK Survey_ID
I would like to take the last entry of a sequence number and carry it over to

i have an option group with two check boxes. if option 1 is checked nothing
needs to be done, if option 2 is checked i want to open another form and
minimize the current form. i have created an openform macro but it doesn't
work no matter where i put it!

I have a form that contains a completed flag field and a completed date
field.  If the user checks the completed date field, I want to populate the
completed date field with the current date, allowing the user to change it if
they like.

I have a command button on a subform that opens another form.  The On Click
Event has this procedure:
Dim stDocName As String
   Dim stLinkCriteria As String

I have this code
=nz(DLookUp("[UPC_SALES]","SQLDAT3_SSITMXRF","[CORP_ITEM_CD] = " &
[tblItemNumber]),0)
this works properly but i need to be in number format. right now this

I have created a form in Access 2000 where one field is a date field.  I
have set the input mask and format so it works as I wish.  However when I
showed the application to one of the many people that will be using it, his
comment was it would sure be nice if we could have a ...

How to set fields in a form to be mandatory

How to set a combo box where the data entry person can start entering data
and it goes to that letter or compination of letters for the user to pick
from but if they contiune to data entry a word and it is not in the combo box
list how do you set the box to allow that data entry ...

How do I get the following pseudo code working?
OpenForm.Maximize  - this actully works, I know
Me.MoveLast + 1       - Move to last record of the source table plus start
the Add    New Record function

When exit cboDOTMLPF on frmSolutions I am trying to use case select to
populate cboSolLoc on subfrmSolLoc with the following code (only one
of 8 cases)
Private sub cboDOTMLPF_Exit(Cancel as integer)