 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Grid on form
Greetings, I am creating a subform to be place in another form. I want a grid to appear on the form and contain table data. How do you place a grid on the form ? thanks, -D Will continuous forms do what you're looking for?  Signaturehth, SusanV > Greetings, > I am creating a subform to be place in another form. [quoted text clipped - 4 lines] > thanks, > -D Sorry but what are continuous forms (I'll look at them and see if they suffice). -Darryl > Will continuous forms do what you're looking for? > > Greetings, [quoted text clipped - 5 lines] > > thanks, > > -D Set up a form with the labels above the controls, so that the controls span left to right in a single row across the form. Drag the form footer or bottom of the form to directly below the data textboxes. In the form's properties>> Format tab >> Default View, select Continuous Forms. Your labels will be across the top above the data, and the records will list in rows below, similar to an excel spreadsheet or table layout. > Sorry but what are continuous forms (I'll look at them and see if they > suffice). [quoted text clipped - 10 lines] >> > thanks, >> > -D I must be eating "stupid" pills today. I can't quite get the form - subform relationship working. Table 1 memberid (Primary key) otherfields. Table2 memberid (field in table). Created a form. Put a listbox on the form. When placing the listbox answer the wizard's questions and select the table fields I want show. Create a form (which will be a subform). Do like your previous posting. Drag and drop the subform I created into form1. Select subform and choose properties. Can't use the build child link or master link "Can't build a link between unbound forms". If I type in memberid in child link and memberid in the master link, it still doesn't work. Definition of doesn't work: Click on entry in listbox, doesn't cause records from table2 to display in the subform (records from table2 that have the same memberid as the record selected in listbox). -D > Set up a form with the labels above the controls, so that the controls span > left to right in a single row across the form. Drag the form footer or [quoted text clipped - 17 lines] > >> > thanks, > >> > -D Is the same table/field part of the source for both forms? If not, you will need to work out a way to manage this, in order to create the master/child links. Signaturehth, SusanV >I must be eating "stupid" pills today. > [quoted text clipped - 51 lines] >> >> > thanks, >> >> > -D Table1 contains records for members (memberid, name,etc). Table2 contains transactions for the members (trannum,memberid,trandate, etc). In the listbox I want all the members to appear. When the user clicks on a user name in the listbox, I want a grid on the right to show all the transactions for that member. So, the linking field between table1 and table2 is memberid. I haven't created a "relationship" (1 to many) between the tables. I thought by specifying the child link and master link fields as memberid I would be ok. What am I missing ? > Is the same table/field part of the source for both forms? If not, you will > need to work out a way to manage this, in order to create the master/child [quoted text clipped - 54 lines] > >> >> > thanks, > >> >> > -D No, the relationship must be defined in order to link the fields. I bet once you do this it will be fine ;-) SusanV > Table1 contains records for members (memberid, name,etc). > Table2 contains transactions for the members (trannum,memberid,trandate, [quoted text clipped - 83 lines] >> >> >> > thanks, >> >> >> > -D thanks for the help. Still cludgy and doesn't work quite right. Everything I've read says drag-n-drop and all is well. When I drop a subform on a main form, it NEVER builds the child/master links. When I click the wizard (...) it says "Can't build a link between unbound forms". If I assign a data source to my main form (which doesn't have any controls other than 2 subforms), then it works but since the main form does not cycle through the records, the subreport sticks on the first record of table2. Ready to scream now. Even tried a listbox on the main form and then the detail sub form. When I click on a record in the listbox, the detail doesn't show. A tutorial probably would help. -D > No, the relationship must be defined in order to link the fields. I bet once > you do this it will be fine [quoted text clipped - 90 lines] > >> >> >> > thanks, > >> >> >> > -D I feel your pain Darryl, been there believe me! I ran into the EXACT same thing you are on my first project. Then one day when my head hurt from running it into the wall I realized - instead of using 2 subforms, use ONE as the main form and make it bigger to accommodate the second one as a subform to that one. Make sure both forms are related and you should be good to go. It can be frustrating for sure, but you'll get it working! ;-) > thanks for the help. Still cludgy and doesn't work quite right. > Everything I've read says drag-n-drop and all is well. [quoted text clipped - 120 lines] >> >> >> >> > thanks, >> >> >> >> > -D |
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.