Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

That seems to have done the trick Thank you

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

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