Search results for query: *

papadba, I resolved this. I had used the CICS pre-compiler with the CALLED program, which replaced my PROCEDURE DIVISION statement in the program with "PROCEDURE DIVISION USING DFHCOMMAREA", so my linkage was not addressable because it didn't exist! Thanks for all the feedback. Lesson...

papadba: interruption code is 0010. I have no idea what could have corrupted the address of the linkage section. The MOVE statement where the interrupt occurs is the third statement executed in the procedure division. The first two statements are a PERFORM and a DISPLAY. So no other DATA...

Yes, it was used for both. Thanks! Scott

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

Ok, I see now. I thought there were files there because we have this code a little farther down that zips the tif files: find $TMPPATH -name *.tif | zip -j $output_zip_file -@ >> $LOG where TMPPATH is the same dir I'm processing in my for loop, but now I realize that the files are deeper...

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

That did it! Thanks! Scott

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

Strange... I tried using requery after I set the record source (see above code), and it didn't work for me. Oh well, I think it's better to do as much as you can without code. Makes it easier for less-techy folks to support. So Duane's solution is better anyway. Thanks again. Thanks! Scott

Thanks, MajP. That worked. Works beautifully now. I actually found a link to an article about this here: http://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp It's a little different in that it suggests setting the control source of the hidden field in the main form to...

I'm trying dhookom's suggestion, so I'm not using the SQL string anymore. Thanks! Scott

Sorry, I stated this in my second post: "This code is in the Current event of the main form (Supplier)." Thanks! Scott

Enabled=Yes Thanks! Scott

Well, I added the hidden text box as you suggested, but I don't see the value that I added in the list of "Master" fields. I tried saving the changes, closing the form and re-opening, but I still don't see the new text box in the Master fields list. Is it possible that this list is only...

Yes, the field I'm trying to reference is on subform2 (RemittanceLocation). I'm trying to make the recordsource of subform2 be a record in the RemittanceLocation table that contains a particular value that matches a field on subform1. This code is in the Current event of the main form...

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 " & _...

Do you think it's not liking this because rs2 is the same data that I'm trying to update (albeit a QUERY and not the actual TABLE)? Thanks! Scott

Well, that didn't work either. I'll post more of the code so you can see what I'm trying to accomplish. Again, I need to import this file (actually a collection of files, but the tables are already loaded for now, so I can get the other file imports working after this is fixed). Then I need...

Voucher is text, so I'm fine there, but you're right about the WHERE clause. See... I'm looping through a table to create a specifically formatted export file (can't use transfertext, etc.). I'm actually looping through the same table I just loaded with the RunSavedImportExport command. But I...