Search results

Geez thanks for pointing that out! Well ive fixed that, and when I am just retreiving one column I get, what I would expect, but when I call more than one column I just get the lonely first two parts of the record like before; and it appears to stop the search. Its so weird. Ive mixed up what...

mainText is the name of the text box im using :)

Hi thanks for the reply. The field is not null, and what im finding if I click my button which runs the code (which I have now modified as you have suggested) theres a slight pause, the first two items come up as ive shown above, then if I click to another window and then click back I get ...

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

Update: I have added a combo box to the subform, which lets me select a record, however when I do so, instead of selecting an existing record it creates a new one. Even more bizarely, it takes the original equipmentID and sets that as the name of the new one, despite showing the name in the...

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

Thanks a lot! Did not know about #!

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 > '" &...