PC Review


Reply
Thread Tools Rate Thread

Horizontal Form

 
 
comish4lif
Guest
Posts: n/a
 
      2nd Mar 2012
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?
 
Reply With Quote
 
 
 
 
Access Developer
Guest
Posts: n/a
 
      2nd Mar 2012
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 Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"comish4lif" <(E-Mail Removed)> wrote in message
news:12084226.285.1330702525829.JavaMail.geo-discussion-forums@yner4...
> 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?



 
Reply With Quote
 
 
 
 
bennettkristina@gmail.com
Guest
Posts: n/a
 
      14th Jun 2012
On Friday, March 2, 2012 11:38:41 AM UTC-7, Access Developer wrote:
> 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 Linson
> Microsoft Office Access MVP
> Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
>
> "comish4lif" <> wrote in message
> news:12084226.285.1330702525829.JavaMail.geo-discussion-forums@yner4...
> > 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 Ais
> > 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?


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
 
Reply With Quote
 
Access Developer
Guest
Posts: n/a
 
      14th Jun 2012
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

<(E-Mail Removed)> wrote in message
news:6e5a4877-6e4f-4880-a5b5-(E-Mail Removed)...
On Friday, March 2, 2012 11:38:41 AM UTC-7, Access Developer wrote:
> 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 Linson
> Microsoft Office Access MVP
> Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
>
> "comish4lif" <> wrote in message
> news:12084226.285.1330702525829.JavaMail.geo-discussion-forums@yner4...
> > 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?


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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use horizontal column titles in list box (VBA form) Mr. Smith Microsoft Excel Discussion 3 10th Jul 2006 11:06 PM
horizontal continuous form =?Utf-8?B?dGlt?= Microsoft Access Forms 2 13th Feb 2006 09:38 PM
Draw a horizontal line on the form without using GDI A.M-SG Microsoft Dot NET Framework Forms 6 17th Jan 2006 09:02 PM
outpulsing data of a form in vertical format, not horizontal dave Microsoft Access Forms 25 21st Nov 2003 12:34 AM
What's wrong with this Form code ?? --Horizontal Mis-Alignment Mystery!!!-- tmb Microsoft Frontpage 3 17th Sep 2003 10:10 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:19 PM.