My Assistant
![]() ![]() |
|
|
May 6 2012, 01:51 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 190 |
Hi
I am not sure if this is an excel or an word question but here it goes... How can we do several tables in the same page ? But i am speaking about for example 3 or 4 different tables but all together and side by side... This image have a small example... Has you can see in the image you have there 2 tables (all together), the left one has a different hight from the right one. How can i do something like that ? Thanks in advance
Attached File(s)
|
|
|
|
May 6 2012, 02:27 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 8,166 From: Pacific NorthWet |
One way might be to use Word's "merge cell feature and the "line" feature to box in cells in one large table to look like separate tables.
Out of curiousity, why? What will having several tables all pushed together on one page allow you to do? |
|
|
|
May 6 2012, 02:36 PM
Post
#3
|
|
|
UtterAccess Addict Posts: 190 |
Hi
I am not sure if that will work... If i hide the lines in the left table to correct the right one the hight of it will be different from the others and the space between lines will be different. if i do the opposite the left hight lines tables will be different... This is a paper report from a fire department and i was trying to excel it or word it (with out modified it), to print after the report letter with out the tables... Using the paper with the tables and them print the words on the paper in the correct places. But i can´t figured out how the [censored] they have done that... I have try once to scan it and try to recognize it with... but many lines are not recognized by excel... I think i have here somewhere the scan of it.. let me check... |
|
|
|
May 6 2012, 03:56 PM
Post
#4
|
|
|
UtterAccess Addict Posts: 190 |
Hi
Here it is one scan... Hope you guys can help me to understand how can i do this. Thanks in advance
Attached File(s)
|
|
|
|
May 7 2012, 09:20 AM
Post
#5
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
There is software out there that will take a scanned form, as you have posted, and convert it to an electronic form that can be filled in. If possible, that is the way I would do this.
If you can't do that, then you may be reduced to developing a Word form that can be filled in via Word's Mail Merge function, for instance. |
|
|
|
May 7 2012, 09:34 AM
Post
#6
|
|
|
UtterAccess Guru Posts: 744 |
Making an "imperfect" form work is going to be really hard. I'm just warning you. You can probably do this with nested tables, but it won't be easy. I would tend to agree with others and use the image of the paper form (like a background image) and then overlay the tables in Word. Still it won't be easy.
|
|
|
|
May 7 2012, 09:49 AM
Post
#7
|
|
|
UtterAccess VIP Posts: 8,166 From: Pacific NorthWet |
When I need to have "tables" in a Word document separated from each other, I add an extra column, make it skinny, and remove its borders. That gives the appearance of two separate tables.
I suspect you could do the same thing, then work with Word's cell merge and border features to 'paint' the picture you're after... Since the hammer I use most is MS Access, what about the idea of laying out the fields you want in an Access report and pushing data into the fields? |
|
|
|
May 7 2012, 12:10 PM
Post
#8
|
|
|
UtterAccess Addict Posts: 190 |
Hi
Thanks for all your reply's... On the beginning i thought doing this all by hand, like counting all the lines and columns and them merge some in left and UN-merge them in right etc, etc etc. But like i was suspecting it's very hard to do it. Someone have spoke about a background image and i remember, how about if i take out a new scan from the paper (a beater and complete one), them i edit the scan image and clean it (take out all letters/words and dirty around the lines) and try using a recognize program... Will the recognize program, recognize the hidden/merge lines and make all the tables and necessary lines ? Thanks in advance... |
|
|
|
May 7 2012, 01:02 PM
Post
#9
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
I think what we are all trying to tell you is that there is no "automatic" way to do this. The last suggestion about making the form into an Access report, then filling in via queries, is most likely going to be the way you have to do this. It might be possible to scan the document into a PDF file, then insert fields in the PDF file. But I don't know if you can then fill the form from the data in an Access database.
|
|
|
|
May 7 2012, 03:09 PM
Post
#10
|
|
|
UtterAccess Addict Posts: 190 |
Hi
Well in the end i want to use the Microsoft Access to make some menus and to open a form with this page data and them print the form answers into the report page... But how can i make sure that will work, that the answers will be printed in the correct "coordinates" of the "question" ? Is there any way to preview the page after and check with the outside paper if the margins, coordinates, etc are correct ? note: Sorry about not understanding at first, but enghlis is not my primary languages and sometimes i have difficult to fully understand completely what you guys mean. Thanks in advance This post has been edited by Miguel_A: May 7 2012, 03:11 PM |
|
|
|
May 7 2012, 04:06 PM
Post
#11
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
If that is what you want to do, then I do this via an Access report that consisted of a main report, and several subreport controls.
Then I would develop several forms that put the data into several tables, each table would contain the data for one table in the report. It is then fairly simple to use each table as the data source for one of the subreports on the main report. |
|
|
|
May 7 2012, 07:55 PM
Post
#12
|
|
|
UtterAccess Addict Posts: 190 |
Hi
I have create a new post in the reports part on the board the link is http://www.UtterAccess.com/forum/Printing-...r-t1986713.html . Once you guys knows what i am speaking about and if you guys could help in something please take a look to that topic. Thanks in advance for all the help |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 19th May 2013 - 10:29 PM |