Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sat May 10 16:17:59 CDT 2003
John: Already did it. That's where I got the 1/2 to 1/3 reduction in the time in opening the form. On my box it's a little hard to tell. Opened before in about 3 seconds. Now much faster. I'll wait to see what happens on their network. Rocky ----- Original Message ----- From: "John Colby" <jcolby at colbyconsulting.com> To: <accessd at databaseadvisors.com> Sent: Saturday, May 10, 2003 10:35 AM Subject: RE: [AccessD] CC J-I-T Forms > My lawyers have informed me that you certainly may. ;-) > > You will find a demo on my web site. I haven't looked at it recently. > > John W. Colby > www.colbyconsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin - > Beach Access Software > Sent: Saturday, May 10, 2003 11:31 AM > To: accessd at databaseadvisors.com > Subject: [AccessD] CC J-I-T Forms > > > John: > > Big THANK YOU for the JIT. I have a form with a tab control with three > subforms. The client has the BE on a server and their network isn't super > fast. It was taking about 11 seconds to open the form. I haven't tried it > there yet but on my box it would appear that the form now opens in 1/2 to > 1/3 the time. > > I'd like to show this at the next AUGSD meeting for my Coder's Corner > presentation if you have no objections. With attribution, of course. > > Best, > > Rocky Smolin > Beach Access Software > > ----- Original Message ----- > From: "John Colby" <jcolby at colbyconsulting.com> > To: <accessd at databaseadvisors.com> > Sent: Friday, May 09, 2003 4:12 PM > Subject: RE: [AccessD] Subjects in Newsletters > > > > And years later, I had a REAL reason to do JIT his way. Only once so > far... > > > > ;-) > > > > John W. Colby > > www.colbyconsulting.com > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William > > Hindman > > Sent: Friday, May 09, 2003 4:48 PM > > To: accessd at databaseadvisors.com > > Subject: Re: [AccessD] Subjects in Newsletters > > > > > > ...AccessD rite of passage ...until you've been on the wrong end of of a > JC > > rant, you can't really belong :) > > > > ...years back, a raw newbie to AccessD, I dared to mention that I did my > > j-i-t subforms just a bit differently ...two weeks later and a masters > > degree in Access intricacies later, we called a truce out of sheer > > exhaustion ...not ours of course but everyone else on the list ...but I > did > > buy his JIT sample and used it from then on :))) > > > > William Hindman > > > > ----- Original Message ----- > > From: "Ron Moore" <rmoore at comtechpst.com> > > To: <accessd at databaseadvisors.com> > > Sent: Friday, May 09, 2003 4:37 PM > > Subject: RE: [AccessD] Subjects in Newsletters > > > > > > > Martin, hasn't everyone who came on this list had a long argument with > > JC? > > > Are you saying we only begin to learn after we've had said long > argument? > > > > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of > > > Mwp.Reid at Queens-Belfast.AC.UK > > > Sent: Friday, May 09, 2003 3:39 PM > > > To: accessd at databaseadvisors.com > > > Subject: [AccessD] Subjects in Newsletters > > > > > > > > > Yip. When I came on tho this list (lot of years now) and had a long > > argument > > > with JC I started to learn. Today I have two books published, numerous > > > articles and I am currrently working for the Microsoft Office Team. None > > of > > > this would have been possible without the likes of John Colby, William, > > > Rocky, > > > Arthur, Mike Gunderloy and the other great developers on this list. Not > > > forgetting Susuan Harkins. The other day I got an email that was > addressed > > > to > > > myself and three others. I sat and looked at it but for this list and > the > > > ideas, arguments and teaching that has taken place I would not be here > at > > > all. > > > > > > But outside of that its the friends I have made here that mean more than > > > anything else. > > > > > > I have to name John Colby and Susan. Two people who give freely of their > > > time > > > and expertise to others. Susan in particular has opened so many doors > for > > me > > > in the Database world. Arthur Fuller as well who I think does more of > list > > > than he does on. > > > > > > Martin > > > > > > Quoting John Colby <jcolby at colbyconsulting.com>: > > > > > > > Ron, > > > > > > > > I have been on this list since about July, 1997. I have come further, > > > > faster, than would ever be possible without the list. In fact, truth > > > > be > > > > known, I'd be lost without it. Even as a pretty knowledgeable guy, I > > > > still > > > > have questions. Access is so complex that no one "knows it all". > > > > > > > > I remember my first job in Access. I came from programming, but it > > > > wasn't > > > > event driven. I was sooooo lost. I sold myself for well under 1/2 my > > > > normal wage because the company was willing to let me read and learn > > > > what I > > > > had to learn to do their database. 4 hours reading, 6-8 hours > working, > > > > 6 > > > > days a week (the company's old db was dying a painful death). This > was > > > > 1994 > > > > and there was no (widely available) internet, in fact not even an > > > > Access > > > > Users Group. I was one of the founding members and board member of > the > > > > San > > > > Diego Access Users Group and loved having someplace I could go once a > > > > month > > > > to talk about Access. MAN, it was LONELY out there back then. > > > > > > > > This group becomes like a family. Kindly Grandmothers like Susan, > > > > demented > > > > cousins like William, snotty nosed nephews like Drew... well you get > > > > the > > > > picture. <ducking REAL low> > > > > > > > > Yea, life just wouldn't be the same without AccessD! > > > > > > > > John W. Colby > > > > www.colbyconsulting.com > > > > > > > > -----Original Message----- > > > > From: accessd-bounces at databaseadvisors.com > > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Ron Moore > > > > Sent: Friday, May 09, 2003 3:04 PM > > > > To: accessd at databaseadvisors.com > > > > Subject: RE: Subjects in Newsletters: was RE: [AccessD] SQL in-line > > > > subquery > > > > > > > > > > > > My great-grandfather had an old saying: 'Throw a rock in to a pack of > > > > dogs, > > > > and the one that yelps is the one that got hit'! :-) Honestly > though, > > > > I > > > > agree with you John; I don't think solutions are being stolen, I think > > > > concepts learned the hard way are shared (why reinvent the wheel) and > > > > new > > > > territory is explored on a group basis (sort of a mass 'power > > > > programming' > > > > approach). I have received much more from this list than I could ever > > > > offer > > > > (partly because the answers appear in my mailbox before my original > > > > posts). > > > > I consider ourselves fortunate to have such talented authors among our > > > > venerable list members. > > > > Charlotte and others - Don't stop writing! > > > > > > > > Ron > > > > > > > > > > > > > > > > _______________________________________________ > > > > 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 > > > > > > _______________________________________________ > > > 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 > > > > > > > > _______________________________________________ > > 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 > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >