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!

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

    OnPrint Event executes only after all data is formatted

    CosmoKramer, Thanks for your quick response. I added the line Cancel=True, but even that didn't work. For some reason, it formats the entire report before printing, and I think that is the reason it's losing the formatting options and now the Cancel value. I'm sure I'm doing something wrong...
  2. RandyJ

    OnPrint Event executes only after all data is formatted

    I have a report that needs to determine a set of criteria for each record prior to printing the detail line. In the OnFormat event, I test each record in the recordset. If it doesn't meet the criteria, I set the following properties. With Me .MoveLayout = False .NextRecord = True...
  3. RandyJ

    String variable only storing 256 characters.

    Never mind. I figured out the problem. While in Debug mode, I was copying the Watched Variable Value field and pasting it into UltraEdit. Apparently, that value only displays the first 256 characters. :-)
  4. RandyJ

    String variable only storing 256 characters.

    Good Afternoon, I'm trying to store a long string into a string variable, but it seems to only retain around 256 characters. In looking at the Access VB reference regarding String Data Types, it suggests that this data type will hold up to 64,000 characters. Am I misunderstanding? I've also...
  5. RandyJ

    "Word is calculating the word count" message for Properties

    ilses, Thanks again, not only for the post, but for reminding me that there are other sources of information which I should have used prior to taking up your time. :-) I'm going to give this code a run through to see if I can come up with something. Take care, Randy
  6. RandyJ

    "Word is calculating the word count" message for Properties

    Ilses, Thanks for your suggestion. I created an object for the BuiltInDocumentProperties as shown below. Dim propAuthor as DocumentProperty Dim propCompany as DocumentProperty Dim propHBase as DocumentProperty Set propAuthor = objDoc.BuiltInDocumentProperties(wdPropertyAuthor) Set...
  7. RandyJ

    "Word is calculating the word count" message for Properties

    Good Day, I've experienced this problem in the past but it's not been critical since my documents were small. But now that I'm working on larger documents, it's become a problem. I've written a script to set several BuiltInDocumentProperity fields. When I run the script it recalculates the...

Part and Inventory Search

Back
Top