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 Mike Lewis 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. delboy1295

    Prevent Word Exiting until Printing Done

    You techies have been very helpful to me previously - I'd like to try again! I'm calling Word from a bespoke VBA application. I assign bookmarks & print a couple of copies of a document. When I add the line:- WordApp.Quit I get the message that exiting Word will stop the spooling/printing...
  2. delboy1295

    Hide & Print a Word Document from within VBA

    Many Thanks Rogue Poet! I'm running this from an Accounting Program that allows me to 'hook' into it when certain events occur. What you've suggested looks fine, but I havent had cjance to try it yet! Thanks Again Delboy1295
  3. delboy1295

    Hiding & Printing a Word Doc from VBA

    I wonder if I may call on your expertise to help me with a problem. I'm developing an app in VBA. After a particular event, I want to take various data and transfer it to a Word Template. I have set up bookmarks and everything works fine. At present the document is displayed and can then be...
  4. delboy1295

    Hide & Print a Word Document from within VBA

    I wonder if I may call on your expertise to help me with a problem. I'm developing an app in VBA. After a particular event, I want to take various data and transfer it to a Word Template. I have set up bookmarks and everything works fine. At present the document is displayed and can then be...
  5. delboy1295

    InStr Function

    Many thanks Lplates! With a little personalising that was v useful!
  6. delboy1295

    InStr Function

    1. Thanks for info BB. 2. I need to create a list of acceptable codes Eg:- CLT/,FLT/,TPT/,VLN/ etc. Then I need to check that the first four letters on a new record contain them. So going back to the program, the OKCode needs to be a list of the above. I get various errors depending how I...
  7. delboy1295

    InStr Function

    A Simple questiob for you wonderful techies! I want to check the validity of certain codes viz:- Dim OKCode, StkCode As String StkCode = Mid(StockItemForm.StockItem.Code, 1, 4) OKCode = "CLT/" If InStr(OKCode, StkCode) = 0 Then MsgBox StkCode, vbCritical cancel = True...

Part and Inventory Search

Back
Top