Number11's latest activity
-
NNumber11 replied to the thread Solved Help this is not working - Dlookup.this was correct and worked If DCount("[Account No]", "Master", "[Account No] =" & Me!AccountNo)>0 Then many thanks
-
NThen try If DCount("[Account No]", "Master", "[Account No] =" & Me!AccountNo)>0 Then
-
NNumber11 reacted to bob fitz's post in the thread Solved Help this is not working - Dlookup with
Like.
Perhaps you need a space in Me![AccountNo] too If DCount("[Account No]", "Master", "[Account No] =" & Me![Account No])>0 Then -
NNumber11 replied to the thread Solved Help this is not working - Dlookup.Thanks working now :)
-
NNumber11 replied to the thread Solved Help this is not working - Dlookup.in the table it is Account No and on the form the field name is AccountNo
-
NNumber11 replied to the thread Solved Help this is not working - Dlookup.Thanks but this is not working at all still, even if i try and eneter with say account number 999 it promps me but nothing in the table...
-
NNumber11 replied to the thread Solved Help this is not working - Dlookup.No its a number field?
-
NNumber11 replied to the thread Solved Help this is not working - Dlookup.same didnt work If not IsNull(DLookup("[Account No]", "Master", "[AccountNo] ='" & Me!AccountNo & "'")) Then
-
NI am trying to get this to work, so the form has this and i want it to promp message if the customer is already on the database, but...
-
NNumber11 replied to the thread Query date.So i have the query linked by the "Customer Ref Number" with criteria "is not null" - this bring me a list of all appointment requested...
-
NNumber11 replied to the thread Query date.brings no results at all :(
-
NNumber11 replied to the thread Query date."Customer Ref Number"
-
NHi, So I currently have a query that looks at a table with appointment requests against a another table Appointment Booked and then...
-
NNumber11 replied to the thread Sending an email with attached report - dont sent if nothing attached?.Oh ok sounds good how would i go about setting this up
-
NNumber11 replied to the thread Sending an email with attached report - dont sent if nothing attached?.Ok so sometimes it falls over afte this point... .Attachments.Add "File name and locatin here" & Format(Now(), "DD-MMM-YYYY hhmm ") &...