473,880 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

calendar in Access

58 New Member
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?
Jan 17 '07 #1
76 24248
nico5038
3,080 Recognized Expert Specialist
Why create this with Access ?
Personally I would look into web based solutions like the Yahoo agenda so every employee with an internet browser can have access to the calendar....

Nic;o)
Jan 17 '07 #2
ADezii
8,834 Recognized Expert Expert
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?
If you are interested, I have a fully functional Calendar created entirely within Access via 1 Table, 2 Forms, 1 Class, and 1 Standard Code Module. It was used as a simple Appointment Calendar for a certain Unit within the Philadelphia Fire Department. It is quite simplistic and easily adaptable. Let me know if you are interested.
Jan 18 '07 #3
apartain
58 New Member
If you are interested, I have a fully functional Calendar created entirely within Access via 1 Table, 2 Forms, 1 Class, and 1 Standard Code Module. It was used as a simple Appointment Calendar for a certain Unit within the Philadelphia Fire Department. It is quite simplistic and easily adaptable. Let me know if you are interested.
I am absolutely interested. Thank you so much.
Jan 19 '07 #4
apartain
58 New Member
Why create this with Access ?
Personally I would look into web based solutions like the Yahoo agenda so every employee with an internet browser can have access to the calendar....

Nic;o)
This is a very interesting database. The users would love to have the calendar in the same database as their projects and employee time for cross-reference. They also need to be able to input availabilty so projects can be assigned accordingly. I'm with you, why not use Outlook or something, but they asked me to try.
Thanks as always for your helpful responses. You are very appreciated.
Jan 19 '07 #5
nico5038
3,080 Recognized Expert Specialist
Hmm, your comment triggered for me the thought to incorporate a Webbrowser in a page and have that pointing to the Yahoo (or other) web calendar :-)

Main question is or all people that need to enter their availability do have access to your .mdb.
For most of these systems I know the users are on a distance and have no access to the .mdb.

Nic;o)
Jan 19 '07 #6
apartain
58 New Member
Hmm, your comment triggered for me the thought to incorporate a Webbrowser in a page and have that pointing to the Yahoo (or other) web calendar :-)

Main question is or all people that need to enter their availability do have access to your .mdb.
For most of these systems I know the users are on a distance and have no access to the .mdb.

Nic;o)
Yes, the are on an inter-office network so they all have access to the database. They also have a vpn, which concerns me because I'm not sure how the database will operate with all that traffic.

They use Outlook now, but want it in the database. If I can't figure it out, they'll just have to continue using Outlook. If I can, they'll think I'm really smart. hehe

Not really, I'll give credit where due.

At the very least, I can create a simple table and sort it by date and they can look at it that way.

By the way, I don't know VBA code very well, so if you were to be kind enough to help me out, could you please give specific instructions?

Thanks,
ang
Jan 19 '07 #7
ADezii
8,834 Recognized Expert Expert
I am absolutely interested. Thank you so much.
Give me your E-Maill address and I'll send it as a File Attachment.
Jan 19 '07 #8
Noob
14 New Member
Hi
I would also be interested in the calender file as im looking for a way to incorporate a courtesy car booking calendar into my database for a qiuck visual reference showing availability.Yo ur calendar sounds perfect , if possible could you send me a copy too.

Many Thanks

Email address removed per site rules!
Cheer
Jan 19 '07 #9
nico5038
3,080 Recognized Expert Specialist
You might use automation to access the appointments from outlook, checkout:
http://support.microsoft.com/kb/209963/en-us
Thus the users don't have to learn new tricks :-)

Nc;o)
Jan 19 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4239
by: Michael Holberton | last post by:
Hi All, I have Access 97, 2000 & 2002 installed in different directories under Win2K Server on a new PC box I built. The Calendar Control on my Date Selector Form is not working and causing various problems. The file in C\winnnt\system32 appears to be the version for Access97. Even if I register the version for Access 2000, that resides in the Office directroy of my Office 2000 installation(or move it to the C\winnnt\system32...
1
2070
by: Marco Simone | last post by:
Hi, If someone can answer how to add calendar control on form, where you can choose date. I think there is Calendar control in ActiveX add in, but I don't know how to implement it. Thanks for your help, Marco
8
2462
by: Shyguy | last post by:
Is it possible to create a calendar that shows previous input data and also allows for input of new data?
1
4183
by: Norman Fritag | last post by:
Hi there I have avoided to use active x controls because I thought they are causing more problems then they are doing any good. I a new application I would want to use the tree and list view control in access 2002. Prior to that I like to fine some information or here some feed back from developers who have use active x controls success fully in there application, what their experience was.
3
8240
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...
16
3071
by: DFS | last post by:
If you're listening, I want the middle of the calendar (showing 1 month) to open below the cursor position. It currently opens just to the right and below the cursor position. I hunted through the code, but can't determine what to alter. Very nice piece of work, by the way. Thanks
9
5827
by: Greg | last post by:
Hi, I have a table with "dates", i'd like to display those dates on a calendar. I've put a calendar in a form, linked to my "date" field, and it works, but only showing one "date" per calendar. I can see all "dates" moving to next records, but one per calendar. :-( Ex: 17/06 on one claendar, then if i click on next record, I can see my calendar with 24/06 ...etc ...
1
3008
by: xian2 | last post by:
Hi, I wanted to create a calendar in Access that would call on data stored within tables in the database (dates in forms) and would show it visually on a calendar when the calendar was opened. I was told about calendar control fundtion and created a calendar in a form but cannot work out how to call on the data within the tables so it appears as an entry in the calendar when the calendar is opened. Please can you give me some advice on...
2
1960
by: BerkshireGuy | last post by:
I need to create a form that is a giant calendar. For each day of the month (users should be able to browse the months) the date is a different color if: 1) The daily routine ran 2) If the daily routine didnt run. The idea is that a daily routine needs to happen everyday (unfortunately scheduling is not an option right now).
340
109088
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? ...
0
9925
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11089
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10809
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,...
0
10395
tracyyun
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...
0
9550
agi2029
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...
1
7948
isladogs
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...
0
7104
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();...
0
5777
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...
3
3219
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.