Search results for query: *

I 'm afraid that I haven't got any bright ideas for puzzles to contribute to this site, but would still be interested if some new ones were posted. - Andrew M.

Thank you, GGreen. I will check that out.

Chriss, Griff, Mike I thought that the SET DECIMALS TO 18 instruction would allow me to BROWSE a table which had a field with 4 or 5 decimal places to be displayed with full accuracy. I now find that this is not the case. SET DECIMALS does indeed have an effect on expressions which do not have...

I take your point, Mike, about not being too liberal with the facilities I offer to 'Administrative users'. At present I only have three operational systems (apart from my own), and perhaps have not let these users know about the option; so I am the only person who uses the facility. I will...

Thank you Chris and Mike. The SET DECIMALS which you recommend, Chris, does the trick. It seems to have a lasting effect on the database. When I close the application and go into it again, if I browse a table, the fields in the table which have more than two decimals are shown in their full...

An application offers a user with ‘Administrative rights’ the ability to browse any of the tables in the application. The application lets the user enter the commands in an editbox. So, for example, the user could enter these commands : SET DELETED OFF USE XSDET (A table of sales order detail...

Thank you Chris and Mike, for your replies. To Mike’s point, I am revisiting an old report to make a new version with different options. The control into which I am entering the month is not part of a date : it is just part of specifying a range for the report. The control used to just have...

I am revisiting some old code. There is a 2-digit text box which is to specify a month. So ‘03’ would represent March. What is other users' practice for specifying the properties of such a field on the form, and for validating it? Thanks - Andrew

Thank you very much, mJindrova - Andrew

I have two tables with the same record structure : ENTS with 1235 records and ARCS with 16,800 records. How can I use SELECT SQL to create a single cursor with all 18035 records. I realise there is some information in the VFP Help files, but if anyone has written or can recommend a short...

I am using Office 365 including the use of OneDrive. When I am editing a Word document and click on File, the menu on the left offers Save and Save As. And if I close the document (X in top right), it will ask me whether I want to Save the document. This happens with most of my documents...

Thank you Deniall. . . Alt key held down, then 0150 on numeric key pad. For some reason this does not work for me on my Office 365 version of Word. However if I set the autocorrect option on : File | Options | Proofing | Autocorrect | Autoformat and tick Replace hyphens (--) with en-dash...

Thank you for your prompt reply, combo. I realise that the 'recent symbols' list is usually dynamic, but it seems to have become static on my machine! Even though I have used the en-dash about a dozen times in my recent session, the 'Recent symbols' remains unchanged; for example it includes...

When entering a Word document, I often use the 'en-space' — a slightly wider hyphen. To put this into the document, I click Insert on the top ribbon menu, then Symbol on the right, clicking on the drop-down list. This shows some recently used symbols and the 'More symbols'. From there I choose...

I am sorry, Griff, that you are being subjected to this unmerited criticism. Your responses to queries from members are always helpful - Andrew

Thank you Mike, for your prompt reply. I apologise for re-visiting this theme! I don’t exactly _do_ the search for customer (by partial name) within the txtcust.valid() method; but if the user knows the partial name of the customer, and keys in ‘#LEW’, then txtCust.valid() calls a method which...

I have an application with a textbox in which a customer account code can be entered. (this text box is based on a class used within the application). The Valid() method of this particular control – call it txtCust - will do several things, including helping the user to search for suitable...

Thank you Tore. I shall bear that in mind. - Andrew M.

I have a table XSORD which has a field ‘Account’ - the customer account number, and have executed the instruction : SET EXACT ON In order to retrieve records for a particular customer, say ‘S100’, I can execute a command : SELECT * FROM XSORD WHERE Account = ‘S100’ This however returns a...

Thanks Tore - Quicker than a speeding bullet ! That certainly makes a difference. The Word window comes up and is displayed - I will continue testing. Andrew