Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Your site is a great idea. I should have joined your site years ago. Better late than never..."

Geography

Where in the world do Tek-Tips members come from?
bartus991 (Instructor)
14 Apr 12 9:22
For an event database in access if have created a static overview of the planned events. It looks like:

CODE

Auditorium    Event            Start Date    End Date
Milano        EventMilona      01DEC2012     05DEC2012
London        EventLondon      03DEC2012     06DEC2012

Per event I created a detailed programm:

CODE

Auditorium Event         Date      Time  Duration  Description
Milano     EventMilano   01DEC2012 13:00 90MINS    Lunch

I would like to create a graphical display like the outlook planner, or the image in the attechment.

Is this possible in MS Access and how?
And if it is possible. Can a event be changed by simply drag an drop?
MajP (TechnicalUser)
14 Apr 12 12:01
It can be done, but there is no native control to do this. I have done it several different ways, but all require extensive vba experience. Unless you are an advanced access programmer, I would look for a third party add in. However one thing, do not break up date and time.  It should always be a single field.
Ex: dtmStart  12/01/2012 1:00:00 PM

All "date" fields store a date and time component.  This field can be formatted into any date/time/date & time format. Do not store the duration. That is a calculated field. You could have a duration control on a form that sets the end date time.
MajP (TechnicalUser)
14 Apr 12 13:21
dhookom (Programmer)
14 Apr 12 14:06
As MajP suggests, building an interface (forms) like this is a complex task that is probably better off handled with a third party solution.

There are report sample at Hook'D on Access for week at a glance and similar display.

Duane
Hook'D on Access
MS Access MVP

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close