Recent content by AndrewMozley

I understand that the MessageBox() is modal. So even during the pause when the message is being displayed – the user cannot click on the form where the Customer record is being edited. So the form which was trying to post the invoice now displays a message to that effect, inviting the user to...

This application has a ribbon menu which allows the user to have several forms visible at the same time. For example, a user could be entering a sales invoice for a product, but he may wish to find out what this customer – or another customer – paid last time; or what deliveries of the product...

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