Recent content by JJFernandez

That worked great - Thank you!

Thanks for that, looks promising. I'll give it a go and report back...

Thanks for the reply. So far I've just used the DateDiff expression to calculate full years within the text box. So I could create an if then statement saying some like if (DateDiff("yyyy",[dob], Now()))<2 then (DateDiff("m",[dob], Now())&"Months" or something similar? Forgive my poor...

Hi all, I would like to populate the age of a person in an unbound control in an access form (also a query) by comparing Now to dob. I can calculate full years or full + partial years in decimal format. I'm wondering if anyone has a tip on how I could produce a result of a full year if over 2...

For the record, I was getting an error about ambiguous outer joins if I simply tried to define all joins at once. What I had to do was first have individual queries between IRF_Suspect_Pointer and Suspect_Info; as well as IRF_Enforcer_Pointer and Enforcement Officers. I then created the main...

Thanks for your reply. I'd actually like all records from the table IRF, but you're correct as that would match the IRF_Enforcer_Pointer results. I will try mess around with the join types and if I'm still stuck I will post a sample db. Thanks again.

This looks like what I need, thanks for your assistance!

Hi all, I apologize if this has been asked and answered but I have put an honest effort in to find an answer with no luck. I'm trying to run a query and return records for all "incidents", even when some fields I am interested in are blank (actually a record does not exist). In this specific...

Hi all, I am trying, and failing, to think of a good way of ensuring that an entry is made into a subform before the user is allowed to move to another record, create a new record, or save the existing record. I've tried simply adding some code to the on click event of a Save/Refresh Control...

That's good thinking! I ended up just creating a combobox with a values list as there are so few possibilities. Just as an update I ended up splitting up 3 separate boxes and concatenating them into a locked Incident_ID field in the AfterUpdate of the Initials field. Private Sub...

I guess we'll start using middle initials as well? The paper form ID number is always unique so the Incident_ID will never be duplicated. Right now there are only 5 officers so we're good!

That looks promising, I'll have a go at that. Thanks for the assist.

Thank you for your reply. That will likely cut down on potential entry errors. The part that I'm getting stuck on is the reversing the date and removing the slashes. If that's not possible, I suppose I could simply have separate input boxes for day, month, and year and then combine...

Can I ask if you have ideas on how to accomplish what I'm trying to do? I'm not sure the why I want to do it should matter this much. I have an autonumber that is hidden from the user. This Incident_ID is for internal use, it is meaningful. An enforcement officer will have pre-numbered paper...

It seems that I should have included in the description that the user-added identifier refers to an identifier in an enforcement officer's (pre-numbered) incident entry book.