Re: Stop saving the filter entered by the user
From: Jim Allensworth (jimNOT_at_datacentricsolutions.com)
Date: 07/27/04
- Next message: PSI-Access: "Hiding/Displaying items on a Menu"
- Previous message: Douglas J. Steele: "Re: Fill bound text box from combo box?"
- In reply to: ConnieA: "Re: Stop saving the filter entered by the user"
- Next in thread: ConnieA: "Re: Stop saving the filter entered by the user"
- Reply: ConnieA: "Re: Stop saving the filter entered by the user"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 21:17:33 GMT
Connie, option 1 is not the best choice. It is really about saving
modifications to a form. I'm pretty sure it will throw an error in
production mode that would have to be dealt with. Option 2 is a better
choice, however you don't need to set FilterOn to false just set its
value to an empty string. (You can also do this in Open Form)
- Jim
On Tue, 27 Jul 2004 12:38:39 -0700, "=?Utf-8?B?Q29ubmllQQ==?="
<ConnieA@discussions.microsoft.com> wrote:
>Thank you for answering my question. I prefer option 1, but am unable to get this to work.
>
>Please excuse my ignorance, but I'm very new to access.
>
>I am assuming that I'm placing this code in the onClose event and I'm also assuming that were MyFormName is I place my actual form name. Am I correct on these assumptions? And do I just string this whole statement along one line?
>
>Thank you so much for your help.
>
>Connie
>
>"George Nicholson" wrote:
>
>> 1) When you close the Form, you can specify that it NOT save changes.
>> "DoCmd.Close acForm, MyFormName, acSaveNo"
>> acSaveNo only refers to saving changes to the Form and its properties (like
>> Filters), NOT to changes in the records/data displayed on the form.
>>
>> and/or
>>
>> 2) In the Form_Unload event:
>> Me.Filter = ""
>> Me.FilterOn = False
>> This way, even if the Filter property does get saved, you are saving it in
>> an "off" condition.
>>
>> --
>> George Nicholson
>>
>> Remove 'Junk' from return address.
>>
>>
>>
>>
>> "ConnieA" <ConnieA@discussions.microsoft.com> wrote in message
>> news:5AC4F32B-9568-464E-ACEA-7A8EEC68AC71@microsoft.com...
>> > I have an application written in Access that is used to maintain our
>> Oracle database. I have created a form that automically opens up in "filter
>> by form" mode. After the user opens the form they enter the information
>> they want to filter on, look at the results and then closes out of that
>> form. It does not ask if you want to save changes, but when I then look at
>> the properties for the form, the filter information the user entered is
>> saved in the filter property.
>> >
>> > Does anyone know a way of not saving the filter that was entered by the
>> user??
>> >
>> > Any help on this would be much appreciated by myself and my frustrated
>> customers.
>> >
>> > Thanks, Connie
>>
>>
>>
- Next message: PSI-Access: "Hiding/Displaying items on a Menu"
- Previous message: Douglas J. Steele: "Re: Fill bound text box from combo box?"
- In reply to: ConnieA: "Re: Stop saving the filter entered by the user"
- Next in thread: ConnieA: "Re: Stop saving the filter entered by the user"
- Reply: ConnieA: "Re: Stop saving the filter entered by the user"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
