I believe I read a post somewhere here on how to change the first day of the week to Monday in this MS Access Calendar, but is unable to search it up again. I've changed lines 5 and 8 in the quoted code (PopulateCalend ar Sub-Routine, and by the way, line 4 seems to be missing a "/"?), and moved the day labels around. To my surprise, this is working so far. Is this all that is required? I'm a bit worried that I've overlooked anything.
Thanks for your time! - '*************************************************************************
-
'ADezii
-
'NOTE: Will work in the UK (United Kingdom) and other European Nations
-
'strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)
-
strFirstOfMonth = "1/" & Str(intMonth) & "/" & Str(intYear) ' PPelle added "/"
-
'*************************************************************************
-
-
bytFirstWeekdayOfMonth = Weekday(strFirstOfMonth, vbMonday) ' PPelle added vbMonday
2  1484  ADezii 8,834
Recognized Expert Expert
Never actually thought of or attempted this, PPelle. Thanks for this useful Insight and addition, it is appreciated.
Okey, thanks for your reply. I will assume than that this is all that is required. I have a few code lines that will actually use the system settings, automatically or by changing a constant. I can post it here if there is any chance you will include this in your code base.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: GuineaPig |
last post by:
Hello gurus,
Does anybody know of a function/module that can help me with the
following problem:
In my app the user can encode the starting and ending hours of his
workdays. The app calculates the time the user worked (per week) and
the user's overtime. The results are exported to an excel-sheet for
printing.
|
by: Matthew |
last post by:
I currently have a form in MS Access that has certain combo boxes
which specify criteria in order to run a query based on that criteria.
I want to add to this, a calendar from which a user will be able to
click on a date, where the chosen date will then be used as the
criteria for the control source of the calendar. What do I need to do
to make the calendar active?? I can physically get it on my form, and
specify the criteria in my...
|
by: afr0ninja |
last post by:
Hello all, and thank you in advance for your assistance.
I'm pretty new to access and I'm trying to teach myself some VBA by
using various bits of code I find here and there mixed with my own.
I've seen mentions of this issue in other forums, but haven't found an
ansewer (at least one I understand lol) in other postings.
I have a text box that users need to input a short date into. I tried
using a Access's built in calendar control...
|
by: Cliff |
last post by:
I want to use the Datepart function to determine the week number based on my company's fiscal calendar which starts Nov. 1.
I have tried the following and they all produce #ERROR# .
DatePart("ww",!,2,"11/01/2005")
DatePart("ww",!,2,#11/1/2005#)
If leave the Nov 1 date out, I get a result that appears to be based on Jan 1 as the date. It also appears to be the week number in the year, such that Jan 1 in 2005 and 2006 both have a week...
|
by: apartain |
last post by:
Has anyone ever created a shared calendar within Access? It would be similar to MS Outlook, but clearly not as in-depth. I would need to use it for employees to enter their availability so managers can assign projects accordingly. As well, it would be nice if it actually LOOKED like a calendar.
Do you recommend the ActiveX Calendar Control?
| | |
by: MyWaterloo |
last post by:
This thread has been closed as it has gotten just too big.
If you have any questions about the application discussed in this thread please start a new thread in MS Access by clicking on the Start a Discussion button and link to the this thread in your question.
Just wondering...Am I the only one in the access universe that would like an Outlook like calendar option? Is there such a thing as a calendar that can be used for data entry? ...
|
by: ADezii |
last post by:
MS Access Calendar – OVERVIEW
Many times over the years, a similar type question has been asked of us here at Bytes, namely: How Can I Incorporate Calendar Like Functionality Solely Within The Context Of My Access Application? The individuals posting these questions are not referring to the varied ActiveX Calendar Controls that essentially present a Popup Dialog that enables you to select a Date then populate a Form Field with that Date, but...
|
by: RockKandee |
last post by:
Hi,
I am getting an error message when trying to print.
I am using the MS access calendar found here:
http://bytes.com/topic/access/answers/761255-ms-access-calendar
I have Windows 8 and Office/Access 2013. I am using this in a desk top database and would like to transfer it to a web database in the future.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
