Search results for query: *

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

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

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

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

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

Hi. Yes, I know that.

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

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

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

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

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

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

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

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