How to display database in a calendar format

[Danny]

Hi,

I would like to know how to display the database in a calendar format.
Example :
Database name call MyTeamDuty
Field : Name , Task , Start Date, End date

Display it in a calendar form such as Weekly, Monthly or even a year.
Boxes like Mon, Tue, Wed, Thurs, Friday, Sat, Sun and the boxes is
highlighted with color if it is within the start date and end date for the
person name.

We can also check it by monthly.

Thanks

 

[Pete D.]

You might look at this flexgrid demo by Pete Hibbs
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

 

[Mark Andrews]

There are a bunch of activeX components that can be used for
calendar/scheduling. I'm currently working on a Microsoft Access
appointment scheduling template (hopefully it will be done in about a
month). Most of the components allow for daily, weekly, or monthly views
and tie together with a date selection control. So you can select 3 days
and it will show just those three days etc.... You can double click on any
entry in the calendar and edit the information etc.... You can drag
events around on the calendar and various other nice behavior.

Checkout some of the normal component vendors. However you need to look for
activex only.

In my opinion this is one of the areas where it makes sense to use a third
party control. Building a calendar equal to some of these controls is a lot
of work.
However depending on your exact needs something simpler might do the job.

Note: it is a little tricky to use some of these controls. They usually
have hundreds of objects, methods, properties etc...

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[John... Visio MVP]

Hello Danny,

I provide help with Access applications for a reasonable fee. I developed
a calendar form and a calendar report that looks like a page torn off a
wall calendar. My calendar form and calendar report can display
different data each day. The year and month are selectable. Other
functionality can easily be added to the calendar. This would be ideal for
displaying the tasks in your database. I can implement my calendar form
and calendar report in your database for a modest fee. Contact me at
(e-mail address removed).

Steve

These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is a known troll who has been harrassing people for work for years.
He has proven on many occassions his ineptitude for working with Access and
any of the other Office products. He is the only one who does not understand
what FREE support means.

John... Visio MVP

 

[Danny]

Hi Peter, Thanks!
I have downloaded and try it out. Copy the activeX into the system32.
Basically failed to run on my machine.

Hi Others
Hope anyone else can give more guidance on display database in a calendar
format.
I intend to display my team schedule so that I know who is free and who is
overloaded.

Example :
Name | Mon | Tue | Wed | Thurs | Fri | Sat | Sun | ......
John
David
Alice
...

It is like the MS Office project where we can see the team scheduler ..

Cheers

 

[Peter Hibbs]

Danny,

I think a Flex Grid control will do exactly what you want.

How did it 'fail to run' on your PC?
Did you get any error messages?
What version of Access are you using?
What version of Windows are you using?
Did you copy the MSFLXGRD.OCX file to the correct folder?
Did you register the control with RegSvr32.exe?
Did you check that the Flex Grid Reference is ticked?

More information on the problem may help to get it working, then you
can decide if you want to use it in your project.

Peter Hibbs.

 

[Danny]

Hi Peter,

How did it 'fail to run' on your PC?
I able to open the Flex Grid mdb and go to the main switchboard. But when I
click on each of the example, it shows error saying object not supported or
run-time error "???".

Did you get any error messages?
Yes, when I run the regsvr32.exe as per your installation document, it sh
ows error "The module MSFLXGRD.OCX was loaded but the call to
DIIRegisterServer failed with error code 0x8002801C.

Then I just try to run the flex Grid mdb and click on the first example
Calendar and Diary Manager, it shows error "Object doesn't support this
property or method.
Then I click on second example images in flex Gric and Editing a cell, it
shows run-time error '438'. And same to the rest of the example.

What version of Access are you using?
I'm using Access 2003 CP2

What version of Windows are you using?
Windows Vista Home Premium SP1

Did you copy the MSFLXGRD.OCX file to the correct folder?
I copy it to c:\windows\system32

Did you register the control with RegSvr32.exe?
Yes, as explain about and I got the error

Did you check that the Flex Grid Reference is ticked?
Yes

Thanks

 

[Peter Hibbs]

Danny,

I able to open the Flex Grid mdb and go to the main switchboard.

That tells me that you copied to the correct folder, the code checks
for that.

Did you get any error messages?
Yes, when I run the regsvr32.exe as per your installation document, it sh
ows error "The module MSFLXGRD.OCX was loaded but the call to
DIIRegisterServer failed with error code 0x8002801C.

Well that is obviously the problem, if the control is not registered
correctly, it is not going to work. I suspect that the problem is
something to do with Vista although no one else has reported problems.
I don't have Vista so I can't say if that is the problem. However, I
Googled your error message and found a couple of Web sites which you
could look at. They are :-
http://www.cryer.co.uk/brian/windows/trbl_nt_rgsvrfld8002801c.htm
and
http://www.vistaheads.com/forums/mi...ista-general/55707-error-code-0x80004005.html
and there are a few more.

All I can suggest is that you check these out and see if you can find
the solution there. Please let us know how you get on, it may help
other users in the future.

Peter Hibbs.

 

[Pete D.]

Did you run regsvr32 as with your administrator account?

 

[Tony Toews [MVP]]

I provide help with Access applications for a reasonable fee.

Please stop soliciting for work in these forums.

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/

 

[Danny]

Thanks! Pete D and Peter Hibbs,
Let me try out what u suggested and I definitely let you all know the
outcome..

Cheers

Danny Boy

 

[Danny]

Hi All,

I manage to load the msflxgrd.ocx.
Here is the link to the solution.
http://home.comcast.net/~jesse99/Vista.html
Although I'm using administrator to run it previously but it is still failed.
The tips is that I need to turn off the UAC protection.

Now I can run the flex grid.
I like the project management example. How can I know how to create that?

 

[Pete D.]

Thank you for posting back, may help others. As far as how to create, play
with it and when you get stuck post back. Suggest since this problem is
solved you start new thread with other problems. Pete

 

[Peter Hibbs]

Danny,

Thank you for the Web site address, that is very useful information
which I will bookmark for future reference.

How can you create the Project Example - that is a bit of an open
ended question. All I can suggest is that you study the code and try
and relate that to your own requirements. I think that you have chosen
the most complicated example, I would suggest that you start off with
something simple and build on it one stage at a time, that's what I
did.

Good luck.

Peter Hibbs.

 

[Danny]

Hi All,

thanks for all the suggestion. Let me try out first.
Will post more question if needed..

Cheers
Danny

 

[Danny]

Hi Peter,

I try to run the frmProject but it does not work.
The debug seem pointing to flexAlignCenterCenter.
I guess it is because the MSFLXGRD.OCX not loaded because I did not run from
the switchboard.
How can we load the MSFLXGRD.OCX directly when I run the frmProject?

Thanks

 

[Haylee Moldenhauer]

Well i honistly dont know how to do that but i have the same troubles off
and on
any help out there 4 us?

 

[Peter Hibbs]

Danny,

Usually the error you are getting is because the Flex Grid control has
not been registered correctly so that Access does not recognise the
Flex Grid constants.

You said in an earlier post that the demo program was working
correctly so I presume you have registered it OK. I'm not sure I
understand what you are doing now, are you trying to use the
frmProjects form in another database? In the demo program itself it
does not matter if you run that form from the Switchboard or from the
Database window, it should still open properly.

More information would help.

Peter Hibbs.

 

[Danny]

Hi Peter,

Yes, you are right. The demo work perfectly fine after I fixed the
MSFLXGRD.OCX issue previously. I want to learn more on the frmProject because
that is what I'm looking for. I need to know how this is being construct. So
I open another new database to import all the necessary tables, queries,
form and modules from your demo. Once imported, then I want to make sure it
is working as you original Demo before I start the play around with it to
know how it work, the logic and how it help in my project. At this stage I'm
stuck with the error that I mention. Bear in my the MSFLXGRD.OCX still loaded
in the c:\Windows\System32

Running from the Demo is ok, but if we export into a new database and run
it, its complaint in the debug mode in some line with the function
flexAlignCenterCenter which I believe its try to refer to the MSFLXGRD.OCX.
Then I believe it have something to do with the loading of this Active
control.

Pls enlighten me in this matter..

Cheers

 

[Peter Hibbs]

Danny,

It sounds to me as if you have not set up a reference to the control
in the VBA window (Tools > References...). If that is not the problem
then, if you want, I would be happy to have a look at and see if I can
fix it. Just send me a (zipped) copy to the email address in the Word
doc.

Peter Hibbs.