Switchboard

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi all,

I have Access 2003 sp3. I just created a swtichbaord, and I placed on
it a calendar control. I save it and open the switchboard, but to my
surprise, I was not able to pick any date on the calendar, it seems to
be locked. I checked the properties of the calendar and made sure that
it was not locked, I save it again and it still does not work.

I tried to place code in the open even of the swtichboard:

Form_Switchwboard.calDatePicker.value = Format(Now()-1, "mm-dd-yyyy")

That didn't work either. Can you tell me what might possibly be wrong?

Thanks,

Ben
 
Hi all,

I have Access 2003 sp3. I just created a swtichbaord, and I placed on
it a calendar control. I save it and open the switchboard, but to my
surprise, I was not able to pick any date on the calendar, it seems to
be locked. I checked the properties of the calendar and made sure that
it was not locked, I save it again and it still does not work.

I tried to place code in the open even of the swtichboard:

Form_Switchwboard.calDatePicker.value = Format(Now()-1, "mm-dd-yyyy")

That didn't work either. Can you tell me what might possibly be wrong?

Thanks,

Ben
Click to expand...

The form that the Switchboard Wizard creates is (typically) unbound and locked
for editing, so no control on it can be edited either. You may want to "roll
your own" switchboard rather than using the wizard.
 
John,

I take it that you do not recommend, somehow "unlock" the
switchboard, if there's even a way to do so? What is the down side of
that?

Thanks,

Ben
 
John,

I take it that you do not recommend, somehow "unlock" the
switchboard, if there's even a way to do so? What is the down side of
that?
Click to expand...

Well, you could - I don't like the look of the switchboard, I don't like the
feel of it, and I don't like the smell of the left-hand tunnel; there's bad
air down there or I am no guide <oops sorry>.

Try checking its Allow Updates property, and maybe even create a little
one-row, one date field table to use as its Recordsource, and bind the
calendar control to it.
 
I don't like the look of the switchboard, I don't like the
feel of it, and I don't like the smell of the left-hand tunnel; there's
bad air down there

Yeah, I agree with you. Thanks for your helpful suggestions, John.
Have a great weekend.

Ben
 
Back
Top