Solved

Calendar Control in Visual Basic

Posted on 2007-04-03
4
150 Views
Last Modified: 2010-04-30
Hello all, I am writing a program in visual basic 6 which is to be an appointment booking system for a salon. I want to use Calendar Control so the user can click on a date and all appointments for that date will be displayed in text boxes to the side of the calendar and then a button by each of these texts boxes will bring up a detailed description of the appointment. I have already created the databases and the layout but am finding it hard to find any  information on Calendar Control. Any help would be much appreciated...
0
Comment
Question by:Mrdogkick
  • 2
  • 2
4 Comments
 
LVL 67

Accepted Solution

by:
sirbounty earned 500 total points
ID: 18843401
What exactly are you looking for?
Sample code?

You'll want to use the DatePicker.Value for your query

strSQL="Select * From TableName Where ApptDate=#" & DatePicker.Value & "#;"

for example...

0
 

Author Comment

by:Mrdogkick
ID: 18843475
First of all I need to know how to assign an appointment from my 'appointment' table to a specific date on the calendar...
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 18843650
Not sure I follow that...
If you've saved appointments to your database - to retrieve them - you would initiate a database query using the appointment date (datepicker.value) as your parameter...
How are you saving to the database now?
0
 

Author Comment

by:Mrdogkick
ID: 18843841
I havent started the programming yet so have just entered a record straight into the table...The thing is there are multiple appointment slots for each day (half hour slots) and i want to be able to click on each slot to view the details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA error replacing data 6 40
using web browser with BING 40 122
Passing a Text Box name to a Sub 6 96
Copy a range from 1..n excel sheets to one destination sheet 2 35
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

832 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