Solved: MS Access - Problem Moving Subforms
forms ms-access-2013 subforms share|improve this question edited Mar 31 '14 at 16:57 asked Mar 31 '14 at 15:56 guyuzB 1117 add a comment| 3 Answers 3 active oldest votes up vote Thread Status: Not open for further replies. OBP, Dec 16, 2005 #2 carlamac1 Thread Starter Joined: Mar 14, 2005 Messages: 24 Any more info on how to do that please ? The user needs consistency, and being forced to press [Ctrl][Tab] instead of [Tab] or [Enter] to exit a continuous subform isn't consistent. have a peek at this web-site
Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. The concept is, in one form's Close event, you open the next form. Select the subform in the Project Explorer window and then enter the procedure in Listing A into the subform's module. However, a continuous subform has the potential to trap you on the current record if the subform is the last control in the main form. https://forums.techguy.org/threads/solved-ms-access-problem-moving-subforms.425526/
Could this work TF? Attached Files: access_error.doc File size: 109 KB Views: 128 carlamac1, Dec 16, 2005 #1 Sponsor OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,132 I do not know how to Debug.Print strTable, col.Name, lngOldSeed, " => " & lngNewSeed End If End If End If Exit For 'Table can have only one AutoNumber. As already stated, for a particular project there may be some of the 'subforms' which will contain no data, eg a one storey building will not, for example, have any lifts
The code does not work on attached tables: if your database is split, run it in the back end data file. For example, instead of doing this: Currentdb.Execute "UPDATE MyTable SET MyField=True WHERE RecordID=" &Me.RecordID You'd just do: Me.MyField = True And let Access handle the saves. 0 LVL 47 Overall: How can I Let the Back one Jump In Front Based on Key Down Or any other Event? 10 38 2d corrupt Databases 9 42 4d Export to Excel 7 22 here is the general code: Expand|Select|Wrap|Line Numbers PrivateSubForm_AfterInsert() Me![CustomerSupportActivityBranchsubform].Requery Me.[CustomerSupportActivityBranchsubform].Form.RecordsetClone.MoveLast Me.[CustomerSupportActivityBranchsubform].Form.Bookmark=Me.[CustomerSupportActivityBranchsubform].Form.RecordsetClone.Bookmark EndSub Thank you Oct 7 '09 #1 Post Reply Share this Question 3 Replies Expert Mod 15k+ P: 29,959
However, cycling through the controls until you reach the last one and then pressing [Tab] or [Enter] will not give focus to the next control in the main form. For code to reset the Seed for one table only, see: ResetSeed(). Scott, I think that is exactly the problem. There may also be other scenarios where JET is tricked into resetting the AutoNumber to an unusable value.
Make the subform perform just like all other subforms. Once you're in the subform, pressing [Tab] or [Enter] cycles through the controls in the subform, until you get to the last one. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record… Microsoft Access Advertise Here 803 members asked Dim strTable As String 'Name of table.
Get rid of this bad design. However, I have just noticed that, in Form View, placing the cursor at the very bottom of the (sub form) column heading results in the cursor changing to a four directional If you guys can see some major flaws with it, I would rather it was 'right' before I start wasting time plugging data into something which is going to be useless. I am typing this on a widescreen laptop with 1920x1200 and that is a problem.
You may find the form wizards a big help while prototyping, but most developers seem to prefer creating forms from scratch.Be consistentAdding a continuous subform to a form can create navigational http://sumolinux.com/solved-ms/solved-ms-access-where-condition.html My advice would be to either incorporate the data in to one table where applicable or at least have the Project ID in the other tables as a guarantee that it However, in your case you establish the parameter from the query itself, so I don't know whether it could work. –EricPb Mar 31 '14 at 17:45 Hmm.. Interesting idea.
Where was Dumbledore's tomb placed? Last Updated: January 2015. I agree however that "Access does not save well". http://sumolinux.com/solved-ms/solved-ms-access-problem-using-inputbox.html When the focus is in the subform's last control, pressing [Tab] or [Enter] will give focus to the next control in the cycle on the main form.
GET / POST conflict in a multi-page form. There's no automatic way to give focus to the main form's next record.In this case, let the KeyDown event give focus to the main form's next record instead of to the Select the new record and cycle through its controls, including the last control.The code you just added checks each record to see whether it is the last record in the form.
Join our site today to ask your question.
You don't tell us, and we have no way of finding out for ourselves, what is different in the design of any of these forms. All rights reserved. Post your question and get tips & solutions from a community of 419,744 IT Pros & Developers. have a peek here There may also be some unexpected results for the user who doesn't understand what is going on....
If they can't see it, they won't fill it in !!