ocx calander on a form with subform (datasheet view)

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
 
M

Mike Painter

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.
 
T

Tony Toews [MVP]

Mike Painter said:
You can fake it by creating a continuous form which looks like a datasheet
and add your combobox - calendar (?) to that.

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/
 
T

Tony Toews [MVP]

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/
 
M

Mike Painter

Tony Toews [MVP] wrote:
worth spending money. Every time I open one I save the price of the
book.
Agreed, but it always amuses me to think how much I've spent to make less
money...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top