Hi,
I'm creating a Vendor/Product database and want users to select the vendor
from the Combo Box (CboVendor), and then the List box (LstProduct) will
display all products that particular vendor has.  

Please tell me, how I get single  record print at single page because I have
100 recode. And I want to print one recode at one single page and second
record at second page. If I want to print any one or more record range how I
get print at singe page one by one.(I have designed ...

Access 2003   XP pro
I have a form (1st form) that I use as a selection list for a query
parameter.  Works great.
A button (code below) submits the query parameter data to a form (2nd

I want to fill a listbox with items in a continuous form. Each row has
different data. I thought about storing the data in the table in the form of
a value list, such as:
"John Smith";"123 Main Street"

I have a combo box in a form that allows a user to type in a loan
number and on enter the form then pops up the information on that loan.
However, if the incorrect loan number is typed in I get the run time
error 3077 "Syntax error (missing operator) in expression." I have the

I have a form with a subform inside which both manipulate 2 tables:
Quotations and QuotationDetails (One-to-many rs).
I have a button which when pressed will transfer the quotation details to
invoice.

Here is my problem.  Googling and using the help hasn't assisted me as I
must be using the wrong terminology.
I'll explain what it is I'm trying to do:-
I want to be able to log cross-sections measured along a river using three

Im Back again,
I Need some help on creating some sort of query which displays results
of company's that are assigned a service type.
With in my Companies Contract Table i Have a Service Combo Dropdown

Not having much luck with this - hope someone can help.
I want to display the result of a crosstab query in a datasheet form, fixed
amount of columns, variable amount of rows.
The user is to copy the data and paste into a spreadsheet. I'm want to use a

Can someone look at my code and tell me why my looping is not working?
Dim rst As DAO.Recordset
Dim strSQL As String
Dim db As Database

I know how to do this in excel but I dont know how to do it in an
Access form. I have two dates inv_date and QueryDate. Both dates are
field in my form. What I want is subtract QueryDate - inv_date and get
the results in days. This is what I tried w/o any luck

What I need to do to have a form where someone can input 2 co-ordinates
(i.e. x and y of each point).  In another unbound box it needs to calculate
the distance between the two points.  I have no problem setting this up and
I know the equation, but I can't figure out how to build ...

I have a field called StartingDate in my table.
I would like to make a query where it asks the user to input valid
parameters. I put in the query a parameter concerning the StartingDate
field:

I am working on a new database and part of the requirements will be to
be able to take existing documents that are in existing folders and add
the path to a field that is a hyperlink field called:     foundin
in the table named:    document      in the form of a hyperlink...

I'm working on a databse for my company and I'm using many custom dialog
boxes to help filter data. After the user chooses the information, they click
a button and the form is displayed using the criteria from the dialog box
That is to say, the forms underlying query contains this ...