BleepingComputer.com: Access macro help

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.

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Access macro help

#1 User is offline   FunkyChicka 

  • Member
  • PipPip
  • Find Topics
  • Group: Members
  • Posts: 110
  • Joined: 15-October 08

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

#2 User is offline   tos226 

  • BleepIN--BleepOUT
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Members
  • Posts: 1,412
  • Joined: 21-October 04
  • Gender:Female
  • Location:LocalHost

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 User is offline   FunkyChicka 

  • Member
  • PipPip
  • Find Topics
  • Group: Members
  • Posts: 110
  • Joined: 15-October 08

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 User is offline   jimhaddon 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 10
  • Joined: 19-June 09

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

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users