Search results

Hi Anyone, I have built a simple DB that churns data and kicks out a Spreadsheet. I want the spreadsheet to have a date stamp on it ie All_Emps_01012010.xls is this possible and if so, how? Currently i have a macro that does 'TransferSpreadsheet' Thanks for any help

First off, I have tried to find an answer but with no luck. I want my Access DB (2002) to send via e-mail (Outlook) to a number of addresses. The mail will send to the LAST person on the list but not to all people. Help would be really appreciated...

Anyone? Here is my dataset example: \a1234 blah\a1234 \a123456 etc - I'm sure you get the idea ;o) I need a way to capture JUST the characters after the "\" I have not used Access 'properly' in over a year so i am more than a bit rusty. Thanks for your help

Hi, Can anyone please tell me what I am doing wrong here? SELECT * from Qry_300_Sel_In Jan not Dec UNION ALL SELECT * from Qry_301_Sel_In Apr not Dec UNION ALL SELECT * from Qry_302_Sel_In Jul not Dec UNION ALL SELECT * Qry_303_Sel_In Oct not Dec; It is telling me that my syntax is...

I have some code (Below) that I have used to send e-mails via outlook. Thanks to Mr Gates I can't do this any more - Looking at varioous threads it seems I have to use SMTP? How the heck do i change this to SMTP Guidance please as I have an internal customer on my back about this (And he is...

Hello, I can't figure out what is wrong with this: Public Function SendEmail() PROC_DECLARATIONS: Dim olApp As Outlook.Application Dim olnamespace As Outlook.NameSpace Dim olMail As Outlook.MailItem Dim dbs As Database Dim rstEmailDets As Recordset Dim strSender As...

About 2 years agao I created a FABTASTIC database in Access that was scheduled to run each day. Since then I have move companies and now can't remember for the life of me how to create this in Microsoft Scheduler. I can get it to open Access, but not a specific .mdb and not a specific Macro...