Hi -
I am receiving a syntax error on the following line of code, and am hoping
somebody more knowledgeable than I can help me define the issue:
If (Me.[Will Prep]) = Don’t Know Yet Or (Me.[Underwriting Requirements]) =

How can I open the select printer window before I print a report, I want to
first select the printer then send the report.
Best regards

I have 2 forms a product change form and an ECN form, the ECN form is opened
by a comand button on the product change form using the code below.  What I
am trying to do is this:  bring the Product change number from that form into
the ECN form when the ECN form is opened and then ...

I have a text file that I need to import into a table. I have it working
fine except that I get an error 13 type mismatch error on the last line of
each of my text files. The rest of the lines in the text file seem to import
just fine. I assume it is because of how I am looping ...

Hi everubody.
I wonder if there is a simpler to get to know if there is a currently active
transaction during execution. The only way I am able to get that information
is to declare a boolean variable inside the procedure or function where I

I have searched and cannot find anything on this.  How could I create a form
that searches the contents of a specific folder on a drive on our network and
then have it display all of the files located in the folder on a form.  Then
allow the user to select one file at a time to ...

I've got a subform set for Continuous mode witha combobox on it. The
subform is only supposed to allow the user to enter one record against
each value in the combobox's drop down list. I prefer to "help" the
user out when it's appropriate; in this case by having the combobox

I have a combobox based on an sql expression.  The box is initially displayed
with no value.  It muxh be seleted from the list.  I with to have a default
value as the, say, first item.  How can I do this?

I have a list box that looks up all the names in a table, EX: 'Smith,Joe',and
puts them in alphabetical order.
Is it possible to only pull up the names that begin with the letters, say  A-
F only, to display in the list?

in both forms and reports, when I align a field with "distribute" the far
right of the field is cut off in printing and in print preview.  Any ideas on
how to fix?

Can you have items in a list appear a certain way if criteria is met ?  Say
you have a list of loans, both active and matured - you want the matured to
show as red or bold - can this be accomplished ?

I've added a button to an Access Form to print the form.  However, it prints
in Portrait and won't fit on the page.  I've added the code "Let
Printer.Orientation=vbPRORLandscape", but am receiving the error "Invalid
Procedure call or argument".  I want this to work for the ...

How do I set the sort order of the control source in the design view?  I have
two list boxes with identical control sources, but want them sorted
differently from high in one and low in the other.  Thanks.

Is there a way of writing a system tray application or background application
in access 2003 that is not visible to the user. If so how do I go about
writing such an application.
Thanks

I have the following code on a form:
For Each ctr In Forms(strCurrentFormName).Controls
   If TypeOf ctr Is TextBox Then
       intTxtCount = intTxtCount + 1