Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Access macro help


  • Please log in to reply
3 replies to this topic

#1 FunkyChicka

FunkyChicka

  • Members
  • 124 posts
  • OFFLINE
  •  
  • Local time:02:32 AM

Posted 18 March 2009 - 11:26 AM

I was wondering if anyone could help please

in Access is there a way to create a macro that is linked to a report? eg. i hav a query that i've linked to a report, but sometimes there are no results in the report, so a blank report just shows. is there a way that instead of the blank report appearing when there are no results, there is a message box that says 'no results' or something along those lines?

thanks

BC AdBot (Login to Remove)

 


#2 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,577 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:10:32 PM

Posted 18 March 2009 - 04:37 PM

Most likely, but I'm not sure, if you put a calculated field in the footer of the report and the calculation says something like 'if number of records=0 ... put out "No records".

#3 FunkyChicka

FunkyChicka
  • Topic Starter

  • Members
  • 124 posts
  • OFFLINE
  •  
  • Local time:02:32 AM

Posted 22 March 2009 - 09:34 AM

i have another issue now. I've mail merged between access and word but now i dont know how to create a button with a macro to run the mail merge. the mail merge is dependent on a parameter query.

could anyone help me out please.
thanks

#4 jimhaddon

jimhaddon

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:09:32 PM

Posted 19 June 2009 - 05:08 PM

Hi...

You could write some VBA code to display a msgbox for your blank report. On the report there is an event called 'OnNoData'. If you add code to this event, when your report is blank, you can display a msgbox with something like 'no data found'.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users