Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-30-2012, 03:15 AM   #1
shutzy
Newly Registered User
 
Join Date: Sep 2011
Location: Wesham, Lancashire, UK
Posts: 775
Thanks: 105
Thanked 4 Times in 4 Posts
shutzy is on a distinguished road
create a colourful clickable schedule

i am looking for some major help. i have posted this problem before but i am wanting to come back to it from a different angle. i have a diary on a form at the minute. this displays a clients name, time and expected finish time. this is all done by a list box via queries. the only snag is that i dont seem to be able to differ from employees. ie have a clumn for joe and 1 for john. i am looking for suggestions that i can explore to be able to achieve this. my must haves for this are

i want a time column(15 min increments)
employee column(dont mind if this has to be manually added for each employee as they leave the business or start)
within the employee column i would like to display the appointment. have the total time for the appointment 'coloured in'(lets have grey) in the grey colour i would like the clients name and what treatments they are in for.

i have been told that a 'listview' might manage this but i seem to hit a wall when finding out info about this. vba told me that it is all about programming and to be hones i dont really know much about programming. im not trying to do this without having to work for it but i kind of need a leg up to get me started. if anyone does have any suggestions how i can achieve this then please just reply.

thanks in advance.

shutzy is offline   Reply With Quote
Old 04-02-2012, 12:39 AM   #2
Trevor G
Newly Registered User
 
Trevor G's Avatar
 
Join Date: Oct 2009
Location: Tamworth, Staffordshire
Posts: 2,331
Thanks: 4
Thanked 229 Times in 219 Posts
Trevor G will become famous soon enough Trevor G will become famous soon enough
Re: create a colourful clickable schedule

Have you looked at the sample database section in the forum, there are a few calendar type database which people have very kindly uploaded as examples for this type of thing, also you could look at the website for Helen Feddema who rights for woodys watch.

http://www.helenfeddema.com/index.htm
__________________
Trevor
I am on a learning curve of life, I know a little but like to share what I have learnt with others.
I am using Microsoft Office 2003 To 2016
Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.
Trevor G is offline   Reply With Quote
Old 04-02-2012, 03:29 AM   #3
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,043
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: create a colourful clickable schedule

You can have a look at the full schedule I made Free to use - Schedule/TimeTable form
I uploaded a new version of it, that should be there any day now

smig is offline   Reply With Quote
Old 04-02-2012, 09:31 AM   #4
shutzy
Newly Registered User
 
Join Date: Sep 2011
Location: Wesham, Lancashire, UK
Posts: 775
Thanks: 105
Thanked 4 Times in 4 Posts
shutzy is on a distinguished road
Re: create a colourful clickable schedule

hi smig, thanks for the sample. it is what i am looking for. columns for different employees and a column for times. the only thing is that i get all the parameter questions that the other posts where wanting. also i am on access 2010.

can you offer any help on creating what you have done for earlier versions on 2010.

thanks for the sample
shutzy is offline   Reply With Quote
Old 04-02-2012, 10:12 AM   #5
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,043
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: create a colourful clickable schedule

The new version is there, please test it
I tested it under access 2010 and it worked
smig is offline   Reply With Quote
Old 04-02-2012, 10:43 AM   #6
shutzy
Newly Registered User
 
Join Date: Sep 2011
Location: Wesham, Lancashire, UK
Posts: 775
Thanks: 105
Thanked 4 Times in 4 Posts
shutzy is on a distinguished road
Re: create a colourful clickable schedule

cheers smig. ive got an error when opening everything apart from datepicker and month schedule. it says

the expression on open you entered as the event property setting produced the following error: a problem occured while schedule was communicating with the ole server or active x control.
shutzy is offline   Reply With Quote
Old 04-02-2012, 11:07 AM   #7
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 2,043
Thanks: 82
Thanked 134 Times in 125 Posts
smig is on a distinguished road
Re: create a colourful clickable schedule

Quote:
Originally Posted by shutzy View Post
cheers smig. ive got an error when opening everything apart from datepicker and month schedule. it says

the expression on open you entered as the event property setting produced the following error: a problem occured while schedule was communicating with the ole server or active x control.
Is it when you open the db and the AutoExec macro run or when you try to open a form ?
the WeekSchedule is the main form should be opened.
Do you have any missing refernce ?

smig is offline   Reply With Quote
Old 04-03-2012, 12:52 AM   #8
shutzy
Newly Registered User
 
Join Date: Sep 2011
Location: Wesham, Lancashire, UK
Posts: 775
Thanks: 105
Thanked 4 Times in 4 Posts
shutzy is on a distinguished road
Re: create a colourful clickable schedule

it is when i try to select a date on the weekschedule form and if i dbl click any form from the nav bar.

i dont really know anything about ole server or active x controls yet so i dont really know how to solve it.

shutzy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query to create an organized start schedule Wizxon Queries 5 05-20-2011 11:15 AM
Question How can I create a schedule viewing window? zebra General 2 04-24-2009 05:31 AM
Create Search list and make it "clickable" mafhobb Forms 15 03-27-2008 08:43 AM
[SOLVED] Using forms to create a schedule and payroll summaries dutrojr Forms 2 01-26-2008 01:32 PM
[SOLVED] Using Access to create a perpetual schedule Chad Grimes General 2 08-11-2005 09:28 AM




All times are GMT -8. The time now is 01:04 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World