Calendar/Appointment database (1 Viewer)

Status
Not open for further replies.

Gasman

Enthusiastic Amateur
Local time
Today, 21:15
Joined
Sep 21, 2011
Messages
7,171
***** Please use the link in post #7 *****
Hi,

I have been asked to submit the database attached as it might prove useful for someone else in the future.

A request was made in this thread for help in changing the display from Sun - Sat, to Mon - Sun.

The code has not been exhaustively tested, I left that up to the o/p to carry out. First impressions is that it is working OK.

I have no idea where the original database came from and as that might be more preferable for some, I have also included that in the zip file.

Each is named appropriately.

Hopefully it might prove useful to others.
 

Attachments

  • Wide Calendar with Switchboard.zip
    324 KB · Views: 3,848
Last edited:

miacino

Registered User.
Local time
Today, 13:15
Joined
Jun 5, 2007
Messages
78
Hi Gasman,
I just came across this database template and its wonderful! I started to modify based on my needs, but noticed that the calendar days are off. On the calendar form - for example - Today 2/12 is listed as Sunday.
Wouldn't have a clue as to how to modify that. Any thoughts?

Thanks for this wonderful tool.

Michele
 

miacino

Registered User.
Local time
Today, 13:15
Joined
Jun 5, 2007
Messages
78
Hi Gasman,
I'm using this calendar tool (I've modified and amplified). Thank you for sharing! (The week starting Monday one). I've noticed though that the day of the weeks are off. (i.e., 2/14/19 is listed in the calendar view as a Tuesday (should be Thursday).
Any thoughts on how to modify?
 

miacino

Registered User.
Local time
Today, 13:15
Joined
Jun 5, 2007
Messages
78
In the private sub PopulateCalendar():

'ADezii
'NOTE: Will work in the UK (United Kingdom) and other European Nations
'strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)


Is this what could be causing my days of week to be off - if I am using this in U.S.? (i.e., my calendar shows Feb1 to be a Wed on the calendar, when it should be a Friday?

Thoughts? I've used this awesome template to build off of, but am stuck with the day of the week not aligning.

Thanks for any guidance. I know this was posted years ago!
 

isladogs

CID VIP
Local time
Today, 21:15
Joined
Jan 14, 2017
Messages
14,030
@miacino
I've just noticed that you made three posts to this moderated area over a period of a week or so. However, unless moderators are made aware of such posts, they can languish in an obscure corner of cyberspace for weeks.
For that reason members are asked to report their posts to moderated areas. See sticky post at the top of this forum area
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:15
Joined
Sep 21, 2011
Messages
7,171
Crikey, It's been a while since I touched that.

I can barely remember what I did yesterday, let alone 4 years ago.:)

So have you swapped the comments for these lines in PopulateCalendar ?

It works fine for me, but then I use dd/mm/yyyy

Code:
'strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)
strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:15
Joined
Sep 21, 2011
Messages
7,171
I have now added code that should now check what date format should be used.
Only added to Sun-Sat and Mon-Sun databases.
 

Attachments

  • Wide Calendar with Switchboard Mon-Sun.zip
    483.3 KB · Views: 633
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom