displaying data in multiple columns - Microsoft Access / VBA

Jane

Hi,
If anyone could help me with this, I greatly appreciate it.

I would like to know how I can display data from a db in multiple
columns rather than have it displayed in 1 column per recordset. Here
is a twist...besides doing this, I would also like to have it paginate
and be able to control how many records gets displayed per page in
multiple columns.

Thank y'all in advance!!!

Jane

Nov 12 '05 #1

Subscribe Reply

2631

Fletcher Arnold

"Jane" <ja**@webdevas. com> wrote in message
news:2b******** *************** **@posting.goog le.com...

Hi,
If anyone could help me with this, I greatly appreciate it.

I would like to know how I can display data from a db in multiple
columns rather than have it displayed in 1 column per recordset. Here
is a twist...besides doing this, I would also like to have it paginate
and be able to control how many records gets displayed per page in
multiple columns.

Thank y'all in advance!!!

Jane

You are talking about reports, right? If you followed the label wizard, you
would get a multi-column report. If you want to do it from scratch, create
your report and go to File>Page Setup>Columns tab and select the column
layout.
The number of records per page depends on the size of the report sections
and margins and the number of columns - unless you force a new page before
it naturally runs out of space on the paper.

Nov 12 '05 #2

Jane Wong

Hi Thanks for replying, but no, I want to display this data on a web
page. What it is, is I am storing links of images and their
descriptions in Access for a gallery page. I would like to display this
info when retrieved from the db into multiple columns with pagination.
Any ideas?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #3

Fletcher Arnold

"Jane Wong" <ja**@webdevas. com> wrote in message
news:40******** *************@n ews.frii.net...

Hi Thanks for replying, but no, I want to display this data on a web
page. What it is, is I am storing links of images and their
descriptions in Access for a gallery page. I would like to display this
info when retrieved from the db into multiple columns with pagination.
Any ideas?

How does it get from the database to a web page? Have you decided on what
basic techniques you are going to employ? Active Server Pages, Data Access
Pages or perhaps a custom-routine written in vba? A lot will depend on
whether you wish to view live data or are happy with a static snapshot.
Have you made any start on this project yourself, or are you looking for
general pointers?
Fletcher

Nov 12 '05 #4

Similar topics

5778

problem displaying MEMO field from ACCESS 2000 on WINDOWS 20003

by: euang | last post by:

Hi, I have been using access 2000 for two years on WINDOWS NT to display dynamic aweb page using ASP My ISP has now changed to Windows 2003, and I am having major problems displaying information from MEMO fields within the Access 2000 database. I have not had any problems before displaying MEMO fields on NT and have tried various tips...

ASP / Active Server Pages

1947

Data Grid displaying columns TWICE!

by: pmud | last post by:

Hi, I have 4 columns in my sql database table. I added a data adapter , data set & a data grid to view this information. But the data grid is displaying those 4 columns TWICE , i.e in the data grid i see 8 columns. In case this is useful, the primary key is Serial no. which is an identity ....i.e everytime a row is added to the database,...

.NET Framework

2348

Date displaying

by: Russ | last post by:

I've got a report that puts dates at the top of columns and the user is prompted to enter a beginning date when the report is opened. That date is put in a textbox in the first column like this: =DateValue() Then the next columns are textboxes that add 7 to the previous column for the date display of the next week like this: =+7

Microsoft Access / VBA

2205

Displaying information in Access - general question

by: Robert | last post by:

Hello Accessors I have some reports created in Access that are very good for what they do. However, it seems to me that when you are displaying information you don't need to print out that a printer-friendly report is not the best way to go. So, I tried converting one of my Access reports to an Access form. I selected the continuous view...

Microsoft Access / VBA

1398

displaying records with many fields

by: Lisa Calla | last post by:

Hi, I need to display records with lots of fields. When placed in a grid, a row of data will scroll off the screen. Not exactly what I'm looking for. I've also used a datalist, which allows multiple lines for a single row of data (yes! no horizontal scrolling!), but columns do not line up across listitems/data rows (very ugly & distracting...

ASP.NET

14657

Displaying only selected columns in a data grid?

by: What-a-Tool | last post by:

Have an Access table loaded into a DataTable that was created at run time, and am displaying these contents in a data grid. Me.dgGames.DataSource = Me.DsGameInfo.Tables("Games") I would like to display only a selected few of the columns, rather than the whole table. Is this possible? Thanks - Sean

Visual Basic .NET

2345

displaying images on a website from binary

by: CLEAR-RCIC | last post by:

I have several images i want to display in an ASP.Net application. The images are being passed to me in binary format from another application. Is there a good way to write them directly to an HMTL page without having to save them to the server and create a URL to the virtual directory? FYI: I currently am doing this with just single...

.NET Framework

4768

Problem displaying multiple records in one form for data entry.

by: NumberCruncher | last post by:

Hi All, I am struggling with setting up my first system of tables, forms,and reports, and could use your help! I am setting up a database to keep track of the production of a produced item. The item is a panel, with a specific texture. There are standard panels that are then produced in a limited number of specific textures. The number of...

Microsoft Access / VBA

3116

Hyperlink Column not displaying

by: William LaMartin | last post by:

I have a gridview (with no properties set) on an aspx page which I populate from an XML file with the code below. The data in the XML file looks like this <description>National Trust for Historic Preservation</description> <URL>http://www.nthp.org/</URL> <category>Architecture</category> Can anyone tell me why the other two columns...

ASP.NET

7465

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7656

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7805

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7416

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5969

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

4944

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3449

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3441

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1878

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp