Creating Diaries/journal in Access?

[A|ex]

has anyone created a diary in microsoft access or heard of anyone who has? I want to make a diary of appointments for certain people so when someone is making an appointment they can assign whatever rep is free for whatever time.

Is this possible to have it layed out like a journal in say microsoft outlook's journal?

 

[jonifen]

It can be done I'm sure... when a timeblock has been booked for a rep it would just update their availability field for that time period to be "busy" so they would be not be invited.

As for making it look like office's journal... you can design it as you wish (have never used the journal, but I'm sure it wont be too bad)

 

[A|ex]

do you have any ideas where to start? i mean how would i start on a form or would i not even use a form? ive never done something like this in a database before. I know its possible doing it other ways where users enter dates etc but this way is diff?

 

[Kevin_S]

Alex -

Not trying to move people away from this site (sorry Jon) but in the interest of helping others if you go to the UtterAccess Site (www.utteraccess.com) and search for "Diary" or "Access Diary" one of the members there has posted a complete Diary Application for free for others to use/disect... may save the effort if you just want the program...


HTH,
Kev

 

[greaseman]

Question about msflexgrid

I, too am trying to create a diary or appointment process in Access. I've seen several references to "msflexgrid" and have found the correct ocx for it, but whenever I try to put msflexgrid into a form, I get a message about the OLE server for the ocx not being registered. I've tried using both the "insert ActiveX" and references to it in code, to no avail. I'm running Access 97 on a Windows 2002 PC and know there's probably something real simple I need to do. Can anyone out there provide a little guidance for me? Microsoft's explanation is in typical "Microsoft-ese." Thanks so much!

 

[Pat Hartman]

A97 may simply be too old to support the control you are adding. A lot has happened to Access in 8 years and 3 versions.

The other thing with OCX controls is that they must be properly registered. Did you install the OCX properly so that windows would register it? You can't just copy an OCX from one db to another.

Kev, I tried searching the referenced site but couldn't find the diary. Do you have a link?

 

[greaseman]

Hello, Pat, and thanks for replying!

Yup, Access 97 is old.... however, the client I work for likes it and has no plans for later and greater versions. Concerning the flexgrid .ocx, I believe I registered it correctly (and didn't copy it from any other database). I first did a search to confirm the flexgrid .ocx was in my WINNT\SYSTEM32 folder, which it was. I then installed the Flexgrid .ocx in Access, using the ActiveX insert option from Access' menus. I also checked for a reference to the same .ocx in my VBA code (and did a recompile of all code). But.... when I go to place the flexgrid .ocx onto a form, Access goes crazy, saying I've got to reregister the PLE server. I've done everything correctly, like I've done with other .ocx's, but this one is aggravating!

If you have ant ideas or comments, I would love to hear what you have to say. Thanks again, and have a great day.

 

[Pat Hartman]

If you have a newer version of Access available, convert your db and try the control there. If it works in the new version you have your answer. If it doesn't we'll keep trying.

 

[greaseman]

No.... we don't have anythng newer here than good old Access 97. I think I might try taking home a copy of the application, since I have Access 2000 at home, as well as Access 97. Thank you for the suggestion! And thanks for the offer to keep on trying!

 

[A|ex]

does anyone want to get together to design and create a diary or journal?

 

[greaseman]

Sound interesting!

That sounds like a great idea, especially where there seems to be a strong interest for such a concept! How might we go about it? Will we offer our ideas and code? And forms? I'm willing! Plus, keep in mind there is still a large Access 97 community that would need to be included.

Since it's the end of my work day, you won't hear any more from me until tomorrow, but as I said, the idea sounds great! Gee, maybe we could even put a Microsoft-type price on the application and become kazillionaires!

What's the next step?????

 

[greaseman]

For what it's worth

I found a code sample on this forum that produces a Gantt-chart type report and have tied it to my "activity" table. Enclose you'll see a screen shot of it. It might be something we could use. Incidentally, as I said, I did find the code on this forum, but for the life of me can't remeber where! If it looks familiar to anyone, please let me know the thread, so that I can give the proper credit for it. The code is not mine and I don't want to upset the person who so generously offered it.

 

[A|ex]

Need to sort out contact information, i can offer web space to store the database so whenever we update it or have code we can share it to people within the group. I can also sort out a mailing list too so we can email between ourselves etc.

if the people who want to be involved in a project like this all email me their email addresses i will sort the rest out

 

[greaseman]

That sounds great! Not to mention very nice of you..... Should I PM you with my e-mail address?

 

[A|ex]

ive got web space free and bandwidth and i dont think we will be using bucket loads of bandwidth! the only problem is choosing a access format? atm i am using Access 2003 but save all access files in 2000 format just because the 97 > 2000 jump is a lot greater than 2000 > 2003.

yeah pm me ur address and i will sort out a mailinglist for us. Or we can just scrap the mailing list and just email back and forth and cc it to everyone else?

 

[greaseman]

And therein lies my headache! My outfit is using Acc 97, with no plans of moving upward! I'm still willing to participate and contribute. And I betcha there's a bunch of Acc 97 out there who would love something like this!

I'm going to PM you w/ my info ASAP.

 

[A|ex]

How are people creating Access 97 > 2000 databases? are they doing it in say Access 2000 and saving as Access 97? if so i can do that too

 

[greaseman]

Not really sure..... I would think that is what's done, but only having Acc 97.... there also might be a few compatability issues (i.e., ocx's, etc). Most likely would have to tackle those as they show up.

Meanwhile, I guess what could be done is if / when you make something in 2000, also save it in 97, and I could be the "dissector."

 

[A|ex]

did you get the email because i am going to write another?

 

[Pat Hartman]

One thing to be aware of is that the save as and older version doesn't do any converting. It just saves as the older file format. So, if you've used a function not available in A97, the function will not be recognized in A97.

One place where I know there is a problem is with the switchboard. An A2k generated switchboard will fail in A97. No big deal since you can just delete it and import one created by A97. Then if you work with that form as the basis, you'll be ok.