Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rss0213

    CICS called COBOL module fails with Program Interrupt

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

    CICS called COBOL module fails with Program Interrupt

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

    CICS called COBOL module fails with Program Interrupt

    Yes, it was used for both. Thanks! Scott
  4. rss0213

    CICS called COBOL module fails with Program Interrupt

    ...USING MQ-DATA-AREA. The LINKAGE SECTION and PROCEDURE DIVISION header of the called MQ module are coded as such: LINKAGE SECTION. *.---------------------------------------------------------------. *| L I N K A G E S E C T I O N...
  5. rss0213

    Updates fail when process runs as system

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

    file rename loop

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

    file rename loop

    ...sequence number, and 'CTR' = a counter that I just increment for each file in the dir. So, I have the following code: ctr=0 for i in *.tif do let "ctr+=1" newtifname=$DATEDIR"_"$SEQ"_"$ctr".tif" mv "$i" $newtifname done But when I execute this code, I get this...
  8. rss0213

    problem with single quote in recordset field of UPDATE query

    That did it! Thanks! Scott
  9. rss0213

    problem with single quote in recordset field of UPDATE query

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

    subform recordsource not updating

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

    subform recordsource not updating

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

    subform recordsource not updating

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

    subform recordsource not updating

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

    subform recordsource not updating

    Enabled=Yes Thanks! Scott
  15. rss0213

    subform recordsource not updating

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

    subform recordsource not updating

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

    subform recordsource not updating

    ...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 " & _ "Where [UniqueName] = '" & [SupplierLocation].Form!UniqueName & "'"...
  18. rss0213

    trying to exec a SQL update...

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

    trying to exec a SQL update...

    ...Work\PurchasingP2P.accdb;" & _ "Persist Security Info=False;" ' SQL statement to run sqlVoucherNumber = "select * from tblVoucherNumber" sqlPaymentHeader = "select * from tblPaymentHeader" sqlBatchSum = "Select SUM(GrossAmount) As BatchAmount From tblPaymentHeader" Dim cn...
  20. rss0213

    trying to exec a SQL update...

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

Part and Inventory Search

Back
Top