Here is the code behind the afterupdate event of the listbox.
How could I revert the "data entry" property from YES to NO to make the below code work..
------
Private Sub List53_AfterUpdate()
Me.RecordSource = "SELECT * FROM tblCAFMaster " & _
"WHERE [DocID] = " & Str(Nz(Me![List53], 0))
If IsNull(Me.AdjReqAtt) Or Me.AdjReqAtt = "" Then
Me.cmdReq.Enabled = False
Else
Me.cmdReq.Enabled = True
End If
End Sub
--------
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Thursday, May 23, 2013 10:06 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Form #NAME? Error Display
Thank You Liz. That is a great suggestion.
Jim Wagner
________________________________
________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com <mailto:liz_ravenwood%40beaerospace.com> >
To: "'MS_Access_Professionals@yahoogroups.com <mailto:%26%2339%3BMS_Access_Professionals%40yahoogroups.com> '" <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> >
Sent: Thursday, May 23, 2013 11:54 AM
Subject: RE: [MS_AccessPros] Form #NAME? Error Display
How about trying the "data entry" option on the form data property?
Respectfully,
Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
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 ZJUbias
Sent: Thursday, May 23, 2013 11:52 AM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Form #NAME? Error Display
Hi Jim,
With regards to critical issues, I must say nothing, but the main reason why am doing this is;
1. Thought of resolving the issue of slowness of loading.
2. They (user) don't want the form by default displaying any record once the form is open, what they want is, form should only displaying such record based on the selection from the listbox after update event.
Thank you,
Zjubias
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 Jim Wagner
Sent: Thursday, May 23, 2013 9:34 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Form #NAME? Error Display
Zjubias
what is so critical in the recordset that all the records have to be on the form? Have you thought of reducing the recordset and allow users to view the records on a report?. Using Report View on a report is simply awesome.
Jim Wagner
________________________________
________________________________
From: ZJUbias <zjubias@gmail.com <mailto:zjubias%40gmail.com> <mailto:zjubias%40gmail.com> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Thursday, May 23, 2013 11:27 AM
Subject: RE: [MS_AccessPros] Form #NAME? Error Display
Jim,
The reason am doing this is that, some user are complaining that the loading of the form is quite slow, the back end is on the server side.
Thanks,
Zjubias
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 Jim Wagner
Sent: Thursday, May 23, 2013 9:16 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Form #NAME? Error Display
Because there is no recordsource for the form, the bound fields are complaining that they have reference. Why have you put form to unbound?
Jim Wagner
________________________________
________________________________
From: ZJUbias <zjubias@gmail.com <mailto:zjubias%40gmail.com> <mailto:zjubias%40gmail.com> <mailto:zjubias%40gmail.com> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Thursday, May 23, 2013 10:37 AM
Subject: [MS_AccessPros] Form #NAME? Error Display
Hello Pro's,
I have a form with no record source on opening, reason behind, thinking that this may optimize the opening of the form since back end is on server side.
Problem is when my form gets open, I have these #NAME? display all over to my bound controls. Am thinking to hide all the controls, but I don't know how to do it.
Can someone help me please to get rid of these error displays or how to hide these controls the easy way.
CAF Detail.bmp
Ot
ent
Record Source is set on After Update event of my list box.
Thank you in advance,
Zjubias
[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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
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]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (28) |
Tidak ada komentar:
Posting Komentar