statsman
Active member
- Local time
- Today, 08:24
- Joined
- Aug 22, 2004
- Messages
- 2,088
I am creating a football (soccer) stats keeper for a pal. I have been away from Access for awhile, but it's coming back slowly.
The stats part has worked out OK, but the problems lie in in exporting the data from the stats keeper database to the archive database at the end of a season.
Access 2007.
1. Both the team and player stats are exported but there is no reference to the season. In Canada football is a spring to autumn sport so only four numbers representing the year are needed. Is there a method of breaking the Date() apart so only the year is recorded? Set the default value of a field as the year.
2. I have all the steps required for the transfer in a macro, but the SetWarning function doesn't seem to be there. When I run the macro there are multiple screen prompts requiring YES to be clicked to proceed. What happened to SetWarning? I do hope something has replaced it.
The stats part has worked out OK, but the problems lie in in exporting the data from the stats keeper database to the archive database at the end of a season.
Access 2007.
1. Both the team and player stats are exported but there is no reference to the season. In Canada football is a spring to autumn sport so only four numbers representing the year are needed. Is there a method of breaking the Date() apart so only the year is recorded? Set the default value of a field as the year.
2. I have all the steps required for the transfer in a macro, but the SetWarning function doesn't seem to be there. When I run the macro there are multiple screen prompts requiring YES to be clicked to proceed. What happened to SetWarning? I do hope something has replaced it.