Kamis, 23 Mei 2013

RE: [MS_AccessPros] Form #NAME? Error Display

 

Wow… that's solve the issue..

Many thanks Liz…

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Thursday, May 23, 2013 10:54 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Form #NAME? Error Display

First of all you need to have the data bound to eliminate the #Name? or whatever that weird thing is.

If you are then wanting the form to flesh out based on the list selection, then the data entry would have to be changed. You could do this programmatically.

me.DataEntry = false

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 12:44 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Form #NAME? Error Display

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%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jim Wagner
Sent: Thursday, May 23, 2013 10:06 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.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> <mailto:liz_ravenwood%40beaerospace.com> >
To: "'MS_Access_Professionals@yahoogroups.com <mailto:%26%2339%3BMS_Access_Professionals%40yahoogroups.com> <mailto:%26%2339%3BMS_Access_Professionals%40yahoogroups.com> '" <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.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> <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%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:34 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

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> <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 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%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.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> <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> <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> <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]

------------------------------------

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]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (30)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar