Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Mon Jan 26 15:22:07 CST 2004
I seen this to, but has nothing to do with a notebook. Is that maybe a Access runtime on this notebook? The problem I had was with combo/list boxes for which I change the rowsource from VBA. The thing is that the rowsource on the listbox is empty is design mode and I fill it from vba when opening the form. For some reason the Access runtime thinks there nothing to show and does not show when I VBA the rowsource after loading the form. Only solution was to put a SQL string also on the combo/list box rowsource control with the correct number of fields. For reasons of speed I filtered the SQL result so I'm sure no values are displayed when loading the form (textvalue = null) Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Monday, January 26, 2004 10:06 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Form doesn't work on new laptop This is WAY off the cuff, a complete WAG. Laptops, by their nature, are designed to have multiple monitors (the laptop screen, and then a possible external monitor). Sometimes the second monitor is just a mirror of the main monitor, but other times, it can be a 'second' monitor, effectively doubling the width of the desktop. I bring this up, because I have seen combo boxes do WIERD things when used on a multiple monitor system. Quite frankly, I've seen it mostly in Access 97, but wouldn't be surprised to see it in 2000. Drew -----Original Message----- From: Dwylene Garcia [mailto:garciad at kentri.org] Sent: Monday, January 26, 2004 2:45 PM To: accessD at databaseadvisors.com Subject: [AccessD] Form doesn't work on new laptop I have an odd problem that has managed to stump several IT people. We are on the verge of giving up but I thought I would make an attempt to ask this group if anyone has seen such a problem. I have a fairly complicated form (one-to-many-to-many relationship, Main form with two subform, one subform filters the other subform) and this form has worked for 2 years and still does work on every desktop in our office. However, one employee received a new laptop this week running Windows 2000, Office XP and Access 2000 (the same as all the desktops) and the database opens and it appears that the less complicated forms work fine but this one form which is the main form used will not populate the subforms correctly. It recognizes there are records but it won't show them in the combo box... I have found this http://support.microsoft.com/default.aspx?scid=kb;en-us;208866&Product=a cc20 00 in the knowledge base that seems to restate the problem exactly. However, I'm looking for a solution that does not involve altering my form since it does work on the desktop computers. Why will it work on a desktop and not a laptop???? I don't have time to alter the database to make it work on this one laptop when 7 other desktop computers run the database fine. I'm wondering if anyone else has ever experienced this and I'm hoping that it's something silly that I overlooked while troubleshooting. I think we have hit all the obvious troubleshooting points like reinstalling MS Office, I took the database off the network and tried to run from the C:/. When it first happened we received an error "Object invalid or no longer set.", that error is not showing up now. Dwylene Garcia Computer Applications Trainer Kent Hospital, Department of Education Email: garciad at kenthospital.org _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com