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

[Lavs]

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....

[Killer42]

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?

[Lavs]

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...

[Killer42]

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.

[Dököll]

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

[Lavs]

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

[Killer42]

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.

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

(By the way, I've updated the title of this thread.)