Debbie-
I downloaded your database and took a look. The only form with a subform that I
find is frmPgmCounty, and I'm able to update fields in the subform just fine.
Can you describe the specific steps you're following to get that form open so
it's not updateable?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
<http://www.viescas.com/> http://www.viescas.com/
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Okoli, Debbie
Sent: Tuesday, July 03, 2012 5:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Unable to Add Record to Main or SubForms
I have uploaded a zip file which includes a summary of the issues I am having,
as well as a sample database. My issue is that I am unable to add a new record
through several of the forms in my database.
For each of the affected forms and subforms(see DB-Structure-Map file), I have
validated that the following are set properly)::
* Allow Additions = Yes
* Link Child properties = set correctly.
The system is very simple, so I am not sure why this problem is occurring. The
name of my zip file is: Add-New-Rec-Issue-DOkoli.zip.
Thanks again for your help. I would not know what to do without your assistance.
My goal is that I will get more knowledgeable everyday.
Regards,
DebbieO
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Tuesday, July 03, 2012 9:34 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Unable to Add Record to Main or SubForms
Debbie
We don't accept attachments. However you can upload your zipped sample to our
Files>Assistance Needed folder.
Bill Mosca, Founder
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>, "Okoli, Debbie"
<debbie.okoli@... <mailto:debbie.okoli@...%3cmailto:debbie.okoli@...>
<mailto:debbie.okoli@...>> wrote:
>
> The problems I am having are outlined in the attached Excel file. I have also
attached a sample database so that you can review it to determine the cause of
my problems. Thank you in advance for your time and support.
>
> Debbie
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>] On Behalf Of John Viescas
> Sent: Thursday, June 14, 2012 4:06 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Unable to Add Record to Main or SubForms
>
>
>
> Debbie-
>
> We would need to know more about your form and subforms. What's the Record
> Source (the SQL if a query)? If you open the Record Source outside the form,
> can you add records there? Is Allow Additions set to Yes in the form and the
> subforms? Are the Link Master / Link Child properties of the subform control
> set correctly? Help us out here.
>
> John Viescas, author
>
> Microsoft Office Access 2010 Inside Out
>
> Microsoft Office Access 2007 Inside Out
>
> Building Microsoft Access Applications
>
> Microsoft Office Access 2003 Inside Out
>
> SQL Queries for Mere Mortals
>
> <http://www.viescas.com/> http://www.viescas.com/
>
> (Paris, France)
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com><mailto:MS_Access_Professional
s%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com><mailto:MS_Access_Professional
s%40yahoogroups.com>] On Behalf Of Okoli, Debbie
> Sent: Thursday, June 14, 2012 8:22 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com><mailto:MS_Access_Professional
s%40yahoogroups.com>
> Subject: [MS_AccessPros] Unable to Add Record to Main or SubForms
>
> I am currently unable to add a record to my main or sub forms.
> I am not sure why the problem exists. Please provide assistance.
>
> Regards,
> Debbie Okoli, MSPH, PMP
>
> ________________________________
>
> Email correspondence to and from this address is subject to the North Carolina
> Public Records Law and may be disclosed to third parties by an authorized
State
> official. Unauthorized disclosure of juvenile, health, legally privileged, or
> otherwise confidential information, including confidential information
relating
> to an ongoing State procurement effort, is prohibited by law. If you have
> received this e-mail in error, please notify the sender immediately and delete
> all records of this e-mail.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ________________________________
>
> Email correspondence to and from this address is subject to the North Carolina
Public Records Law and may be disclosed to third parties by an authorized State
official. Unauthorized disclosure of juvenile, health, legally privileged, or
otherwise confidential information, including confidential information relating
to an ongoing State procurement effort, is prohibited by law. If you have
received this e-mail in error, please notify the sender immediately and delete
all records of this e-mail.
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar