I have a report where I have an unbound text box as one of the detail line
fields. At time of printing, I want to set that detail line to a value. I
set up my code in the "On Print" event for the detail section to check some
things and then I assign a value to the unbound text ...

How do I do this? (Or is it even possible?)
I have two fields on the form--startdate and enddate.
I would like sort the form the following way:
First: by startdate where enddate is null

I cehcekd the treads already but I could not find an answer to my problem...
I am using Access XP.
I have a form with several textboxes and check boxes, a check box is named
HS_Diploma, if HS_Diploma is checked then the textbox HS_Graduation_Year

Hi groupies.
If a subform contains data I want a message box to pop up and tell the user
that they can not delete the customer (instead of the default access
message) when they click on the delete customer button. I can't seem to get

I am working with a Form with a subform.  The parent form refers to a query
that selects all AuditToolGroups from my AuditToolGroup table which don't
have a parent ID.  This is because the AuditToolGroup table is
self-referencing and can be its own child.  Therefore, there's ...

I have created a form with a subform.  Works fine. Well, almost anyway. :-)
When I open the form, the subform fields display "#Name?" until I select
something from my dropdown menu on my main form.
How can I make it so that my subform opens blank?

I'm getting the following error message "Run time error 429 - ActiveX
component can't create object". The following is the command it fails on:
Set mclsFO = New FileObject
Does anyone have any idea what this message means?

Hi! First off all congratulations for you all by make this discussion group
so helpfull.
I would like to add a button in my form to open a dialog box, browse a
specific folder, choose any file and then change the value of a text box in

Ok. This is the situation.
I have a main form (frmMain) with two subforms (sbfrmBound and
sbfrmUnbound).
I move data from sbfrmBound to sbfrmUnbound using this code in a button

In Access 2000, we are importing Excel spreadsheets into a temporary table
for processing into a permanent table.
One of the columns is a part number which is typically, but not always, made
up of 8 digits.  There are a few part numbers containing letters.

Using the command button wizard I created a button to open another form to
only display records related to the record open on the main form. For some
reason though, I only get the following error message appear when I have one
specific record on display on the main form. For all ...

I am not quite sure how to make this happen.  I want to populate a ComboBox
based off the value entered for the first ComboBox.  I have 2 field names
species and strain.  I would like to make it so when a user selects a type of
species, only the corresponding strains show up in ...

I  have a data entry form that I am entering data from feedback forms.  I'd
like to be able to assign an id# to each data entry form that will be a
running number for each entry.  
Example: For a entry that was entered in the database in October  2005 and it

Is it possible, in the conditional formatting settings of a textbox, to
enter a logical expression, since it's looking for a true result to be
executed? i.e.. Field Value Is     -     equal to     - mid(myField,1,5) =
"Hello"

Form:  Main Menu
From the Main Menu you open up the main form, “Program_services” (unbound)
which serves various purposes aside from the fact that it has a single
unbound, first, subform, “frmMain” with two option buttons.