Rachel Turner
Last Activity: Dec 22 '11, 02:57 PM
Joined: Dec 15 '11
Location:
-
Thanks - I have resolved the problem. -
sierra7 - thanks so much for your help! problem resolved!Leave a comment:
-
The form contains both bound fields and subforms. All the one-to-many tables are included as subforms. I tried to include all the other fields as bound controls, but I dont know if there is a limit on the number of bound fields on a form, as I reached a point where I couldnt add any in. I have some screenshots of the form design and the relationships - how do I post them here? (the image icon asks for a URL?) I have checked the data normalisation...Leave a comment:
-
I havent looked into the Requery option yet - will take some time as I have no idea what that means. Apologies if I am asking stupid questions but I am a beginner...Leave a comment:
-
It, I think, since I havent manually copied any SQL. I take it I might be better off starting from scratch. If thats the case, do you have any advice on how I might design it better, given the huge number of fields I have?Leave a comment:
-
Sorry, I got confused between tables and forms in that last reply. There is one main form and several subforms - none of the subforms have tabs.Leave a comment:
-
Thanks - this makes sense in theory but I have no idea how to do it... will go away and do some reading! I did have a similar but simpler database which had just one main form and several subforms, and the tab controls all worked fine. I also had a previous version of this database with one form plus subforms, which I had created in the same way but had the problem with the tab key - I have been through all the properties and built it up from scratch...Leave a comment:
-
Sadly its a form of my own creation... Its in Access 2007, and based on another simpler version I had made before and worked fine, but the very large number of fields seems to be making things very complicated!
The record source for the main form is below. I'm guessing the fact that this is ridiculously long is not a good sign! I tried first putting all the fields from the one-to-one tables in as bound fields but had to replace many...Leave a comment:
-
Thanks for the response. The Data Entry property on the form is set to 'No', and I can see all the records displayed that were previously entered on the last form, which I have had to redesign to add more fields. When I open the form there are 417 entries. If I start to add entry 418 (e.g. enter ID and another field) the data displays in the table, but when I open the form again it still shows only 417 entries.Leave a comment:
-
Hi, thanks for your reply. I'm sure the design is not ideal as I am a beginner in Access! The database is for data from a very long household survey, and there are >255 fields in the main table so I had to split it into at least two tables with one-to-one (perhaps it would have been better to stick to 2?). I am not sure how I can get around the problem of one-to-one tables with so many unique fields?
I have a single form with tabs,...Leave a comment:
-
How do I Navigate to Next Tab Automatically
Hi,
I am trying to create a data entry form for a large database. There is a parent form with 6 forms linked with a one-to-one relationship (due to a large number of fields) and several tables linked with a one-to-many. All have auto update/delete checked. The date entry form uses tab control (across 11 tabs) and subforms for some of the tables. I have two problems...
Firstly, ** Edit Form Doesn't Display Existing Dat...Last edited by NeoPa; Dec 15 '11, 03:44 PM. Reason: Only one question allowed per thread. Second Q moved to separate one. -
Form Doesn't Display Existing Data
Hi,
I am trying to create a data entry form for a large database. There is a parent form with 6 forms linked with a one-to-one relationship (due to a large number of fields) and several tables linked with a one-to-many. All have auto update/delete checked. The date entry form uses tab control (across 11 tabs) and subforms for some of the tables. I have two problems...
Firstly, if I enter part of the data for a new record...Last edited by NeoPa; Dec 15 '11, 03:40 PM. Reason: Only one question allowed per thread. Second Q moved to separate one.
No activity results to display
Leave a comment: