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
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
Last Comment
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
http://www.helenfeddema.com/Files/accarch44.zip
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
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
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.
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.
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
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
AnnexureII.zip
ASKER
Hello als315
Looks like the zip file is corrupt.
Looks like the zip file is corrupt.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hello ALS315,
Sorry for the delayed response. Was travelling.
Thanks & regards.
Advait
Sorry for the delayed response. Was travelling.
Thanks & regards.
Advait
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
AnnexureII.zip