Printing a record as annexure

Advait Kawthalkar
Advait Kawthalkar used Ask the Experts™
on
Pl look at the attached database. My basic aim is to print the the record in form of annexure or invoice. Refer to form Main. It has different fields. When user fill the record and clicks on "Print Annexure" it should print the record which the user is standing on. Refer to record 6 for example .There are multiple items with quantity for e.g. Masalimine with qty = 25 and Saxagliptin 2.5 with qty 20. This record has 2 items only but some may have more then that. When user prints Annexure which is a report, items should get populated as they are ( 2 or 3 or more) and also the quantity So it should be Masalimine 25 Saxagliptin 2.5 20.
Also instead of primary key, field value in Item should come on the report.
I will then add the other fields on the Main Form to the report.

Let me know if you require any further clearification
Thanks  for your help
Advait
AnnexureII.zip
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Do you like to have something like this sample?
AnnexureII.zip
Top Expert 2009

Commented:
See my Access Archon #44, which has an example of printing an invoice for a selected ID, with multiple related items.  The invoice is created as a Word document.

http://www.helenfeddema.com/Files/accarch44.zip
Advait KawthalkarSr. Manager IT

Author

Commented:
Hello Helen,
Yes I would love to have the invoice in Word format. That solves half the issue. My major issue is going to be how to be able to print multiple items & their quantity selected in the Main Form because if that is not possible I am defeating the purpose of making this database. Let me tell you frankly that am not a VB or Access expert but love to play around. Basically am on the hardware side.
Anyway, thanks and let me know if you could help on the items & qty part.

Regards
Advait
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Advait KawthalkarSr. Manager IT

Author

Commented:
Hello als315,

Yes I would like to print the items & qty in below manner :

item1 qty1,  Item2 qty2,  Item3  Qty3 and so on so forth ..... like wise in front of field "Identification Mark & No if Any" . So instead of line item all items & qty will be in one line. If the invoice gets created in Word format, nothing like it.
Thanks.
Advait.
Advait KawthalkarSr. Manager IT

Author

Commented:
Hello
Attached is what the final outcome required. Area marked with yellow will get populated using the data entered in the form. The form Main has few other fields which are not required to be printed but are for internal reference. Its ok if this is not in Word and is in Access Report form but then it has print specific record only and not the whole database.

Hope this will being more clearity.
Thanks.
Advait.
ANNEXURE-for-EE.doc
You can test an example of records concatenation, but, I think, you can use Helen's Example.
AnnexureII.zip
Advait KawthalkarSr. Manager IT

Author

Commented:
Hello als315
Looks like the zip file is corrupt.
EE uploading problems.
AnnexureII.zip
Advait KawthalkarSr. Manager IT

Author

Commented:
Hello ALS315,

Sorry for the delayed response. Was travelling.
Thanks & regards.
Advait

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial