Click here to download DA format DA MS Word. Click here to download DA format DA FormFlow (FPK)–Be advised, this. 1, HAND RECEIPT / ANNEX NUMBER For use of this form, see DA PAM The proponent agency is ODCSLOG. FROM: TO: HAND RECEIPT NUMBER. download and print a fillable da form hand receipt annex number, get da hand receipt form in microsoft word also download pure edge viewer and .
|Published (Last):||3 April 2005|
|PDF File Size:||18.40 Mb|
|ePub File Size:||4.71 Mb|
|Price:||Free* [*Free Regsitration Required]|
Skip, Just traded in my old subtlety Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members!
Join your peers on the Internet’s largest technical computer professional community. It’s easy to join 2602 it’s free.
Register now while it’s still free!
Close this window and fkllable in. By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden.
However, the link provided by majp is broken. Word versions can also be found with a web search. I’d do the entire thing in Excel. You can query the MS Access db directly, maybe even in the form itself.
DA Form , Hand Receipt and Annex –
If you choose this approach, I’d suggest reporting in forum I saved that document as a Word Template. The original document has form fields. Although not visible they are numbered 1 to So my code prompts the user for the location of the database and reads the data from the table and then puts that data into the correct form fields.
The demo works, but it fillale only a demo. I do not know the structure of the database or what type of information goes in each field.
I provided a dummy database to show that it can pull information from the tables and input into the correct fields. I hard coded some other information because did not know where it would come from.
If you provide a real database with notional data I could refine the code.
If you can follow what I did then you should be able to fix it easily. Since it is a template: You can not save over the template. The same approach could be used on the Excel file as well. I would need to know more about the database structure to know where to pull the real data. I ended up modifying a database I found on http: If you need to fill out DA ‘s from an Access DB, go to that site and search for “arms room” or “database.
I see your post and sample database you provided but could not download it. I tried going about the issue in a different manner: I ended up cutting up the DA Form and breaking it up into several parts that I input into a report.
The original form has 16 lines for data on the first page and each page after that has 21 lines for data 37 lines total for the form. The data for the report is being pulled from a table populated by the user. The size of the report will depend on the size of the unit, the more equipment they have the more items they will need.
I need to come up with a way in which the report will print properly utilizing the amount of items input. For instance if they only have 7 items I need it to fill in the 7 items and then input 30 blank lines in the report. I think your approach would be a much more simpler approach, unless there is some coding that could be done to get the to work properly the way I attempted.
Any suggestions or guidance would be much appreciated. You can print X empty rows in a report with some code. However, not certain how you set this up used for the different pages since the first page has only 16 records and the second But I would think the logic would be if the number of records is less than 16 records add N blank records to make Not sure why you would need 31 because that would be an all blank second page.
MajP – Thanks for the quick reply. I put your code into my database, but now get an error: The field is too small to accept the amount of data you attempted to add.
: Blank DA and DD Forms
Try inserting or pasting less data. When I Debug the error shows at this line of code: RecordSource Not sure what I am doing wrong. The field size are all set to the max of This was a guess. Your recordsource would have to be the name of fillabls stored table or query. If it is a SQL cillable then it will not work. So store the forms record source as a query.
Here is a zip file that fills a and leaves the required rows blank. Also I provided a word Template. Open the Word file and it will prompt you to browse to the database.
Once you select the db, It will fill the word form. The Word templated needs some formatting to make it look correct. I screwed up some of the formatting. Here is the code. I have made it general so that it can be used to make blank rows on any report.
Report Dim ctrl As Access. Control For Each ctrl In rpt. I think I used this same method fillble or less, and it worked out for the most part.
Did fillanle same for a DD and a couple of other forms. I came across this thread looking for a way to use XFDL forms with access still haven’t found awayso thought I’d leave a link to a solution that worked for me: Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Students Click Here Join Us! Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.
I think it is correct. I like doing very formatting complex forms in word because it makes formatting easier, but requires much more code. RecordSource Fiolable Function Fil,able easier solution would be to create a table of blank records.
You would need 20 blank records because that is the most you could have. Then you would also need a sort field so that all blanks are sorted to the end.