Search results

Hi all, Recently we have had a second user, so I put the database as a whole on a mapped drive on sbs 2011. Of course the first power cut crash and the database got corrupted so yes, splitting FO and BE now. I just kept together for ease of changes and edits but I will keep it split from now on...

Hi Guys, I have been struggling for hours trying to do a conditional formatting to change color if the date on the form If i was looking to highlight any date this month then it would be easy. I'm actually trying to highlight a "cut off date" that always finishes on the 15th day of the current...

Hi all. I have been trying to find a solution to avoid doing this manually but can't seem to find a way in Access 2013 or 2016. I have hundreds of reports (used for mailing different letters), and I need to do a find/replace on all instances where the report contains the text box ="Yours...

Hello everyone, I could do with a bit of knoweldge from someone as cant seem to find teh details on the help files. Does anyone know if it is possible to have the tables only of an Access 2007 table saved online, and the front end offline on a few Windows machines that have Access installed...

Hi Guys, I have been trying for days to find a solution. I have a Macro that emails a PDF using the SendObject command, but the PDF attached always loses some quality on the images within it. I have Googled about this and found that there is a setting called acExportQualityPrint and...

Hi Guys, I use Access 2007. I cant seem to work out thge best way to make this code work. Two issues really. Firstly if email2 or email3 do nat have any data, my code crashes, so need to rewrite it so that it still works even without email2 or email3 having data. Secondly I dont seem to...

Hi All, I have converted a macro to code as I need to add acExportQualityPrint so my PDF that gets emailed retains good quality. I would have just kept it as a Macro (if anyone knows how to do it within Macro) but by efault the Macro doesnt have the option to change quality on sendobject. So I...

Hi Guys, I have been breaking my head trying to make this work. I have a problem with an invoices database, and Im trying to get a report that will list all my unpaid invoices in date order but group them together by company name so we see all invoices of that company (but the oldest...

Hi Guys, I was wondering how to do this. We have Access 2007 datanbase built and my Database has sensitive data includind clients details, staff salaries and invoices etc. i Created 1 database to just hold the all table data. Then a full blown databse linked to the tablesm with all the...

Hi Guys, I have written a nice small access database but im banging my head against a wall wondering what I should do next and how to do it. I run a small company and clients submit order details online through my PHP website. This currently comes to me as a simple email with fields filled...