 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Datasheet question again
Is it possible to show a Form Header on a Datasheet form ? Thanks Hi Phill Don't think so. You could create a form with a header and then place the datasheet within this as a subform. This would give the same effect provideing you don't have a border.  SignatureWayne Manchester, England. > Is it possible to show a Form Header on a Datasheet form ? > > Thanks Hello, I have done this, inserting a datasheet as a subform on my main form. Question is: How do you get it to be a datasheet view without having to maximize but the width and height of hte subform itselff to show ALL the data? Thanks, MN > Hi Phill > [quoted text clipped - 7 lines] > > > > Thanks > Hello, > > I have done this, inserting a datasheet as a subform on my main form. > Question is: How do you get it to be a datasheet view without having > to maximize but the width and height of hte subform itselff to show > ALL the data? Make the subform control taller and wider? Sorry the question doesn't really make much sense to me. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Wel that is what I am having to do in order to show all the data in my subform -- which i made to be a datasheet view. What i want is it to be a true datasheet, where no matter what the "size' of the subform is on the main form...that it will show ALL the data -- so you can scroll to the right to see everything. That is not how it is working when it's a subform within a form. > > Hello, > > [quoted text clipped - 5 lines] > Make the subform control taller and wider? Sorry the question doesn't > really make much sense to me. > Wel that is what I am having to do in order to show all the data in my > subform -- which i made to be a datasheet view. What i want is it to > be a true datasheet, where no matter what the "size' of the subform > is on the main form...that it will show ALL the data -- so you can > scroll to the right to see everything. That is not how it is working > when it's a subform within a form. It is if you enable scrollbars. Look at the scrollbars property of the form shown in the subform control. Not of the subform control. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com scrollbars are enabled on both the subform and the form... > > Wel that is what I am having to do in order to show all the data in my > > subform -- which i made to be a datasheet view. What i want is it to [quoted text clipped - 5 lines] > It is if you enable scrollbars. Look at the scrollbars property of the form > shown in the subform control. Not of the subform control. > scrollbars are enabled on both the subform and the form... I don't understand it then. If the form being shown within the subform control has scrollbars enabled then you should see them when viewing the main form. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com I SEE the scrollbars...but what i'm saying is that the subform -- which is supposed to be viewd in datasheet view, is not being viewed that way within the main form. I can't view ALL thte subform's data in the main form unless I completley maximize that subform's' width and height to show as many fields as possible. > > scrollbars are enabled on both the subform and the form... > > I don't understand it then. If the form being shown within the subform > control has scrollbars enabled then you should see them when viewing the > main form. > I SEE the scrollbars...but what i'm saying is that the subform -- > which is supposed to be viewd in datasheet view, is not being viewed > that way within the main form. I can't view ALL thte subform's data > in the main form unless I completley maximize that subform's' width > and height to show as many fields as possible. Do you have the default view of the form set to Datasheet? SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com i have the default view of the SUBFORM set to datasheet, but not hte main form because I have a drop down in the form header for the main form that i want to show up. > > I SEE the scrollbars...but what i'm saying is that the subform -- > > which is supposed to be viewd in datasheet view, is not being viewed [quoted text clipped - 3 lines] > > Do you have the default view of the form set to Datasheet? Sorry Maurice and Joan - just noticed you had already answered this question. Phile it's not really a good idea to ask the same question but with a different header. SignatureWayne Manchester, England. > Is it possible to show a Form Header on a Datasheet form ? > > Thanks Sorry, did not mean to. > Sorry Maurice and Joan - just noticed you had already answered this > question. [quoted text clipped - 5 lines] >> >> Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.