Activity Stream

Guess developer did not know about Nz(). I remember when I learned about Nz() - it was a 'Hallelujah' moment. Same when I learned about UNION query.

some tips/code here might be useful http://allenbrowne.com/ser-62.html

Looking at the right hand form, you only need one "Run Search" button. the search button would have code similar to the Search Criteria code by Allen...

it would be easier to put the controls in a continuous form, in the header. no subform. the form shows all records. then user fills out the...

orange, I tried 4 times to install it - never could. So I gave up and eventually found the AotuMacro indenter. Any tips?

Steve, I'm using Smart Indenter on O365. Also there is an Indenter in MZTools.

You really should avoid using spaces in object names. You might also look at Microsoft Access Tables: Primary Key Tips and Techniques

That looks like Excel, but if you have an Access report, use the "Group and Sort" command in the report to set Group headers on the field "Group",...

How do you "lock down" the accdb? I have a form that opens when the user starts Access and when the user hits the button to close that form all open...

I agree. The whole NulltoZero thing makes me laugh. I think it was needed to make the calculations work. It's all unnecessarily complicated. ...

1. take a copy of your db 2. compact and repair I do this frequently depending on how often I make changes to the objects/code For attaching to...

when you get errors on normal functions, its a false error.... the actual error is in the references. which means you need the addcb. you must...

The height is what it is. Format event only triggers with PrintPreview or direct to printer, not ReportView. If you want to display null as 0,...

There's no file attached to your post.

Hard to make any suggestions without seeing the report, so I think all you're going to get is stabs in the dark. You can't UNION any of these fields...

If there is a date stamp you could easily show how many new records were added today or yesterday? There is some email code here...

Now it shows all 684 records need attention. Next hurdle is to get it to count only new records and then drop off the ones that have been correctly...

You're welcome. Always glad to help if I can.

@abosick, if you read what's at the posted link you'll see what the proper etiquette is. People who devote a lot of free time by regularly helping...

Agree with both. The vast majority of the posted code is about the email, which isn't the problem. What comes before and is related to what the user...

Thank you, Bob. That all works perfectly now.

Sorry, I've just realised my mistake. Try: Private Sub Form_Close() Forms!frm_Patient2.txt_School = DLookup("School_Name",...

You're very welcome! Cheers,

Here you go Bob. Thank you for this.