UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Tables..., Office 2010    
 
   
Miguel_A
post 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)
Attached File  example.png ( 1.91K ) Number of downloads: 10
 
Go to the top of the page
 
+
Jeff B.
post 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?
Go to the top of the page
 
+
Miguel_A
post 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...
Go to the top of the page
 
+
Miguel_A
post 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)
Attached File  relatorio.jpg ( 1.5MB ) Number of downloads: 10
 
Go to the top of the page
 
+
fkegley
post 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.
Go to the top of the page
 
+
MadPiet
post 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.
Go to the top of the page
 
+
Jeff B.
post 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?
Go to the top of the page
 
+
Miguel_A
post 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...
Go to the top of the page
 
+
fkegley
post 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.
Go to the top of the page
 
+
Miguel_A
post 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
Go to the top of the page
 
+
fkegley
post 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.
Go to the top of the page
 
+
Miguel_A
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 10:29 PM