Calendar - Schedule Access 2007

[wevans]

Hello all.

I'm new to access and am trying to create a calendar/schedule in access. Yes I know there's a bunch of other ways and software to use, but I want to keep it together with the database I already have. I'm new to access and know very little about "coding" (vba) or anything else. Point and click I'm good at. LOL

Here's what I'm working with....

I have 5 days Mon-Fri.. Each day has 8 time slots. Each time slot has about 6 fileds, customer name, address, etc. I'd like to use the Calendar Control to be able to pick a date, and have it display ALL 8 time slots and the info they contain, on the same form, not just one entry at a time. This is so it's easier and quicker to read. Customer calls says come do work, I look up the date and can see I have a couple time slots open. I enter their info, save it and done. I also will create a report first thing the next morning for the day before. I should be able to do that once I get the initial table or tables set up.

Like I said I don'e know how to code, so please keep it simple if you can. Any help would be greatly appreciated.
Thank you,
Bill

[FishVal]

Hello, Bill.

• As I see you are a newbie in database designing, I would like to recommend yo to read the following articles:
  Database Normalization and Table structures
  Basic SQL Syntax for Access Queries
  SQL JOINs
• You are going to design not the most simple database. Without getting into interface programming I would like to give you some clues of the database structure.
  • Database contains two MoL independant parts
  • Part I - is for storing day appointments data. It may be easily implemented with the following tables:
    
    tblTimeSlots
    keyTimeSlotID Autonumber(Long), PK
    dteStart Date/Time
    dteEnd Date/Time
    
    tblAppointments
    keyAppointmentID Autonumber(Long), PK
    dteDate Date/Time
    keyTimeSlotID Long, FK(tblTimeSlots)
    .... your 6 fields related to a single appointment goes here
    
  • Part II - you'll need some mechanism giving you dataset containing sequential dates in some predefined range (advantageously it may give an opportunity to exclude holydays). Here I can suggest you a rather nice solution implemented in the attached database
  • Having at least these two parts working you may manipulate data in rather easy and flexible way thus implementing suitable interface

Let me know whether all this looks promissing for you.

Regards,
Fish

[truthlover]

Hi FishVal,

I'm needing to do the same thing. I'm fairly comfortable with Access (2003) but I dont know VBA.

Any chance you'd help walk me through what i need to do to create this Calendar View? (I did download the zip file).

I've been told this is high priority, so any help you could give me would be much appreciated!

Thanks in advance

Hello, Bill.

• As I see you are a newbie in database designing, I would like to recommend yo to read the following articles:
  Database Normalization and Table structures
  Basic SQL Syntax for Access Queries
  SQL JOINs
• You are going to design not the most simple database. Without getting into interface programming I would like to give you some clues of the database structure.
  • Database contains two MoL independant parts
  • Part I - is for storing day appointments data. It may be easily implemented with the following tables:
    
    tblTimeSlots
    keyTimeSlotID Autonumber(Long), PK
    dteStart Date/Time
    dteEnd Date/Time
    
    tblAppointments
    keyAppointmentID Autonumber(Long), PK
    dteDate Date/Time
    keyTimeSlotID Long, FK(tblTimeSlots)
    .... your 6 fields related to a single appointment goes here
  • Part II - you'll need some mechanism giving you dataset containing sequential dates in some predefined range (advantageously it may give an opportunity to exclude holydays). Here I can suggest you a rather nice solution implemented in the attached database
  • Having at least these two parts working you may manipulate data in rather easy and flexible way thus implementing suitable interface

Let me know whether all this looks promissing for you.

Regards,
Fish

[FishVal]

Maybe you want first take a look at
Ms Access Calendar
calendar in Access

Regards,
Fish.

[JOrsak]

Hello, Bill.

• As I see you are a newbie in database designing, I would like to recommend yo to read the following articles:
  Database Normalization and Table structures
  Basic SQL Syntax for Access Queries
  SQL JOINs
• You are going to design not the most simple database. Without getting into interface programming I would like to give you some clues of the database structure.
  • Database contains two MoL independant parts
  • Part I - is for storing day appointments data. It may be easily implemented with the following tables:
    
    tblTimeSlots
    keyTimeSlotID Autonumber(Long), PK
    dteStart Date/Time
    dteEnd Date/Time
    
    tblAppointments
    keyAppointmentID Autonumber(Long), PK
    dteDate Date/Time
    keyTimeSlotID Long, FK(tblTimeSlots)
    .... your 6 fields related to a single appointment goes here
    
  • Part II - you'll need some mechanism giving you dataset containing sequential dates in some predefined range (advantageously it may give an opportunity to exclude holydays). Here I can suggest you a rather nice solution implemented in the attached database
  • Having at least these two parts working you may manipulate data in rather easy and flexible way thus implementing suitable interface

Let me know whether all this looks promissing for you.

Regards,
Fish

Hey, this is a really cool little calendar.

What are the chances of getting some help with further development? I need to be able to click on the day and schedule a specific time slot. 10 Minute increments would be perfect. I'd also like to be able to pull from an employee list to assign that specific time slot to an employee for appointments.

Would that be possible?