Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Appointment book

Posted on 1998-05-26
16
Medium Priority
?
471 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 4

Accepted Solution

by:
zsi earned 400 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
 

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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

926 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