Search results

Ah! They don't call me "tinkle-toes" either. Full Stop!!

Probably not as well as you :ROFLMAO:

Post a copy of your db

Is that the only event that isn't working? Is the event property set to [Event Procedure]

Is your db split, with each user having their own front-end and each front-end linked to tables in a single back-end file?

Without wishing to be pedantic and for the sake of that clarity, what you have said is correct but take the following into account: If the body that issues a cert were to change the length of time a cert is valid for from, then you would need to create a new entry in "CertListT" rather than edit...

If CertificationDate is the date that the Cert was issued then it might be better to NOT have an ExpiresOn field in a table but have that date calculated in the query. It is usually considered to be better to do the calculation whenever and wherever it is required than to store it in a table.

I think that would work but you might need to check the length of Cert Validity AS WELL as the checking for Null in CourseID2. Perhaps a 3rd conditional rule. Post back if you need more help :)

I've just had an afterthought. Won't you need to take into consideration the length of time that a certificate is valid for? I noticed a field called "ValidFor". Would I be correct in assuming that this holds the number of days that the certificate is valid for? Do you need to indicate in the...

Always pleased to help if I can ;)

Not sure that I've understood the requirement but see attached:

So how many products are in the list and how large will it need to become before you decide to structure things properly by creating a "ProductType" related to the "Products" table

Perhaps your criteria should be in a different column

Nector Perhaps you just need to change the "Data Entry" property of the main form from Yes to No

Glad to help if I can. Be sure to test well wit more data.

Try: SELECT Max(YourTableName.SeatimeID) AS MaxOfSeatimeID, YourTableName.CrewID, Last(YourTableName.JoinDate) AS LastOfJoinDate, Last(YourTableName.LeaveDate) AS LastOfLeaveDate FROM YourTableName GROUP BY YourTableName.CrewID ORDER BY Max(YourTableName.SeatimeID);

I've certainly not offered any solution. All I've offered is some advice on cross-posting.

You may be correct about "new posters", I can't remember that far back anymore :ROFLMAO: Not so sure about the need for new glasses though. In post #12 at: https://www.accessforums.net/showthread.php?t=88955 he said, "Okay thank you, you are awesome. You saved me lol, what did you change so I...

I never realized that you were such an optimist ;)

I notice that Minty managed it. I always use copy/paste to show a link here. It's never let me down.