Recent content by PipSmalls

Thanks for the reply, but that would not really be suitable in this case. Anyone any other ideas ? could it be the [date] part ? All i am looking to do is check if a record exists for a certain date..surely this must be simple ?

Hi, can anyone tell me what is wrong with this function ? It keeps coming back as no data, even though there is a date set in the table. Public Function ifdateexists() If IsNull(DLookup("[TT.date]", "qry_TT", "[TT.date] =" & Forms!TT!frm_date![txt_searchdate])) Then MsgBox "no data" Exit...

Thanks Rich, but what i am trying to do is replace the Me.myTextbox on the fly, so it adopts the 'clicked' variable

Hi, I am trying to write a function and am having diffuculties with syntax and how to go about it. When a use clicks on a textbox, i want to set a variable which is basically the name of the box. I then want to have a public function find out if that box has any text in it. Private Sub...

Hi, I am looking to retireve 1 row from a table based on a query. i.e. select * from TT where id="1" I then want to put the entire contents of this into an array. The array will hold the id,date,number,text,text,text,text...etc How do i do this ?