Search results for query: *

Hello all, I am trying to find a way of a user entering a postcode for an address look up which I can later use when we create an order. I have tried the below but without success so I am asking for advice on what is wrong with the below or do the expert users know some other way to do this...

Hello all Haven't posted for a long time and hoping someone can suggest a link or other assistance. This forum has multiple posts for WhatsAPP messages via VFP but having tried them, none appear to be working, well at least not for me. I have the WhatsAPP Windows 10 App installed from the...

Hello I recently resolved my problem on thread https://www.tek-tips.com/viewthread.cfm?qid=1825298 (thank you) This is a follow on from that thread and would like to know how to change font type using "Print when" or other method on a report when a particular condition applies. I am aware of...

Hello all I have a form with multiple tables, the master table being CASMASTER. The other tables on the forms Data Environment are linked to the master by the field MASTLINK in CASMASTER. The form itself has a pageframe with grids on several pages displaying the relevant records linked to...

Hello I am trying to add records from several tables to a SYS(2015) file that meet a certain criteria: * Using mmastlink=525 as an example USE CAACTIVITY SHARED COPY STRUCTURE TO tempfile+'.dbf' SELECT * FROM CAACTIVITY WHERE MASTLINK=mmastlink ; ORDER BY ACTDATE INTO TABLE tempfile+'.dbf'...

Hi I posted sometime back about creating folders for documents which works perfectly (thanks to those who contributed) on a standalone computer. The purpose of the created folders is to store PDF's relating to job sheets, purchase orders etc that are automatically generated by the system. The...

The below code is used to retrieve items that are linked to a MASTER table. There are several hundred items in the table MYITEMS. USE MASTER SHARED GO m.recno && Record number m.mastlink=MASTLINK && This stores the actual linked number from MASTER to MYITEMS tempfile=SYS(3) SELECT * FROM...

Hi The below is my standard use of selecting a printer before printing: cPrinter = GETPRINTER() IF EMPTY(cPrinter) RETURN ENDIF SET PRINTER TO NAME(cPrinter) * CODE ETC SET PRINTER TO Is it possible to embed the printer prompt on a form as I would like to show other information on that...

Hello I have created a form with multiple fields from a table called STOCKBOOK On that form I have placed a grid (grdExps) which is populated with columns from a table called EXPS The table's linkmaster is STOCKBOOK and recordsource is EXPS This works absolutely fine and shows the main...

Hello I am having an issue with what I thought was a straight forward COPY FILE TO requirement. I previously created an automated .doc Word document (no issues there) but if I need to automatically search and copy the .doc file (if it exists) to a dedicated "Jobs" folder, I cannot get this to...

Hello all A field in MYTABLE is called QUOTEDEST which holds the path to the folder which stores any documentation in both .PDF and .DOC created (I've had much success with a previous thread here at https://www.tek-tips.com/viewthread.cfm?qid=1818098) From a command button in the click event...

Hello I am trying to copy a created PDF file into it's relevant folder but I cannot get it to copy into the correct folder. Here is what I have so far: ********** mrecno=205 && Just to send it to a RECNO() for testing ********** USE MYTABLE SHARED GO mrecno murn=0 murn=URN myear=0...

Hello I've searched high and low but getting nowhere with this. I've even set up a free months trial with Office 365. How, what or where is the best method (even subscription) to set up Office 365 so I can easily send encrypted emails from Office 365 (not the app but online). I have seen and...

Hello This is a very frustrating thing for me. I have two tables call them table1 and table2. I have placed both tables on a form in grids and linked them via an index called JOBLINK. Ok, this works perfectly when I scroll through the grid records showing each linked record in table2 to...

Hi all I have a report that lists invoices. I can choose whether I want to show "paid", "unpaid" or "all". A field in my table called INVOICEPYN is a character field C(1) which either stores a "Y" for paid or "N" for unpaid. Examples: * Invoices "paid" cPrinter=GETPRINTER() IF NOT...

Hi all There are lots of examples on this forum for the above subject and I have managed to successfully implement one which sends an email seamlessly from VFP9. Perfect! However, unlike automating an Outlook email which stores a copy in a sent folder, where (if at all) is the sent...

In a follow up to a previous question (https://www.tek-tips.com/viewthread.cfm?qid=1812776), I would like to add the working code below to a form so I can add some additional fields from a table to it. Kindly resolved by Chriss, this is what I have now: Public oForm oForm =...

Hello all Firstly, credit to Cetin Basoz who posted the following in the Microsoft Developer Network (Visual Foxpro General) back in 2009: Public oForm oForm = Createobject("sampleForm") oForm.Show() Define Class sampleForm As Form Height=320 Width=320 Add Object myImage As Image With...

Hello I have a field on a report called: QTY The field is a N,7,3 On my report the field is displayed as STR((invprodrecs.qty),7,3) which is fine when the figure is 1.250 or 1.500 etc. I have changed this to STR(invprodrecs.qty) which works fine if the number is 1, 2, 15 etc but will cut...

Hello all I have created a small application with a list of clients I do jobs for. Each client has an ID number stored in a field called CLIENTID N(8) - Table MYCLIENTS When I create a job this is given a Job Number and also a URN in a field called JOBLINK N(8) - Table THEJOBS When items are...