Recent content by vanceric

Unfortunately I think that wouldn't really work in my instance as well as using a DB Property. For instance if my end user changes the file path where they export data from "X:\Stuff\" to "Y:\Stuff\" I need a simple form where they can just go change the directory that an export button points...

I've changed the extension to accdr which forces the application to run in runtime mode even if the user has the full version of access. Seems to do the trick for what I need.

Exactly what I needed. Simple and it works. For anyone interested in the end result

It may not be the best solution but you can skip error trapping and just add On Error Resume Next It will skip the line of code where the error happened but it needs to be added to every function where you could encounter an error. There's not global solution I'm aware of in Access.

Try Expression is [TextBoxName] Like "N" Change TextBoxName to the name of the text-box you want to format.

Thanks for the reply... my issue with a table is that I would only need 1 record to accomplish the task and if the form for input got switched to record number 2 they may not be able to get it back to 1. I know I can disable navigation but it still scares me. Could you elaborate a little more...

Hello everyone. I have a little issue and I'm not sure what the best approach is to fix it. I've built a rather robust database that needs to be idiot proof. Chances are after I leave there will be little to no back-end maintenance on it. There are hyperlinks throughout the database as well as a...