Search results

OK I fixed it as below; and the compile error message is now gone, only to be replaced with a new one. "an expression you entered is the wrong datatype for one of the arguments".. Any ideas? Option Compare Database Option Explicit...

Thanks Pbaldy but I still cant get my head around it. No matter how many commas I add its still breaks. Any more help on how it should look? I really am stuck on this. Thanks very much.

Thanks for that but unfortnately im still getting the compile error syntex message. for your reference, I have colour coded exactly how it looks. Maybe that helps? Option Compare Database Option Explicit '------------------------------------------------------------ ' INVOICEFOREMAIL '...

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 PNGBill, Thanks for your help. Unfortunately it doesnt work. It seems when I set a group in a report it wont let me sort via another field this way. Im still stuck. I added a Group called CompanyName, but it will only let me sort by A-Z or Z-A first and only then by Invoice ID. What...

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, Thanks for your response. I actually did mean linked rather than imported. I have thought of renaming teh file, however they can easily rename back so its not really an option - or is it??? Thanks Don

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