User Profile
Collapse
-
Disregard. The above code works. -
Updating Memo Field from form Control
I have a form with an unbound control called RevevantDateNot es. This is used to gather and update information stored on a table field of type Memo, with the same name (RevevantDateNo tes).
The After Update [Event] is shown below:
I need to store an email (cut and past) of a resignation letter. When I cut and paste a letter into the form field, I get the following error with a portion of the letter embedded in the error message:... -
Fish
Thanks for putting all that effort into this. I will be back on this particular job this weekend and will get back to you with my results. I appreciate the assistance.
JohnLeave a comment:
-
Converting Query Record Source to Columns in a report
For a report, I am using a query as my record source. The query produces 5 columns by 3272 records.
The data in columns 1 & 2 (“Objective” and “Rating”) repeats every 409 records The data for “initial” and “Date” are unique for the individual. Currently there are 8 individuals (409 * 8 = 3272)
. . . . .. . . . .Objective . . . Rating . . Initial . . . .. Date . . . . . Name
[rec0001].... -
Hi n8kindt
Hopefully there is a solution in queries. I have dozens of queries that need to be altered to account for LOA. Adding something to the criteria line in a query would beat having to convert everything to vba. My skill level: Access - beginner; vba - at least one step below beginner. Simple subs I can do, but I would need a bit more time under my belt before taking on a revision to vba at this point.
...Leave a comment:
-
Hello Fish
I hope this answered your questions.
What you want is validation of [tbl_Join_Member _Event] table data. If an event date falls into a member LOA period, then record in [tbl_Join_Member _Event] table relating the event to the member is considered to be invalid.
***Yes, invalid for purposes of calculating the member attendance, but not invalid for knowing the member was at the event – one example...Leave a comment:
-
FishVal
Question #1. [tbl_Join_Member _Event].[StartDate]
This is the same as
[tbl_Training_Ev ent].[Training_StartD ate] and is unnecessary. Thanks for pointing that out.
Question #2. There is no short answer
This DB is for tracking training and participation on a Search and Rescue Team. There are multiple organizations that require reporting of activities, inlcuding our own team. Using a...Leave a comment:
-
Thank you for responding Fish. I have the requested metadata below.
Let me update the original request. I have a MS Access query that calculates a member’s attendance at team training events over the past 12-months; i.e., DateAdd("yyyy",-1,Date()). This is one of several queries used; others calculate the total number of training events that occur within the past 12-months. These are used to calculate percentages, etc....Leave a comment:
-
Select Date Range except while on Leave of Absence
I have a MS Access query that calculates a member’s attendance at team events over the past 12-months (i.e., Now()-365). This is one of several queries used; others calculate the total number of events that occur within the past 12-months. These are used to calculate percentages, etc. They are working fine.
All members have what is termed an ‘Attendance Calculation Date’, the date upon which they joined. This may or may not be...
No activity results to display
Show More
Leave a comment: