DTPicker Problem

[keeegs]

Hi All

I've been playing around and hunting online for a few hours to try find a solution to this problem with no luck yet.

I have a user form which I want a DTPicker where I only choose the month and year.
Is this possible with DTPicker?

The information is then transfered to a worksheet, thats no problem.

Other options I was thinking was just having 2 drop down lists, 1 containing months and 1 with years and then transfering that to a single cell but Id much prefer it if I could use something like a DTPicker.

All help is appreciated

Thanks, Keegan

 

[Norie]

Keegan

There's no control that you can just show the month and year.

Using comboboxes is probably the best idea.

PS Some people don't have access to the DTPicker control or use a different version.

So it's possible that you could run into problems with that if you use one.

 

[keeegs]

Norie

Thanks for that. I will likely just use combo boxs for that 1.

I also have a DTPicker on the same form that I use day month and year for.

Is there a macro command that when they open the sheet/form it gives them access to the DTPicker?

We all run on the same spec PCs at work, just most of them won't have the DTPicker selected in the menu.

Thanks, Keegan