wanting to get a 2062 form to put into access(need help)

[MrBilko]

I have set up a database with all my MTOE items. Wanting to see if anyone has a 2062 form already created for access I could get ahold of. I am in Afghanistan and have alot of equipment. Thanks for your help.

 

[MajP]

http://www.per.hqusareur.army.mil/services/support/forms.htm

Here is a word version. The easier approach I think, would be to put code into this word form to make a connection to your database. Then use ADODB to read the data from your db and populate the Word form.

If interested in that approach I can provide you a lot of the code to do this. What I would need is your table structure and tblNames to know how to pull the data.

If you could post a dummy set of tables and notional data, that would help.

I find this approach easier when I have to get exact formatting for documents and reports.

Word also has some built in Mail Merge features, but does not work so well with continous data.

 

[MajP]

Here is a demo. It contains a dummy database and a 2062 template. Ensure you enable macros on the template. It prompts you to browse to the database and then populates the form.

I do not know where you pull the data from for the different fields so you would have to explain that. Currently that information is hard coded.

http://www.4shared.com/dir/w_NOG_S3/form262Upload.html