AC2007-Change where to send Report.

[Andrew]

Another Question from Andrew.

I have a table [Contracts] with a field [Contract_Number], text field, no
duplicates. This table is maintained by in house (Back end). Users of the
database (Front end) fill out routine data on forms which fill up several
tables. Queries are used to compile data for reports, most of which is the
same however depending on [Client] the format of the form must change. I have
designed several forms to meet their “Particular needsâ€. Is there a way to
fire off the info to the right form (using a print form button) based on
[Contract_Number] ?

Any help as always is appreciated!!!

 

[GP George]

The terminology can be a bit confusing, but it sounds like what you want are
customer-specific reports not forms. In other words, in Access you do your
data input and editing through forms.

When you are ready to create a printed version to send to your client, you
do that with a report. Therefore, when you suggest that "Queries are used to
compile data for reports, most of which is the

same however depending on [Client] the format of the form must change." I
think, or hope, that you are referring to a "printed form" for the client.

If I am on the right track here, then one approach will be to create a
"Client Form" table in which you record each client and the name of the
particular report they should get. You will actually insert only the
ClientID (as a foreign key from the client table). You'll probably want two
text fields, one for a user friendly name ("Client ABC Form") and one for
the Access report name ("rptClientABC"). Display the contents of this table
to your users as a list box, hiding the ClientID and Access report name
columns. Then, when a user selects a "Client Form" from the list, and then
clicks on your "Print" button, run code that selects the appropriate report
name for print.

If, on the other hand, you are actually talking about having different
ACCESS forms for each client and wanting to print those ACCESS forms, I
think you might want to rethink that approach.

HTH.

George

Another Question from Andrew.

I have a table [Contracts] with a field [Contract_Number], text field, no
duplicates. This table is maintained by in house (Back end). Users of the
database (Front end) fill out routine data on forms which fill up several
tables. Queries are used to compile data for reports, most of which is the
same however depending on [Client] the format of the form must change. I
have
designed several forms to meet their “Particular needsâ€. Is there a way to
fire off the info to the right form (using a print form button) based on
[Contract_Number] ?

Any help as always is appreciated!!!