Solved

Horizontal Continuous Forms

Posted on 1998-08-16
7
673 Views
Last Modified: 2006-11-17
In Access 97 any form can be changed to continuous, but then it places the records vertically. Is it possible create the form that will display them horizontaly. (I don't want to place the fields on the from throught the means of the code and then manually handle events) However if some one will provideme with such code I will pump up the number of points.
0
Comment
Question by:alex123
7 Comments
 
LVL 4

Expert Comment

by:tomook
ID: 1959297
You can do it in reports, but not forms. This sounds like a good product enhancement idea for MS.
0
 
LVL 17

Expert Comment

by:ramrom
ID: 1959298
You can "fake it" using a series of identical sub-forms arranged in a horizontal row. By applying appropriate filters to each you can display a series of rows, and simulate scrolling by changing the filters.
0
 

Author Comment

by:alex123
ID: 1959299
Thanks to ramrom, but I belive that solution will make the database to slow
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 5

Expert Comment

by:tuvi
ID: 1959300
I think then the only way is to use the controls on the form and populate them with codes and simulate scrolling. If you fix the horizontal size of the form: that is, a fix number of records per view, you can do it in code. It's not that hard, really.
0
 
LVL 4

Expert Comment

by:tomook
ID: 1959301
Good point, tuvi. That way the performance would not suffer either.
0
 
LVL 5

Expert Comment

by:kulikuli
ID: 1959302
If the items you'd like to display are not to be editable you can create a cross-tab query and format it so that you get your values displayed as you like.
0
 

Accepted Solution

by:
eugeneo earned 30 total points
ID: 1959303
Create an extremely wide form with one text-box. On_Load of that form, count the number of records and replicate the text box that many times (I know for sure it's possible in VB, but maybe impossible in Access.... you'll have to try :) Go through all the records and write the values into the textboxes.
Now, that wide form should have a horizontal scrollbar enabled. Insert it as a subform into any form and you'll have a horizontal subform! (Well, sort of :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now