Recent content by jackb1117

Yup, I am embarrassed. Tossed the me. in front of the control names, and realized that it was trying to call a control I had renamed, hence the error. Thanks for the help folks!

Thanks for the reply! I did try that, with the same result, which makes me wonder if it has to do with something other than the SQL syntax that particular line is building. I will try again in the morning in case I am mistakenly remembering trying that, and will check back in. Cheers, J

Hey Guys, Having an issue with what I thought would be a simple couple lines of code, but I keep getting kicked a run-time error (object required), and I can't figure out why. Basically I have a form where a user has selected a couple values from a dropdown element, and entered a few...

Thanks for the reply, ghudson. I agree- an odd setup for sure. There unfortunately is a business need for this. Cliff notes from a process perspective: End users have some data they run against a couple of tables in the DB. Based on the results, they make some decisions, and then either add...

Hello All, I am relatively new to developing with Access, and brand new to this forum. I have a question about locking down an access database. We have a database that lives on a shared network drive, and is shared by ~12 users. Becsuse of the nature of the function of the database and the...