I created a hyperlink that opens that database itself but really need it to
open a specific form within that databse.

I know I put this in the validation rule for the date field in the table but
I am having a hard time getting the right syntax.  The field name is service
date - I do not want the user in the form to be able to put a date in less
than or greater than 30 days from today.

Form_1 has field Application_Acronym and a subform with field
DataElement_Name.  I wish to link to Form_2 using both fields from a function
within the subform.  
stLinkCriteria = "[DataElement_Name]=""" & Me![DataElement_Name] & _

I have researched the various issues as it relates to truncation of memo
fields. I read Allen Browne's fine treatise on the subject. However I am
experiencing something I can't quite understand or correct. Here goes.
I have a form with a text box control on it. There is a query ...

    Is it possible to have more than one bound column in a combo
box? I need to search 2 txt fields of a query and would like to start
to enter the text with autofill to select an item in either column for
the parameter for a report.

How can I show a form in pivochart view summing the hours that passed between
two dates?
where is the excelent custom format [h]:mm???

I have two fields in my db, one is a long integer, the other is text.   I
want to display them concatenated in a textbox on a form (i.e. intNumber & "
" & txtWords).   When I enter the expression in that way, I get "#Name?" as
an error.   I can't see that I'm doing anything wrong ...

Access 2003.
First Issue:
I have a main data entry form.  It has 2 subforms on it.  There is a record
selector for the form.  If my user makes an error and wants to delete the

I have the below code added to the after update event of the grossweight
field.  the default value of both grossweight and truck hours for a new
record is 0.
When I go to a new record both are 0 but if I want to put some value in the

OK, this is probably very simple but I can't see it.
I have a small mdb that I wanted to experiment on, by converting it to
Access 2007. So the first thing I thought was to remove the feature that
opens a main form on Startup. So I go to Startup and nothing is specified!

Is there a way to allow someone to print record information from two
different forms with one command button.
Situation is I have a form that has basic information about a contact, user
click on a command button to open a new form if they need additional

I have a main form (Contacts) which has many related tables. For this
message we will use the related table "Letters" which stores records
representing different letters and literature sent to a contact.
When a user on the Contact form, presses the "Letters" button, they

On Form received an error that led me back to the is line in my sql:
REVNUM GRID = list. 10 column(5, list 10. list index + 1)
I was told from post to make the REVNUM GRID a String.
How is this done??

Will conditional formatting (Access 2002) allow the use of
DLookup?
I've been hammering on such a thing all morning, and can't
seem to find the right stroke.

I would like to use a label to create  '(    )' and then put a text box over
it so that users can enter an 'X' if appropriate. What happens is that the
Label is in front of the Text Box and I don't know how to move it behind the
text box so that 'X' can be entered. Is this ...