Is it possible to print a form with the subform?  Then my next questio
is, how do I attach 'Clear form' or 'Save form' and clear it ready t
be used again.
I have created an invoice as a form and subform, spending quite a bi

I have some experience in using databases, but for the
life of me I cannot understand why Access makes you jump
thru so many hoops to do a simple procedure. All I want to
do is set up a number field in my table called rate. I

I'm using XP Pro and trying to use Access 97 by first loading up Office 95
and then an Upgrade to Office 97. Office 95 installs fine but then the
upgrade to 97 yields the following message" The application or DLL
c:\`mssetup.t\~msstfof.t\wmsset32.dll is not a valid windows image. ...

Hi I have asked this question befor and did'y quite understand the answere but here goes
I have a table with various sub tables. from the table I have a query called "Qry-property-selection
I have a form with two comboboxes named
"ComboDepartmentSelection

I have built a Students/Classes database and I need a
report that will print out transcripts.
The report is set up fine, however, I need to have the
report print a different student on each page. Right now,

I have built a table that contains monthly sales totals
from each our 52 stores. I have stores as rows and months
as columns.
Ex:                      Months

I have an unbound text box, with a simple Iif statement to give a "Yes" or
"No".
I would like this to stand out by having the text green for "yes" and red
for "no" - or if this is not possible can I change the background colour of

I hope someone can help me please
I set up a report from two tables - "Staff Table" contains details of all staff within the company.  "Courses Table" contains staff names plus all courses they have completed
Each table contains staff's first name and surname in two separate fields ...

I have a database with some linked tbales in it, but I
need to find out where the original tables are located
that these are linked to. If i right click the table and
go to properties it doesn't tell me.

I have some SQL where I Insert into a table with a primary
key field that is an Autonumber. Once I have done that can
I then use this field without having to go and read the
record?

How can i arrange the info that is populating my report in a decending
order. The report shows payments made by a person in increment starting from
the initial amount to the last amount paid. The query that runs the report
is set to decending within the 'sort' and when run display ...

I want to have an unbound text box that will always display last months date
in the form of
"figures for the month of " March
or

How would I derive totals within a report group that is really a count of
group headers and not the number of records in the detail section?
An example:   a report that show employee records, grouped by location,
then by supervisor.  I ant the # of employees by location and ...

I have a Form (frmTeam) and a Sub Form (subfrmMember) and I wish to limit
the number of records to four (4) for each Form Record.
How do I get the Sub Form to count the number of Records?
Thanking you in anticipation.

I have some code attached to a button on a form that runs
a query, hides the form and then tries to show another
form. It hides the first form, displays the result of the
query but doesn't show the second form. What am I doing