Please Help, second post

  • Thread starter Thread starter Les Coover
  • Start date Start date
L

Les Coover

This is my second post concerning this matter. I have tried everything
including rebuilding my form many times but I still can't get what I want.

I have 3 tables TABLE A 1 to many> TABLE B 1 to many> TABLE C

All relationships have:
Enforce Referential Integrity = True
Update Related Fields = True
Cascade Delete Related Fields = True

I want to build a form based on the 3 tables. And I want to be
able to print individual records so the record will indicate whatever
scenario is in the current view. For example the 3rd record in
TABLE B is selected and the corresponding TABLE C records
are displayed.

I have tried many different things to no avail When I print the
record the hardcopy always shows TABLE C records associated
with the FIRST TABLE B record, the printout does not mimic
what is displayed in the current view.

Is there anything I can do to make my form "Printer Friendly" ?

If not, is there a way to align a form and report so I could print
the information that way?

Thanks again.

Les
 
You need to create a query that joins the three tables. In that way, you'll
know which values from Table A and Table B correspond to the selected value
in Table C.

Also, you don't indicate what exactly you're printing. Realistically, you
shouldn't be printing Forms: that's what Reports are for.
 
Douglas, thank you for the reply.
I will try creating a query first and then base the form on the query. I
assumed
that since I used the Form Wizard to build my form with subforms the Query
would be created automatically and placed with the Form.

I know, I have heard before about not using Forms for Reports. I do have
several Reports and do use them for more extensive reporting. In the
clerical
settings I work in it is very common for administrators to request a
printout
of one record for some reason or another. That is why I need to use the
form this way. It's really about the same as clicking the Print Screen key
on
the keyboard and pasting the copy into MS Word then printing it.

I will try the Query method. If you have any other suggestions I would be
glad to hear from you.

Thanks,

Les
 
Douglas

Created the Query then built the Form based on the Query. Here is the
Query:

SELECT tblAgencies.AgcyName, tblAgencies.MOUdate, tblAgencies.BSW,
tblAgencies.Gen, tblAgencies.Clin, tblAgencies.AgcySpecialty,
tblAgencies.Region, tblDivisions.DivName, tblDivisions.DivAddress,
tblDivisions.DivCity, tblDivisions.DivState, tblDivisions.DivZip,
tblSupervisors.SupLast, tblSupervisors.SupFirst, tblSupervisors.[FI\PC],
tblSupervisors.FIeducationBkg, tblSupervisors.SupPhone,
tblSupervisors.SupFax, tblSupervisors.SupEmail
FROM (tblAgencies INNER JOIN tblDivisions ON tblAgencies.AgcyID =
tblDivisions.Agcy_ID) INNER JOIN tblSupervisors ON tblDivisions.DivID =
tblSupervisors.Div_ID;


After doing this I got the exact same results. When I print the form the
hardcopy does
not match how the form looks on screen.

Since the Print Key button on the keyboard does make a copy of the current
view. Would
you know a way to use this feature to print the form, without having to
paste it into
a Word Document?

Any other suggestions, please send them.

Thanks again,

Les
 
Sorry: since I never print Forms, I have no ideas for work-arounds.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Les Coover said:
Douglas

Created the Query then built the Form based on the Query. Here is the
Query:

SELECT tblAgencies.AgcyName, tblAgencies.MOUdate, tblAgencies.BSW,
tblAgencies.Gen, tblAgencies.Clin, tblAgencies.AgcySpecialty,
tblAgencies.Region, tblDivisions.DivName, tblDivisions.DivAddress,
tblDivisions.DivCity, tblDivisions.DivState, tblDivisions.DivZip,
tblSupervisors.SupLast, tblSupervisors.SupFirst, tblSupervisors.[FI\PC],
tblSupervisors.FIeducationBkg, tblSupervisors.SupPhone,
tblSupervisors.SupFax, tblSupervisors.SupEmail
FROM (tblAgencies INNER JOIN tblDivisions ON tblAgencies.AgcyID =
tblDivisions.Agcy_ID) INNER JOIN tblSupervisors ON tblDivisions.DivID =
tblSupervisors.Div_ID;


After doing this I got the exact same results. When I print the form the
hardcopy does
not match how the form looks on screen.

Since the Print Key button on the keyboard does make a copy of the current
view. Would
you know a way to use this feature to print the form, without having to
paste it into
a Word Document?

Any other suggestions, please send them.

Thanks again,

Les
Douglas J. Steele said:
You need to create a query that joins the three tables. In that way, you'll
know which values from Table A and Table B correspond to the selected value
in Table C.

Also, you don't indicate what exactly you're printing. Realistically, you
shouldn't be printing Forms: that's what Reports are for.
Click to expand...
Click to expand...
 
Back
Top