If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I simple create a table like structure in my form
Access 2007
I want a table looking object in my form so I can put buttons text boxes etc.. .. in it. It is not a table, just has that grid look. If at all possible I really don't want to create a bunch of boxes manually and populate with them. Is there an object that replicates a table look. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
#2
|
|||
|
|||
How can I simple create a table like structure in my form
I think you are talking about Datasheet View or Continious Form.
-- Build a little, test a little. "Hoardling1 via AccessMonster.com" wrote: Access 2007 I want a table looking object in my form so I can put buttons text boxes etc.. .. in it. It is not a table, just has that grid look. If at all possible I really don't want to create a bunch of boxes manually and populate with them. Is there an object that replicates a table look. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
#3
|
|||
|
|||
How can I simple create a table like structure in my form
For what purpose? Are you trying to give your users something that looks
like a spreadsheet? If so, having them use Access as if it were a spreadsheet may lead to more issues later... Regards Jeff Boyce Microsoft Access MVP "Hoardling1 via AccessMonster.com" u43783@uwe wrote in message news:9d352ba53bad6@uwe... Access 2007 I want a table looking object in my form so I can put buttons text boxes etc.. . in it. It is not a table, just has that grid look. If at all possible I really don't want to create a bunch of boxes manually and populate with them. Is there an object that replicates a table look. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
#4
|
|||
|
|||
How can I simple create a table like structure in my form
On Tue, 06 Oct 2009 22:58:26 GMT, "Hoardling1 via AccessMonster.com"
u43783@uwe wrote: Access 2007 I want a table looking object in my form so I can put buttons text boxes etc.. . in it. Those would seem to be contradictory requirements: a Table has textboxes but not buttons. It is not a table, just has that grid look. If at all possible I really don't want to create a bunch of boxes manually and populate with them. Is there an object that replicates a table look. I would suggest a Continuous Form. You'll need to (one time only) create a textbox bound to each field, and snug them up to the top of the detail section of the form and to each other. You can intersperse combo boxes, command buttons, option groups, etc. if those are suitable for the data. Drag the bottom of the Detail section up to the bottom of the textboxes and you'll get a pretty good imitation of a datasheet in appearance, but still have the flexibility of control types; *and* you can display the form Header and Footer for custom labels, subtotals, calculated fields, search combos, etc. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
How can I simple create a table like structure in my form
"Hoardling1 via AccessMonster.com" u43783@uwe wrote
I want a table looking object in my form so I can put buttons text boxes etc.. in it. It is not a table, just has that grid look. If at all possible I really don't want to create a bunch of boxes manually and populate with them. Is there an object that replicates a table look. There's no "grid look" object built in to Access. Access can use some (but not all) ActiveX controls, and there are various grid-look controls available from third-party vendors, if you are that serious (they have much more capability than you describe, and are not necessarily inexpensive). Although you say you don't wish to do so, you can, and some have, grouped controls within the rectangles and lines that are built in Access controls. Given that your wish for a built-in grid is just not the way things are, you may just have to work with the way things actually are. But, as others have commented, it would be helpful if you would explain what you are trying to accomplish, if it is not just to satisfy your own idea of appropriate design. There are many experienced and talented developers who participate in this newsgroup, and it's entirely possible that some of them might be able to make useful suggestions for accomplishing your purpose in a different way. Larry Linson Microsoft Office Access MVP |
#6
|
|||
|
|||
How can I simple create a table like structure in my form
I only need a grid view for visual purposes only. Something with borders and
a transparent background. The grid view will not link to data. Just eye candy to help split up a form. Larry Linson wrote: I want a table looking object in my form so I can put buttons text boxes etc.. in it. It is not a table, just has that grid look. If at all possible I really don't want to create a bunch of boxes manually and populate with them. Is there an object that replicates a table look. There's no "grid look" object built in to Access. Access can use some (but not all) ActiveX controls, and there are various grid-look controls available from third-party vendors, if you are that serious (they have much more capability than you describe, and are not necessarily inexpensive). Although you say you don't wish to do so, you can, and some have, grouped controls within the rectangles and lines that are built in Access controls. Given that your wish for a built-in grid is just not the way things are, you may just have to work with the way things actually are. But, as others have commented, it would be helpful if you would explain what you are trying to accomplish, if it is not just to satisfy your own idea of appropriate design. There are many experienced and talented developers who participate in this newsgroup, and it's entirely possible that some of them might be able to make useful suggestions for accomplishing your purpose in a different way. Larry Linson Microsoft Office Access MVP -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
#7
|
|||
|
|||
How can I simple create a table like structure in my form
On Wed, 07 Oct 2009 20:35:19 GMT, "Hoardling1 via AccessMonster.com"
u43783@uwe wrote: I only need a grid view for visual purposes only. Something with borders and a transparent background. The grid view will not link to data. Just eye candy to help split up a form. The Rectangle tool would appear to be suitable, in that case. -- John W. Vinson [MVP] |
#8
|
|||
|
|||
How can I simple create a table like structure in my form
Transparent? Not that I know of but take a look at Peter Hibbs demo on
FlexGrid. http://www.rogersaccesslibrary.com/f...ts.asp?TID=511 Hoardling1 wrote: I only need a grid view for visual purposes only. Something with borders and a transparent background. The grid view will not link to data. Just eye candy to help split up a form. -- Please Rate the posting if helps you. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
Thread Tools | |
Display Modes | |
|
|