I'm fairly new to VBA and Access 2010, but I've been building a database for my Admin Department. My problem is that I work in a military installation which uses standard forms for routing correspondence. As such, I've been using the unbound OLE object control to use as the report print out and included bound textboxes to fill the data. This has worked well with other reports, but the routing sheet utilizes a specific list of office codes that identify who needs to review and/or sign whatever is being routed. This can change with the type of correspondence being routed. The report has two columns of 10 textboxes and I would like the textboxes to only fill based on the not null or not zero string values in the query(i.e. move up the list of textboxes). Is there some coding or function that would help me accomplish this vice binding the textboxes to individual controls?
-
-
Short answer is that there is no built-in function to handle this... you will have to build it by hand.
Without the details of your form/Control it will be difficult to advise you.
What I have done (none of which are ideal solutions):
- it's a total pain, is recreate the forms in our lab as a report...
- Related to the above, place the fields on the report in the corresponding areas and print directly to the preprinted form. I do this for some customer sent forms... they seem to change their forms daily so I am constantly having to reposition the fields. :( which is why I went to:
- scan the image and insert it into a word document, overlay a table, and then using vba automation open that document and assign the information to the correct cells.Last edited by zmbd; Apr 15 '15, 12:34 PM.
Comment