 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / January 2006form layout
Hi i have imported two tables from excel each table contains information about a team what i want to do is display the records on the same form side by side i have created a table using a query and append the two imported tables but i cant get the records to display the way i wish fields are team time fault action i would like the form to be laid out as folows information for team 1 information for team 2 time fault action time fault action can anyone help please thanks kevin > Hi > i have imported two tables from excel each table contains information [quoted text clipped - 19 lines] > > thanks kevin So you no longer have two tables, but one - is this how you want the data structured? Does the data really only relate to two teams and the main form only displays team 1 and 2, or will the form be used to show other 'pairs of teams'? What about any other functionality of the form, eg find, sort, add, edit delete? At its simplest (and if there are no other requirements) I would have an unbound main form with two subforms with recordsources of: SELECT MyTable.* FROM MyTable WHERE MyTable.Team=1 SELECT MyTable.* FROM MyTable WHERE MyTable.Team=2 thanks i will try it now Anthony i have created the unbound form and inserted two sub forms is there any reason why i can not write to a text box in the sub forms thanks again for your help kevin > Anthony > i have created the unbound form and inserted two sub forms is there any > reason why i can not write to a text box in the sub forms > thanks again for your help > kevin Can you see the data and not able to edit it? Or are you talking about adding a new record? Is the textbox bound to a field? Have you set AllowEdits? Good morning Anthony, 1. i can see the data in all the fields 2 the textbox is bound to a field in the table 3 allowedits is set to yes i am returning the data from the tables(imported from excel ) i have a field then called action this is where i want the user to enter data, the field will record the action taken > Good morning Anthony, > 1. i can see the data in all the fields [quoted text clipped - 4 lines] > this is where i want the user to enter data, the field will record the > action taken I can't think what else might be wrong. If you can write directly to the table, but not the form then double check the SQL behind the subforms - it should be a standard SELECT (no TOP or DISTINCT) and the recordsource type should be dynaset (if it were snapshop that would stop you editing) Anyway, if you're still stuck - send me a copy of the mdb file. I've let you know my contact details via e-mail (assuming you post your real e-mail address). |
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.