Horizontal Form

C

comish4lif

Is this possible?

In access, you can set up headers and detail and footers, and then within the detail, the data retrieved is stacked/displayed vertically (where A is over B which is over C, etc).

Is there a way to make the header, detail, and footers to display across the page (where A is to the left of B which is to the left of C and so on)?

Anyone have a clever workaround?
 
A

Access Developer

You can do _almost_ anything with enough thought, cleverness, VBA code, and
_work_. The question would be "Why?" I've never seen any evidence, not
even any indication, that such an arrangement would be more productive, and,
if you are talking about "continuous forms view" in the body, it's not
something that Access provides or even makes easy to accomplish as a
workaround to 'standard design'.

In general, Access is intended to make it easy, if not trivial, to create a
simple database application for an individual, workgroup, or as a client to
a server database on a single machine or a LAN... so it includes 'good
practice' options, not 'all' options. My guess is that, if you choose to go
to the effort and spend the time to try to implement what you describe that,
before you are finished, you'll regret having done so.

But, if you feel compelled, I'd start with a main form and one to three
subforms (you might put the header and footer information directly on the
sides of the main form and the subform centered).
 
B

bennettkristina

You can do _almost_ anything with enough thought, cleverness, VBA code, and
_work_. The question would be "Why?" I've never seen any evidence, not
even any indication, that such an arrangement would be more productive, and,
if you are talking about "continuous forms view" in the body, it's not
something that Access provides or even makes easy to accomplish as a
workaround to 'standard design'.

In general, Access is intended to make it easy, if not trivial, to createa
simple database application for an individual, workgroup, or as a client to
a server database on a single machine or a LAN... so it includes 'good
practice' options, not 'all' options. My guess is that, if you choose to go
to the effort and spend the time to try to implement what you describe that,
before you are finished, you'll regret having done so.

But, if you feel compelled, I'd start with a main form and one to three
subforms (you might put the header and footer information directly on the
sides of the main form and the subform centered).

Larry

May I complement you on a completely condesending response with almot no helpful information? The fact you can't conceptualize a need in no ways means the need doesn't exist. It only means you have a very narrow knowledge point. Not that it's needed, but to assist in your continued growth I'll say I came to this page because I am designing a media center utilizing an access db base. With my widescreen TV, I could scroll the movie icons vertically have have 2-3 display...or I could have 10-11 display if I were able to scroll the table horizontially.

I hope to the diety of your choice that you aren't in the software support field. I'd hate to be your customer having to explain their 'need' for your approval before hoping for any assistance.

And now I'm off to see if there is any real help availab.e
 
A

Access Developer

In my neck of the woods, that'd be known as a "left-handed compliment".
This isn't, as they say, "my first rodeo" . . . IMNSHO, Access isn't the
best development software for implementing a media center; that's certainly
not what Access was intended for. Oh, by the way, nowhere did I say there
was _no need_ for what you asked about -- but, it's true that I don't see a
need for it in the kind of "normal business database applications" for which
Access has always been intended.

Access has been, and is, an excellent tool that makes it easy to develop
certain types of application -- "normal business database applications" for
individuals, small workgroups, and client-server applications on a LAN or
even a WAN. Graphics and media are not its strong point. Forms and reports
have a limit of 22 inches ("Windows inches") horizontally and vertically for
each page (screen) which makes it even more difficult.

You can, very likely (as I said, with enough thought, cleverness, VBA code,
and work) do what you want. It is likely that you could do it with somewhat
less of all of those using a different software development product. It's
certainly not something that could be handled in one or a few posts in a
newsgroup thread.

I'm sorry I can't offer you more encouragement and a few posts to accomplish
what you want to do... but, as far as I know, Access just isn't _that_
adaptable. On the other hand, I'm always happy to learn, so if you come up
with an easy way to use Access to accomplish what you describe, I'd really
like to see/hear/learn that approach.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

You can do _almost_ anything with enough thought, cleverness, VBA code,
and
_work_. The question would be "Why?" I've never seen any evidence, not
even any indication, that such an arrangement would be more productive,
and,
if you are talking about "continuous forms view" in the body, it's not
something that Access provides or even makes easy to accomplish as a
workaround to 'standard design'.

In general, Access is intended to make it easy, if not trivial, to create
a
simple database application for an individual, workgroup, or as a client
to
a server database on a single machine or a LAN... so it includes 'good
practice' options, not 'all' options. My guess is that, if you choose to
go
to the effort and spend the time to try to implement what you describe
that,
before you are finished, you'll regret having done so.

But, if you feel compelled, I'd start with a main form and one to three
subforms (you might put the header and footer information directly on the
sides of the main form and the subform centered).

Larry

May I complement you on a completely condesending response with almot no
helpful information? The fact you can't conceptualize a need in no ways
means the need doesn't exist. It only means you have a very narrow
knowledge point. Not that it's needed, but to assist in your continued
growth I'll say I came to this page because I am designing a media center
utilizing an access db base. With my widescreen TV, I could scroll the
movie icons vertically have have 2-3 display...or I could have 10-11 display
if I were able to scroll the table horizontially.

I hope to the diety of your choice that you aren't in the software support
field. I'd hate to be your customer having to explain their 'need' for your
approval before hoping for any assistance.

And now I'm off to see if there is any real help availab.e
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top