ACCESS FEED: Re: [MS_AccessPros] Form #NAME? Error Display

Kamis, 23 Mei 2013

Re: [MS_AccessPros] Form #NAME? Error Display

Thank You Liz. That is a great suggestion.

Jim Wagner
________________________________

________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.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@yahoogroups.com] On Behalf Of ZJUbias
Sent: Thursday, May 23, 2013 11:52 AM
To: MS_Access_Professionals@yahoogroups.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@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Thursday, May 23, 2013 9:34 PM
To: MS_Access_Professionals@yahoogroups.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> >
To: MS_Access_Professionals@yahoogroups.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@yahoogroups.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>
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> >
To: MS_Access_Professionals@yahoogroups.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]