[AccessD] Exact reports are such a pita

Dan Waters df.waters at comcast.net
Tue Apr 19 13:32:06 CDT 2011


I think I would just build a string, using the values if I have them,
underscores if I don't.

If you're using Access 2002+, you can use the OpenArgs parameter when you
open the report, if that would work out.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, April 19, 2011 1:26 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Exact reports are such a pita

I need to build a report that looks as close as possible to a state form.
This includes a couple of subforms which look like:

1) From:_____________ To:___________
2) From:_____________ To:___________
3) From:_____________ To:___________

And if I don't have a line 2 or line 3 I still need to fake it, put in the
number and underline.

IOW it should be indistinguishable from a copy of their form casually
compared side by side.

Can you say PITA.

The only thing I can think of is to build a temp table, place the 1) 2) and
3) in three records
(programmatically) and then fill in each record as needed.

That seems rather over the top.  Any suggestions for easy ways to fake this?

--
John W. Colby
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list