Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #10670
| From | "Phil" <phil@stantonfamily.co.uk> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Referenced database not loading properly |
| Date | 2015-04-23 16:15 +0100 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <mhb2a3$4ps$1@speranza.aioe.org> (permalink) |
| References | <mhab0q$372$1@speranza.aioe.org> <d7e04352-a657-41c6-ac57-bb9cb48ebe73@googlegroups.com> |
On 23/04/2015 14:32:03, Patrick Finucane wrote: > On Thursday, April 23, 2015 at 4:37:52 AM UTC-4, Phil wrote: >> Here's a weird one. >> In all my databases I used a referenced database called Utilities.AccDb o > r >> Accde. This contains elements that seem common to so many databases like > an >> menu (Switchboard) system, logging on forms, backup routines, company >> information etc. etc. Works perfectly with all my databases except one th > e >> Music datatbase. The first obvious thing is the Logon form (in the Utilit > ies >> database) comes up a different colour. Then on another form I get an erro > r >> 2424 - the expression you entered has a field, control or property name t > hat >> Music can't find. This is checkbox called HideAccDe. There is also anothe > r >> control called Hide. >> >> If in the Debug window I enter ?me.controls(10).name and get HideAccDe >> If I enter ?me.controls(10) I get error 2424. >> >> If in the Debug window I enter ?me.controls(6).name and get Hide >> If I enter ?me.controls(6) I get the correct value of -1 (True) >> >> I've tried creating a new database and importing everything, decompiling > etc. >> >> Any ideas >> >> Phil >> >> --- >> This email has been checked for viruses by Avast antivirus software. >> http://www.avast.com > Are the db's that work and don't work the same version of Access? Any diff > between adddb and addde? Any diff if you changed ?me.controls(10) to ?me. > controls(10).value? Seems like you have a weird error or an error code tha > t doesn't adequately define the error. > > Hi Patrick. All Access 2010 on Windows 7. All on the same computer. Add databases use the same code to load the Utilities database. Adding the Me keyword makes no difference. Intellisence is quite happy with HideAccDe Have sorted out the Login form being the wrong colour. The picture was defined as "Yellow Gradient", but that did not exist in the Music database. --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Referenced database not loading properly "Phil" <phil@stantonfamily.co.uk> - 2015-04-23 09:37 +0100
Re: Referenced database not loading properly Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-04-23 06:32 -0700
Re: Referenced database not loading properly "Phil" <phil@stantonfamily.co.uk> - 2015-04-23 16:15 +0100
Re: Referenced database not loading properly Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-04-23 08:55 -0700
Re: Referenced database not loading properly "Phil" <phil@stantonfamily.co.uk> - 2015-04-25 09:49 +0100
csiph-web