I have a form called OwnerForm.  It contains a combo box called
Owner.  The combo box looks up names from a table called OwnerName.  
It contains fields called OwnerID and Owner.  I also have a main form
called ProjectsForm.  This form has several fields to enter data.  I

Hello,
I am using Leban's PDF code to convert a number of reports to PDF.  Once the
PDF is created, they are automatically being emailed.  However, the PDF
remains open.  I would like to do one of two things:

I have quite a unique issue - I would be very grateful if someone
could help out with this challenge....
I have two columns, Column A contains and acronym, and Column B
contains a corresponding file path. Like below:

In my form header I have fields for Employee Name, Employee ID #, Vehicle
Type, Vehicle #, Classification, etc.  I want to be able to click the drop
down list and select the employee name.  After the emloyee name is selected I
would like all of the other fields to pre populate with ...

I've hit a snag - I know this is easy, but the logic is escaping me. I
need to set criteria in a query to find dates in a date field that lie
between Tuesday of the current week and Tuesday of the previous week.
Any suggestions would be appreciated.

I have a report which has a list of products, with a total page count.
Due to layout concerns, the client wants to be able to adjust how many
products are printed on a page.
What I do, is keep a count of products and force a page break when the

I wasn't sure how to search for this so sorry if it's already been
posted.  Here's the issue and it's more of an annoyance than
anything.  Whenever I open an access database in Access 2003 (SP2) if
i open any tables, forms, etc it opens them in seperate windows

In table A I have a field called Color.
I have a color report that groups the colors and prints the total.
One section will list and total all the records that have red in the
color field, one section will list and total all the records that have

What this function attempts to do is remove the first string of
numbers in an address field.
I get "invalid procedure call or argument" for line:
----

I have a ComboBox, when dblClicked, displays the combobox's row
content in a continuous
subform. Changes can be made to this content in the subform and then
closed.  The ComboBox needs to be requeried to immediately reflect

I have a form with a text box that has its control source set to a
field in a table. Let's say the table looks like:
Field1:1,2,3,4,5,6,7,8,9,0
Field2:a,b,c,d,e,f,g,h,i,j

Ok'
I have 2 tables.
The first being my main table where each record has a 'FigureID' txt
box. (Indexed - No duplicates)

I've never used this event before and I'm struggling.  I have this code in
it:
If MsgBox("You entered " & Me.cboManagerName _
   & " - is this the manager's network logon ID?", vbYesNo, "Confrim

I'd like to filter by the following criteria:
left(LeadDisposition,3) = "Sit"    AND      Appt_Date = Text767
I have no idea how to do this. Appreciate help.

I have a problem with running a query.
Str = "SELECT Biographies.BID, Biographies.family_name AS [family
name], " & _
              "Biographies.first_name AS [first name],