Sometimes it just takes someone else's perspective. Thanks for this - it works perfectly again now, although I would like to know why it stopped working in the first place. I guess we'll never know!!
Regards David -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Antonino Sent: 20 September 2005 23:22 To: AccessDevelopers@yahoogroups.com Subject: Re: RE: [AccessDevelopers] Strange Things Are Happening I think I have expereinced something similar a while ago. I remember having to reset the recordsource of the subform (in code) as a way of requerying it. This seemed to 'refresh' it everytime with the correct data. HTH, Angelo ----- Original Message ----- From: David Pearson [mailto:[EMAIL PROTECTED] Sent: 9/20/2005 7:23:18 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Strange Things Are Happening > *****UPDATE***** > > I added a manual refresh button to my main form. When the pop-up > closes the sub form is still empty. Quick fire clicking of the > refresh button makes the stock code appear in the sub form after a > couple of seconds. This suggests a time delay on writing the file to > the table. The thing is that I have a remove button on my main form, > when I highlight the stock code in the sub form and click the remove > button it removes it instantly so there is no delay there. > > Again this only happens in start-up mode or in the MDE. > > Regards > > David > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of David Pearson > Sent: 20 September 2005 10:04 > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] Strange Things Are Happening > > Hello all, > > I have a large application that I am continually developing. This > problem is a little annoying. > > I have a form with a sub form. I have a button which opening another > pop-up form that lists stock codes, a code is selected from the list > and a button is clicked. This runs some SQL that appends data top a > table (the same table that the sub form on my main for is based on. > After the SQL I requery the sub form and close the popup. The stock > code selected is now in the sub form. > > Now with no intervention from my I now have users complaining that the > stock codes aren't being added. I investigated and found that they > are actually being appended by the SQL but the sub form is not being > refreshed. Upon further investigation I found this only happens when > in startup mode on the MDB file (i.e. I have hidden the database > windows and other things) and in the MDE I create for distribution. > If I open the MDB with [Shift] key down (i.e. full access the everything) and try the form it works perfectly. > > This was all working fine, even in the MDE. I changed another no > related part of the app and redistributed to my users and then this > started happening. > > Aaaaarghhhhh! I hate problems like this. > > Regards > > David > > > > > > ============================================================= > The information in this Internet email is confidential and intended > for the sole use of the addressee(s). Copying, disclosure or re-use, > in any way, of the information contained in this email by anyone other > than the addresse(s) is unauthorised. We accept no legal > responsibility for the content of this message. Any opinions or views > presented are solely the responsibility of the author and do not necessarily represent those of Siddall and Hilton Ltd. > and any of their subsidiary companies. If you have read this email in > error, please return it to the sender and remove from your system. > Siddall and Hilton Ltd. and any of their subsidiary companies may > monitor the content of emails sent and received via its network for > the purposes of ensuring its compliance with its policies and procedures. > ============================================================= > > ______________________________________________________________________ > __ This e-mail has been scanned for all viruses by Star. The service > is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________________ > __ > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> Fair play? Video games influencing politics. Click and talk back! > http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM > --------------------------------------------------------------------~- > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ============================================================= > The information in this Internet email is confidential and intended > for the sole use of the addressee(s). Copying, disclosure or re-use, > in any way, of the information contained in this email by anyone other > than the addresse(s) is unauthorised. We accept no legal > responsibility for the content of this message. Any opinions or views > presented are solely the responsibility of the author and do not necessarily represent those of Siddall and Hilton Ltd. and any of their subsidiary companies. If you have read this email in error, please return it to the sender and remove from your system. > Siddall and Hilton Ltd. and any of their subsidiary companies may monitor the content of emails sent and received via its network for the purposes of ensuring its compliance with its policies and procedures. > ============================================================= > > ______________________________________________________________________ > __ This e-mail has been scanned for all viruses by Star. The service > is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________________ > __ > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links ============================================================= The information in this Internet email is confidential and intended for the sole use of the addressee(s). Copying, disclosure or re-use, in any way, of the information contained in this email by anyone other than the addresse(s) is unauthorised. We accept no legal responsibility for the content of this message. Any opinions or views presented are solely the responsibility of the author and do not necessarily represent those of Siddall and Hilton Ltd. and any of their subsidiary companies. If you have read this email in error, please return it to the sender and remove from your system. Siddall and Hilton Ltd. and any of their subsidiary companies may monitor the content of emails sent and received via its network for the purposes of ensuring its compliance with its policies and procedures. ============================================================= ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
