Search results

Not often do I get cold and frosty reception here :ROFLMAO: Happy Christmas Jon and everyone.

So, I repeat, have you checked the "Name" property setting and the "Source Object" property setting of the control being used to hold the subform. The "Name" property setting can be found on the tab called "Other" on the Property Sheet and the "Source Object" property setting can be found on...

Have you checked the "Name" property setting and the "Source Object" property setting of the control being used to hold the subform.

I think it can be difficult/misleading to generalize but I wouldn't say that was true of the UK. Perhaps another good reason for us not being in Europe ;)

Sounds like an interesting project ;)

Welcome to the forums :) What does the "RC" stand for in "RC hobby" ??

If both B and C are opened, using the acDialog argument, then whichever is opened last should stay "On Top". Double-check that you did set the acDialog argument of DoCmd.OpenForm when opening both B and C.

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