Search results

  1. S

    Large Recordset, Large Search Criteria

    Hi All, Ive got a pretty difficult task in terms of size. I have a table which has 629326 records in it. And I have to extract * where tlGLCode = 841 criteria. Obviously the idea method would be to SQL statement it, but SQL cant handle that many conditions. So I thought, I'd knock up a...
  2. S

    Question Creating data relationships using subforms

    Hi all, I am doing this for a friend, and personally don't have a great deal of expierance using Access! Basically I have set up 3 tables : tblEquipment equipmentID item (being its name) room (where its located) tblExperiment experimentID name date tblRelationship relationshipID...
  3. S

    Comparing A date to a date

    Hi, In my database set up I have a field called start date which is a shortdate datatype. When I compare the information from a date picker I get a data type mismatch error. Could you help? Set rs = CurrentDb.OpenRecordset("SELECT ID, startDate, endDate FROM tblLeave WHERE startDate > '" &...
Back
Top Bottom