Search results

Right, we need to concentrate on one area at a time. Can you please tell me your first query in detail and i will see where i can assist.

Hi Rammudali, many thanks but it works now therefore i no longer require assistance for this particular issue, although i'm sure i'll need some assistance elsewhere. Many thanks for your help once again. V

Hi, i did double checked and i was getting blank rows. Yeh sure thats fine. But i do not have any issues with either queries. Many thanks for all your assistance. Best wishes:D

Hi, I've got it to work, did some digging around and found a working method! :) copied from a website: In Microsoft Access, how can I prevent records with blank fields from appearing in a report? In Microsoft Access, to prevent records with blank fields from appearing in a report: Open...

Many thanks, I have tried setting properties in subreport and main report canshrink = yes but still no luck. On the same note, if some records on subreport are populated and some records are empty, how do i stop the empty ones from showing? Thanks for your help

Hi, I've been researching on how to hide a sub report if there is no data within. Basically i have an access database that enables me to run a register report, now linked to the register reports is a subreport that is for special requirements, so if that particular employee has any special...

Hi, I've got VBA to open Outlook and create an email but as i have 3 different Outlook profiles i need code that automatically selects the profile. On a button, once that is pressed it opens an email with pre written text then sends it but then closes Outlook and reopens outlook, but this...