Avatar of Advait Kawthalkar
Advait Kawthalkar
Flag for India asked on

Printing a record as annexure

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
Microsoft Access

Avatar of undefined
Last Comment
Advait Kawthalkar

8/22/2022 - Mon
als315

Do you like to have something like this sample?
AnnexureII.zip
Helen Feddema

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 Kawthalkar

ASKER
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Advait Kawthalkar

ASKER
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 Kawthalkar

ASKER
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
als315

You can test an example of records concatenation, but, I think, you can use Helen's Example.
AnnexureII.zip
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Advait Kawthalkar

ASKER
Hello als315
Looks like the zip file is corrupt.
ASKER CERTIFIED SOLUTION
als315

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Advait Kawthalkar

ASKER
Hello ALS315,

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