Hello group.  I'm really stuck and don't know what I'm doing here so any
advice would be appreciated.
Every client has alot of companies that they owe money to.
I have a report that is based on a query.

i have more than 100 records for printing. what i did is,
first i created report and used subreport to fit more than
5 reports in a single report.the first subreport has more
than 50 records and it may consume for about 3 pages. page

I am a beginner and am using a fairly complicated access database.  I have a
record in one access table which has ##error## in every field.  If I try to
click on any field, I receive an "invalid argument".  It is linked to an
outside table and I dont know if I need to break the ...

I am a Access newbie:
I am trying to add 3 fields together to get a sum on my
form. the fields are [PS1], [PS2] and [PS3]. their
respective value are 10, 20 and 30. When I do this =[PS1]+

I can remember reading that you can call a sub by entering 1 line of code.
So If in my OnLoad Event I wanted to use the code in the Afterupdate event
of a checkbox  I could just type
Sub chkBoxname_AfterUpdate()

I have 5 tables all on a 1 to 1 with the link being the PK on all plus 2
additional tables 1 to many with the link being PK to FK_Id on both.
I then created a qryMain to hold all of the fields and this is used as the
source for the form, the 2 1 to many tables are sub forms on the ...

I have the following problem:
In a form I have a text-box named "Akyra-reason" and a check box named
"Akyra".
What I want is whenever I enter any data at the text-box "Akyra-reason"  I

Right now I have my WorkedAreaHoursTotals query as a source for a crosstab query and it's working like I want it to.   Now I want the hours on the crosstab query to show my hours as shifts worked rather than hours.  A 12 hour period will be equal to 1.  I know I need to fix this ...

Why am I unable to enter data in a field on the form section of an Access
data base?

I get an error when I tried to assign the value in a textbox to a variable .
the error says "You can't reference a property or method for a control unless
the control has the focus.
my code is:

First of all, a big thanks to Kurt and Rob for helping me
get this thing working. I have one more question
regarding linked combo boxes.  I'd like to display more
than one row in the first box (cboDivisions).  If I use:

What is the VBA format/code for looping through records. This is what I
am trying to do.
I have a table called appointments. A student can have as many
appointments. This table has among other fields change date, reason and

This is probably a daft question but I've decided to post it.
I'm need to design a form to ask the user two questions
1) If the user has a Car (check box)
2) If the user can borrow a car (check box)

I need help getting the jpeg graphics installed and working in Access 2000.

I know there's away using a query to "capture" all the objects in my mdb.
I want to list out tables, queries, etc.
Also list out all the fields in any given table.
What is the query for this?