Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

Forums     

Microsoft Access Forum
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
This forum is for the discussion of Microsoft Access.

Access is my personal specialty. Have questions? Comments? Want to discuss how to do something? Post it here. Also, I get a LOT of questions sent to me in Email from people around the world. I'll post the interesting ones in here. Feel free to comment on them.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Permanent Link
Keywords: microsoft access forum
Post New Topic

Read Calendar by Masih O @ 11/27/2017
Hi!
I want to make a report with only seven list boxes to display 7 days of the week. Do I have to change the codes or is it enough to make a weekly form first and then a report from that? Do you have any addendum to the weekly calendar?

Regards
Masih Ostad


Reply from Alex Hedley:

Just add 7 boxes instead of the full month, just get the data for the week you need.
Show Just This Thread        Post Reply
Read Setting up Course Calendar Schedules by Dottie @ 10/2/2017
Thank you so much!  I think this seminar is just what I'm looking for.  After I finish a project I'm currently working on at work, I plan to purchase this and build this database.

Thanks again.
Show Just This Thread        Post Reply
Read Setting up Course Calendar Schedules by Dottie Arnold @ 9/25/2017
I want to create schedules that I'm now doing in Excel in Access.  I have one tab in Excel that has all the exception dates, including holidays. I'm thinking I should create one table the same.  The other needs to be the course name and # of days the course runs.  I want to have the database populate a end date using the number of days and skipping over the exception dates.  How do I write that with code?


Reply from Alex Hedley:

You could use something similar from the Access DateTime Seminar
- Create a Holiday Exclusion Table for Work Day Results
Show Just This Thread        Post Reply
Read Google Calendar Integration by Eddie P @ 1/4/2017
Anyone done anything with API's for google calendar?


Reply from Alex Hedley:

You'd need an API key from Google first.
What are you wanting to do?
Show Just This Thread        Post Reply
Read Weekly or daily calendar by Henry P @ 10/31/2016
How do I divide in hours or half hours, link the daily with a weekly or monthly calendars, so that I would see the appointments.
How do I make it so it does not allow user to overlap appointments.n


Reply from Alex Hedley:

The Query used to fill the Listbox determines what records show, if you set the query to group by a given time you could then show the rows you want.

The Work Order Seminar shows how to Schedule appointments, you can use a DLOOKUP to check if a DateTime already exists.
Show Just This Thread        Post Reply
Read Weekly or daily calendar by Henry P @ 10/31/2016
What I want to know is if I pay for the Calendar Template, will these items I mention be included there: Daily calendar, Weekly calendar, setting appointments and have the code make sure the time slot is already booked, repeating tasks, etc... all the typical features of a calendar.


Reply from Alex Hedley:

There is a free demo download of the calendar so you can, scroll down to the bottom of the page to find the links. You can then try it out.

The Calendar Seminar doesn't cover Daily/Weekly, only Monthly, but it wouldn't be hard to apply the knowledge and previous suggestions to add your own.

The Work Order Seminar covers Scheduling. This covers checking a Table for current appointments and showing when the next available one is.

I've made a tip for Multiple Days, this could be amended to do every x day.
Show Just This Thread        Post Reply
Read Weekly or daily calendar by Henry P @ 10/29/2016
Thanks, how do I create a daily calendar


Reply from Alex Hedley:

Depends how you want to display the data but just create a DailyF and get the Data based on the Date picker from the original Form.
You could just show 1 listbox and still have the forward/back buttons.
Show Just This Thread        Post Reply
Read Weekly or daily calendar by Henry P @ 10/28/2016
You mention that it is quite easy to just convert to a weekly, or daily calendar, I did not find it that easy, can you explain further?
Also, how can I add a more user friendly and realistic control for the calendar, usually you would have arrows to allow user to browse the following or previous period, you usually don't need to input the date in a date picker, also would like to see if I can add alarms, if I can add different calendars erg: calls to make, to dos, appointments set, must do today's. and then create lists of the items in each calendar where I would be able to address all items in sequence until done with the day or period.


Reply from Alex Hedley:

I've added the links to the Addendums in the previous post.
The Template would be a good one to use.

The Advanced Date Seminar covers setting up alerts based on a DateTime you could combine the two.

You could extend the Event to have another Field which is a Type and show a Symbol next to the event or maybe some sort of colour difference.
Show Just This Thread        Post Reply
Read Weekly or daily calendar by Henry P @ 10/27/2016
After completing your calendar seminar, you mentioned that it would be simple to create a weekly, yearly or daily calendar, but did not ever address thr HOW TO,
Can you expand?


Reply from Alex Hedley:

You have the principles for showing a month, just use those calcs for a week or year.
Daily just have it open the date you picked then you could have the plus/minus buttons to move between.

Have you watched the Addendums?
Calendar Seminar Addendum
Calendar Seminar Addendum 2
Calendar Seminar Addendum 3
Template
Show Just This Thread        Post Reply
Read Calendar Seminar by Henry P @ 10/22/2016
USING the Microsoft Date and Time Picker control 6.0 (SP4), I don't think dateserial recognizes this control for the purpose of calculating the first sunday of the monthly calendar like the one in the calendar seminar


Reply from Alex Hedley:

Which version of Access are you using?
Why not just a Textbox set to a Date.
Show Just This Thread        Post Reply
Read Calendar Seminar by Henry @ 10/22/2016
I have now selected an ActiveX with a calendar.
When I get to the part in the seminar where I input the code to calculate StartDate:

Private Sub CalculateStartDate()
  StartDate=DateSerial(Year(Calendar),Month(Calendar),1)
End Sub

Private Sub Command20_Click()
  Calculate StartDate
  DoCmd.OpenForm "MonthlyCalendarF"
End Sub

Private Sub Open Calendar B_Click()
End Sub

No Monthly calendar opens.
It was opening same as the seminar, up to this point.
Could you let me know what am I doing wrong?


Reply from Alex Hedley:

Are you using an old version of Access?

Does Command20 link to a button on your Form?
If you click Command20 on your Form in Design View and go to the Events tab is the event connected.
Show Just This Thread        Post Reply
Read Calendar Seminar by Henry P @ 10/11/2016
I purchased the Access calendar seminar, and it mentions that I should get the calendar ActiveX, which is non existent in Access 2010.
Can you please give me a substitute way?


Reply from Alex Hedley:

There's a list of Addendums on the Course page that mention the updates.
Just use a Textbox, it comes with a DatePicker now.
Show Just This Thread        Post Reply
Read Can I create a calendar by Henry P @ 10/8/2016
Can I create a form that resembles a calendar (month, week, day) and show the activities that have been scheduled and the free time?


Reply from Alex Hedley:

There's a Calendar Seminar that covers exactly this.
Show Just This Thread        Post Reply
Read Calendar seminar by Brauna R @ 2/8/2016
Hi,
I have been able to create a very usable calendar in English and now I want to create a version using French labels. It is 99% done but I haven't figured out how to change the months in the MonthlyCalendar report.  Can you help?  Thanks.
Brauna


Reply from Alex Hedley:

Do you have your machine localised in French?

The Month has the following
Format(DATE ,"mmmm yyyy")

You could also use
MonthName ( number, [abbreviate] )
Show Just This Thread        Post Reply
Read access calendar control by Joe @ 1/22/2016
what replaced the active X calendar control for Access 2010 and higher? Where can I get what ever replaced it?


Reply from Alex Hedley:

See this blog article?
Show Just This Thread        Post Reply
Read Missing Calendar Control by John B @ 1/11/2016
I downloaded Access 222.  How do I get the file to work with Access 2016? I keep getting the error message MXCAL.OCX version 7 missing


Reply from Alex Hedley:

See the Addendum Tip for the Access Imaging Seminar
Show Just This Thread        Post Reply
Read ActiveX Calendar by Danny B @ 12/4/2015
I am using Access 2010 and it does not contain the Calendar used in Calendar Seminar video 6 but now contains a pop up type of calendar.  What calendar can I refer to so the days will correctly correspond to the date as in video 6.

Thanks Danny B


Reply from Alex Hedley:

Did you read the Student Interactions? There are a few Addendums you can watch.
Show Just This Thread        Post Reply
Read Calendar Code Not working by Danny B @ 12/4/2015
Yes, it is checked but after a lot of thought and change request we will not be needing the check box.

I will come back to it at a later date to see why it is not working (probably something I've enter incorrectly).

Thank you for your reply
Danny B
Show Just This Thread        Post Reply
Read Calendar by Danny B @ 11/30/2015
I did not copy the entire line from the form, my fault.  The entire line from the row source is shown below.

SELECT CalendarID, apptTime, Description FROM CalendarQ WHERE dateTime >= Forms ! DatePicker ! StartDate AND dateTime < Forms ! DatePicker ! StartDate + 1 ORDER BY apptTime;


Reply from Alex Hedley:

You don't need the spaces between the !
Show Just This Thread        Post Reply
Read Calendar Code Not working by Danny B @ 11/30/2015
Sorry for the slow reply, I've been on vacation

Yes it is checked.


Reply from Alex Hedley:

If you add a msgbox in the else clause does it get called?
Show Just This Thread        Post Reply
Read Calendar Code Not working by Danny B @ 11/20/2015
The code works partially; my checkbox triple state is set to true.  

My listbox will show the True items, False Item but then goes to False items when it should be all.

I am using 2010 if that matters

If ShowClosedItems = True Then
        ApptListBox.RowSource = "SELECT CalendarID, DateTime, Description, Close_Item FROM T_MyCalendar WHERE Close_item = True ORDER BY DateTime;"
    ElseIf showcloseitems = False Then
        ApptListBox.RowSource = "SELECT CalendarID, DateTime, Description, Close_Item FROM T_MyCalendar WHERE Close_item = False ORDER BY DateTime;"
    Else
        ApptListBox.RowSource = "SELECT CalendarID, DateTime, Description, Close_Item FROM T_MyCalendar ORDER BY DateTime;"
    
    End If


Reply from Alex Hedley:

Is the Checkbox set to allow three states?
Show Just This Thread        Post Reply
Read Calendar by Danny B @ 11/19/2015
I'm using the Calendar Seminar lessons to learn how design and use a calendar in my db but I've run into a problem.  The code below works to find only zero hour entries and it finds them

SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime=Forms!F_DatePicker!StartDate ORDER BY Q_DateTime.ApptTime;

but when I adjust the code to below it does't show any records at all.

SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime>=Forms!F_DatePicker!StartDate AND DateTime
I am using 2010 if that matters


Reply from Alex Hedley:

You need to compare it with something:

SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime>=Forms!F_DatePicker!StartDate AND DateTime

SELECT * FROM x WHERE DateTime >= y AND DateTime < z

If you replaced yours with sample values you'd have
SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime>=#1/1/15# AND DateTime
=>
SELECT * FROM x WHERE DateTime >= #1/1/15# AND DateTime < #1/1/16#
Show Just This Thread        Post Reply
Read Access 2010 and the Calendar Training by Joe-Paul R @ 10/1/2014
Hello...
First..your samples won't open for Access 2010...is there anything newer?  And when I follow the course..it gets to setting up different days on the form... in the listbox rowsource, it says to use DateTime >= Forms!DatePickerF!StartDate ... this is does....but then when I added " < Forms!DatePickerF!StartDate + 1 the query won't run...it says that it is too complicated or has a misspelling in it...Not!...:0)...So I did a  "DateAdd("d",1,Forms!DatePickerF!startdate) and it works... then tried to build the date boxes with =Forms!DatePickerF!StartDate and the first box was ok, but when I did that "+ 1", I get an error in the box "#Type!" ??  Tried that "DateAdd ... function again...and that does not work...any help?  Thanks


Reply from Alexander Hedley:

Hi Joe,
What error are you getting when you try and open the Sample File?
Are you getting the 'missing or broken reference to the file 'MSCAL.OCX' version 7.0'?
Show Just This Thread        Post Reply
Read Outlook Calendar by Selby H @ 4/17/2014
Dear Richard,
I am trying to add data from a Access Table to the Outlook Calendar. I can download the data to the Default Outlook Calendar, it works great, but want to download to another specific Calendar I have created, how do I find the path to the folder.
Just trying to find the path to an outlook folder and use a Recordset to copy data to a outlook Calendar that has been created.
Thanks.
Kindest Regards
Selby Halfpenny
Show Just This Thread        Post Reply
Read Access Calendar by Susan P @ 4/2/2014
I'm going thru the lesson but cannot get it to find the first day of the month. Here is my code:

Option Compare Database
Option Explicit

Private Sub CalculateStartDate()

    'set the first day of the current month
    StartDate = DateSerial(Year(Calendar), Month(Calendar), 1)

    
   'find the first SUNDAY
    While Weekday(StartDate) <> 1
        StartDate = StartDate - 1
    Wend
  
    
End Sub

Private Sub Command2_Click()
     DoCmd.OpenForm "MonthlyCalendarF"
End Sub

Nothing seems to be happening. I'm using Access 2007.


Reply from Richard Rost:

Your code looks fine. Throw a MsgBox in the loop there so you can see what it's doing.

While Weekday(StartDate) <> 1
StartDate = StartDate - 1
MsgBox StartDate
Wend

Show Just This Thread        Post Reply
Read Calendar Date Picker refresh by Joseph M @ 1/7/2014
I just completed chapter 7 of my calendar seminar and I am working with my calendar. When I enter a date for the first time in my date picker I get the expected results. If I change the date in the date picker and reopen the calendar I'm back to the previous entry. If I click on the refresh button I get the new result. How can I auto refresh this form?
Show Just This Thread        Post Reply
Read Export Query to Outlook Calendar by Jeff @ 7/15/2013
I have a database currently running that has a reminder pop up to inform a user to prepare a check for their client.  Is their a way to export a query and have it load the outlook calendar with all the pertinent data?


Reply from Richard Rost:

You can control Outlook from Access (create appointments, etc.) but it requires VBA. I'll be covering this in a future seminar.
Show Just This Thread        Post Reply
Read Calendar Choosing a WeekEnding Date by BEN C @ 4/16/2013
Hahaha! you made my day! no wonder I cannot find it, this is really cool stuff.

thank you


Reply from Richard Rost:

You're very welcome.
Show Just This Thread        Post Reply
Read Calendar Choosing a WeekEnding Date by BEN C @ 4/15/2013
exactly! it is the combo box for a user to pick a saturday date is what i need. lol. Can you tell me which lesson in AC2003? or AC2010?  I know you covered covered the loop somewhere in AC2003.


Reply from Richard Rost:

I haven't covered this in any single class, but it's a combination of stuff I've showed in a bunch of different classes. Manipulating a ListBox with AddItem, dates, the WEEKDAY function, etc.

Since you're a good, long-time customer, I'll walk you through it. Create a LISTBOX called MyList. Make it an "I will type in the values that I want" type of listbox (not bound to a table). Now make a command button. In the command button code, put:

    ' Clear the listbox if it has anything in it
    While MyList.ListCount > 0
        MyList.RemoveItem (0)
    Wend
    
    ' get the next year's worth of Saturdays
    For X = 1 To 365
        D = Date + X ' today's date + X
        If Weekday(D) = 7 Then ' 7 = Saturday
            MyList.AddItem D
        End If
    Next X

That should do it. Now click on the button to load up the next year's worth of Saturdays in your box. If you want this to happen automatically, then you could also run this code in the OnLoad event for your form.

Hope this helps.

Show Just This Thread        Post Reply
Read Calendar Choosing a WeekEnding Date by BEN C @ 4/15/2013
Hi Richard,
i know if creating a field for Date&Time in 2007 or 2010, it will give you a calendar for user to pick a a Saturday weekending.  How in access 2003?, way I can have user to pick only Saturdays for the year, do you have to create a table for it? Or is there a command for a lookup?


Reply from Richard Rost:

I'm not quite sure I understand what you're trying to do. Do you want a popup calendar for Access 2003 so the user can pick a date? If so, you need to use the MS Calendar Control. I cover that in my Calendar seminar. If you just want a list of Saturdays, however, you could fill a combo box or list box with a little bit of VBA code. Just make a loop and if the WEEKDAY of the date is Saturday then .AddItem it to your list box.
Show Just This Thread        Post Reply
Read Multi Day Event in Calendar by Charles H @ 12/7/2012
In the Calendar Seminar, I have added a Start Date and an End Date in my Table. How can you get the information to populate in the calendar according to the dates. I am trying to set it up as a Leave Calendar and do not want to type in each date individually. Example John is taking off from say 12/26/12 to 1/2/13. If input the startdate as 12/16/12 and the End Date as 1/2/13 I want this to automatically populate in the calendar. I am sure there is a code to do this, I just do not know how to do it.


Reply from Richard Rost:

Charles, your question finally got me off my behind to post this Calendar Seminar Addendum that Alex sent in to me a few months ago.
Show Just This Thread        Post Reply
Read Calendar Seminar Part 2 by Deon R @ 9/24/2012
Hi Richard, I'm very interested in a second seminar.  The popups, recurring, and such that you mentioned would be great.

Best regards,

Deon
Show Just This Thread        Post Reply
Read Calendar Seminar by Mary F @ 9/23/2012
Hi Richard, I completed the Calendar Seminar and want to use it in my workorder database can I do this or do I have to create forms tables etc. in the workorder database?


Reply from Richard Rost:

I don't see any reason why you couldn't copy the required objects over from one database to another. I haven't tried it, but it should work.
Show Just This Thread        Post Reply
Read Another Calendar seminar question by Alex Hedley @ 9/6/2012
Hi Don,

I trick used by Rich in another lesson (can't remember which one, might even be this one) is to close the form then reopen it, then it will re-run all the code for that form and show the new record you added.
Show Just This Thread        Post Reply
Read Another Calendar seminar question by Donald W @ 9/5/2012
Richard,
Your seminar had us enter vba so that when the MonthlyCalendarF! listbox (Day1, Day2,etc) was doubleclicked, the CalendarF opened to the appt in question so we could view all aspects of the appt, or edit it.

To take it a step further, I wanted to be able to dbl-click something, say Date1, and have CalendarF open to a new record, autopopulate the DateTime field and set focus on the Description field so I could add a new appt on the fly.

It works great!  But, I don't see the appt when it closes. I don't know how/where to requery the form.  Every rowsource is different.  Can you point me in the right direction?  I've tried requery in numerous places but it simply doesn't work.

I'm sure I'm overlooking something simple.  Your help would be appreciated.  Thanks,
Don
Show Just This Thread        Post Reply
Read Calendar seminar question by Don Wright @ 9/3/2012
Thanks, worked great.
Don
Show Just This Thread        Post Reply
Read Calendar seminar question by Donald W @ 9/3/2012
Richard,
Just finished the recently purchased Calendar Seminar.  I built mine in Access 2010, vs you doing it in 2007.  I don't know if this has a bearing on my question.

I noticed that in the CalendarT you would sometimes just enter a date (9/7/2012), sometimes a date/time (9/8/2012 8am). When you opened the calendar, your plain dates would show as 9/7/12 0000 and it would show on the correct date.
When I enter just a date, the date in question shows up on the date I typed AND on the previous date.  So 9/7/2012 would show as 9/7/2012 0000 ON 9/7, and it would also show up on 9/6!

Since I am using this for personal use, many times I don't need a time.  So I want to just pick a date and keep on trucking.  I don't want to have to enter a fictitous time.  But, I want to maintain the time functionality when I do have a specific need, like "DR X @ 2:15".
Can you think of something I've done wrong, or is this a 2010 quirk?

Thanks,
Don


Reply from Richard Rost:

Make sure you are displaying dates that are GREATER THAN OR EQUAL TO StartDate and LESS THAN (but NOT equal to) the EndDate. Like:

>=StartDate AND
If you used ">=S AND <=E" that would cause those midnight dates to show up on both calendars.
Show Just This Thread        Post Reply
Read Calendar control issues by Don Wright @ 8/23/2012
Thanks very much, Alex.

I don't have it in front of me now, but your notation is different from mine.  I'm sure I've screwed it up!!
Thanks for the help.
Don
Show Just This Thread        Post Reply
Read Calendar control issues by Alex Hedley @ 8/23/2012
Don have you seen this tip?

http://www.599cd.com/tips/access/forms-formname-field-notation/

It's probably something to do with the subform notation:

=Forms!ParentForm!SubForm.Form!FieldName

Al
Show Just This Thread        Post Reply
Read Calendar control issues by Don Wright @ 8/22/2012
Hello,
I've been working in Access 2000.  I have a form (unbound) with a tab control on it.  On Tab1 I have a calendar control.  I placed some vba in the form's On Load event to have the CalControl open to taday's date:  Me.CalControl.Value=Date.  Works OK so far.
I created a form (to use as a subform)(AppointF) that is bound to a query.  The query pulls from the ContactsT the name, appointment date, appoint time, and a note field.  In the AppontDate field I have a where that says Forms!MainFormF! so it opens to the appointment, if any, on that date.

When I open MainFormF, then AppointF it works great.  But when I place AppointF in MainformF on Tab1 as a subform, it won't work.
I'm truly frustrated and would appreciate any help.
Thanks,
Don
Show Just This Thread        Post Reply
Read Calendar Problem by Verna Candava @ 7/13/2012
Dear Richard,
I completed my calendar but I'm having a problem. I made an appointment like June 3 but when i view the calendar it appears at the calendar form on June 2.
can you help me correcting it.
Thanks
verna


Reply from Richard Rost:

Verna, without seeing your database it's very hard to fix a problem like this remotely. Check your field names and make sure you have the right boxes where you expect them. Check your date ranges.
Show Just This Thread        Post Reply
Read Calendar Event by Verna C @ 7/7/2012
Hello richard,
Re the double click event on the calendar if Day1 is Null i want to open the calendarF but it should open as new so that i can enter an appointment. can you help me how to put the code



Reply from Richard Rost:

So something like this:

If IsNull(WhateverField) Then
  Docmd.Openform "CalendarF"
  Docmd.GotoRecord ,, acNewRec
Else
  ' open the form normally
End If

I think that's the right syntax for the parameters for GotoRecord (it's off the top of my head... but that's basically what you want).

Show Just This Thread        Post Reply
Read MS Access Calendar by Raju Pulidindi @ 11/10/2011
Hello Richard,

I have created an application with MS Access calendar function. The calendar works fine on my 'C' drive where MS OFFICE sofware resides. When I take it to the network drive, the calendar is not popping up. What could be the source of the problem ?
Thanks, Raju


Reply from Richard Rost:

What version of Access? Does it not work on YOUR computer, or just other computers? My thought is that other computers don't have a reference to MSCAL.OCX.
Show Just This Thread        Post Reply
Read Calendar Seminar by Mike B @ 11/6/2011
ny idea why?
Show Just This Thread        Post Reply
Read Calendar Seminar by mike @ 11/6/2011
Thanks Alex.  The addenum has the info. that I need.
Show Just This Thread        Post Reply
Read Calendar Seminar by Alex Hedley @ 11/5/2011
Hi Mike
Have you seen the Calendar Addendum 2, this allows you to got back and forward 1 month or 1 year.
Al
Show Just This Thread        Post Reply
Read Calendar Seminar by mike @ 11/5/2011
Once the first calendar is built has anyone learned how to add a control button to the calendar to advance, or go backwards, the month by each click of the button and the year at the next January .  Additionally is there a way to wrap text in the calendar boxes? My attempts have been unsuccessful so far.
Show Just This Thread        Post Reply
Read Calendar Seminar by Lindray @ 10/29/2011
thank you very much alex, I followed your tip and it worked perfectly
Show Just This Thread        Post Reply
Read Access Active X Calendar by Alex Hedley @ 10/27/2011
Hi Robert,

Which version of Access are you using?

Have you been working through the Calendar Seminar?

Check out the Addendum Rich posted if you are using Access 2010 as Microsoft did not ship the Calendar Control in the latest version which could be why you are having problems.

Alex
Show Just This Thread        Post Reply
Read Access Active X Calendar by Robert @ 10/27/2011
The Active X Calendar is not linking to the StartDate Text Box. How can I do this?
Show Just This Thread        Post Reply
Read calendar seminar by Alex Hedley @ 10/26/2011
Add an extra field saying closed/cancelled then base the query of appointments on only ones that aren't closed or cancelled.
So add a WHERE clause saying WHERE closed = NO now when you change it, it shouldn't be shown
Al
Show Just This Thread        Post Reply
Read calendar seminar by Lindray @ 10/26/2011
what can I do so once an appoinment is canceled or closed does not appear in the calendar, so far all appear even after closing.
Show Just This Thread        Post Reply
Read Calendar Control Addendum 2 by Alan Hill @ 9/22/2011
Hi Everyone
I added all those + month buttons to my calendar form when I created it. I also ran code on startup to add recurring dates. So why would I want to watch the video. There is always something new to learn when Richard does a video. Thanks for the stop flashing form tip and the form scroll tip
Best wishes
Alan Hill
Show Just This Thread        Post Reply
Read Calendars by Kathy Warner @ 8/11/2011
Hi, I recently completed you calendars seminar.  It was great.  I used Access 2000 to create a database now I am moving to 2007.  When I open the calendar not allof the items are displayed and when I double click the listed item I get a run-time error '3048' Cannot open any more databases. Do you have any suggestions where I can look?  Thanks for your time and consideration.
Show Just This Thread        Post Reply
Read Calendars by Robert Prideaux @ 8/2/2011
Don't know about Google (shudder) - you know Google; "we do no evil, but we will sell you out to opressive regimes - and read your mail" :)

Scenario: I have a cklient who is a hair dresser. Appt's are in pencil... in a tatter diary.
Has to stop to take calls; (and appt's.)
Client gets peeved because they get an answering machine then you ring them back and the time they wanted has been taken... etc.
For me, I would like to be able to have a service call (am a little MSP these days)booking calendar; without me being in office (AKA not earning...)
all on a simple web page with the Access DB driving it?
Figured it would be a doddle for you (coz you are smart - grovel , grovel) and would make it nice little seminar?


Reply from Richard Rost:

You know what would be even better... something like this where you can just load up a web page to put appointments in... but also where established clients can set up their OWN appointments! You (the hair dresser) can specify what hours are "open" and clients can sign in and reserve a block of time (hour, half-hour, whatever). Great idea for a seminar. Should I add it to the list?
Show Just This Thread        Post Reply
Read Calendars by Robert Prideaux @ 8/2/2011
Richard,
How hard would it be to enhance the Calendar Seminar, to an online, interactive appointment calendar?
Got to have a huge scope; basically anyone who takes clients by appointment? Plus elimainate all those interupting calls; which all take time - or missed business because you are busy and cannot answer...


Reply from Richard Rost:

I've thought about this. Do you mean something along the lines of Google Calendar?
Show Just This Thread        Post Reply
Read Calendar Seminar Part 2 by Selby @ 4/27/2011
Very interested Richard for you to complete Calendar Seminar 2.

Selby
Show Just This Thread        Post Reply
Read Calendar Seminar Part 2 by Alex Hedley @ 4/26/2011
Hi Rick
I think a lot of additions have already been mentioned in the Seminar blog post and seminar lesson interactions but to re-iterate adding more functionality to the basic calendar would be fantastic
• recurring events [copy the payables seminar?]
• reminders on the main form for upcoming/today's events
• not sure different colours could work without a plugin although add an extra label/drawing tool around a list box
Added complexity:-
• Event types - Birthday, Bill ... (add a symbol)
• import calendars from Facebook etc
(you can import the ics file from Facebook into Outlook/Windows calendar, can this be parses into Access, I guess it's just data like everything else)
• other calendar events from google mail etc
• I think sharing has been mentioned below
• holidays for staff etc (dependant on calendar use)
• public holidays / Easter, Christmas, Bank Holidays
• multiple users, then filter by in form view/report view

[Is there still Interest in the Tracking Attendance seminar as there were ideas linking to that which would be useful?]

Hope you had a fun Easter :)

Kind Regards
Alex
Show Just This Thread        Post Reply
Read Calendar Seminar Part 2 by Donald Wright @ 4/26/2011
Yes, I'm interested.  The popups, recurring, and such that you mentioned would be great.
Show Just This Thread        Post Reply
Read Calendar Seminar Part 2 by jimmy @ 4/26/2011
i will like if you will cover also how to send a event item to outlook (or to gmail if is not very complicated) or to send email to friends about this event..
Show Just This Thread        Post Reply
Read Calendar Seminar Part 2 by Angela @ 4/26/2011
Most definitely! I took the seminar and would definitely be interested in a follow-up with more features.
Show Just This Thread        Post Reply
Read Calendar Seminar Part 2 by Richard @ 4/25/2011
One of my good students, Jimmy, asked if I was planning to create a followup for my Calendar Seminar. He says that the current seminar is great, but he'd like to see extra features added like popup reminders, appointment categories, recurring events, and so on.

Of course, the point of the original seminar was just to show you how to format a form and a report to LOOK like a monthly calendar, but he does raise a good point.

So, is anyone else interested in a followup to the Calendar Seminar to add all of these extra bells and whistles? If so, what features would YOU like to see added?
Show Just This Thread        Post Reply
Read Setting Date of Calendar Control by Mike Lesson @ 11/16/2010
DatePickerF


Reply from Richard Rost:

The problem is that there are no EVENTS tied to just selected a year or month. You HAVE to pick a DAY for that calendar to get a value and fire an event. The only other solution I could see would be to build your own combo boxes with the months and years in it, and then use the code I gave earlier (see previous comments) to set the DAY to the first of the month, for example.

Or... just build your own mini date-picker form (which wouldn't be too hard)... OR just use the date picker fields that are now built into Access 2007 and 2010.
Show Just This Thread        Post Reply
Read Calendar Seminar by mike @ 11/16/2010
I just changed the color to red on the Mopnthly Calendar for the days that are not part of the month... and it WORKED ?? must be a video thing ??

Thanks


Reply from Richard Rost:

You should be able to change them to whatever color you want. :)
Show Just This Thread        Post Reply
Read Setting Date of Calendar Control by mike @ 11/16/2010
Wehen Choosing a start date...  you can use the month and year dropdowns...  you MUST click a day in order to go to that month.  I do not want to click the day.  the entire month opens anyway.  the day at that point is umimportantant. Can this be done ?  :)


Reply from Richard Rost:

On which form are you working?
Show Just This Thread        Post Reply
Read Setting Date of Calendar Control by mike @ 11/15/2010
I also noticed that the graying of the boxes at the begining or the end of the month on monthly calendarF  arent accurate. I downloaded your student version and saw the same problem ??  
Show Just This Thread        Post Reply
Read Setting Date of Calendar Control by mike @ 11/12/2010
Thanks but what I am trying to acomplish is not choose the day of the month on the calendar.  The calendar opens based on the month.  Dont need to choose the day ??
Thanks


Reply from Richard Rost:

I'm sorry, but I don't quite understand what you're trying to do.
Show Just This Thread        Post Reply
Read Setting Date of Calendar Control by Mike Lesson @ 11/7/2010
I was wondering  if.....
when using the active X calendar control, Can the Day be automatically the first of the month. When you choose any day of the month the calendar opens the full month anyway, so no need to choose a day?
Also once the calendarF is open, how could you add back and fourth scoll buttons for next and last month ?  

As always the seminars and videos are awesome.  Thanks for all your help


Reply from Richard Rost:

If you want to SET the date of the Calendar Control Object, here's some code you can use. This will set the Calendar to the current date:

Calendar.Year = Year(Date)
Calendar.Month = Month(Date)
Calendar.Day = Day(Date)

If you want it to show the current date when you first open the form, put that code in the FORM_LOAD event. It will NOT work in the FORM_OPEN event.

Moving the CalendarF to a different month would just be a couple of command buttons to change the date and requery the form.
Show Just This Thread        Post Reply
Read Integrate Access Calendar Seminar into Existing Da by Angela @ 7/19/2010
I have completed the Access Calendar seminar, and I've built the Calendar form step by step and it works fabulously.

What I'm hoping to do now is integrate it into an existing database.

In my database there is a form to show the due dates for each step in a schedule.

The existing due date form uses one table, with multiple date/time fields, each field indicating the milestone for a project.

I need to be able to display each milestone (the date/time field) on the calendar I just built using the seminar. There would be no need to show times, as only one milestone happens per day. I would need each item to appear on the appropriate day of the calendar.

Please tell me this is possible.

Thanks,
Angela



Reply from Richard Rost:

To use your existing table that has multiple date fields would be a little tricky. You'd be better off using an append query and copying each of those multiple dates to your Calendar table so each one shows up as a separate record. Perhaps trigger it with an "Add Dates to Calendar" button on that form. Otherwise, you'd have to change the structure of your Calendar forms and reports to read multiple date fields.
Show Just This Thread        Post Reply
Read Access Calendar 2010 by Bob Sanders @ 5/31/2010
Access 2010 does not
recognize the calendar Active X Control. Can you advise on a work around to make the Calendar I built with the aid of your calendar course work. Many Thanks Bob
Show Just This Thread        Post Reply
Read Calendar Function Repeat Event by Jan @ 5/21/2010
Thanks for the reply it is not quite what I needed.
I need the functions or code that would help identify the Second Wednesday of every month between the start date eg 1/1/2010 and end date eg 12/31/10


Answer from Richard Rost:

Oh… well that's getting a lot more complicated. :)

You can use the WEEKDAY function to determine what day of the week a particular date is. You'd have to enclose that inside of a loop to check for the 2nd Wednesday - along with a counter to count the number of Wednesdays. Something like this:

D = InputBox ("Enter start date")
NumWed = 0
While NumWed < 2
   If WeekDay(D) = 4 then ' Wed
      NumWed = NumWed + 1
   End If
   D = D + 1
Wend

Now when this loop exits, you've got the 2nd Wednesday of that month in the value D.

You could take this and create a function out of it, and then wrap this inside something like that first bit of code I gave you to add the dates to your subform.

Again, not exactly EASY to do, but it's not terribly hard either IF you have the right VB background.

I hope this helps get you started in the right direction.
Show Just This Thread        Post Reply
Read Calendar Function Repeat Event by Jan @ 5/17/2010
Platform is Access 2003(XP), I have used MSAccess since 1995 (just so you know my level to understand your instructions.
I have a reservation system that uses a subform to assign the facilities needed for an event.  Some clients use the same facility for the entire year for the same day every month - ie second Tuesday every month.  I would like the code to fillin the dates for the rest of the year (or an stop date I specify) and repeat the facility code for every line in the subform for that eventID.  Have you created or seen VB code that addresses this and can be used in MSAccess?


Answer from Richard Rost:

You could do this with a little bit of VBA code. Just make a button in the footer of your subform that would do something like this: (THIS IS NOT TESTED, but is to just give you an idea of how to do it)

StartD = InputBox ("StartDate")
EndD = InputBox ("EndDate")

X = StartD
While X < EndD
  Docmd.GotoControl "DateField"
  Docmd.GotoRecord acNewRec
  DateField = X
  X = X + 7
Wend

This will basically form a loop that will run from your start date to your end date, going to a new record, and then setting the date. It will then move ahead a week (+7).

Again, I didn't test this, it's just off the top of my head… but it should get you started. I'm sure you'll have to adjust the field names and syntax a little bit.

Hope this helps.
Show Just This Thread        Post Reply
Read Access Calendar Monthly dropdown by Chris @ 1/13/2010
Hi Richard,

I have a form containing a calendar (MSCAL.Calendar.7). I also have a textbox on the form. When a user chooses a date it looks at the month chosen and displays in the textbox the users task for that month. The problem I have is if they select a new month from the monthly dropdown the calendar doesnt update until you click an actual date that month. So if July the 1st is selected and you drop down and change to September the value is still July the 1st until you click a date in September. Is there a way I can access the value of the dropdown box. If i knew in vba which month was selected at the time I can write some vb so set the calender to the 1st of that month, prompting the change of date.

thanks

Chris


Answer from Richard Rost:

I don't believe you can change the behavior of that calendar control. It doesn't get a value until someone selects an actual date.

If all you need is just a list of months, then why not just create two drop downs - one for year (2000, 2001, etc.) and then another with the 12 months. Have them pick values in both of these boxes and then run your event.

The alternative, of course, would be to just build your own calendar. I cover this in my Access Calendar Seminar:

http://www.599cd.com/site/courselist/seminars/access-calendar/?key=BlFAlEx

I just spent about 20 minutes playing with the calendar control, and I found that there are events that fire when the Month and Year dropdown boxes are changed (NewMonth and NewYear) but I could not find any way to access those values. It's not a property of the control. I tried searching on Google for some explanation of how to do this, with no luck.

If anyone else knows how to access the Month and Year properties of the Calendar control, that would be a great help.

Sorry I couldn't be of more assistance. Since I usually build my own calendar controls, I don't really have a ton of experience with the Microsoft calendar control.

Oh… hold on… I found it. There is a way you can access those properties, but it's a LOT of code. Here's a link:

http://support.microsoft.com/kb/193967

Hope this helps.
Show Just This Thread        Post Reply
Read Calendar Seminar by Richard Rost @ 10/18/2009
Debbie, the current Access Calendar Seminar doesn't cover any integration with Outlook, but that's an excellent idea for a future seminar.

I will add it to the Waiting List, and if enough people are interested, I'd certainly love to record it. Cast your vote here:

Waiting List - Access Outlook Seminar

Have a great day.
Show Just This Thread        Post Reply
Read Calendar Seminar by Debbie @ 10/18/2009
the calendar seminar looks great and I know that is the first step for what i need. I would like to know if you will offer and future classes to learn how to link Access with any of the other calendar software programs, so you can have the option of real-time reminders?
Show Just This Thread        Post Reply
Read Calendar Report by Richard Rost @ 8/15/2009
Mike, you could format a report to look like a calendar, sure. It will take some tricky formatting. I created on once using seven different columns for the days, and you have to get creative with figuring out which column to start with.

If anyone would like to see an example of this, let me know and I'll make sure to add it in a future lesson.
Show Just This Thread        Post Reply
Read Calendar Report by mike @ 8/12/2009
I am following your Access tutorials, which are excellent..  I am at the part where you are creating a task list, access 206.  Can a report be created to look like a calendar listing the tasks?
Show Just This Thread        Post Reply
Read Calendar control to help run reports by Richard Rost @ 1/30/2009
Denis, you just need help setting up the calendar control to pick dates? I cover this in my Access 203 tutorial: www.599cd.com?GOAC203.

One of the nice things about Access 2007 (yes, there are a FEW nice things) is that a "date picker" caneldar object is automatically included with date/time fields.
Show Just This Thread        Post Reply
Read Calendar control to help run reports by Denis @ 1/28/2009
HI, I need help please.

I am craeting a telephone data base and this stores all our extension numbers and what call have been made and the final cost for the month per extension per person per department.
I have now managed to write a few queries that will sort and send specific information to the relevant departments.
I have created a form for each manager to view there own departments cost and how much staff have used.
And now this is where my problem is, i want to be able to have a calendar controls that can run reports between two dates. Yet, I don't know how to link this to the tables i need.

EG, if want to run a report on "stores" department. I have the forms set up and the table, yet, if i want to run report on dates for certain periods EG,28/01/2008 to 28/01/2008 and call up the whole usage including the call types cell, land line, local and international, how would i set it up.
This is one of my final steps in order for me to finish the reporting.

URGENT thanks
Show Just This Thread        Post Reply
Read Access 2003 Dates to populate Calendar by Richard Rost @ 10/15/2008
Mike, you can certainly automate Outlook to do all of these things. Unfortunately, that's a whole class in and of itself. I'll try to cover this in an upcoming lesson. It's not HARD, but it involves a lot of code.
Show Just This Thread        Post Reply
Read Access 2003 Dates to populate Calendar by Mike @ 10/7/2008
Hi,
I have an Event database that I created for training scheduling purposes. I would like to populate a calendar program, preferably Outlook, with the event dates, titles and maybe the attendees names.
thank you in advance for your help.

Mike  
Show Just This Thread        Post Reply

Collapse All Topics

 

Post Your Comments or Subscribe
    If you would like to be notified of new posts on this forum,
    just enter your email address below. It will be kept private.
 
If you just want to subscribe to get email updates when this forum is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 9+7:
  
  Notify me when the this forum is updated
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

You may want to read these articles from the 599CD News:

3/23/2018Microsoft Access Developer 7
2/22/2018Microsoft Access Developer 6
2/22/2018Access Assistance Available
2/21/2018Putting Access Databases Online
2/18/2018Microsoft Access Developer 5
2/10/2018Microsoft Access Developer 4
2/1/2018Access Tip: Salary History
7/19/2017Access Developer 2 and 3 Released
7/19/2017Microsoft Access Developer 3
7/19/2017Microsoft Access Developer 2
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP