Search results for query: *

I have a VFP6 exe incorporating a report including fields in currency format. On my and other NT4 machines, the report prints with £ symbols. On a Win2000 machine it is printing with $. In all cases, all regional/locale settings are English (UK). The exe was compiled with 'Use System...

I am using Excel 97 SR-2 on Windows NT4 SP6. System regional settings are English (UK) with short date format of dd/MM/yy and long date format of dd MMMM yyyy. My VB code is : ActiveCell.NumberFormat = "dd/mm/yyyy" ActiveCell.Value = "01/02/2003" This displays as...

My Visual FoxPro 6 code programmatically opens an Excel workbook through COM with objExcel.Application.Workbooks.Add(<Filename>) This works fine except when the workbook is marked for sharing. In that case, it loads OK but immediately displays a Save As dialog with the default filename of the...

I am using a DTPicker control in a VFP6.0 form. I set the control's properties in the form Activate event, eg: WITH oleDTPicker .Day = 1 .Month = 2 .Year = 2003 .Refresh ENDWITH This works fine and the correct date is displayed. A user selects a data set from another control in the...

The last piece of code in the READ WHEN clause of my screen is : BROWSE FIELDS Changes.ControlTxt :20 :H = 'Item', Changes.OldValue :20 :H = 'Old Value', ; Changes.NewValue :20 :H = 'New Value', Changes.Status :15 :H = 'Status' ; NOEDIT NODELETE NOAPPEND NORMAL NOMENU NOWAIT ; TITLE...

I need to make secure (ie prevent tampering) the data for a large 16-bit legacy application running under Windows NT4. My thought is that I use Windows security to hold the data with access limited to a single user account. I then wrap my legacy app in some VB code that uses LogonUser and...

My function has been passed a control as a parameter. Please could you explain how I determine whether it is a member of a control array?

Please could somebody suggest a way of identifying the live connections to a SQL database from within a stored procedure. I am logging user activity into a table but, if a connection is lost as a result of system error or hardware failure, I have no way of logging this. I awnt to be able to...

Please can anyone tell me how to identify the domain name under which the user is logged on in NT4 (both local machine and server ae NT4)?

I would welcome some advice on how to structure a VB dll so that I can create my own extended stored procedures. Do I need any special components, structures, etc? I am a competent VB programmer but a novice at SQL Server.

I have a document management application in VB6 running on NT4 SP6. I embed an instance of Word in my VB form using the SetParent API and disable its system menu so that I have full control of size, position, etc. I also want to get at its user menu so as to control what the user can do...