Search results

Thanks for the reply. ?? All the code works except for the portion that I have added. Dim varInDNC As Integer varInDNC = -1 forget the name, but another member provided me with the rest of the code. My purpose for setting the Y/N is for nothing more than criteria for a...

Well I've always like a challenge..... Here is what I am trying to do. Private Sub Phone_AfterUpdate() Dim strSQL As String Dim rsPhone As DAO.Recordset Dim varInDNC As Integer strSQL = "SELECT * From tblDNCList " & _ "WHERE PhoneNum =...

I want to set a y/n if a previous result is true or specific value. Is it more efficient/easier to use a query or code?

I have a simple query for a report, but I can not get the query to exclude a specfic value. Ex: Not Null or = xyz Where "xyz" is the value I do not want excluded. Thanks in advance.

THANKS!! Your code snippet worked great... I greatly appreciate the help. I think I will be looking into a course or two due to the fact I clearly do not know what I am doing. Thanks again! Here is what I ended up with for others reference. Private Sub Phone_AfterUpdate() Dim strSQL...

sorry forgot to paste the code..... (Let see if i do this right) Dim db As Database Dim rsTable As Recordset Set db = CurrentDb Dim strNum As String strNum = "tblDNCList.PhoneNum" Set rsTable = db.OpenRecordset("tblDNCList") If strNum = Me.Phone Then MsgBox...

Thanks for the direction. Unfortunately I maybe a complete dope. I picked up a book on Access VBA (the yellow one) and this is what I came up with based on your direction and examples. Doesnt seem to do anything though. I think I'm going to need some handholding through this...

I am new to VBA, as you will soon see... :confused: , and have limited experience in Access as well. BG: I agreed to develop a database for my company for the purpose of tracking and logging marketing calls. I have created a flat table to track the individual potential customer data, and by...