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!

Recent content by ROGERIORIOS

  1. ROGERIORIOS

    Table Corrupted

    Thank you for your help. 1-I created another identical and empty table in the database. 2-I downloaded the backup of the table in another folder. 3-I exported this backup table to a third table. 4-Then I opened the empty table in the database and imported the records. 5-Then I recreated the...
  2. ROGERIORIOS

    Table Corrupted

    When I turn it into a free table I can't use it because of a field that has more than 8 characters
  3. ROGERIORIOS

    Table Corrupted

    Ok,First I'll try to create an empty table and import the records.
  4. ROGERIORIOS

    Table Corrupted

    What did I do : 1- I removed the table from the database with the command REMOVE TABLE tbturma 2- I made a Validate Database 3- I downloaded 2 files: tbturma.dbf and tbturma.cdx 4- I renamed the corrupted files. 5- I copied the copies that I downloaded from the host into the folder where the...
  5. ROGERIORIOS

    Table Corrupted

    I was changing the structure of a table in the database and forgot it was open in a query. There was an error in the VFP , it crashed and closed. Afterwards I received the message that "field did not match". I removed the table from the database, renamed it and got it from my backup. I...
  6. ROGERIORIOS

    Word MergeField with Excel

    Hi. Yes, I know that.
  7. ROGERIORIOS

    Word MergeField with Excel

    Hi Chris as I posted above , I always said I was using MERGEFIELD not Merge Mail. Best regards
  8. ROGERIORIOS

    Word MergeField with Excel

    Hi Chris.08:35 am Brazil Theoretically, this command was missing. oWord.ActiveDocument.MailMerge.OpenDataSource(Sys(5)+Sys(2003)+'\planilhabasehistorico.xls') Watch : https://youtu.be/ijNZvle-XIw So : TRY m.nameword = Sys(5)+Sys(2003)+'\'+ALLTRIM(tbcontrole.cnomearqhistorico) Local oWord...
  9. ROGERIORIOS

    Word MergeField with Excel

    Hi Chris. 15:50 Brazil Thanks for the research and the suggestion. What exists in the .docx file is the command ( I don't really know if it's a MACRO ): {if{mergefield myfield}="1" {mergefield myfield2} "-----"}, that I insert the braces { } by pressing ctrl +f9. And the fields myfield and...
  10. ROGERIORIOS

    Word MergeField with Excel

    Hi Chris : " Also: Are you sure the Excel file and its Sheet is only linked and not embedded into the Word document, so an update of the data actually changes what Word displays?" I ran the routine inside my vfp system with different classes of students: The result is the same: when opening it...
  11. ROGERIORIOS

    Word MergeField with Excel

    Hi Chris ! Thanks for the answer. Yes, it is opening the correct .docx file, I had already done this test showing a wait window with the file name. Now I did a test and commented all the code that works with the Excel.Application object. Nothing has changed, the docx file continues to open...
  12. ROGERIORIOS

    Word MergeField with Excel

    Hi MIKE ! SORRY.... I will try to explain better. In the Microsoft Word word processor, it is possible to create documents linked or associated with a database (in this example, the base is a spreadsheet). OK ? So I, using this feature, created a linked word document associated with an excel...
  13. ROGERIORIOS

    Word MergeField with Excel

    I have a VFP 9 system. It generates a spreadsheet with data coming from the database. I have a docx file that is associated with this worksheet. In the docx I have some cells that I use the {if{margefield ....}....} to be able to show or not some fields in certain positions. The problem: when I...
  14. ROGERIORIOS

    Is there a free software to convert .dbf to .sql tables ?

    Select the table DBF... Connect to mysql.. Use the copy structure extend to ... use the .dbf table structure and create your commands to create the fields ( name, type ..) field_type, field_name,field_len... Use mysql information_schema to check if the table already exists.. Check if there are...
See more

Part and Inventory Search

Back
Top