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

Please get my customer receipt working!

P: n/a
I'm trying to set up a simple relational Access database to look after
customer orders for our small bookselling operation. I'm a beginner at
this, teaching myself via Help files and the manual 'Access Inside
Out'.

I've set up linked tables Customers, Orders and OrderDetails and these
seem to be working OK, accepting new data via forms and subforms. So
now I need to print out a receipt detailing the order for the
customer. I've assumed this should be a report and have set this up
based on the tables. The customer and order details are going into the
report OK, but it's including these details for all orders. Should I
have based the report on a query - in which case what expression
should be used (I assume in the OrderID field) to restrict to the
current (usually the last) order. Or is it better to fire a macro from
the order form to OpenReport but again what expression will restrict
the report to the current order. I've had a go at both these ways but
can't get it right. Please tell me there's a really simple way to
produce a receipt!

Other immediate problems are:
How do I vertically close up an empty line in the customer address
when there is no data in Address2 field?
Plus, any suggestions on the best way to produce customer shipping
labels? Would a continuous roll printer be best (if there is such a
thing)?

All help most gratefully received - I'm pulling my hair out!
SusieS
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Susie,

It sounds like you need to limit your recordset to the current record on your
Print Command Button. When you go into the code side of your form, look at the
link criteria, which will be stLinkCriteria, you'll need to add a Dim statement
of Dim stWhere as String and then use the Record ID to limit your records to
only the current one.

Dim stWhere as String

stWhere = "FieldName=" & Me!FieldName

Then where you see the stLinkCriteria, place some comma's and you'll see the
Where clause, place your stWhere there and see if that eliminates your problem
with all the records?

HTH

Michael
Nov 12 '05 #2

P: n/a
As far as Labels, Access has a great wizard for creating labels, that uses
standard Avery Label formats. Look at your report wizard Susie.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.