 | |
access2007 calendar generator
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
access2007 calendar generator -
04-28-2011
, 04:05 PM
#2
| |||
| |||
|
|
Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John |
http://www.access-template.com/Access_Scheduler.html
There's a free trial version.
#3
| |||
| |||
|
|
flymo wrote: Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. *Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John Maybe look at this site.http://www.access-template.com/Access_Scheduler.html There's a free trial version. |
Excellent, thanks I will take a look at the demo.
John
#4
| |||
| |||
|
|
Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John |
a fair bit of VBA code, you can "Roll Your Own" by stacking 36 List box
controls on a form in a 7 wide by 6 high grid (row 6 has only 2 list
boxes) and controling their visibility and row data sources with code.
While building a calendar this way results in it not being directly
editable. What I did was to provid a "Drill Down" capability that
allowed the user to double click the list box row they wanted to edit,
and opened a modal form thta let them make changes.
The big advantage to this method is, it's an All Access solution that
does not require that you install any 3rd party controls.
Worked for me, might work for you.
Rdub
#5
| |||
| |||
|
|
flymo expressed precisely : Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. *Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John If you are willing to get your hands dirty and are confortable writing a fair bit of VBA code, you can "Roll Your Own" by stacking 36 List box controls on a form in a 7 wide by 6 high grid (row 6 has only 2 list boxes) and controling their visibility and row data sources with code. While building a calendar this way results in it not being directly editable. What I did was to provid a "Drill Down" capability that allowed the user to double click the list box row they wanted to edit, and opened a modal form thta let them make changes. The big advantage to this method is, it's an All Access solution that does not require that you install any 3rd party controls. Worked for me, might work for you. Rdub |
I have written some procedures, functions, datasets etc, but nothing
complex so I am not too confident of making anything yet.
Willing to learn, but need a frame of reference to get going.
Thanks for the suggestion, it seems to be similar to the app mentioned
above.
John
#6
| |||
| |||
|
|
Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John |
though. You can see a room calendar I did at
http://www.williamsonenterprises.com/lgalleryforms.htm (2nd grouping
of the gallery).
I've done lots of calendars with it using Access 2003. The learning
curve is a little steep but it is worth it.
-paulw
#7
| |||
| |||
|
|
On Thu, 28 Apr 2011 14:05:39 -0700 (PDT), flymo <fly... (AT) hotmail (DOT) com wrote: Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. *Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John Check out Solutions Schedule atwww.dbi-tech.com*It's not cheap though. *You can see a room calendar I did athttp://www.williamsonenterprises.com/lgalleryforms.htm*(2nd grouping of the gallery). I've done lots of calendars with it using Access 2003. *The learning curve is a little steep but it is worth it. -paulw |
Hi Paul,
Thanks for the info.
The dbi-tech apps are probably along the lines of where I'd like to
go, the room calendar looks excellent. As they have the COM version
which will be usable with Access (If I understand their info
correctly) that would be a great start and can be modified.
I also stumbled across http://www.scheduleit.co.uk/ - not custom and
can't be modded - nice functionality tho'
Much appreciated.
John
#8
| |||
| |||
|
|
I have been tasked with creating an access application for scheduling a fairly complex set of requirements. Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? |
http://www.granite.ab.ca/access/calendars.htm for some Access specific
calendar forms.
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
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
#9
| |||
| |||
|
|
On Apr 28, 10:09*pm, PW <emailaddyin... (AT) ifIremember (DOT) com> wrote: On Thu, 28 Apr 2011 14:05:39 -0700 (PDT), flymo <fly... (AT) hotmail (DOT) com wrote: Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. *Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John Check out Solutions Schedule atwww.dbi-tech.com*It's not cheap though. *You can see a room calendar I did athttp://www.williamsonenterprises.com/lgalleryforms.htm*(2nd grouping of the gallery). I've done lots of calendars with it using Access 2003. *The learning curve is a little steep but it is worth it. -paulw Hi Paul, Thanks for the info. The dbi-tech apps are probably along the lines of where I'd like to go, the room calendar looks excellent. As they have the COM version which will be usable with Access (If I understand their info correctly) that would be a great start and can be modified. |
versions of Access. I don't know C# yet but they have a .NET version
too.
There really isn't much of an interface so you must accomplish what
you want in VBA. It's pretty darn powerful. I've done some slick
calendars (imho, of course ;-) but have not tried doing any thing with
letting the user draw their own calendars and move the time bars
around.
Quote:
|
I also stumbled across http://www.scheduleit.co.uk/ - not custom and can't be modded - nice functionality tho' Much appreciated. John |
-paulw
#10
| |||
| |||
|
|
On Fri, 29 Apr 2011 09:55:05 -0700 (PDT), flymo <fly... (AT) hotmail (DOT) com wrote: On Apr 28, 10:09*pm, PW <emailaddyin... (AT) ifIremember (DOT) com> wrote: On Thu, 28 Apr 2011 14:05:39 -0700 (PDT), flymo <fly... (AT) hotmail (DOT) com wrote: Hello All, I have been tasked with creating an access application for scheduling a fairly complex set of requirements. *Staff, trainees, technical disciplines, rooms/locations, devices etc. I can work out the basic table structure inputs etc, but I have been searching for code that would be usable or mod-able to generate the events, create a calendar form showing events by multiple filters , and then be able to push out a calendar report in a weekly/monthly format. There was mention of a flexgrid/datagrid control(?), which I haven't used to date - are these an option? Any tips or pointers to any such resources would be appreciated, I have been searching google for options and many are web based (hosted), or refer to pop up type calendars but the preference is for access07 and a fully fledged interactive app. Thanks in advance John Check out Solutions Schedule atwww.dbi-tech.com*It's not cheap though. *You can see a room calendar I did athttp://www.williamsonenterprises.com/lgalleryforms.htm*(2nd grouping of the gallery). I've done lots of calendars with it using Access 2003. *The learning curve is a little steep but it is worth it. -paulw Hi Paul, Thanks for the info. The dbi-tech apps are probably along the lines of where I'd like to go, the room calendar looks excellent. *As they have the COM version which will be usable with Access (If I understand their info correctly) that would be a great start and can be modified. Yes. *I use the COM version with MS Access 2003 but it works with all versions of Access. *I don't know C# yet but they have a .NET version too. There really isn't much of an interface so you must accomplish what you want in VBA. *It's pretty darn powerful. *I've done some slick calendars (imho, of course ;-) but have not tried doing any thing with letting the user draw their own calendars and move the time bars around. * I also stumbled across *http://www.scheduleit.co.uk/*- not custom and can't be modded - nice functionality tho' Much appreciated. John Thanks for showing me that. -paulw |
I will no doubt need some further guidance ns the project progresses.
John
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.