By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

Help with pre-printed form

P: n/a
Ron
I have a pre-printed form that I've basically duplicated in Access 2000 with
the form wizards. It uses a main form for the basic info on a client, then
a subform for the transaction lines. I've tweaked it "just a bit" with code
for defaults and stuff, but otherwise, it's pretty much the way the wizards
created it (both main form and sub-form).

However, I need to either limit the number of transactions my user can
input, or limit the number of transactions that will print to 8 on each
form, printing 8 on the 1st form, the next 8 on the second, etc until all
transactions have printed. However I do it, I can only have 8 transactions
printing--that's what my pre-printed form requires.

Which would be easier? Limiting the input into the tables? Or, allowing
unlimited transactional input but only printing 8 transactions per page and
then reprinting the main form with the next 8 transactions, etc. I also
need the total of the amounts (which is the normal charge * quantity on the
subform) for each individual form to be listed just after the 8 lines of
transactions for each printed form (but if there aren't 8 transactions, the
totals for the transactions still need to print in the same place).

I actually wanted to limit the input at first, but just couldn't figure out
how, so I've been playing around with the printing limits and I've got it
kinda okay(I've just made the page header and page footer really large to
include all the stuff I need for each form and that limits the transactions
that'll print), but I just can't get the totals to print for each form.
I've been beating my head against the wall to come up with a solution. Can
anyone suggest something that might work?

TIA
ron

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ron
Still have the same problem. Been playing around with it for ANOTHER 2 days
and I'm at a loss.. Anybody? Nobody? Hello?

Does the lack of response indicate access is incapable of limiting
transaction input or printing output the way I need to do it? Shoot, even
ol' dbase could do that...surely, access has to have a way...

"Ron" <ro*******************@earthlink.com> wrote in message
news:QW*****************@newsread2.news.pas.earthl ink.net...
I have a pre-printed form that I've basically duplicated in Access 2000 with the form wizards. It uses a main form for the basic info on a client, then a subform for the transaction lines. I've tweaked it "just a bit" with code for defaults and stuff, but otherwise, it's pretty much the way the wizards created it (both main form and sub-form).

However, I need to either limit the number of transactions my user can
input, or limit the number of transactions that will print to 8 on each
form, printing 8 on the 1st form, the next 8 on the second, etc until all
transactions have printed. However I do it, I can only have 8 transactions printing--that's what my pre-printed form requires.

Which would be easier? Limiting the input into the tables? Or, allowing
unlimited transactional input but only printing 8 transactions per page and then reprinting the main form with the next 8 transactions, etc. I also
need the total of the amounts (which is the normal charge * quantity on the subform) for each individual form to be listed just after the 8 lines of
transactions for each printed form (but if there aren't 8 transactions, the totals for the transactions still need to print in the same place).

I actually wanted to limit the input at first, but just couldn't figure out how, so I've been playing around with the printing limits and I've got it
kinda okay(I've just made the page header and page footer really large to
include all the stuff I need for each form and that limits the transactions that'll print), but I just can't get the totals to print for each form.
I've been beating my head against the wall to come up with a solution. Can anyone suggest something that might work?

TIA
ron

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.