Calendar/Appointment database (1 Viewer)

Status
Not open for further replies.

Gasman

Enthusiastic Amateur
Local time
Today, 15:47
Joined
Sep 21, 2011
Messages
14,044
***** 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: 4,615
Last edited:

miacino

Registered User.
Local time
Today, 08:47
Joined
Jun 5, 2007
Messages
106
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, 08:47
Joined
Jun 5, 2007
Messages
106
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, 08:47
Joined
Jun 5, 2007
Messages
106
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

MVP / VIP
Local time
Today, 15:47
Joined
Jan 14, 2017
Messages
18,186
@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, 15:47
Joined
Sep 21, 2011
Messages
14,044
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, 15:47
Joined
Sep 21, 2011
Messages
14,044
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: 1,384
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom