PC Review


Reply
Thread Tools Rate Thread

Access 2007 bug?

 
 
Warrio
Guest
Posts: n/a
 
      30th Nov 2010
In Form1, place a subForm. Set SubForm SourceObject to Form2.

In Form2, place one or more text box and one button called Button1.
in VBA, on the Click event of Button1 write the following code.
Me.Parent.Form.FormFooter.Visible = True

And then run Form1. In the subform's text box, enter some text and
then press Button1.

Result: The text previously entered disappears. and if you hit a
second time Button1, your text appears again.

Why???
 
Reply With Quote
 
 
 
 
Warrio A
Guest
Posts: n/a
 
      2nd Dec 2010
It is indeed a bug of Access 2007 and 2010 and hope it will be fixed
soon, because I cannot change my forms layout.

Here is the answer from Nathan O. - Microsoft SupportMSFT :
Hi Warrio5,
I was able to reproduce the problem on my end in Access 2007 and in
Access 2010. I then tested the same steps in Access 2003 and the text
does not disappear there.. Since this seems to be behaving differently
in the newer versions of Access, I will file a report on the issue so
the proper people are aware of it.

The only workaround I have found is to move the command button off of
the subform and place it onto the main form itself. Then after doing
this, modify the code so that is looks similar to:
Me.FormFooter.Visible = True

Best Regards,
Nathan Ost
Microsoft Online Community Support
------------------------------------------------------------------------------



On Nov 30, 6:30*pm, Warrio <warr...@gmail.com> wrote:
> In Form1, place a subForm. Set SubForm SourceObject to Form2.
>
> In Form2, place one or more text box and one button called Button1.
> in VBA, on the Click event of Button1 write the following code.
> * Me.Parent.Form.FormFooter.Visible = True
>
> And then run Form1. In the subform's text box, enter some text and
> then press Button1.
>
> Result: The text previously entered disappears. and if you hit a
> second time Button1, your text appears again.
>
> Why???


 
Reply With Quote
 
Access Developer
Guest
Posts: n/a
 
      3rd Dec 2010
Help me understand. You have something that doesn't work; you know what to
do to make it work; but you "can't change your form's layout"? Pray tell,
why not? If someone is dictating the form's layout, and would rather have
it not work than have a slightly different layout, they must not be very
interested in the information... that'd be "style over substance", wouldn't
it?

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Warrio A" <(E-Mail Removed)> wrote in message
news:e6f5c020-b01b-4ab5-8c09-(E-Mail Removed)...
It is indeed a bug of Access 2007 and 2010 and hope it will be fixed
soon, because I cannot change my forms layout.

Here is the answer from Nathan O. - Microsoft SupportMSFT :
Hi Warrio5,
I was able to reproduce the problem on my end in Access 2007 and in
Access 2010. I then tested the same steps in Access 2003 and the text
does not disappear there.. Since this seems to be behaving differently
in the newer versions of Access, I will file a report on the issue so
the proper people are aware of it.

The only workaround I have found is to move the command button off of
the subform and place it onto the main form itself. Then after doing
this, modify the code so that is looks similar to:
Me.FormFooter.Visible = True

Best Regards,
Nathan Ost
Microsoft Online Community Support
------------------------------------------------------------------------------



On Nov 30, 6:30 pm, Warrio <warr...@gmail.com> wrote:
> In Form1, place a subForm. Set SubForm SourceObject to Form2.
>
> In Form2, place one or more text box and one button called Button1.
> in VBA, on the Click event of Button1 write the following code.
> Me.Parent.Form.FormFooter.Visible = True
>
> And then run Form1. In the subform's text box, enter some text and
> then press Button1.
>
> Result: The text previously entered disappears. and if you hit a
> second time Button1, your text appears again.
>
> Why???



 
Reply With Quote
 
Warrio A
Guest
Posts: n/a
 
      3rd Dec 2010
Why I don't wanna change my layout? because I use my subForm to load
three different forms. In one of them the CommandButton must be in the
middle just next to the search field. and it is different for the two
others. Of course, I can change by code the layout and do lot of
tuning so my form looks the same after all, but I decided not to! Why?
because I think I have lost enough time on detecting it was a bug that
didn't come from my code, but from Access Developers. They should have
tested their code in all different ways before lunching the upgrade. I
prefer to wait for a fix patch.

Hope I have helped you understand.

On Dec 3, 7:11*am, "Access Developer" <accde...@gmail.com> wrote:
> Help me understand. *You have something that doesn't work; you know what to
> do to make it work; but you "can't change your form's layout"? *Pray tell,
> why not? *If someone is dictating the form's layout, and would rather have
> it not work than have a slightly different layout, they must not be very
> interested in the information... that'd be "style over substance", wouldn't
> it?
>
> --
> Larry Linson, Microsoft Office Access MVP
> Co-author: "Microsoft Access Small Business Solutions", published by Wiley
> Access newsgroup support is alive and well in USENET
> comp.databases.ms-access
>
> "Warrio A" <warri...@gmail.com> wrote in message
>
> news:e6f5c020-b01b-4ab5-8c09-(E-Mail Removed)...
> It is indeed a bug of Access 2007 and 2010 and hope it will be fixed
> soon, because I cannot change my forms layout.
>
> Here is the answer from Nathan O. - Microsoft SupportMSFT :
> Hi Warrio5,
> I was able to reproduce the problem on my end in Access 2007 and in
> Access 2010. I then tested the same steps in Access 2003 and the text
> does not disappear there.. Since this seems to be behaving differently
> in the newer versions of Access, I will file a report on the issue so
> the proper people are aware of it.
>
> The only workaround I have found is to move the command button off of
> the subform and place it onto the main form itself. Then after doing
> this, modify the code so that is looks similar to:
> Me.FormFooter.Visible = True
>
> Best Regards,
> Nathan Ost
> Microsoft Online Community Support
> ------------------------------------------------------------------------------
>
> On Nov 30, 6:30 pm, Warrio <warr...@gmail.com> wrote:
>
> > In Form1, place a subForm. Set SubForm SourceObject to Form2.

>
> > In Form2, place one or more text box and one button called Button1.
> > in VBA, on the Click event of Button1 write the following code.
> > Me.Parent.Form.FormFooter.Visible = True

>
> > And then run Form1. In the subform's text box, enter some text and
> > then press Button1.

>
> > Result: The text previously entered disappears. and if you hit a
> > second time Button1, your text appears again.

>
> > Why???


 
Reply With Quote
 
Access Developer
Guest
Posts: n/a
 
      4th Dec 2010
OK, first I thought you said you _could not_ change the UI, but now I
understand that you _don't want to_ change the UI.

Surely, I understand, and you are certainly entitled to your view, but you
do, I hope, realize that you should not hold your breath until you get the
fix. They prioritize those, and some fixes never get done if they decide
that it won't affect many users.

My view has always been, if the users of the database application need the
information (and I wouldn't have implemented 'whatever it was' if they
didn't) it doesn't matter whose fault the problem is, I'm going to get the
information for them if I can. I'm in this business to solve the
user's/customer's business problems, not to make a statement that I'm
certain-sure the developers will not even be aware of.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Warrio A" <(E-Mail Removed)> wrote in message
news:b8cc7de8-620c-4381-94ad-(E-Mail Removed)...
Why I don't wanna change my layout? because I use my subForm to load
three different forms. In one of them the CommandButton must be in the
middle just next to the search field. and it is different for the two
others. Of course, I can change by code the layout and do lot of
tuning so my form looks the same after all, but I decided not to! Why?
because I think I have lost enough time on detecting it was a bug that
didn't come from my code, but from Access Developers. They should have
tested their code in all different ways before lunching the upgrade. I
prefer to wait for a fix patch.

Hope I have helped you understand.

On Dec 3, 7:11 am, "Access Developer" <accde...@gmail.com> wrote:
> Help me understand. You have something that doesn't work; you know what to
> do to make it work; but you "can't change your form's layout"? Pray tell,
> why not? If someone is dictating the form's layout, and would rather have
> it not work than have a slightly different layout, they must not be very
> interested in the information... that'd be "style over substance",
> wouldn't
> it?
>
> --
> Larry Linson, Microsoft Office Access MVP
> Co-author: "Microsoft Access Small Business Solutions", published by Wiley
> Access newsgroup support is alive and well in USENET
> comp.databases.ms-access
>
> "Warrio A" <warri...@gmail.com> wrote in message
>
> news:e6f5c020-b01b-4ab5-8c09-(E-Mail Removed)...
> It is indeed a bug of Access 2007 and 2010 and hope it will be fixed
> soon, because I cannot change my forms layout.
>
> Here is the answer from Nathan O. - Microsoft SupportMSFT :
> Hi Warrio5,
> I was able to reproduce the problem on my end in Access 2007 and in
> Access 2010. I then tested the same steps in Access 2003 and the text
> does not disappear there.. Since this seems to be behaving differently
> in the newer versions of Access, I will file a report on the issue so
> the proper people are aware of it.
>
> The only workaround I have found is to move the command button off of
> the subform and place it onto the main form itself. Then after doing
> this, modify the code so that is looks similar to:
> Me.FormFooter.Visible = True
>
> Best Regards,
> Nathan Ost
> Microsoft Online Community Support
> ------------------------------------------------------------------------------
>
> On Nov 30, 6:30 pm, Warrio <warr...@gmail.com> wrote:
>
> > In Form1, place a subForm. Set SubForm SourceObject to Form2.

>
> > In Form2, place one or more text box and one button called Button1.
> > in VBA, on the Click event of Button1 write the following code.
> > Me.Parent.Form.FormFooter.Visible = True

>
> > And then run Form1. In the subform's text box, enter some text and
> > then press Button1.

>
> > Result: The text previously entered disappears. and if you hit a
> > second time Button1, your text appears again.

>
> > Why???



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why Access 2007 donot have the "Data Access Page" Function ? How I can do with 2007 for this issue ? Martin Microsoft Access 4 3rd May 2010 08:46 PM
importing table contents from Word 2007 into Access 2007 andgenerating queries, reports using Access 2007 g_1 Microsoft Word Document Management 3 12th Nov 2009 06:58 AM
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2007? Steve Microsoft Access Macros 2 11th Nov 2009 01:52 PM
Securely accessing an Access 2007 database...and are Access 2007 databases secure? clifgriffin@gmail.com Microsoft C# .NET 2 11th Aug 2007 04:49 PM
access 2007 have new engine ACE 12 ,can i use it in ASP,if i not install access 2007 ? help Microsoft Access 1 17th Nov 2006 04:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:46 PM.