Recent content by MrJRW

Problem solved I was setting the value of LogNumber via the Default Value property When I changed to setting the value of Me.LogNumber.Value in an event (LogNumber_GotFocus), the update query worked ! Thank-you all who helped. MrJRW

This is too weird. The MsgBox for strSQL yields: UPDATE tblWarrClaimLog, tblClaimNumber SET tblWarrClaimLog.[SEQ] = tblClaimNumber.[ClaimNumber] WHERE tblWarrClaimLog.[LogNumber]='WARR-2012-0090'; ClaimNumber was at 0090 when I ran this. The MsgBox for Me.tbxLogNumber.Value gave...

My Sub: Private Sub tbxNameofParty_Exit(Cancel As Integer) Dim strSQL As String Dim strLogNumber As String strLogNumber = Me.tbxLogNumber.Value strSQL = "UPDATE tblWarrClaimLog, tblClaimNumber " & _ "SET tblWarrClaimLog.[SEQ] = tblClaimNumber.[ClaimNumber] " & _...

Mr. PHV, Thank-you for your help. Removed spaces. Tested.... No joy In my earlier post I ment to say I don't know how to use debug.print (not you debug.print) Now you see why this issue has been vexing (great Scrabble word by-the-way) me ! Again, thank-you for your help MrJRW

MazeWorX, Thank-you for trying to help me. In the control for the Log Number, (tbxLogNumber) I set the Default value to: ="WARR-" & Year(Date()) & "-" & Format$(DLookup("[ClaimNumber]","tblClaimNumber"),"\0000") Hence, the "-"s. I don't know how to you debug.print MrJRW

Whoops ! Typo in my write up. What I have coded is: Dim strSQL As string strSQL = "UPDATE tblWarrClaimLog, tblClaimNumber " & _ "SET tblWarrClaimLog.[SEQ] = tblClaimNumber.[ClaimNumber] " & _ "WHERE tblWarrClaimLog.[LogNumber]= ' " & Forms![frmWarr_NewClaims]![tbxLogNumber] & " '; "...

Good Morning. This one has me really, really, confused. (and frustrated !) This "mdb" is to track warranty claims received. Table 1: tblClaimNumber, one field: ClaimNumber. Integer - defined as four (4) digits: 0001, 0002, etc Table 2: tblWarrClaimLog 5 fields: LogNumber (text)...

Thank-you all. My problem has been solved ! My solution was to add two (2) lines after the SYBASE.sh script: #!/bin/sh . /sybase/STG_12.0/SYBASE.sh <<<<<< New lines added here >>>>>>> PATH=/usr/bin:$PATH export PATH START_DT.... O.K. to close. JRW

O.K. Is there a something I can execute (.profile ?, .login ?)that will set the various environment variables that need to be set ? JRW

MadMichael, Thank-you for responding so quickly. I'm a little confused. When I run the script manually, I'm logged in to UNIX as sybase. This entry IS in the user sybase's crontab (/usr/spool/cron/crontab/sybase Shouldn't being in sybase's crontab already confer the attributes of the sybase...

Good Afternoon. This one has me scratching my head. I have a Sybase data server running on a HP-UNIX host. I've created a script that backups up the databases on the Sybase server. When executed MANUALLY, the script runs fine. Before doing the backups, the script deletes the earliest backup from...

Good Afternoon As part of a SSIS package, I have a task that exports a table to a text file. One of the fields is a datetime data type. When exported, the datatime data is being stored as "YYYY-MM-DD HH:MM:SS.SSSSSSSSS" That's correct; nine decimal seconds. I need to import this text file...

Problem Solved !! The problem actually lies in the 11th line: Set oFile = oFSO.OpenTextFile(DTSGlobalVariables("TransferFTPCommands").Value,2,1) Where the variable "TransferFTPCommands" is the path/filename of the text file the FileSystemObject is trying to create. It turns out the drive...

Yes, The DTS package has been imported to the Management/Legacy/DTS listing; From there I can open/edit/run the package; I've been able to execute the indivual tasks. Only this one task remains not working. JRW

I have a DTS package that has an ActiveX task that uses the FileSystemObject to create a FTP batch file. I'm now trying to run this package from SQL Server 2005. Because of this and other tasks that won't migrate, I'm running this DTS package from a "Execute DTS Package Task" in SSIS. The task...