setting preview/print ranges

  • Thread starter Thread starter Clayton
  • Start date Start date
C

Clayton

Hi again,
I have been working on a database that gathers
ionformation from four fields. Let's call them Field1,
Field2, Field3 and Field4.
I also have the Tables, the Forms (for data gathering),
a Report template (for viewing aforementioned data), and I
also have copied over (from a different DB) a Form for
range-of-date entry: (Beginning Date, and Ending Date),
with a Preview button.

What I need to be able to do, is after each session of
data entry, I want to be able to select Preview or
Print data, from a specified Date Range. Like....I would
make choices from the Switchboard(s) that will eventually
bring me to a Form which will ask for the range-of-dates,
and then either Preview, or Print the Report (depending on
previous selections) with data from the specified range of
dates.
I would guess(?) that once I get to the point where I am
able to Preview a range-of-dates in a Report, I should be
able to then have a button somewhere, allowing me to Print
the same Report.
Maybe I'll let this part go for now, and mention another
aspect I am wondering about.

When I get far enough along, I am going to want to
prevent any unauthorised "user" modifications of the DB.
I believe I read somewhere that this is possible and that
I will be able to remove the Toolbars from the top of the
various Forms, Reports and etc.?

Sorry, for the length of this, but thanks in advance for
any help I can get with it.

Clayton

Again, please feel free to respond to our personal e-
mail address if you'd like/prefer to, or if you have some
examples of Forms/Reports etc. that I may need.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can have the report "read" the range from a set of controls on a
form. Like so (Report's Filter property [line wraps]):

Filter: SalesDate Between Forms!FormName!BeginDate AND
Forms!FormName!EndDate

FilterOn: Yes

To secure your db application you can turn the app into a .mde (or
..ade) file - this will protect all of the VBA modules.

If you want a more secure app you'll have to use the user-level
security. Read the Security White Paper on the MS KnowledgeBase for a
good description of how to set it up.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBF/koechKqOuFEgEQLauACgwgIzr2pTJ4AGa5HachCtImqY6pAAoKNn
wB3N8Dx7CAm0hCnOHM5tZRMj
=I3HJ
-----END PGP SIGNATURE-----
 
Back
Top