Recent content by KLerma

I will look into both ideas. Thanks again, Kev

All, I have a question about security withing Access. I have a rogue user that loves to create/modify my forms and code behind the form. I need to know how to stop him from doing this. Any ideas?? Thanks, kev

That was the ticket!!! Again, this forum rules and u guys rule Kevin

All, I am looking to get a count of a record set and dump it into a variable. I attempted to do the following: docmd.runsql ("select count(*) from Schedule where pdate is between" & variable1 & " and" & variable2. I learned from another post that runsql requires action. HOW DO I DO...

All, I just upsized my from access to SQL Server and I am having some issues with a form. Let me describe the form. The form has a couple of unbound text boxes and a submit button. The submit button runs some vb code that builds a sql statement based on what was in each unbound text box...