Recent content by Navy Ken

LOL file dialog. wow. You should have seen the word salad I was trying to use. Thanks Doc.

Because of the network drives the file paths are rather long and clunky and I REALLY don't want this already very full record row to wrap around to two lines. Talking with the users the chances of them wanting or needing to use this link are bordering on zero but management wants what management...

There will be a button to view the file if, for some reason, someone wanted to, but the file is simply there for historic and evidentiary reasons. (I personally don't feel it is needed and they are just eating up space on the share drive, but its not my database I'm just building it.)

This may simply be me not knowing exactly what search term to use here on the forum. I want to link a PDF file to each of my records. To be clear I want to link the file I do not want to use the OLE object or the Attachment object. So far that is easy enough, the part I can't find any...

Now that Doc explained it I sort of get what's going on, and spaces are fixed fixed it. That was the only change I made.

OK rather high level but I do get the idea. So the TLDR is it's the Navy's fault. LOL Story of my life.

Wow this is so 1992. There is no web based option? I know that Access has the ability to make web based stuff. Never messed with it but, man, this sounds archaic.

Can you explain to me why that code had to use concatenation to arrive at the answer? I am still a bit confused about that.

Ah, didn't realize that flagging it solved locked it out. that's rather inconvenient.

Ok folks thanks for the help, Seriously. Moving foward I just have to build an If, Then, Else. Marking this as solved.

Got it! Believe it or not it was spaces. I needed spaces around the ampersands. Unbelieveable.

In the AreaXEmployeeT table, Yes.

OK the naming convention is a bit of a mess I know but I am afraid I will break something if I go normalizing it. When I add the criteria I get the error. EmployeeVitalForeign = UserID TblProgramAreasForeign = AreaID Private Sub Form_BeforeUpdate(Cancel As Integer) Dim WasItUsed As...

So troubleshooting I have this and get no errors with this snipit. I think I may have an issue with the criteria. Just need a bit to get my head around what the criteria Doc suggested is doing. It APPEARS to me that its concatenating but I'm not sure why. Private Sub Form_BeforeUpdate(Cancel As...

Is there an advantage to using two different application? I may be off my mark but Splitting and having two front ends avoids importing and exporting data. Just seems like a lot of opportunity for data corruption.