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
|
|||
|
|||
Tables in Forms - Field Splitting
Hi all!
I have a quick question - is it possible to have a table within a form (ie the subform is just the table itself - I dragged and dropped the table into the main form from the Navigation screen), and to only bring in some of the fields, or make some of the fields read only, while others are able to be edited? Basically I have a table with BranchCode | BranchName | CashBudget | DebitBudget and I only want users to be able to edit CashBudget & DebitBudget, via a form, but I want to keep the datasheet view (since we have over 40 branches listed). Any ideas? Thanks! -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Tables in Forms - Field Splitting
A form does not 'contain' a table. A form (or subform) has controls that are
bound to columns in a table. If you only want certain columns to be updatable, then do not include controls for the other columns or make the controls hidden or locked. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "ErikFM via AccessMonster.com" wrote: Hi all! I have a quick question - is it possible to have a table within a form (ie the subform is just the table itself - I dragged and dropped the table into the main form from the Navigation screen), and to only bring in some of the fields, or make some of the fields read only, while others are able to be edited? Basically I have a table with BranchCode | BranchName | CashBudget | DebitBudget and I only want users to be able to edit CashBudget & DebitBudget, via a form, but I want to keep the datasheet view (since we have over 40 branches listed). Any ideas? Thanks! -- Message posted via http://www.accessmonster.com . |
#3
|
|||
|
|||
Tables in Forms - Field Splitting
On Thu, 08 Apr 2010 13:46:51 GMT, "ErikFM via AccessMonster.com" u57373@uwe
wrote: I have a quick question - is it possible to have a table within a form (ie the subform is just the table itself - I dragged and dropped the table into the main form from the Navigation screen), and to only bring in some of the fields, or make some of the fields read only, while others are able to be edited? Not a table, no. If you like the datasheet appearance, you can certainly use a Subform with "datesheet" as its default view; it can be based on a query selecting only a subset of the fields. You can also use a Continuous Form which can be made to look very much like a datasheet, but gives you more control; e.g. you can have some controls locked so the user can read but not edit them; you can use other controls such as combo boxes or option groups. You might want to look at some of the hints, tutorials and resources he Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|