Solved

Appointment book

Posted on 1998-05-26
16
462 Views
Last Modified: 2008-02-01
Hi,

I am making an appointment book. Well, its almost done. But I am not sure how I can connect it to the calender. I need an appointmnet book for each day of the year. Also, how can I save the appointments.

Your answer will be much appreciated. I am new to experts-exchange. I am giving 100 points. If you think I need to give more points please let me know.

Thanks - Dooj
0
Comment
Question by:Dooj
  • 10
  • 5
16 Comments
 

Expert Comment

by:minaxi
ID: 1461701
Dooj,
   You can use calender control (mscal.ocx) to keep track of days of the year. To save the entries or appointment create & use database & tables with appropriate fields as, date,day,time,venue,person to meet etc. This can be done using RDO database connectivity or DAO database connection(jet engine availabale in VB).If you don't have MScal.ocx file download it from download.com or computers.com
Best of luck,
Minaxi
0
 

Author Comment

by:Dooj
ID: 1461702
Hi,

I have something called 'MSacal70.ocx'. Is this the same one u r talking about?

-Dooj
0
 

Author Comment

by:Dooj
ID: 1461703
I would like to know how I can save and retrieve appointments for each day in the calender. Can u give me an example ?

--Dooj
0
 
LVL 4

Accepted Solution

by:
zsi earned 100 total points
ID: 1461704
Dooj,

The absolute best tool that you can use for developing a calendar application is Sheridan's Calendar Widgets.  You can download a useable demo at http://www.shersoft.com

The control provides you with calendars, appointment book layouts, and time scheduling controls.  They can even be bound directly to a database.  The controls also come with a lot of sample source code.

I am sure this will be exactly what you are looking for.

zsi
0
 

Author Comment

by:Dooj
ID: 1461705
zsi,

The address you gave me is invalid. Can you give me someother site with examples? This is URGENT.

Thanks. -- Dooj
0
 

Author Comment

by:Dooj
ID: 1461706
zsi,

I tried again and it works. Guess I am just impatient. Will let you know how I went with the program.

--Dooj
0
 

Author Comment

by:Dooj
ID: 1461707
zsi,

I downloaded the controls. But I need to register to be able to use it in my program. I am doing this as my uni assignment. So I dont want to spend $140 on it just for my final assignment. I am still working on the project. Do you hava any working example? I will give you all the points I have.

I need it urgently. I need to submit it on Monday. Can you help me?

Thanks -- Dooj
0
 
LVL 4

Expert Comment

by:zsi
ID: 1461708
You should be able to use it in the development environment, just not at runtime.  Is this not enough?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Dooj
ID: 1461709
It pops up a box reminding me to register. So I cant use it for my assignment.

-- Dooj
0
 
LVL 4

Expert Comment

by:zsi
ID: 1461710
If this is a class assignment, why should that be a problem?  Or, are you expected to write the control yourself?

There are freeware calendar controls available.  In fact, the calendar control is one of the most common controls that people write as their first ActiveX/VB project.  You can emulate the appointment book by using a grid control.  I wouldn't worry too much about in-place editing on the appointment book (which the grid control does not support).  You can just plcae a textbox next to the book or have a popup dialog for the input.

Of course, you can try finding someone who has a registered copy of the controls and see if they will compile it for you.

If you decide to follow my first suggestion about writing it yourself, I can help you out with some of the logic.

zsi
0
 

Author Comment

by:Dooj
ID: 1461711
Hi,
Thanks. I am almost done. I need to print few things like the phone list and appointments. I  need to print what I am viewing. Say for eg. a person's contact details that I am viewing.

Thanks.

- Dooj
0
 

Author Comment

by:Dooj
ID: 1461712
zsi,

This is what I have used.:

CrystalReport1.ReportFileName = "ph.rpt"
CrystalReport1.SelectionFormula = "{Sname} = '" & Sname.Text & "'"
CrystalReport1.Action = 0

And I also tried CrystalReport1.SelectionFormula = "SELECT * from Phone where Phone.Sname = '" & Sname.Text & "'"


But it gives an error (err # 20515; it says error in formula).

What should I do now?

Thanks -- Dooj
0
 
LVL 4

Expert Comment

by:zsi
ID: 1461713
dooj,

Crystal Reports is really not my forte.  You should grade this question to close it, and then open a new question regarding Crystal Reports.

zsi
0
 

Author Comment

by:Dooj
ID: 1461714
zsi,

I fixed the error. Just one small favour. If I email you my project , can you go through my code and tell me where I need to improve? If you cant do it, its ok. Just let me know.

Thanks -- Dooj
0
 
LVL 4

Expert Comment

by:zsi
ID: 1461715
Normally, I would.  Unfortunately, I have two projects whose deadlines are this Friday and Saturday.  I have a third that is due at the end of this month.  I would hate to offer to check your code and then not be able to do it due to time constraints.

zsi
0
 

Author Comment

by:Dooj
ID: 1461716
That's alright. Can you do it after you finish your projects? I have submitted my project. Just for my referece I'd like to know what I have done wrong.

Thanks for your help anyway. Just let me know if I can email it to u later on and if I can, your email address.

--Dooj
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now