Search results for query: *

Thanks a lot for the explanation, the approach of the record a macro is the thing i was missing, thanks, yeah that was right, no reason for the "GO TOP" Thanks again

Here is the word document filled with data, so you can see exactly what happened. Thanks againhttp://files.engineering.com/getfile.aspx?folder=850252ae-babf-478d-b2ec-accc2c06f7b9&file=123917.doc

Hi Guys, I am working on an existing Word doc that has two tables and i am filling the bottom table with data from a cursor, the problem is that the word doc, bottom table is predefined with 17 rows and if i have more than 17 records from the cursor, then the table2 on the Word doc, will get...

Yes Mike , that is working as i was expecting, now let me ask you. if want to put in the doubleclick event soemthing like this this.txtdate.dateformat = 1 should that do the same thing as This.Value = {} ? Thanks

Hi, I have a textbox where i input a date and i have this named as txtdate, so the txtdate Dateformat property = 1 So i would like to use the DblClick property to clear the value i typed in the Txtdate, so i wrote inside the property the following This.Value = '' this.txtdate.DateFormat = 1...

Hi Olaf, Yes, i know i can use "USE"(to close table) , what i did not know was, that i can use "USE" just to close that table and not the Cursor, that is the reason me asking how to close that table w/o closing the cursor Thanks a lot Rgds

Thanks a lot Mike, ggreen61 too, i was looking for some kind of command as: CLOSE TABLE SOMAST04.DBF But actually nothing like this exist.

Hi Everyone, i just trying to immediately, to close the table included in the following "SQL SELECT " after this is executed. SELECT sono, prtid FROM somast04 INTO CURSOR junkmast04 I just want to use the cursor created to display the content into a Grid but i want to make sure that the...

Hi Guys, here is my situation: In SBT PRO 5.0 i am running from Purchase order module, "report order status" the problem is ,that the person in purchasing dept inputed the amount we have to pay in the PO, in pounds sterling, so now when we already received the item related with this PO and the...

Hi mandaragit, Thanks a lot for your help. Thanks to woundedxoul too for confirming Best Rgds

Thanks guys, i will look into it, it was nice to know about the error log.

Hi Everyone, This is in SBT PRO 5.0 This morning i was trying to run this report "Report General ledger for total company with period and account ranges" and i am getting this message "GL entries are being posted. Reports may not be generated while posting is in process" Can anyone point...

Hi Guys, SBT PRO 5.0, HAVE THE CHOICE when running a purchased order report to send it to excel, but it send the data to excel but everything it is a mess, the columns and headers all are out of synchronization, can anyone have any suggestion Thanks in advance

Hi Mandaragit I will check all of that, thanks i will let you know, so you want me to look for that specific purno to match if they exist in the tables you mentioned correct ? Thanks

Hello Jay, Let me see if i understood correctly, you want to add to the invoice form your company phone # and the fax# ? 1-go to your folder PRO50\AR 2- from the vfp 5.0 command window type "modi comm arpstm" (you can only do this if you have the source code and if you have the vfp 5.0 or 6.0...

Hi Guys, Happy new year for everyone. i will attach the error message we get, when we use the ALT+D option in Purchasing module, to print purchase orders that are now in the history file, sometimes we can print two or three po #s but after that we get this error, please see the attached file...

Thanks a lot Edgar, yes some of the invoices did not have details, what i did was i marked all records in armast with prtis= 'P' Again thanks a lot

Hi Guys, I have a problem printing in a batch mode, from the Enter Shipments, the funny thing is only happens with one particular company for example i can print in batch mode for my company APEX04 but i cannot do the same for CAPEX02 When i am ready for printing in batch mode for CAPEX02, I...

Thanks mike it worked

Hi Mike, Here is code i have, but it does not work for me the line .PageSetup.DisplayGridLines = .T. && what i did wrong ? Local loExcel As excel.Application, lcFile loExcel = Createobject('excel.application') lcFile = "c:\qjob\"+._Filename+'.xls' With loExcel...