correcting switchboard

[bknight]

I have a problem with a switchboard. I have manipulated the settings and have come up with the image when the Db opens. I know what the options are for many of the buttons and selecting the 2nd from the bottom, Edit switchboard, I get an error. Then after selecting OK I get what the switchboard should look like. The images are upside down chronologically speaking.
My question is how to get the descriptions to display on opening?

[HansV]

Impossible to tell without seeing the database.

[HansV]

Thanks for sending the database.
For some reason, two form events have become disconnected from their event procedures.

To correct this, open the Switchboard form in design view.
Activate the Event tab of the Property sheet.

Click in the On Current event.
Select [Event Procedure] from the drop-down menu.
Click the builder dots ... to the right of the drop-down arrow.
This should take you to the Form_Current() event procedure in the Visual Basic Editor.

Switch back to Access.
Click in the On Open event.
Select [Event Procedure] from the drop-down menu.
Click the builder dots ... to the right of the drop-down arrow.
This should take you to the Form_Current() event procedure in the Visual Basic Editor.

Next, scroll down to the HandleButtonClick() function.
Change the line

Code: Select all

            Application.Run "WZMAIN80.sbm_Entry"

to

Code: Select all

            RunCommand acCmdSwitchboardManager

Switch back to Access.
Save, close and reopen the Switchboard form.

[bknight]

My version doesn't have a HandleButtonClick() function, unless I'm blind. I went to the All tab to attempt to find it after looking in the event tab.

[bknight]

Ok, I went to the Vb editor and there is the handlebuttonClick()
Changed the code to your suggestion.
And it works, thanks.

[bknight]

I checked the nearly identical Db that has been working and the line
Application.Run "WZMAIN80.sbm_Entry" is there and that switchboard has never had an issue, just for your information, as I said the problem Db code was changed and it works fine also. Strange behavior in the two nearly identical Dbs.

[Gasman]

The number of times I hear near identical systems, but do not work the same, I wish I had a £1 every time.

[George Hepworth]

Near identical means, by definition, there is at least one difference. Sometimes that difference is insignificant. Sometimes it is significant.
I'm reminded here of my favorite aphorism regarding ambiguity.

Ambiguity is required in poetry, humor and politics. It is anathema in databases.

Another synonym for Ambiguity is "near identical" .

Just saying.

[bknight]

Near identical means, by definition, there is at least one difference. Sometimes that difference is insignificant. Sometimes it is significant.
I'm reminded here of my favorite aphorism regarding ambiguity.

Ambiguity is required in poetry, humor and politics. It is anathema in databases.

Another synonym for Ambiguity is "near identical" .

Just saying.

There are differences:
The color of the switchboard
The method of calculating the final numbers
The code to calculate is different of course.
Everything else is identical. Does that appease you?

ETA: Oh, and the files names are different of course.

[George Hepworth]

Sorry I offended you. That wasn't my intention.

I'm just trying to point out that very subtle differences may or may not be significant. Dismissing the possibility that they are significant can be risky.

[Gasman]

Near identical means, by definition, there is at least one difference. Sometimes that difference is insignificant. Sometimes it is significant.
I'm reminded here of my favorite aphorism regarding ambiguity.

Ambiguity is required in poetry, humor and politics. It is anathema in databases.

Another synonym for Ambiguity is "near identical" .

Just saying.

There are differences:
The color of the switchboard
The method of calculating the final numbers
The code to calculate is different of course.
Everything else is identical. Does that appease you?

ETA: Oh, and the files names are different of course.

I doubt the colour of a switchboard is going to make a difference, but I am prepared to hear different.
Changing the calculation?, well you never know? If that calcualtion affects code, well that would be obvious to most people at least?
Code to calculate. Well there is a good place to start.?
As to the rest?, Well I would have to see that to confirm that is actually the case, going on all your previous posts here.?

Then again, you generally do not expose your database here, (probably for good reason), except to Hans privately, so who can tell?

[bknight]

No, these databases have the same entry data collected for almost 20 years. All is public data, and I would post them here, but they are too large, almost 10000 records (9724 as of yesterday).
I will tell you that the data is the NYSE up stocks, down stock, and the volume associated with each and then a number called McClellan oscillator is calculated each day and summed with yesterday's sum. The second is the Ratio Adjusted McClellan oscillator, calculated slightly different the original.
Google it up if you want more information.
The other dB's have personal data and information, those I wouldn't post here.

[Gasman]

And of course, you cannot reduce the data, as you do not know how?

From all your questions here, I am really surprised you have even heard of Google.

[bknight]

This is not the place for snide remarks.

[Gasman]

I beg to differ?
If you cannot be bothered to look for yourself elsewhere, then entirely justified, at least from what I can see from your posts?
You might not well be used to having adverse comments against you, and I feel that is the norm for you, but you seem to expect someone else to do the work for you all the time, which is the complete contrast to my thoughts of helping people how to do something.

Hence my signature
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.

[HansV]

Please remain respectful, guys.

[Gasman]

@Hansv
O/P has left a few 'snide' comments himself, to other members, George Hepworth springs to mind?
So my motto is, if you can't take it, do not not give it out.?

Plus this is the only person I see here with this attitude and laziness?

[HansV]

It was directed at all of us.