Search results for query: *

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

Cheers gents

Mike, at the moment just calling an outlook object: oOutLookObject = CreateObject("Outlook.Application") oNameSpace=oOutLookObject.getnamespace('MAPI') oNameSpace.logon(Outlook,,false,true) oEmailItem = oOutLookObject.CreateItem(0) The oNameSpace.logon(Outlook,,false,true) line forces the use...

I ought to be more specific..... We are running a VFP app on a citrix box. Part of the App sends emails. When a user connects for the first time and tries to send the email Outlook demands that they create an account I.E. Create a profile. How can I stop this from occuring and forcing outlook...

Hello all, Can anyone tell me how I can specify which Outlook profile (WORK as opposed to PERS) is used to send an email from VFP. Thanks in advance Simon

Hello everyone. I have just built a PC for a German Client. I have used windows 2000 SP4 and Office 2000 Pro german editions. IE6 is also German. Infact the only non german software used is Winzip and Acrobat 6.01 reader The trouble I have is that some menu items are in English and some in...