473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

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

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
6 1429
Killer42
8,435 Expert 8TB
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
Lavs
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
Killer42
8,435 Expert 8TB
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
2,364 Expert 2GB
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
Lavs
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
Killer42
8,435 Expert 8TB
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

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

Similar topics

3
by: Hodad | last post by:
I would like to adapt, as much as possible, the appearance and color red of the font in this button: <P><CENTER><BUTTON VALUE="SUBMIT"><A...
1
by: vsk | last post by:
Hai all, How to retrieve the information about the Network Interface Card(NIC) in C++ ?. Please help me in this regard. Thanks, vsk.
1
by: RWC | last post by:
Hello, I'm getting the error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data" when I run a report. I'm simply trying to apply the...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
1
by: laddie1997 | last post by:
When I try to create a report in Access 2003, the error message "the wizard is unable to create your report" comes up. My printer is a network printer and no local printer is attached. I can get...
0
by: David Garamond | last post by:
I want to know how functional indexes are used "in the real world". Here are the common uses: * non-unique index on the first parts of a longish text field (SUBSTRING(field)) to save disk space,...
28
by: Steven Bethard | last post by:
Ok, I finally have a PEP number. Here's the most updated version of the "make" statement PEP. I'll be posting it shortly to python-dev. Thanks again for the previous discussion and suggestions!...
3
by: prljng | last post by:
Can anyone tell me how to report "no data" in an Access report? When a field value in the detail section is null, I want to have text that says 'No results for this group header'.
4
by: Micheal | last post by:
Greetings Access Group, Being relatively new to Access, I try to work through problems on my own and have been very successful, although I have a conundrum that I have been working on for two days...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shćllîpôpď 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.