In my MS Access project I have two objects - my form and my report.
I need to pass variable value from
Command_click procedure of my form to
Report_open procedure of my report.

i would like to thank Darryl, he helped me a lot
now i have another problem
LeBayNum is the primary key in [tblListedItems]
relates to SeBayNum in tblSold

This is probably a really silly question but I am exhausted and cant
seem to find the answer. I have a query that I run from a command
button on a form. The query has three criteria set. The first is built
into the form and so is not a problem. Then the second and third

Hello all, I use Access to keep track of approx. 80 vehicles.
I have a table of vehicles with specs.
I have another of service records linked to the vehicle table.
Works great! I can expand each vehicle to see what service I have performed

I have an Excel table I need to import into Access. The name is entered into one field "Name". I'd like to have two fields in Access, FirstName and LastName. How do I do this.

I am trying to use a SQL Query to return a random record from an
Access 2000 Database.
I am using:
SELECT TOP 1 Example

I Have A Main Form  this form has a Subform The SourceObject  for the
Subform is another subform.
I have mastered changing the SourceObject, so that I can have
different Subforms appearing when I need them BUT what I need to be

I am new to Access and I am creating a form.  I have the following:
clients form which has the following lookup fields (in addition to
other entry fields)....
casemanager (from casemanagertable)

May anyone can teach me to assign a autonumber, I want to create a
number that is starting with year (auto change to year 2006) +
autonumber (eg. 2005-1001, 2005-1002 and so on)

I am a novice where Microsoft Access is concerned.  I am retired (age
63) and have been asked to design a ticket sales database tracking
customers, peformances/events, tickets sold, reserved seating and
associated reports.  This project is for a non-profit community theater

Can someome please advise what the equivalent query would be in
Microsoft SQL Server ... I've tried a number of combinations with no
success ... Thanks, Ralph Noble (ralph_noble@hotmail.com)
================

I am new to Access and need to link to two tables with a case number.
If I link using the Relationship feature will it automatically enter
the case number in the child database if I put the case number in the
main database like it does in Approach or do I have to do something

When I open a table and select one of the item format to %, when I
input data it will mulitple by 100 (eg. input "2" and result come out
to "200%", input "0.2" and result come out to "0"),please advise how
to do it?

Is it possible to setup a number format in a query to display result
as
x.xK (4.0K instead of 4000)
I am trying to abbreviate the numbers contained in graphs which are

Anyone have a clue about this:
Here's some form code:
Me.Filter = ""
Me.FilterOn = false