ocx calander on a form with subform (datasheet view)

  • Thread starter Thread starter chez
  • Start date Start date
C

chez

Hello, I am able to successfully use a calander on my form, using a combo box
and the date will be inserted....but....I actually want to use it when the
form is in datasheet view (unable to happen) there fore I've put the
datasheet viewing subform in the body of a form, I am hoping to be able to
click on the datasheet combo box and the calander will appear on the form and
when I click will send the data back to the datasheet combo box...I'm hoping
it's just a matter of adding the form and subforms name etc, just never sure
which order to write the names in...any suggestions
Cheryl
 
You can fake it by creating a continuous form which looks like a datasheet
and add your combobox - calendar (?) to that.
The only other choice would be to switch to Access 2007 which has a
datepicker built in and which works with a datasheet.
 
Mike Painter said:
You can fake it by creating a continuous form which looks like a datasheet
and add your combobox - calendar (?) to that.
Click to expand...

Which is exactly what I always do. Frequently I also have command
buttons opening up other forms anyhow.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Don' use an OCX calendar as it's a pain to distribute the OCX.

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month
Calendar derived directly from the Common Control DLL. There are
links to several downloadable calendar forms at my website. As these
are forms you can also do anything with them you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.

Duane Hookum has an awesome and simple calendar in a report. See the
Calendar Reports sample section at
http://www.access.hookom.net/Samples.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Tony Toews [MVP] wrote:
worth spending money. Every time I open one I save the price of the
book.
Click to expand...
Agreed, but it always amuses me to think how much I've spent to make less
money...
 
Back
Top