Administrator
administrator at it.glasgow.gov.uk
Wed Jan 29 03:13:12 CST 2003
Hi Drew Sounds great. Please include me on your test list also. Thanks Selina ---------------------------------------------------------------------------- ---- Selina Iddon selina at easydatabases.com.au Ph: 0414 225 265 Easy Access Databases ----- Original Message ----- From: "Drew Wutka" <DWUTKA at marlow.com> To: <AccessD at databaseadvisors.com> Sent: Saturday, January 25, 2003 5:32 AM Subject: RE: [AccessD] MiniCalendar Wish List Request... > Actually the 'current' version does the date/color scheme. The setup is a > little clunky, but it works just fine. > > Did you want to be on the beta testers list? > > Drew > > -----Original Message----- > From: Andy Lacey [mailto:andy at minstersystems.co.uk] > Sent: Friday, January 24, 2003 12:38 PM > To: AccessD at databaseadvisors.com > Subject: RE: [AccessD] MiniCalendar Wish List Request... > > > Drew > I made two major changes but they may not be very general use. Up to > you. > > The first was to add a column of financial week numbers on the left hand > side. When you click OK I can return either the week or the date. > > The second is to have tables of public holiday dates and company > shutdowns. I then colour the dates on the calendar according to whether > each day is in one or other of those tables. > > > Andy Lacey > http://www.minstersystems.co.uk > > > > > -----Original Message----- > > From: AccessD-owner at databaseadvisors.com > > [mailto:AccessD-owner at databaseadvisors.com] On Behalf Of Drew Wutka > > Sent: 24 January 2003 15:46 > > To: ''AccessD at databaseadvisors.com' ' > > Subject: RE: [AccessD] MiniCalendar Wish List Request... > > > > > > In the works. The version I am working on sets up properties > > on the form itself. Right now what you have listed as > > 'startdate' is current SelectedDates. Need to work on the > > time issue....I'm debating about whether to include a clock or not. > > > > Drew > > > > -----Original Message----- > > From: Marcus, Scott (GEAE, RHI Consulting) > > To: 'AccessD at databaseadvisors.com' > > Sent: 1/24/03 5:30 AM > > Subject: RE: [AccessD] MiniCalendar Wish List Request... > > > > Drew, > > > > It would be cool if one could do something like this in code.... > > > > Dim calMiniCalendar as MiniCalendar > > Dim dtWhen as Date > > Dim dtTime as String > > > > Set calMiniCalendar = New MiniCalendar > > calMiniCalendar.StartDate = #2/1/2003# dtWhen = > > calMiniCalendar.GetDate 'Shows MiniCalendar > > calMinicalendar.StartTime = "13:00:00" dtTime = > > calMiniCalendar.GetTime 'Shows a clock . . . > > > > You get what I'm saying? > > > > Make it a class that creates and opens forms that the class > > makes. Then just import the class module in your project and > > away you go. > > > > Scott Marcus > > > > > > -----Original Message----- > > From: Drew Wutka [mailto:DWUTKA at marlow.com] > > Sent: Thursday, January 23, 2003 8:04 PM > > To: 'AccessD at databaseadvisors.com' > > Subject: RE: [AccessD] MiniCalendar Wish List Request... > > > > > > Okay, that is actually one of the 'big' changes I am building > > on. The 'current' version is a form. You can open the form, > > and it 'works', though it doesn't do anything for you. That > > is because it is run from a module, called fMiniCalendar. > > Using that module allows you to tell it to send a date to a > > textbox(or another valid control), it can also set the date > > selected to a global variable. There is a lot you can do > > with the function (for instance, the feature I am the > > proudest of, even though it is quite simple, is the Cycle > > mode, where you give it a 'parent form', and as the user > > moves the mouse about the calendar, the parent form updates > > it's data based on the mouse overed date), but it is pretty > > 'clunky' using the calendar directly from the function. > > > > What I am building now is an all inclusive form. You will > > just have to import the form into your database, and whalla. > > For instance, the form will have a 'SelectedDate' property. > > So you can open the form, let the user select a date, then > > get the forms selected data property, or you can make it a > > subform, and use it's SelectedDate property for a control. > > All of the calendar's abilities will be part of the form's > > properties and procedures. (For example, you will be able to > > Set the SelectedDate property, and the calendar will conform > > to the new date....). > > > > Does that make sense? As I said I am in process of building > > it right now. If anyone would like to volunteer as a beta > > tester, I would be glad to send along incremental versions.... > > > > Drew > > > > -----Original Message----- > > From: Francisco H Tapia [mailto:my.lists at verizon.net] > > Sent: Thursday, January 23, 2003 6:48 PM > > To: AccessD at databaseadvisors.com > > Subject: Re: [AccessD] MiniCalendar Wish List Request... > > > > > > Man I was beginning to think the list was down again ;o). > > > > Drew, > > In your calendar (sorry I haven't look into it for quite > > some time) could I just call it from a parent application.. > > sort of an add-in(esq) type thing? It'd sure beat the pants > > out of including the damn ocx. Plus what would be the syntax > > for calling your form from a button command, and passing > > arguments? This way it could be more useful in the sense of > > as I said an add-in. Thanks -Francisco http://rcm.netfirms.com > > ----- Original Message ----- > > From: "Drew Wutka" <DWUTKA at marlow.com> > > To: <AccessD at databaseadvisors.com> > > Sent: Thursday, January 23, 2003 4:23 PM > > Subject: [AccessD] MiniCalendar Wish List Request... > > > > > > : Some of you may have used my MiniCalendar form. I decided > > I needed a break > > : from some of my current projects, so I am revamping the > > MiniCalendar. In > > : fact, I am starting from scratch. The new calendar will be > > quite a bit > > : different to use, but also much easier. I am adding some > > features that I > > : remember getting requests on, such as complete keyboard > > interface (allowing > > : for the calendar to be controlled from the keyboard alone, > > or from the mouse > > : alone, or from a combination of both). Also, I remember > > someone wanting the > > : calendary to list the days of the week based on regional > > settings (actually > > : I am setting it so you can tell it which day you want first). > > : > > : So, the question is, other then the current capabilities, > > what else would > > : you want a calendar form to do for you? (If you want a > > copy of the last > > : 'update', give me a holler, and I'll email it to you. > > Right now my site is > > : still down, so you can't download it from there. > > : > > : Feel free to send me stumpers if you want. I like the challenge. > > : > > : Drew > > : This list sponsored by Database Advisors Inc., a worldwide > > association of database developers. > > : Visit http://www.DatabaseAdvisors.com, the database > > developers' list portal and support site. > > : > > > > > > This list sponsored by Database Advisors Inc., a worldwide > > association of database developers. Visit > > http://www.DatabaseAdvisors.com, the database > developers' > > list portal and support site. This list sponsored by Database > > Advisors Inc., a worldwide association of database > > developers. Visit http://www.DatabaseAdvisors.com, the > > database developers' list portal and support site. This list > > sponsored by Database Advisors Inc., a worldwide association > > of database developers. Visit > > http://www.DatabaseAdvisors.com, the database > developers' > > list portal and support site. This list sponsored by Database > > Advisors Inc., a worldwide association of database > > developers. Visit http://www.DatabaseAdvisors.com, the > > database developers' list portal and support site. > > > > > > This list sponsored by Database Advisors Inc., a worldwide association of > database developers. > Visit http://www.DatabaseAdvisors.com, the database developers' list portal > and support site. > This list sponsored by Database Advisors Inc., a worldwide association of database developers. > Visit http://www.DatabaseAdvisors.com, the database developers' list portal and support site. > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd