AndrewKent
03-09-2009, 03:14 AM
Hi there,
I am trying to transmit data to and from an Excel worksheet to an ".mdb" file. However if I try and recall a record from the file to excel where the primary key doesn't exist, I get a EOF BOF debug.
I want to put in an IF statement that will firstly check if the record exists in the table before it trys to return it.
How can I do this? I think I have to check if EOF BOF is true but I don't know how to write the syntax, can anyone help?
Andy
I am trying to transmit data to and from an Excel worksheet to an ".mdb" file. However if I try and recall a record from the file to excel where the primary key doesn't exist, I get a EOF BOF debug.
I want to put in an IF statement that will firstly check if the record exists in the table before it trys to return it.
How can I do this? I think I have to check if EOF BOF is true but I don't know how to write the syntax, can anyone help?
Andy