Search results for query: *

Hi. I have an MQ I-O routine that I want to be callable from a batch or CICS program. So I have coded my first CICS calling module as such: CALL MQ-API-PROGRAM USING MQ-DATA-AREA. The LINKAGE SECTION and PROCEDURE DIVISION header of the called MQ module are coded as such: LINKAGE...

I have a vbscript that updates a couple access tables (just loads records). When I run it manually, it works fine. When I run it with an Enterprise scheduling tool, which runs as "system", the updates fail. Can someone tell me what I need to change? I'm using MS Access 2007. Thanks! Scott

Hi. I have files in a directory with names like: 1.tif 2.tif 3.tif . . . n.tif I need to rename these files to YYYYMMDD_SEQ_CTR.tif, where 'YYYYMMDD' = date (duh), 'SEQ' = a pre-assigned sequence number, and 'CTR' = a counter that I just increment for each file in the dir. So, I have the...

I have this code to update an Access table from a text file (this is actually vb script): sqlStr = "UPDATE CustomersMain SET [RMName] = '" & trim(oRS("OfficerName")) & "' WHERE [CustomerID] = " & trim(oRS("CustomerId")) Problem I have is when an OfficerName has a single quote in it, like...

Hi. I have a form with two subforms, and I'm trying to link the recordsource in Subform2 to a field in Subform1. (Subform1 is linked to data in the main form.) So I have the following code to accomplish this: strSQL = "Select * " & _ "From RemittanceLocation " & _...

I have this code... sqlStr = "UPDATE tblPaymentHeader SET [Voucher] = '" & varVoucherNum & "'" appAccess.DoCmd.RunSQL sqlStr ...trying to update an Access 2007 table. It's failing, but the only error it tells me is "The RunSQL action was canceled." I know my connection and all is good...

Hi. I'm getting a syntax error in my vbscript trying to set a SQL variable to the following string value: strSQL = "SELECT * INTO tblPaymentDetail FROM OPENDATASOURCE(Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=C:\Documents and Settings\apprss\Desktop\Purchasing...

Hi. Trying to assign the recordset of subform B (frmRemittanceLocation) to records from a table that are related to a value in subform A (frmSupplierLocation), but the query is not returning any results (and I've validated that the data is there). Here is the code: strSQL = "Select *...

I have a field for address lines in my table (AddressLines). One or more (up to 3) address lines will be stored in this text field. Each address is separated by a colon (:). Examples: 1. PO Box 123 2. Attn Fred:PO Box 123 3. Attn Fred:123 Any St:Suite 456 So, I want to display each...

Hi. I'm struggling with a task to parse a CSV into individual fields. I found a topic about this on this forum and others, but implementing the code has not provided the results I expected. Here's my code: BEGIN CODE ----------------...

I have an XML Spreadsheet that I'm creating on the mainframe and sending to my users. I would like for the data in the rows (which I'm creating on the fly with a COBOL program on the MF) to be sorted when the user opens the XML attachment (which opens in Excel). I have the following tags in...

Hi, I'm not sure if this is the correct forum, but it IS related to MS Excel... I have an XML Spreadsheet that I'm creating on the mainframe and sending to my users. I would like for the data in the rows (which I'm creating on the fly with a COBOL program on the MF) to be sorted when the user...

Hi. My users created a field in a table with an input mask. How do I obtain this value without its input mask? The field is a fax number, and they have it masked as "(###) ###-####". So when I code "varFaxNum=Customers.FaxNumber", I get "(555) 555-5555". But I just want the numbers - not...

I'm struggling to figure out what I'm doing wrong here... I have two instances that I need to execute a batch file from my VBA code. The first one is working, but I can't get the second one to work. I keep getting the error "Method 'Run' of object 'IWshShell3' failed". This is the code: Set...

I'm new to VBScript, but I've written and modified a few scripts... I need to read a report file (ASCII format), and generate multiple PDF files from certain pages in the report. I can handle the logic to parse the report file into multiple documents, but I'm trying to find a free tool to...

We have the following distributed queue setup: remote queue definition on mainframe that corresponds to a local queue on a server We are putting messages to the server with char set 500, encoding 785. Our Queue manager is converting the data from EBCDIC to ASCII. When we browse the messages...