I've been using Allen Browne's "Search Criteria" example form
(http://allenbrowne.com/ser-62.html)  to create a Animal Quick Entry form
that allows the user to preview a batch of animals based on selected
criteria(the "preview" is the continuous form in the example), remove ...

I have a module with a Public Sub and Public Function.  On a form I have a
button on a form that calls the Sub and Function.  But, when I do, the screen
begins flickering and I see the outline of the forms opening and closing.  It
has been awhile but isn't there a line I can use ...

I have a form where I enter in accident information.  When I save this form,
I want it to look into a another table (Accident Investigation) to see if an
investigation has been completed that matches the Case #.  If no
investigation is found, I want it to add a task to the task ...

I need some help in refering a subform control in a parent form.
I have below line in Parent form which is called as "frm_edit_front_end",
Subform is called as "sub_frm_appeal".
Call load_appeal_data("frm_edit_front_end", "sub_frm_appeal")

I have a continuous form consisting of 1 row of infomation.  I want to put a
button in the form heading that shows comments or hide comments.  I would
like to make visible or hide comments based on the button selection.  I can
do that, but what I want to also happen is the height ...

Is there a way to create my own page setup pop-up Form for printing forms or
reports.
Currently when I convert my mdb to mde, the last page setting becomes the
default. Each time the same report is to be printed it goes back to the

I have a form which displays general employee data.  From this form, the user
can access another form which displays general 401K information.  From THAT
form, they can access another form that allows additions or changes to more
specific 401K info.  Everything is linked via ...

I have a subform which displays several lines of data, with all records
selected based  a  a field in the master.  In addition, I added several text
boxes at the bottom of the screen to indicate a "selected" row of data.  
There are several text boxes that will be filed in by the ...

I have a Command Button (Edit_Report) on my home page that I would like to
trigger a user to enter a report number and then go to Edit that report.  If
the number that the user entered does not exist I would like to tell the user
to re-enter a number or cancel.

I apologize ahead of time if my thoughts are all over the place.  I have a
form that acts like a switchboard which is used to pull the different reports
that i have created.  On the form i have unbound combo boxes: Startdate and
EndDate.  On the mouse down function I have code ...

i need to show the value from the 2nd column if my combobox.
i'll be matching a string value to the 2nd column.
how to?
tia,

I have 12 continuous forms across a form to represent the 12 periods of the
year.  I have code written that disables and locks subforms that are
populated with actuals (prior months).  I would like to remove the border
from the textboxes where actuals are present.  I know I have ...

I have a query that is used to provide data for a form.  The query has a
field that identifies the date an item was sold.  That field is specified as
a date field.  In the form, I put a value into a text box and requery.  The
only thing that will work if there are dates in the text ...

I am using Access 2007 and I know about the problem with printer drivers.  
What I'd like to know is this:  Can I create an Option Group and assign two
buttons-one for the default printer and one for another printer driver?
If so, can I be directed towards an example of the code ...

Is there a way to progam a button to open an attachment in Access
2007?
I'm trying to get around using the built in method of double clicking
the