Search results

Thanks for the SQL but it confuses me a bit. Seems like I have to create extra tables? I tried but still not working. Could you maybe post the sample db you did it on here?

Yes - true they are

@arnelgp - think I said thanks to quickly - I noticed that the orders don't line up with the dates. So at first it seems to work but if you look at the unfiltered lines, then the data displayed are not correct. Any idea?

@arnelgp - thanks a lot!

This would give multiple lines: SELECT Clients.Name1, Clients.Surname, Clients.CompNum, Orders.Code, Orders.DateCompleted FROM Clients INNER JOIN Orders ON Clients.ID = Orders.ID;

Hi all, I have 2 tables with a one to many relationship displaying orders for each Client. If I run a query on all orders by Client, I get multiple lines for each Client which is to be expected but I need only one line per Client displaying only the most recent order by date. Not displaying...

OK - I got it to work by first creating a batch file in VBA on the fly and testing it until it worked. From that I learned that I should put in 3 X quotes in from and behind the text containing spaces but although I did try it at some point I also had the command and argument split. It worked...

If I hard code it into Task Scheduler it looks like the attached screen shot. So I know if works but just to get it into the Shell command line...

Need some more help please: I'm creating my own Command Prompt reminders from a trick I saw on another site. However the syntax is escaping me: Shell "schtasks /create /tn MyApp /tr CMD /sc once /sd 03/12/2015 /st 11:36", vbHide Works 100% but I fail to add parameters or arguments to it I...

Seems like the space in my TaskName was the biggest problem This works: Shell "schtasks /create /tn MyApp /tr c:\test.txt /sc once /sd 03/12/2015 /st 11:36", vbNormalFocus

Hi all, I'm trying to create a task straight from the command line using the Shell command instead of first creating a batch file and calling that with the Shell command I'm sure I have a syntax issue somewhere with all the quotes Can someone help please? Shell...

Sorry I actually meant "SendObject" But nope - you right it does not cater for attachments if I remember correctly. Just Access objects with will not work for your pdfs How about storing all the pdfs on a webserver and sending the hyperlinks to the people as normal text in the email body? That...

Thanks to all for your input. I think this matter is now closed with the conclusion that the method will not work in A2003. Will look at upgrading on my side. Forgot to add this: The reason for my OP had to do with setting reminders from within A2003 writing to Outlook Task Scheduler and not...

Hi all, OK - I've stripped some of the lines from the code in the above link in #15 to come up with an ugly piece of code that does the trick. Maybe some of you can test it. Should just say "True" if "Microsoft Outlook" is found in the Installed Programs of the local machine. Refer to line...

The code in this post give me a whole list of all installed software and I can see Outlook in the list http://www.mrexcel.com/forum/excel-questions/535773-list-softwares-installed-excel-using-visual-basic-applications.html So in theory it must be possible to test for it by using much simpler...

@Minty - thanks - I tried it but with the same result ("False"). Maybe the VBA is limited to only checking the same version as Husky suggested Sure there must be a API does doesn't care about this If I remove the error checking I get the same thing on all scripts tried above. "ActiveX component...

@husky - sorry man - too many posts at once :) I hear what you saying. So you recon if you running Access 2003 you cannot test to see if the Client has any Outlook other than 2003 installed? If that is the case (which MarkK disagrees with in #8) these should still be a way to test for the...

Sorry for all the single posts but I tried: Access.Application and got true (running Access2003) Word.Application and got true (running Word 2013) Excel.Application and got true (running Excel 2013) So it is just Outlook that is sticky. Also tried MSOutlook Is there a way to display all apps...

@MarkK - Yes I did reboot. Also tried "Microsoft Outlook.Application" since that is the name on the taskbar and also the Process name in TaskManager Otherwise I must loop through all Folders eg: Office12, Office 14, Office 15 etc and check for "Outlook.exe" file name

@MarkK - Thanks - I tried your code but also got 'false' in reply Any other way of checking for Outlook maybe using a API