By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,097 Members | 1,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,097 IT Pros & Developers. It's quick & easy.

How to make a data report as small as an index card 3" X 15" for creating a catalog?

P: 16
Halu is there anybody who could give me an advice or a sample code oh how to create an index card size report for my card catalog for a library system.
I badly need this today because our thesis presentation will be done tomorrow, and it's one of the outputs that were anticipated by the panels... please if there's anyone who could help me, i really need it now... please....
Mar 23 '07 #1
Share this Question
Share on Google+
6 Replies


Expert 5K+
P: 8,434
Halu is there anybody who could give me an advice or a sample code oh how to create an index card size report for my card catalog for a library system.
I badly need this today because our thesis presentation will be done tomorrow, and it's one of the outputs that were anticipated by the panels... please if there's anyone who could help me, i really need it now... please....
Have you investigated the properties of the Printer object, such as Height, Width and Papersize?
Mar 23 '07 #2

P: 16
Hi there! :-) thanx for entertaining my question. I'm new to all these things that i'm using now. i have not yet encounter the printer properties. I thought the data report size can be set in design time. By the way, can you please send me a sample code if you have, because i have no time to explore, i am still working on some bugs in my code, and also working for the unfinished part. Thank you very much...
Mar 23 '07 #3

Expert 5K+
P: 8,434
Hi there! :-) thanx for entertaining my question. I'm new to all these things that i'm using now. i have not yet encounter the printer properties. I thought the data report size can be set in design time. By the way, can you please send me a sample code if you have, because i have no time to explore, i am still working on some bugs in my code, and also working for the unfinished part. Thank you very much...
Sorry, I missed the "datareport" reference. Unfortunately, I've never dealt with data reports in VB. I was thinking that your code was doing the printing directly.

By the way, where the subject of this thread indicates that the cards are to be 3 feet 15 inches, was that meant to be 3 inches by 15 inches?

Sorry you don't seem to have been able to find what you need here. Have you tried using the search box at the top-right? You can search TheScripts for various terms such as "vb datareport page size", and if necessary, expand the search to the rest of the web.
Mar 23 '07 #4

Dököll
Expert 100+
P: 2,364
Also, use "DataReport Adodc1" in your search terms. I am not sure about the report size, but you will definitely find something here that allows you to run a report that can be viewded/printed using MS Word. Good thing is you will not need actual code to do this...

Good luck, Lavs!

Dököll
Mar 26 '07 #5

P: 16
Thanks a lot for your help. I'll try looking for what you've advised me. By the way, you're right, i mean 3 inches by 5 inches(3" 5", not 3' 5")lol.
You're smart coz you're able to notice it. By the way i hope this is not the last time you'll help me.

Have you tried using the shell( ) in vb 6.0 in this manner?

shell("cmd. exe /c " & "c:\firstfolder>copy db1.mdb e:\secondfolder")

It was supposed to be for copying the file db1.mdb to another location which is e:\secondfolder. But it didn't work. Can you analyze my code? I have already tried the filecopy ( ) and it works. Just want to explore about shell ( ).lol
Mar 28 '07 #6

Expert 5K+
P: 8,434
Thanks a lot for your help. I'll try looking for what you've advised me. By the way, you're right, i mean 3 inches by 5 inches(3" 5", not 3' 5")lol.
You're smart coz you're able to notice it. By the way i hope this is not the last time you'll help me.

Have you tried using the shell( ) in vb 6.0 in this manner?

shell("cmd. exe /c " & "c:\firstfolder>copy db1.mdb e:\secondfolder")

It was supposed to be for copying the file db1.mdb to another location which is e:\secondfolder. But it didn't work. Can you analyze my code? I have already tried the filecopy ( ) and it works. Just want to explore about shell ( ).lol
You need to leave out the "c:\firstfolder>". This is not part of the command. When using the command prompt, this is just displayed to show you where you are. What you are doing here is telling DOS to execute the command "c:\firstfolder.com" or "c:\firstfolder.exe" or "c:\firstfolder.bat" (which probably doesn't exist), and redirect (">" is the redirection character) the output to a file called "copy db1.mdb e:\secondfolder" (which isn't a valid name). Thus, the whole command doesn't make any sense.

Try this.
Expand|Select|Wrap|Line Numbers
  1. shell("cmd. exe /c copy c:\firstfolder\db1.mdb e:\secondfolder")


(By the way, I've updated the title of this thread.)
Mar 28 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.