473,233 Members | 1,374 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,233 software developers and data experts.

report lay-out & reading data from txt-file

allrite folks, got some questions here...

1) LAY-OUT OF REPORTS
How is it possible to fundamentaly change the lay-out/form of a report in
access? I dont really know it that "difficult", but listen up;

Reports, the way I look at them, all present data downwards, in this way;

TITLE
data
data
SUBTITLE
data
data
SUB-SUBTITLE
data
data

is it possible to present the data "sideways", like this;

TITLE data data data data
SUBTITLE data data data data
S.S.TITLE data data data data

e.g. for making week-schedules and stuff??
2) READING DATA FROM A TXT FILE
Know this better in delphi... What component do I use if I want to load a
txt file into my app? How do I open a txt file and display it in the
component? How to read the text line by line, reading ONE character at a
time, and all the RIGHT$/LEFT$/MID$ functions would also come in handy
here...

Thanks !

Magnus,
Norway
Nov 12 '05 #1
1 6719
"Magnus" wrote
1) LAY-OUT OF REPORTS . . . Reports, the way I look at them,
all present data downwards . . .
is it possible to present the data "sideways", like this;

TITLE data data data data
SUBTITLE data data data data
S.S.TITLE data data data data
It depends on the data. If it is suitable, a CrossTab Query in Access 2000
or earlier, can be used as the RecordSource of a Report. In Access 2002 and
later, you can take a look at Pivot Table view -- that may be even easier or
better for you.
2) READING DATA FROM A TXT FILE
Know this better in delphi... What component
do I use if I want to load a txt file into my app?
How do I open a txt file and display it in the
component? How to read the text line by line,
reading ONE character at a time, and all the
RIGHT$/LEFT$/MID$ functions would also
come in handy here...


A text box control will work nicely for displaying text. Some basic FileI/O
statements you can look up in Help are Open, Input #, Line Input, Close...
these are for reading text. But you will actually read the data into a
variable.

There are other modes of reading that might work if you really need to
_read_ a character at a time. You can work your way through the data,
though, a character at a time, easily enough with VBA code.

There's also the FileSystemObject for handling files. My tests using it for
text files didn't show any advantage over the "old way" and lots of System
Administrators disable it as a security measure. If your SA does not, and
you prefer to work with objects instead of plain old code, that might be of
interest.

A newsgroup response really doesn't work well as a "tutorial" on a subject
this broad, though. I have an example database of random access file I/O
that you can download from
http://accdevel.tripod.com/downloads...accessdemo.zip. Unfortunately,
that deals with files of records, rather than just sequential text files, so
probably won't be any help to you. That is a different approach, and uses
different statements.

Larry Linson
Microsoft Access MVP
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tom | last post by:
I have a report where one field tends to be rather lengthly and ends up being several lines long while another field has several short entries. The problem I have is that the first of the short...
4
by: John Baker | last post by:
Hi: At the bottom of a report, I wish to sum all the amounts that appear in a field called Discount$ that appears on the report. I am not doing this summing in the query that supports the report...
0
by: Timmy Jones | last post by:
Hey all, I am trying to try get a crytal report running properly. A "Hello World" report that does not add criteria to the record selection formula of the report (either in the development tool,...
0
by: RJN | last post by:
Hi I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the formula in the main...
0
by: RJN | last post by:
Hi Sorry for posting this message again. I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be...
0
by: rjn | last post by:
Hi I have a main report in which I have inserted a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the...
2
by: amith.srinivas | last post by:
Hi all, From a word macro in VBA, I am trying to create a report in access DB. The report is based on a query with a parameter. I am using Set rpt = Application.CreateReport rpt.RecordSource =...
4
by: MLH | last post by:
I have a report and on it, a subreport control Main Report Name: rptInvoiceMain Sub Report Name: rptInvoiceSubReport SubReport Control Name: rptInvoiceSubReportCtl The...
0
by: John Smith | last post by:
Hello, I am developing a VB.NET 2003 application that will use lots of Crystal Reports. Sometimes the users will preview a report in a Crystal report viewer, and sometimes they will send the...
0
by: kamboj.shalabh | last post by:
Hi to all, Well, I am working on dotnet 2005 with crystal reports 10 and backend as sql server. I am facing a problem while loading a report. Actually the issue is, when I load report it takes...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.