Search the web
Sign In
New User? Sign Up
MS_Access_Professionals · MS Access Professionals
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
About my post re split forms and controls dissapearing   Message List  
Reply | Forward Message #74525 of 77543 |
Re: About my post re split forms and controls dissapearing

Hi Terence,

Whenever I have a form that is acting in an unusual fashion I make sure the form
itself is not corrupted.

To fix a corrupted form is usually very easy. In the database window I click on
the form, hold down the Ctl key and drag and drop it. That creates a copy of
the form. I then delete the original form and rename the copy to the original
name.

Of course it always pays to make a copy of your database before you do this.

Best Regards,
Pat
http://gainingaccess.net/


--- In MS_Access_Professionals@yahoogroups.com, "buffalome90210"
<buffalome90210@...> wrote:
>
> I have been playiong with them a bit, and reading about somne of the
mysterious quirks.
>
> I have gotten around all the issues I had/have so nothing is eminant.
>
> The two questions I have remaining are:
>
> 1. I was able to toggle (programatically) the filter off via Me.filter
NO.....But have not been able to re-0establish the filter....Turn it back on, OR
rest the entire form to its load state....any Ideas.
>
> 2. The strange manifestation I saw on the split form, I ralize and accept that
their are quirks, and that my filters may be a bit odd...BUT, I still don't
understand, not accept, that a filtered Split form should have the ability to
make the controls in the form portion "NON Visible" ?...That I fail to
understand..how..why..under any circumstances it should occur.
>
> Terence
>





Sat Jul 11, 2009 12:59 pm

hunterpaw
Offline Offline
Send Email Send Email

Forward
Message #74525 of 77543 |
Expand Messages Author Sort by Date

I have been playiong with them a bit, and reading about somne of the mysterious quirks. I have gotten around all the issues I had/have so nothing is eminant. ...
buffalome90210
Offline Send Email
Jul 11, 2009
11:01 am

Hi Terence, Whenever I have a form that is acting in an unusual fashion I make sure the form itself is not corrupted. To fix a corrupted form is usually very...
Patrick Wood
hunterpaw
Offline Send Email
Jul 11, 2009
12:59 pm

Terence 1. You should be using Me.FilterOn False . The options are True/False And when you turn a filter on after it being off I'm pretty sure you have...
Bill Mosca
wrmosca
Offline Send Email
Jul 11, 2009
5:04 pm

oh cantare monami Hi Bill !....... pretending I'm John :) NO NO NO....the weirdness is the the cONTROLS on the top portion , The Form Portion, THE listboxes...
buffalome90210
Offline Send Email
Jul 11, 2009
6:29 pm

I thought I would explain the business purpose this form achieves, because its purpose has a generic fundamental use to all. and thought I have not attempted...
buffalome90210
Offline Send Email
Jul 11, 2009
6:58 pm

Terence You have a terrible accent. :O) At first I thought you were writing in Italian. Cantare means "to sing", but looking at the rest, I figured it was...
Bill Mosca
wrmosca
Offline Send Email
Jul 11, 2009
7:18 pm

Terence- Sorry, but that's the way Access has always worked. When you filter a form that cannot add records so that it has no records, all the controls ...
John Viescas
jlviescas
Offline Send Email
Jul 11, 2009
7:11 pm

Oh WOW! I just learned something totally and completely new! I thought the disappearing controls were a bug and have gone way out of my way to get around this...
Jesse Melton
irritable_ba...
Offline Send Email
Jul 11, 2009
7:19 pm

John Why would filtering cause controls to vanish? I don't understand this one. Regards, Bill From: MS_Access_Professionals@yahoogroups.com ...
Bill Mosca
wrmosca
Offline Send Email
Jul 11, 2009
7:27 pm

Bill- If the filter causes the form to return no rows, and the form does not allow new records (either because Allow Additions is False or the recordset is not...
John Viescas
jlviescas
Offline Send Email
Jul 11, 2009
7:51 pm

John , are u saying that if I allow records to be added, then the disappearing act will cease ? terence...
buffalome90210
Offline Send Email
Jul 11, 2009
8:07 pm

John I've never seen that before. I guess because I've built forms that don't fall under those specs. Interesting to say the least. I would have thought you...
Bill Mosca
wrmosca
Offline Send Email
Jul 11, 2009
8:59 pm

Terence- As long as the form's recordset is updatable, yes. But maybe you don't want users to be able to actually add a record. If the controls are only to ...
John Viescas
jlviescas
Offline Send Email
Jul 11, 2009
8:20 pm

TY Uncle V.....I will however be interested to see the posts which may (or may not) go between you and Bill regarding this so called "feature"........ I...
buffalome90210
Offline Send Email
Jul 11, 2009
8:31 pm

Terrence, If I can weigh in seriously here, I agree that it is odd for a developers tool (Access) to provide "features" like this as many development ...
Jesse Melton
irritable_ba...
Offline Send Email
Jul 11, 2009
9:13 pm

Terence- I don't think it's inappropriate at all. If you open a form whose recordset returns no records and the form can't add records, why display any...
John Viescas
jlviescas
Offline Send Email
Jul 11, 2009
8:42 pm

Bill- Do this in Northwind: 1) Start a new form. 2) Set the Record Source to: SELECT * FROM Customers WHERE 1 = 0 3) Add a few controls 4) Set Allow Additions...
John Viescas
jlviescas
Offline Send Email
Jul 11, 2009
9:15 pm

John I did create a form just for testing. Not that I doubted you...I just wanted to see it happen. I think it's counter-intuitive (at least as far as my...
Bill Mosca
wrmosca
Offline Send Email
Jul 11, 2009
9:23 pm

To ALL involved in this conversation, I see ALL sides! Yes Jesse I agree that Access does indeed transcend other development tools in it's intuitive assists to...
buffalome90210
Offline Send Email
Jul 11, 2009
10:38 pm

Hi Terence, Well you now know what happens when you try to display no records with AllowAdditions = No. It is quite logical in the case of Continuous Forms...
Clive Williams
horastacatto
Offline Send Email
Jul 13, 2009
1:46 pm

Hi Clive, WOW, my head is spinning, I did not anticipate that my simple little question would have ensighted the discussion which occured. I see ALL sides of...
buffalome90210
Offline Send Email
Jul 13, 2009
2:13 pm

Terence A truly admirable and professional approach! Asking the client what he expects the application to do is what your job is all about. After all, this is...
Bill Mosca
wrmosca
Offline Send Email
Jul 13, 2009
2:28 pm

Terence- First, if you're leaning toward Bill, what would you expect the form to do if you filter it to no records and you can't add a record? Bill suggests...
John Viescas
jlviescas
Offline Send Email
Jul 12, 2009
8:43 am

Bill. We could look at it this way: In a bound form, the detail section comes into play only if there is at least one displayable record. If there is none, not...
A.D.Tejpal
adt_h
Offline Send Email
Jul 12, 2009
9:32 am

A.D. Thanks for your input in this. Your detailed diagnosis is excellent. John's suggestion sounds like a very good one to me. A bit more overhead, but a more...
Bill Mosca
wrmosca
Offline Send Email
Jul 12, 2009
5:53 pm

Bill- If no records can be displayed, as A.D. noted, the Detail section basically does not exist. NO controls appear - bound or unbound, linked or unlinked. ...
John Viescas
jlviescas
Offline Send Email
Jul 12, 2009
6:32 pm

Thanks, John. Regards, Bill From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas Sent:...
Bill Mosca
wrmosca
Offline Send Email
Jul 12, 2009
8:39 pm

Bill, You are most welcome! You wished to explore the behavior of un-anchored labels. As stated in my previous post, the canvas of detail section itself...
A.D.Tejpal
adt_h
Offline Send Email
Jul 12, 2009
7:09 pm

Very good suggestions, A.D. This thread has proven quite educational and certainly given us all something to think about when designing user-friendly forms. ...
Bill Mosca
wrmosca
Offline Send Email
Jul 12, 2009
8:43 pm

You are most welcome Bill! Quite often, access developers have to deal with the phenomenon in question. It is nice that various aspects stand covered under the...
A.D.Tejpal
adt_h
Offline Send Email
Jul 13, 2009
2:08 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help