printing all tabs in form

[yepwingtim]

how can i do that

If i had to make a report how am i going to make it? I have over 200 fields~
________
Fake Weed

 

[KenHigg]

I would suggest building a report and get away from printing forms -

 

[yepwingtim]

this is in case we get audited i need to print it the forms out
________
Marijuana Vaporizer

 

[dkinley]

You can't show a database diagram to demonstrate to the auditor's that the data all comes from the same source?

-dK

 

[KenHigg]

off topic: dk, how'd you get a red reputation?

 

[yepwingtim]

that's up to the auditor... I have no clue what he/she wants...

any suggestions??
________
Vaporizer

 

[KenHigg]

Any auditor that will not take a report as a source of data should be fired for wasting company time and resources. If the report could contain bogus data the form could contain bogus data as well

 

[yepwingtim]

I really need to know a way around this... My head's explodin x(
________
Homemade Vaporizer

 

[dkinley]

hehehe ... im shameless I guess ...

A fellow was wondering about a structural problem so I gave him my take on it on how I resolved a similar delimma in the past. He reported me for "Giving advice to denormalize".

I am not really sure what that meant, I was just offering A solution that worked for me in the past - not telling him how he should do his business.

So .. there you have it.

-dK

 

[dkinley]

yep ...

I am not offering any formal advice on office politics or anything, I am only recounting past experiences.

In similar situations things have been requested of me in the past. I complied and then spent the next several weeks doing what auditors wanted (because they are, after all, the law) and by golly, they wanted it RIGHT THEN!

I explained that was beyond the scope of the office and proceeded to do it manually. They were miffed at the time it was going to take. Next, I handed them several cases of printed pages they would have to go through (imagine 1k records with 3 tabs each).

So, after the time and the expense I was allowed to a datadump into an Excel spreadsheet.

Ask your boss what you should require and be required to do. That's what bosses are paid for.

-dK

 

[KenHigg]

About all I know to do is click tab 1 and print the form, then click tab 2 and print the form, etc.

 

[yepwingtim]

I guess it's not possible -_-
________
FORD EDIS HISTORY

 

[KenHigg]

I hate to keep this one going but I a little baffled as to what you need.

- You have a form with a tab control with numerous fields of data. Now you want to print the form and have all of the fields magically appear somehow - ? What was you thinking - That you could somehow stretch the tab control into one long section that contained all of fields when it was printed - ? Not trying to be a smarty just trying figure out what you envisioned - ?

 

[georgedwilkinson]

I'm also not sure why you want it, but why not just take a screen shot of the form displaying the record(s) in question? You'd have to click on each tab in turn but it should resolve the auditor's question.

 

[yepwingtim]

http://img413.imageshack.us/img413/5996/76957291kw7.jpg i know the form sucks any advice thanks

i want to print out all the tabs... the printer will print general tab first then gynecologic then obtetiscal and so on
________
SUZUKI RV 125 VAN VAN SPECIFICATIONS

 

[KenHigg]

I would put a 'Print Tab' button on each tab and print the form from there. That way when you print the form the tab that is currently selected will print.

 

[Mike375]

Assuming the form is based on a table with 200 fields I would do the following:

For 200 fileds the odds are very high that there will be different groups of data type, that is, there might be 12 fields that cover a certain class of data and there might be 15 fields that cover another class of data and so on.

I would make queries that selected the fields based on such grouping and then just print the queries out in landscape. However, each query for a group of fields would also have the customers name or whatever the main entity is so as to identify the data. If you want to make the print out look fancy or have it group data etc then make make Reports based on the queries.

 

[KenHigg]

Or something like the following:

me.TextBoxNameOnTabOne.setfocus

Print code goes here

me.TextBoxNameOnTabTwo.setfocus

Print code goes here

Etc...

 

[KenHigg]

(I would preffered to have seen the 'General' tab as the one you posted )

 

[yepwingtim]

Hi Ken the general tab has personal infomation I cannot use that one lol...
I have very little VB knowledge how would I use that code?
________
LOVE ADVICE ADVICE