[AccessD] A2K: Something new

Darren DICK d.dick at uws.edu.au
Thu Jan 22 17:54:31 CST 2004


Just a WAG
but look for timers firing on the subs - even on the main
I have had odd things happen to me when timers are firing.
Especially quick timer intervals like 350 or 100
Good luck

DD

----- Original Message ----- 
From: "Steven W. Erbach" <serbach at new.rr.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Friday, January 23, 2004 12:54 AM
Subject: [AccessD] A2K: Something new


> Dear Group,
>
> You think you've seen it all, when all of a sudden...
>
> I've taken over development and support of a domestic violence shelter statistics program. In my efforts to re-factor (how's that
for an Extreme Programming term?) some of the data entry forms I've run into something odd.
>
> One of the main data entry forms (key field ChildID) has a subform which contains a Tab object. Each of the tabs on this subform
contains a sub-subform. While getting familiar with the workings of the program I noticed that one of the sub-subforms did not have
the proper linking fields set up.
>
> The subform's linking field is that same ChildID...but the RecordSource table for the subform is NOT keyed! The sub-subform in
question also has only ChildID as the linking field...but the key field for the sub-subform's table is FreeFormID. ChildID is a
foreign key in that table.
>
> The behavior I'm seeing is this: when I go to check the linking fields in the subform I noticed that the VB window's title bar
shows the following:
>
> Microsoft Visual Basic - STATISTICS [running]
>
> After a moment I see the Subform Field Linker dialog box. While the dialog box is on-screen the title bar of the VB window shows
[running]. When I close the dialog box the VB window flashes and [running] disappears from the title bar.
>
> But when I go to check the linking fields for the sub-subform in question, [running] appears once again in the VB title bar, but
then I see a Microsoft Access dialog box with the following message and OK button:
>
> Object variable or With block variable not set
>
> ...as if the application was trying to start itself! I can't get at the Subform Field Linker dialog box at all. When I click OK on
the dialog box the VB window flashes and [running] disappears from the title bar.
>
> So I tried deleting the sub-subform and placing it on the tab page again. When I've finished using the subform tool to place the
object on the tab page, I get another dialog box labeled "StatsTracker" (the name of the application):
>
> Your code contains a syntax error, or a Stats Tracker function you need isn't available.
> If the syntax is correct, check the Control Wizards subkey or the Libraries key in the StatsTracker section of the Windows
Registry to verify that the entries you need are listed and available.
>
> I click OK and I see the subform object on the tab page. I can assign the Source Object property, but when I go to Link Master
Fields I get the "Object variable or With block variable not set" message.
>
> Can any of you figure out what's happening to me here? Thank you.
>
> Regards,
>
> Steve Erbach
> Scientific Marketing
> Neenah, WI
> 920-969-0504
>
> Message created with Bloomba
>
> Disclaimer: No tree was killed in the transmission of this message. However, several coulombs of electrons were temporarily
inconvenienced.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list