jwcolby
jwcolby at colbyconsulting.com
Thu Nov 12 10:50:50 CST 2009
Boy do I need to get good with that wizard builder. I tried to wrote my own but it was too much work. John W. Colby www.ColbyConsulting.com Arthur Fuller wrote: > Thanks. That explains it. Incidentally, this code is from a wizard-builder > that I found on the net. It looks pretty nice. Years back there was a wizard > builder for Access 2000 but it allowed only one wizard per app, which was a > pretty serious limitation. This one gets around that problem nicely. Its > heart is a class called clsWizard and an associated form you use to plant > your subforms on each page. Then to execute a given wizard within your app, > you call RunWizard wisName. The only thing is, you need to create all the > subforms before building the wizard, which only makes sense. > > I forget where I got this wizard builder but I found it with Google, so it > must be readily available. The guy who built it is on the Access development > team. > > Anyway, thanks for clearing up the bang thing. > > On Thu, Nov 12, 2009 at 11:01 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > >> Arthur, >> >> > I've never seen a line of code that begins with an exclamation point >> before. >> >> The ! is used because you are referencing a CONTROL on a form, not a >> PROPERTY of an object. >> >> > With Forms(m_sFormName) >> >> referencing a FORM m_sFormName >> >> > !sfcWizPanel.SourceObject = ... >> >> referencing a CONTROL (scfWizPanel >> >> then a property of that CONTROL .SourceObject >> >> The correct syntax for Access is to reference controls with a ! and a >> property with a . >> >> The compiler will try to fix any mistakes you make in doing this but you >> really should use the >> correct syntax. >> >>