Search results for query: *

I want to call the Date function to put today's date in a field: Me.txtDate.Value = Date Easy enough except that there's a field named "Date" and this line of code gets that value rather than calling the Date() function. If I type Date() then Access autocorrects it and removes the brackets...

There's a Fox function to split a string into words and I've forgotten what it is. I know I can work around it with ALINES() and a memo field but can anyone help me with an easier way? Geoff Franklin www.alvechurchdata.co.uk

I need a copy of VFP 9 for a client. None of the usual suppliers (up to and including Microsoft Store) have it in stock in the UK. I can find one on-line supplier but is anyone else having dificulties getting hold of a copy? Geoff Franklin www.alvechurchdata.co.uk

In VFP 9 it's easy to add properties to "Favourites" in the Properties Window. Is there any way of removing them. Sometimes I've managed to remove one by resetting _MemberData to default but I would hope that there's a more reliable way Geoff Franklin www.alvechurchdata.co.uk

The ACT Contact management system used to use dbf files and I used to be able to pull data out of it. Does anyone know what data format is going to be used by ACT 2007? Sage sales staff won't say anything other than "more efficient" and I can't get technical information without buying a support...

I display an image in a VFP 8 report. All the images are stored as gif files and are appended into a general field just before the report runs. This works on my PC <g>. On the user's PC they get the name of the gif file displayed instead of the image. If they delete the gif file then they get a...

This has been running for five years and failed today. I create a cursor in a form's Init event and use it to drive a grid. Elsewhere on the form there's a GO TOP. Today that failed with an "Error 12 - Variable not found". For some reason Fox had decided this morning to generate the cursor by...

I need to generate a table holding the full names of all the controls on all the forms in an app. By full names I mean something like: ... frmOrder.pgfOrders.pagDetails.grdDetails.colType frmOrder.pgfOrders.pagDetails.grdDetails.colType.hdrType...

I have a form with a PageFrame. Page 1 shows customer details and I add an extra page at runtime for each of the customer's maintenance contracts. The caption of each contracts page gives the make and serial number of the machine under contract. This works very well. Users can see at a glance...

I'm producing a four-part report in this application. Users like the new preview features in VFP9 but they'd really like to be able to page up and down through all four reports as a whole. I have a vague memory that we can now concatenate reports but I can't find it here or in VFP Help. Is this...

I've spent the day to my nice new Toshiba. Reports in Fox 6 are using centimetres but Fox 8 is using inches. Could someone remind me how to select the units of measurement please. Geoff Franklin www.alvechurchdata.co.uk

We have a VFP8 report which works when the exe is called from the development environment but fails with "Their_ref not found" when the exe runs on the user's PC. "Their_ref" is a field of the cursor being printed on the report. I have single-stepped the code and checked that "Their_ref" does...

We've had a dozen users sharing an Access 97 database for the past five years. Each has the front end on their own PC linked to the back end on the server. Now we've got VPN installed and have found that only one person at a time can use the front end on the VPN server. Is this normal? Geoff...

We've just got broadband and had a router installed. Whenever I Beautify code in VFP8 now the FoxPro window freezes for about five seconds and the router lights flash as though Fox is accessing the Internet. FoxPro unfreezes and refreshes the code window when the router lights stop flashing...

I've fixed a reporting problem by adding a BROWSE statement. It's a kludge and I want to fix it properly. There's a query which builds a cursor. I check _TALLY immediately and run the report if any records have been retrieved. This technique works everywhere else in the app but in this one...

We've got a customer using the Time and Chaos Contact Management system. Does anyone have experience linking into this database? I believe it uses the ISAM driver from Software Source. Be glad to hear of any experiences - good or bad. Geoff Franklin www.alvechurchdata.co.uk

We've got a customer using the Time and Chaos Contact Management system. Does anyone have experience linking this into Access? Be glad of any experiences - good or bad. Geoff Franklin www.alvechurchdata.co.uk

Three copies of an Access 2003 frontend are using Access 2 data on a server and sharing this with an old Access 2 application. If one of the 2003 frontends crashes then that user cannot reopen the application. The other two 2003 users and the Access 2 user can continue work but the crashed...

Can anyone help me remove the VFP 9 Beta? It's expired and I want to get rid of it before moving on. The instructions say to run SetUp.Exe but that tells me that I need to install some prerequisites and then hangs. Geoff Franklin www.alvechurchdata.co.uk

Customer's just moved a simple wizard-generated report from Access 97 to Access 2003 and it's stopped working. They asked me to take a look and it was the Trim() function in the report fields that was crashing it. I "fixed" it by removing the calls to Trim() so the customer's happy. I'm still...