Daily Calendar

[cavscout]

I'm modifying a calendar I downloaded from one of the forums.

What I want to do is allow the user to double click the specific day, which is a subform in the main calendar form, to open a deatiled view of that days events.

The problem is when the detailed view opens, I'm not sure how to pass the desired date to the query. I've tried several ways (openargs, value like a field...) but I don't seem to be able to make all the connections.

Can someone kick me back on the right track.

Thanks in advance.

 

[Rich]

You have a field named Date, bad move in Access it's a reserved word, I'll leave you to rename it and change all the references.
You can now click the header and open the form to the desired date, however if there's no entry for that day it'll open to a blank date, you'll have to pass the date to the date field once you've renamed the Date field

 

[cavscout]

Good Point Rich.

Thanks for your response. That's exactly what I needed.

 

[metad]

Please help with norwegian date format

Hi. First of all thank you for good code. I have used your database, and everything works well when I changed the field Date to Date1. But we use Norwegian date format, and it seems that the code only works with Date format as English (United Kingdom).

Have you any advice to what I should do?

Thanks in advance.
metad

 

[metad]

Could you please help me with norwegian date format?

You have a field named Date, bad move in Access it's a reserved word, I'll leave you to rename it and change all the references.
You can now click the header and open the form to the desired date, however if there's no entry for that day it'll open to a blank date, you'll have to pass the date to the date field once you've renamed the Date field

I have used your database, and everything works well when I changed the field Date to Date1. But we use Norwegian date format, and it seems that the code only works with Date format as English (United Kingdom).

Have you any advice to what I should do?

Thanks in advance.