473,503 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Calendar function in MS access

8 New Member
I got the attached database somewhere online. I do not own it. It has a great example of Calendar function which I am trying to develop. Could anyone please help me to understand the relation between tblInput and frmCalender (and other forms and reports related to it)so that I can link a table similar to tblcalendar to the calendar function.

I appreciate your response.
Attached Files
File Type: zip Input.zip (100.8 KB, 94 views)
Feb 25 '11 #1
4 2053
johny10151981
1,059 Top Contributor
look at Private Sub Form_Load() at Form_frmCalender

it calls the function Cal which is defined in modCalender module.

in Cal function is called PutInData. in this function you will get the relationship ......
Feb 26 '11 #2
Dalia Allencher
8 New Member
Thank you Johny. I went ahead and changed all the connections of frmCalender to the table tblInput and connected frmCalender to tblcalendar. I changed in the code module and control source of properties by replacing tblInput by tblcalendar and the fields InputText by Steps and InputDate by DueDate as per the fields of tblcalendar.

But, I am getting an error in frmCalender whenever I go to December 2010, October 2010, etc, which have text to show in frmCalender according to tblcalendar. Could you please help? I'have attached the file.

I appreciate your response.
Attached Files
File Type: zip CF.zip (2.09 MB, 68 views)
Feb 28 '11 #3
Dalia Allencher
8 New Member
I fixed it; thank you. It was a small issue in the code that kept throwing the error.
Feb 28 '11 #4
johny10151981
1,059 Top Contributor
To Fahad,
You better ask it in a different thread

as well as, Debug your code......... you will know why unexpected value is being showed
Mar 2 '11 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
7459
by: Mark Dicken | last post by:
Hi All, I am trying to Pass A Collection To A FUNCTION ??? (Access 2000) I have a Class called BO (for Business Objects) Within BO I have a Function called ShowCollection Public Sub...
1
1630
by: Charles | last post by:
I have a query in access 97 that pulls names and associates those names with dates. I'd like to have a calendar function that would simply display the names under the correct date listed. ...
0
1418
by: ss | last post by:
i read a few posts about global function access. well i am not interested in global functions. rather, i am seeking for a way to may my call in ASPX pages but not the code behind. for example:...
3
2755
by: Hutty | last post by:
I'm trying create a calendar control that updates an access database with events. I have some code I managed to piece together. First error I'm running into is the Mycommand.ExecuteNonQuery(). I...
2
1487
by: acord | last post by:
Hi, Can anyone please tell me how to get the return values from calling javascript calendar()? Thanks A
2
1318
by: GertJanVersteeg | last post by:
Good afternoon, My name is Gert-Jan and I from Holland. I like to use a Calendar in Access. For example: if I press on the button "15th" of November this date must appear in a other cell. Like a...
76
24070
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...
3
5616
by: dolphin | last post by:
Hello everyone! Can a static member function access non-static member? I think it is illegal.Is it right?
3
7391
vs2k8
by: vs2k8 | last post by:
Hello guys, I am using Access 2003 and in my form I have 3 date fields,Ord Date, Recvd Date, Due Date, user needs a calendar button so when clicked it shows calendar and when date is selected in...
0
7202
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,...
0
7086
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...
0
7330
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6991
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...
0
7460
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...
1
5014
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...
0
3154
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1512
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 ...
0
380
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...

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.