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 Chriss Miller 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. mork571

    Bank Process Control (BK0105)

    Yup. I have been recording the stuff occuring from the 'print/post' button. At that point, there is a field 'Next Check Num' and it does assign check numbers to the payments.. but none of that magic seems to show up in the recorded macro's at all. But yup, the plan is for the program to try...
  2. mork571

    Bank Process Control (BK0105)

    The error batch is to the effect of 'duplicate check number 000000000' for each check in the batch. The payments in these batches have SWPRNTRMIT set to TRUE. When I record the macro's, it seems like they are merely calling the crystal report. I'm not sure how things tie together with respect...
  3. mork571

    Bank Process Control (BK0105)

    actually, I should note, the status of the batch does end up being 'Posted', but the error batch is still generated and things don't seem to show up in the GL.
  4. mork571

    Bank Process Control (BK0105)

    Thanks, I had been trying that for posting as well. That technique doesn't work for some reason either. An 'Error Batch' is created (identical to the batch I attempt to post). the only errors in the session view are; hSession.Errors: Posting Complete. Error Batch Created. hSession.Errors...
  5. mork571

    Bank Process Control (BK0105)

    I'm trying to 'print/post' payment batches in AP from an external program. I'm at my wits end.. using the macro recorder, it seems fairly clear, but I've had no luck mimicing the macro. Here's a snippet of my code; ------- Dim BKPROC As xapiView Set BKPROC =...
  6. mork571

    Changing default for "find"

    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, ,acMenuVer70 SendKeys "%ha%n", False That's what I do. Literally sending keystrokes to change it. Use it in all of my apps.. you might think it would be unreliable, but it isn't - works great! For a detailed explanation, search MS...
  7. mork571

    Validate and convert a string prior to exporting

    have a look at an ascii table. If it is only upper case and lower case characters you want to keep, you could try the following treatment on your string; For i = 1 to 31 strString = Replace(strString, Chr(i), "") Next i For i = 33 to 64 strString = Replace(strString, Chr(i)...
  8. mork571

    Sub Class_Initialize()

    Yup.
  9. mork571

    Open Map

    Shell "explorer /e,/root, c:\map" I think that's what you're looking for. I think the switches determine if a treeview is shown or not and something else.. I can't remember, but I pulled this from an app. I once wrote. Should give you a place to start from.
  10. mork571

    Progress & Crystal Reports

    Just wanted to chime in and agree with BSitko. We're also using the Merant ODBC driver. We have no complaints about the performance of our crystal reports.
  11. mork571

    Using Microsoft Access

    Dim myInteger as Integer msgbox Nz(MyInteger) msgbox Nz(MyInteger,0) Nz takes 2 arguments, the second being optional. The first is your variable/expression. Nz returns the input var/expression if it is not null, and retuns 0 otherwise (or the value specified in the second argument)...
  12. mork571

    AP Batch/Invoice from VB6 - hit a wall.

    woa. I thre a "hheader.update" in front of the insert and it seems to be working now. proof-of-concept done. now on to the real work - I'm sure I'll be back with more questions (or even answers).
  13. mork571

    AP Batch/Invoice from VB6 - hit a wall.

    By browsing these forums and playing with the Macro recording in Accpac, I think I've come pretty close, but I get the following error; "View: AP0021. View call failed" The error is thrown on the line "hHeader.Insert". My current code is as follows (tried a lot of different...

Part and Inventory Search

Back
Top