@Adezii - You are brilliant! After reading your updated post. I went back to try the code again. Apparently it must have been a fluke as to why it did not work the first time. After trying it again this morning with fresh eyes....it did exactly what you said it would.
You are a true genius! Thank you so much for all of your help.
As a side note, I did not have to change PopulateEventsL ist() sub-routine. The updated...
nerd4access
Last Activity: Dec 2 '10, 04:52 PM
Joined: Jan 8 '08
Location: Columbia, SC
-
@Adezii - I tried the fixes you suggested. With those changes neither the calendar nor the list box were populated with data; however an error was not produced.
I thought it may be useful to add a screenshot of the SQL produced for dbo_vwCalendar (the view on which the calendar form is based).
@NeoPa - I am not sure if I have provided a good answer to your inquiry about "where SQL is failing". Can you provide...Leave a comment:
-
I am not exactly sure where SQL is failing. I do not receive an error message of any kind and the data in the linked table is accurate.
Let me see if I can provide some background:
My tables for the access front end are linked to a database on the SQL Server (2005). I wanted to query the data in SQL before pushing it to the front end to make the database run faster. With that being said, I created a view called 'dbo.vwCalendar '....Leave a comment:
-
@Adezii - Removing the dbSeeChanges Option provided the same result.
I feel very fortunate to have the help of both you and NeoPa as I am self taught in MS Access, VBA, and SQL.
Any help that you can provide is greatly appreciated.Leave a comment:
-
@Adezii - your description of the issue is accurate. The issue always surrounds the 1st and 2nd of the month. It appears that the issue arises with the 15th and the 22nd on occasion. It is quite strange that it only affects those dates.Leave a comment:
-
[MeetingDate] is a datetime field. I have attached a screen shot of the calendar connected to the SQL Server.
As mentioned in a previous post, you can see that November 2, 2010 is selected on the calendar. The box in the calendar grid is empty, but the list box displays all of the events that take place on that date.
[imgnothumb]http://bytes.com/attachments/attachment/4228d1290615330/calendar_meetin gdate.jpg[/imgn...Leave a comment:
-
Thanks so much for your help. I will keep searching for a solution.Leave a comment:
-
I am in the United States.
I adjusted the code as indicated above to see if that would make a difference, but there was not change in the outcome.
I have converted the database to the 2003 version as you requested.
It seems that this is a SQL Server issue as the information displays properly when the table is in access instead of linked through an ODBC connection to the SQL Server.
For...Leave a comment:
-
I have downloaded this calendar and put it to great use. I am very thankful for all of the hard work that was put into this calendar. However, I am stuck on something and have looked everywhere for an answer.
I have an access front end and a SQL Server 2005 backend. Most of the dates along with the corresponding information is displayed on the calendar except any events that fall on the 1st, 2nd and sometimes the 15th & 22nd...Leave a comment:
-
We are not one in the same, but it's okay. I will view the attachment in your last post. Thank you so much for your help! :-)Leave a comment:
-
It will display info for a single date.Leave a comment:
-
I like the cosmetic changes. I would agree that they are more appealing to the eye. Thanks for those touch ups.Leave a comment:
-
The Band-aid listed in post #208 worked. The list box at the bottom of the screen populates correctly...mat ching the date chosen in the calendar.Leave a comment:
-
My apologies...I have uploaded the database in an earlier version. I will try the code from the last post to see if it works.
Again, thanks for your help on this....Leave a comment:
-
I have attached a sample version of my database. The code works fine when using an access table. Wires seemed to get crossed when using SQL Server 2005 as the backend.
Again, thanks for all the time you have spent on this....Leave a comment:
-
The datatype for StartDate is datetime in the SQL Server DB.Leave a comment:
-
When I change the code to include lines 4 and 5 from the code snippet you provided, the listbox does not populate. It remains empty regardless of the date selection.Leave a comment:
-
re: MS Access Calendar
Thanks for your help thus far. I have been working on this for quite some time.
The screen shot below is what I get when I added the following code:
The MsgBox pops up and displays the date for the textbox that I have chosen; however the information in the listbox is still not accurate. In this example I chose 1/3/2010. The data is displayed...Code:MsgBox CDate(ctlDayBlock.Tag)
Leave a comment:
-
re: MS Access Calendar
The unbound textboxes that create the calendar display the data accurately. If I click on any one of the days of the month, the label next to the list box at the bottom of the form displays the chosen date; however, the list box does not list the data accurately. The list box displays data that is two days in the future. I have attached a screen shot to provide a better picture.
...Leave a comment:
-
re: MS Access Calendar
ADezii,
I must say I love the Calendar_Single Date demo you posted. I have incorporated it into a database that I am building. I ran into a small issue in doing so. I am using an Access front end and a SQL 2005 backend. The code worked fine before upsizing the backend to SQL.
My current issue occurs when I click on a day in the calendar, the list box shows data for a date two...Leave a comment:
No activity results to display
Leave a comment: