User Profile

Collapse

Profile Sidebar

Collapse
jglabas
jglabas
Last Activity: Dec 16 '08, 12:26 AM
Joined: Jun 1 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • jglabas
    replied to Updating Memo Field from form Control
    Disregard. The above code works.
    See more | Go to post

    Leave a comment:


  • jglabas
    started a topic Updating Memo Field from form Control

    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:...
    See more | Go to post

  • 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.

    John
    See more | Go to post

    Leave 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]....
    See more | Go to post

  • 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.

    ...
    See more | Go to post

    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...
    See more | Go to post

    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...
    See more | Go to post

    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....
    See more | Go to post

    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...
    See more | Go to post
No activity results to display
Show More
Working...