User Profile

irishalanm · Apr 25 '09, 12:50 PM

Hi Fish,
I amended your flat calender query to add the day of the week. It is brilliant. i can't believe how easy it is (when you know how!). I guess the moral of the story is it is all about using the in-built functions and SQL. I used the Weekday() function to convert the date to the day of the week.

Thanks very much

Regards

alan...

irishalanm · Apr 25 '09, 12:40 PM

Hi Adezii,
I'm not sure what your calendar project does or how it works-I can only see the form-it looks good though!!

regards

Alan...

irishalanm · Apr 25 '09, 12:36 PM

Hi everyone (who might be interested;))
I have found a way to append dates to the table -it is not sophisticated but it works.

First I create the table which will store the dates I need.
Table [Watchdates-A/B]-contains a single Date/time field [A/B WatchDate] which is a PK
I add dates that are worked in a single 28 day period for a certain shift -This amounts to 7 dates.

I then create an Append table...

irishalanm · Apr 18 '09, 09:17 PM

Thanks a million ADezii,

The Calendar application looks amazing-I haven't had a chance to experiment with it yet.
Thanks for the link as well Fish-I haven't had a chance to look at it yet.

Regards

Alan

irishalanm · Apr 18 '09, 09:59 AM

Hi ADezii,

I am doing a project for college which is work-related and I want to cross reference dates in tables which are particular to a group of people with a calendar as well as various rosters they have been assiged holidays to. Part of my project relates to researching how a similar problem might have been solved by someone else. I appreciate your offer and understand if you don't want to show your work. But I need to solve the...

irishalanm · Apr 17 '09, 01:39 PM

ADezii's calendar

Yes sounds good-could someone attach ADezii's calendar? I'm afraid the attachment is no longer there from thread way back.

Thanks

Alan...

irishalanm · Apr 16 '09, 08:28 PM

Hi Dan
The tables contain dates and an important part of the project is to cross reference these dates. I was thinking about using DateAdd() function but I don't know how I would access the table in VBA or otherwise.

Thanks

Alan

irishalanm · Apr 16 '09, 08:08 PM

The problem is I don't know how to do it. Do I use VBA with the DateAdd() function? Does anyone know how to access the calendar control function in Access 2007 or is this possible?
Thanks

Alan

irishalanm · Apr 16 '09, 12:16 AM

I am storing several tables with nothing but dates in them and I need to have a calender in a table as well. I plan to cross reference dates. I have seen previous thread where ADezii posted an example database from Philly Fire Dept a while back but the link has been removed so i couldnt see it but it sounds like it could be similar to what I want to achieve.

Regards

Alan

irishalanm · Apr 15 '09, 10:41 AM

Hi NeoPa,
Thank you for your time and apologies for the delay in reply. I think I need to give you some background to my project so you can see what I am trying to achieve. I am designing a database to monitor leave (days off) for a company that has different groups of staff on different shifts. Because the employees work more hours than the standard week they are entitled to different leave throughout the year. These are rostered to every...

irishalanm · Apr 7 '09, 06:36 PM

Ok Sorry about being less than clear!

What I want to do is advance each date in a table of dates by exactly 28 days. I suppose I would have to set up a loop and for each field value use the AddDate() function to add 28 to each and either append the new values in the existing table or create a new table, leaving the original dates unaffected. Does that explain it any better?

Thanks again

Alan

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Using VBA to perform action on every field in a table