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

Well it did work and changed 3 or 4 reports, but didn't work fully for me. After wondering why it only found and replaced 3 reports after opening the lot, I now realise that the vast majority of my reports have bound Word docs in there with that text, so have to find another solution now again...

Thanks for the quick reply. I will give it a try and report back. Thanks again.

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

This may be your lucky day JIK... I have found they answer for myself and it works without any hard coding... Let me know if it helps you as my hours of trial and error seemed to finally help me from tearing all my hair out :) If you save your background image or your logo as an EMF (vector...

It' would be much better if Microsoft simply would allow non compressed PDFs as sendobject or allow a third party to do the pdf conversion as you simply cant send objects as pdfs with logos or images as not professional rnough. I can't get manage to get a routine to work in outlook as I'm not...

Hi, thanks for all the help. Converting to SQL server sounds good, (and im told we have SQL server on our work sbs2300 server), main issue I have is once converted, how easy would it be to convert back to Access every time I need to modify the database? I can't programme, hence access is so...

Thanks very much for your help. I may convert the database to access 2010 to take advantage better. Can you advise me where I can buy some sharepoint space online thats is reliable but not too pricey, that supports access 2010 and keeps its easy to start so I can start playing? My database is...

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

This looks like a spam message for a peice of software unrelated to the thread. If you find a way to convert to a non lossy PDF via a macro for emailing than respond to this thread.

Hi, Thanks fr that. I have tried but access still compresses it, even further I'm afraid. Until Access adds an option that you can choose high quality when you send as PDF I think the only way is to write the via and save first, then send from where it saved with same options then delete it...

Hi, I am still stuck with this so would appreciate you sending me your code (you can PM me if you want, and just tell me where I shoudl install and tweak it) and I will do the rest :) Apreciate your help very much..

Hi, Did you ever file a solution to your problem? Im still stuck on this one. I reasearched alot but seems only way to email a high res PDF is to Save it first on to your hard disk (as you can choose a higher resolution through Access) but then teh problem is that you cant use SendObject...

I wish I knew, people before says its a good answer but I have spent te last 2 days trying to work this out :( I may have to find an access guru to do this job as I'm simply lost.

Hi Uncle Gizmo, I did piost about it a weke ago, but no luck since then. I have had an answer that "You will be looking at automating it using the Outlook object or other e-mail object."but I dont want to automate it, it doesnt help at all. Sincerely looking for a way to see if we can change the...

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

Thanks for the NZ method. That part works. Is there no way to send a high quality PDF by email? it seems by default Access optimises it for screen...

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

Well i played with it a bit more and seem it doesnt like .Email2, .Email3, I basically took out everything after that... Weird