I have used things from these posts to bring up the default Printer Dialog
box so that a user can choose a printer for the report.  I also have built my
own.
However, occasionally (more than I care to admit) I have users without a

I want to lock all the data fields in a form when I open it, leaving only the
filter combo boxes available for use.
Three of the data fields are combo boxes (InsurerID, TypeID, and ProdCatID).
The code I've used is below.

I have an access form that I want to use to delete records. There is a
trigger on the table and when I attempt to delete the record I get a "Cannot
insert null into......." message with the ID field of the user. I thought I
could run a pass through query on form open that would ...

I have a form/sub form into which I enter times (start and end) for a given
process.
User selects the process in the main form, and the sub form contains the
fields into which the start time and end time are entered.

Is there any way to open and edit a pdf file using vba?  If so, does any
using this code need a full version of Adobe on their machine?  Thanks in
advance.

I am recreating a puzzle found in a book.
The form uses 72 line segments to build a particular geometric pattern (not
a maze) - and it works exactly as intended.
I used the Tool Box to put one line on the form, then made 71 copies of it.

I just learned that it is efficient that split mdb to front end and
back end database.
I just wonder that does it mean that front end and back end
communicate with SQL string and result set to reduce network traffic?

I have a from "Form1" that has a subform "frmInfosub". Sub form has a combo
box to select a vendor. If the vendor is not in the list the can click on
<New> and it will open the add vendor form. When that form closes I would
like the Vendor name combo on my subform to display the ...

I try to write a program for a user to search a word that is a partial word
inside of the record. I created a table containing the fields Files and
Descriptions, and a form named fSearch; there are two text boxes txtFiles and
txtDescriptions to take the inputs from user and a ...

I have a criteria form from which I preview/print reports and need to
close all open forms EXCEPT the criteria form and a main menu prior to
previewing/printing.
What I'd like to do is click the preview or print button which will

I have a form in which I make numerous changes to label captions, control
visibility, control rowSources, etc.  Is there a method to "reset" a form to
its defaults as if it has just opened other than a) closing it and then
re-opening or b) looping through all the controls?  I ...

I am using a second form to enter new data, when I return back to the main
form I can only auto fill the productID detail, all the other data entered in
the 'newpart' form is not visible on the main form, Don't know how and where
to refresh the form data, can anyone assist? ...

I'm getting this error and it's regarding this:
DoCmd.OpenReport "rptPKWeightCalculatorASSsFGs", acPreview, , _
   "[PKWTID] = " & Me!PKWTID
The problem is that values in [PKWTID] can contain non-alphanumeric

trying to do a DLookup  with a concatenated 'where', in which one of
elements is a Date(patepart, to be exact), while the other ([year])is
text.
I've tried all sorts of variations, but without luck:

I would like to show the status when a process is running on the
form.  I do that now in the Access status bar, but that can be turned
off and I would like to have it more evident so people see it.  It
would be nice if it blinked also.