Search results for query: *

Well I got it to work on test tables with no problems. The problem I am having now is that it won't delete the rscords in the table I want. When I try to delte the rows manually it gives me this error: Cannot remove last status entry. Status is the name of the table. TIA

I tried the script but it didn't delete anything. At the createdate I replaced it with the colun name SDT. It uses a smalldate time field.

Would you happen to know where I can get a good script to do what I need or how to rewrite this one?

I'm trying to delete records that are older than one year through a stored procedure but haven't been able to do yet. Anyone have a sample script that will do that? I have tried a few that work on tables that are not connected to anything and they work but not on connected tables that are...

Yes, it was the first thing I checked. I found a script that is put into a command button that protects the form with a password but it is not what I'm looking for. I want to be able to go into a hidden table and change passwords when I need to but everything I find is for .mdb database types...

I am trying to password protect a form in my database. I'm using SQL as my back end. The password form comes up as I open the form I want. Once I enter the password it sends me to visual basic. When I hover over the script I get some errors. The errors are next to the scipt in brackets in...