Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by relms
-
Securing database in Access 2000...doesn't work like '97 did :(
I've been working on this off and on for a while. I thought that I had my database working the way I wanted it, but today I found out that I was wrong. In Access 97 I was able to make it secured so that you can log onto it if you have the MDW file (Removing all permissions from the 'admin'...- relms
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
Update and Delete RunSQL using parameters set inside a VB Module
AWESOME! Worked like a charm! Thanks Rick!- relms
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Update and Delete RunSQL using parameters set inside a VB Module
I have been trying to get an update and a delete RunSQL statement to work using the parameter "DeleteDate" which is defined in my VB Module (I have no clue if I'm using the correct terms...). Anywho, here's the code I'm using. Dim DeleteDate As Date DeleteDate = #5/5/2002#...- relms
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Need "IIF" Statement to pick between 3 fields
This should work. IIf(Field3 Is Null,IIf(Field2 Is Null,Field1,Field2),Field3) Translated From: If Field3 is Null Then If Field 2 is Null Then Field1 Else Field2 End Else Field3 End- relms
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
