Recent content by Simonbegg

Tamar & Dan. Many thanks.

And thanks to all for the advice.

How do they plan to use the file?" Import into an SQl server. But they are insisting on | and field headings. I have suggested that I could put the file directly onto their SQL server as an SQL table, but no, they want a flat text file 'in case anything goes wrong'

Hello Everyone. Need to be able to export a cursor to a text file. That bit is no problem. The issue is that the reciever wants the field names as the first record. How can i do that? At the moment I am just doing... >Select curResultTable >Locate >Copy To &lcfullfilepath Delimited With "" With...

Stella, Thanks for the confirmation. Cheers Simon

Afternoon All, I would like to create an option group that looks like a set of traffic lights (red, amber, green). No captions on the option - just change the colour of the buttons as they are selected. As yet I cannot find out how to chnage the colours of the buttons. Any ideas? Cheers Simon

outlook Menu: "tools" "Send/receive settings" -> "define send/receive groups" In Window "Send receive groups" Highlight "all accounts", click "Edit" In right hand side 2nd check box down is "receive mail items". I want to programaticaly uncheck it.

Afternoon all, I am trying to programmatically alter Outlook’s Send/Receive settings so that only a Send occurs (i.e uncheck the “receive mail items” box). Anybody know where control/property is for this so that I can call it from VFP. Cheers Simon

Afternoon all, I am trying to programmatically alter Outlook’s Send/Receive settings so that only a Send occurs (i.e uncheck the “receive mail items” box). Anybody know where this control/property is ? Cheers Simon

Afternoon all, I am try to programmatically alter Outlook’s Send& Receive settings so that only a Send occurs (i.e uncheck the “receive mail items” box). Anybody know where control/property is for this so that I can call it from VFP. Had a good look round, but can't find it. Cheers Simon

Cheers Stewart, works a treat!

Stewart, Version 7. Had tried that, get the error "OLE IDispatch exception Code 0 from Excel. unable to get the copy property of the worksheet class." Cheers Simon

Hello all, Trying to copy a sheet within a book. The excel VBA code for this is : Sheets("Sheet1").Select Sheets("Sheet1").Copy Before:=Sheets(1) the bit I'm struggling to translate to VFP is the: Before:=Sheets(1) so can anyone tell me what I should out after: oexcel.Sheets("Sheet1").Copy...

Thanks folks.

Hello All Is it possible to grant db_owner (or any other admin role) permissions to a stored procedure, so that that specific procedure can run with "enhanced" permissions by a std user? Cheers Simon