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

    Index doesn't match data

    Thank you everyone for your input. The facts: The problem happened 25th Aug but only came to light last week, because the customer ran a routine which did a 'pack' The data was written to the database, but then overwritten - both these events happened on the 25th Aug Doing a SEEK on the 5...
  2. MgtHargreaves

    Index doesn't match data

    Hi Chris Just knowing the Reg_no (from the index) would be enough, because the customer has paper records to find out the rest of the information. That is the reason I was interested to know whether there was some 'easy' way of getting that information from the index in a routine which could...
  3. MgtHargreaves

    Index doesn't match data

    Hi Mike Yes, I believe the index does contain the reg numbers of the two overwritten records, simply because of this (reading the file using the index) : and that fact that I have identified which 2 records are missing using other data supplied by the customer. What I was hoping to do, was...
  4. MgtHargreaves

    Index doesn't match data

    I have a backup of the data from BEFORE this all went wrong. So, this backup has the duplicate records - I just need to know what was in the index which is pointing to these duplicate records. Margaret
  5. MgtHargreaves

    Index doesn't match data

    Hi Mike Yes, that is what we did. However, these duplicate records have overwritten 2 other records, and I need to know what was in those records. Margaret
  6. MgtHargreaves

    Index doesn't match data

    I think it is fair to say that in this situation, it would be expected that the index needs to be recreated. However, we have a situation where the index is actually correct, but the data is wrong. It came to light because the customer ran a routine which did a pack, and therefore the index...
  7. MgtHargreaves

    Word Automation

    I have an update on this. It appears that our customer was also having the same problem when she opened Word documents directly from File Explorer. Having got very frustrated, she contacted Microsoft, paid them £65, and they logged onto her machine and seemed to have fixed the problem...
  8. MgtHargreaves

    Word Automation

    I did check that Mike, and the setting is the same on machines which create the error as machines which don't create the error. Margaret
  9. MgtHargreaves

    Word Automation

    Thanks Olaf, I will have a look at that. I have just discovered something else which might give a bit of a clue. Using CREATEOBJECT to open Word. If the software controls the opening of Word, opening, populating, printing and then closing the document - typically for invoices - then the...
  10. MgtHargreaves

    Word Automation

    Thanks Olaf My gut feel is that it is something to do with a setting in Word which is different on these few machines, but up to now I haven't been able to find it. I checked task manager, and only 2 winword.exe processes were running. Interestingly, having replied 'No' to the original...
  11. MgtHargreaves

    Word Automation

    Mike Thanks very much - on initial tests this does seem to fix the problem. It is just so weird that we have not had this problem in all the years we have been using automation. JRB-Bldr - We are the developers of the software using VFP9, and have been using automation for years without this...
  12. MgtHargreaves

    Word Automation

    I am hoping that some-one else has come across a problem we have encountered recently. We have a 'vertical market' product used by over 100 customers, and now have a problem with 3 of these. If a Word document is open (via Word) on the system, and then the software opens another Word document...
  13. MgtHargreaves

    automation - printer dialog

    Thanks, I will have a go at your suggestions. Margaret
  14. MgtHargreaves

    automation - printer dialog

    Hi Mike No, surely oWord.Dialogs(97).Printer = GETPRINTER() is using the Word printer dialog box. The code I am using was suggested in a previous thread to stop the windows default printer being changed. The reason for needing to know whether the user has clicked on Cancel, is that the Word...
  15. MgtHargreaves

    automation - printer dialog

    Hi Mike I tried that, but oWord.Dialogs(97).Printer always returns the default printer. Even if I set it to "" first Margaret
  16. MgtHargreaves

    automation - printer dialog

    thread184-1384177 Using the following code : #DEFINE wdDialogFilePrintSetup 97 oWord = CreateObject("Word.Application") oWord.Documents.Add("C:/xxxx/yyy.dot") WITH oWord.Dialogs(wdDialogFilePrintSetup) .Printer=GETPRINTER() .DoNotSetAsSysDefault = .t. .execute() ENDWITH...
  17. MgtHargreaves

    Missing printer in publisher

    Using Publisher 2000, I am getting a 'no printer installed' message when trying to print a publisher document. There are printers installed and work perfectly when printing Word or Excel documents or when printing from any other software. We have just changed printers, and so removed the old...
  18. MgtHargreaves

    Word Automation printing upsets Excel

    That seems to have done the trick Thank you
  19. MgtHargreaves

    Word Automation printing upsets Excel

    I have an interesting problem which one of our users brought to my attention - using automation to create and print a Word document. Having created and printed the Word document, if we then open an excel document (normally, not using vfp) and try to print the document, there is nothing in the...
  20. MgtHargreaves

    CDX files in zip file

    You will pleased to know that both customers are now back up and running. In both cases we went into Outlook Express, and unticked the Tools/Options/Security/Do not allow attachments to be saved or opened that could potentially be a virus setting. Then re-saved the zip file from the email and...

Part and Inventory Search

Back
Top