Search results for query: *

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...

SQLBill, I solved it. I found a post on the net: http://west-wind.com/weblog/posts/2928.aspx The easiest solution is to install Books Online locally. Thank-you again for responding. JRW

SQLBill, Good Morning and thank-you for responding to my plea for help. I followed the directions in the readme.txt file: Double-clinked on sqlbolsetup.msi.

Good Afternoon This one has me stumped.. I installed SQL Server Books Online (Server 2000) The left-hand pane displays the contents, etc. However, the right-hand pane displays the IE error "The page cannot be display" The error message ends "Cannot find sever or DNS Error Internet Explorer"...

Good Afternoon I'm having a problem with an application written by a developer. The developer wrote an Access app in VBA. The dll was written in VB 6.0. I've installed the MDE. Problem - When I click on a button to run a procedure in the program, I get the following error: "The expression On...

Hi Juliane26 I have learned some things since my initial post... In the DB2 Commands panel (13 OS/390 User/DB /7 DB2 Commands) -Display Group (-DIS GROUP) will give you the IBM VRM (Version/Release/Modification) of DB2. In my case, the DB2 LVL was 710: Version 7, Release 1, Modification 0...