Recent content by Smudger Smith

I have been searching but not getting very far i'm afraid. I promise ghudson that i always search first! - I am just an ego covered in skin so asking for helps REALLY hurts!

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

Cheers Ken - I really appreciate your help on this. Thank you so much

thank you so much

Hiya, There are no nulls in there as they are taken out when the table is created. Does that help?

I think you have hit the nail on the head there. What you see is what you get on the module front. I am very 'OLD SKOOL' and mainly use Queries and Macros, only venturing into VBA when i really have to. So... How do i loop and how do i get it to start from the top and work down the list...

How do i do that then?

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

Thanks Mike - Great and speedy response!

oh - yeah - should have said - I want to do this in a query and NOT vba - Thanks Excel equiviemt would be =mid(a1,((find("\",A1)+1),99)

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

Thanks to you both. Indead the "[..]" did work and shame on me for using spaces! Thanks again!

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

Pleasure, I have not found it either - In the end I cheated, stayed with Outlook 2003 and installed Express click yes. Works fine but obviously not the best solution.

Lagbolt - You are a star - Thanks so much for this - You have saved me from a certain Ulser Cheers Smudger