check if record exists (1 Viewer)

[gisler87]

Hi,

I am creating a cd borrowing system. currently i have a form that shows the borrowers name and details then i have a subform that shows all the cd's they have borrowed.

in the subform i have a button next to every cd borrowed that will allow you to renew the loan.

what i am trying to do is when i click on the renew cd i would like to check if the cd has been reserved. i have tried using a macro by opening up a query and then checking a field but i keep getting "object does not contain automation object...."

any suggestions would be much apreciated

Many thanks

gisler

 

[boblarson]

but i keep getting "object does not contain automation object...."

Usually when that error occurs it is because you tried putting VBA code into the event PROPERTY on the property dialog instead of actually into the EVENT in the VBA Editor.

See here:

http://www.btabdevelopment.com/main/LinkClick.aspx?link=56&tabid=55&mid=385

 

[gisler87]

No i am using an embedded macro. the macro is opening up a query and then i am checking a field to see if the value is empty.

many thanks

 

[boblarson]

No i am using an embedded macro. the macro is opening up a query and then i am checking a field to see if the value is empty.

many thanks

You might have to use VBA.

 

[gisler87]

any method that would be good to do this? at least to get me in the right direction. i am unexperienced with vba but feel i can learn it if i just know where to begin.


thanks for all the help

 

[boblarson]

Here's a good Tutorial on VBA:
http://www.functionx.com/vbaccess/index.htm