I had a similar incident and I had to change the users behavior options under the file drop down for the "enter" key to not go to a new record.
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Information Technology
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, January 18, 2018 9:31 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Limit subform to only 1 record
Jim,
I would add some code to count the records and if there are any, set the allow additions of the the subform to False.
Regards,
Duane Hookom
________________________________
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>> on behalf of luvmymelody@yahoo.com<mailto:luvmymelody@yahoo.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
Sent: Thursday, January 18, 2018 5:22 PM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Limit subform to only 1 record
Hello all,
We support a database that has a Form with a sub form. I have yet figured out how the users are creating a second record in the subform. I have hid the navigation buttons so they cannot click new record or navigate to another record. The subform is linked on Person Id in the main form to the Person Id in the subform.
I thought if I try and limit the subform to only allow the TOP 1 records that would work. or try and code the OnCurrent event to stop allow.additions from happening I would solve it. But neither of these are working.
Without being able to replicate the users adding records to the subform I am at a loss on how to fix the issue. Is there a way of limiting the form to only 1 record?
the main form is all active employees. the subform is the employees schedule and hours they work.
Thank You for your help
Jim Wagner
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar