fizz_uk83
02-24-2005, 03:57 PM
Hi, I'm new to access and am trying to generate a report using values from excel... Basically on a form 'AnimalSelection' in access I will type the name of an animal in the animal text box and press the generate report button. When pressed, the excel sheet 'Enemy' needs to open and be searched for the name typed in the text box. When found the name of the animal along with the name of the enemy associated with it needs to be inserted in to the report in the locations specified in the report....Im really struggling with this as i dont know much VBA http://www.utteraccess.com/forums/images/icons/frown.gif
....I have attached what I have so far....any help would be really appreciated..
thanks
Faye
-x-
....I have attached what I have so far....any help would be really appreciated..
thanks
Faye
-x-