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@yahoogroups.com] On Behalf Of John Viescas
Sent: Thursday, June 14, 2012 4:06 PM
To: MS_Access_Professionals@yahoogroups.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@yahoogroups.com<mailto:MS_Access_Professionals%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>
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]
Tidak ada komentar:
Posting Komentar