Search results

  1. P

    if query is null

    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...
  2. P

    function & syntax

    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...
  3. P

    Split 1 record into array

    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 ?
Back
Top Bottom