Search results for query: *

Hi, I'm sending an email message and my code below worked (at home) - the smtp setttings that I used didn't require a secure connection. I tried on different machine (clients) and got the message above. How can I add get this to go away? Set objEmail = CreateObject("CDO.Message") Set...

Thanks I used the link and got an email message. I now have to test it on the real machine Thanks again Grd

Hi, I'm now able to get the information I need (using skipline and skip methods) - I now need to send this info via email. I have outlook on the machine and it is able to send and receive email. I don't have to send through outlook if there is another easier way. Is this complicated? Tx again Grd

make sense and works now a little bit closer... tx

Hi PHV, Thanks for the link. I needed this to get started. Now I have ' VBScript: Trying to open and read a line Dim fso Dim MyFile Set fso = CreateObject("Scripting.FileSystemObject") Set MyFile = fso.OpenTextFile("c:\Logs\testfile.txt", ForReading, True) MyFile.Close I'm trying to use...

Hi, I have a log file generated everyday which is called Log followed by the date 03122009 so the name is Log03122009.txt Its on the same machine where I'm running my code C:\Logs\. On the second line (not at the beginning) I have the following: Record Counts: 333 I would like to open up the...

With the testing I've done it works. The file gets closed if its open. I removed the wscript.echo so it runs unaided. Tx again

Hi, I need to automatically check if an Excel file is open and if it is I want to close and save it or just close it without saving changes. I can do VBA but new to VBScript, so I understand things like Option explicit and Dims. The excel file is on the machine (Win2003 Server) where I would...

Perfecto!! G

Hi there, I have a report which has a list of pay periods for my employees. Its just a list report with no groups. The data looks like this Joe 1/1/2009 JOe 8/1/2009 JOe 15/1/2009 Some pay periods (i.e. certain weeks) are missing and I'd like to have it say missed after the record...

update changing the set datasource properties worked Tx G

Thanks lbass, I'll check this option out.

Hi there, My subreports are all prompting for a db login (to Oracle) despite the fact that both them and the main report are coming from the same database. I'm using Corral Viewer (a free viewer from Groff Automation) to run these reports. They don't prompt in Crystal Designer. Is there...

Thanks everyone These are working (I thought it would be a much harder formula)

Hi there, I've had a request to filter a report by the last month's data but to exclude Mondays! I've tried quite a few things but my formula is not quite working. Could anyone give me a heads up about how to approach this. Its harder than I thought when I said it was possible. Any help or...

Thanks lbass and Ido, the lastfullmonth function is what I need

Hi there, I need to filter my {CustName} field to certain customers - lets call them "acme1", "acme2" however I need to narrow it for the last full Month. I can filter using a between however I don't want to have to keep changing the formula. Any help would be greatly appreciated Thanks Suzanne

Thanks KsKid, I'll have another look at it with this in mind and see if it makes more sense. G

Hi Lbass, Tx for the reply. I'm trying to understand the SQL statement - to figure out what its doing and I can't. You have the sales table (in my case its the Orders table) as Table A - however then you have it linking to Sales again. Is the table linking to itself? Sorry if I'm being dumb...

Hi there, I had this question asked of me and I don't think its possible. We have a report grouped by Sales Person and we have an inner group based on month. We see the best month for each salesperson (the innergroup has a summary and its set to show Top 1). This works great - shows each...