Search results for query: *

Hello, I have a multi line grid with 5 text fields which works superbly. However, I have changed the 5 text fields to read only and the background is now grey instead of white. When in read only mode the backcolor property does not change to any color in the regular way. Am I overlooking...

Hello, I have a multi line grid that I created in VFP6 (YES a multi line grid) it works superbly and is accessed on a daily basis with new data. However, I wish to place a condition on a table field called quantity. When the quantity field is greater than 1 then I would like it to display in...

I have a form with a grid containing data and a checkbox. All works well except that sometimes when you pass the cursor over the checkbox without clicking, a selection (or de-selection) can be made. Is this a fault in VFP6 or is there a property which I can use to cure this? Thanks

[tt][pre][tt][tt]Hello, I've received a database with about 5000 records. There's an ID field together with a Group code field as follows:- ID-------Group 987691 987691 G99 987691 G99 654230 654230 G233 888765 888765 H91 etc., etc. As you can see the first...

Hello, I have a field in a column which can have either 'STD' or 'EXP' so I wish STD to appear in black and EXP to show in red. What is the easiest or correct way to achieve this Many thanks

Hello, I have a database within a grid and one of the fields is 80 characters long, is it possible to wrap this particular field to say 40 characters over 2 lines? I know this is easy to achieve in the report writer but cannot find any help regarding database field wrapping. Thanks

Hello, I have created multiple address labels before but now I need to print return address labels which are all the same. My label sheets contain 65 labels, so does this mean that I have to create a database with 65 records OR is there another way of achieving this. Thanks.

Hello, A client has asked me if there is a way of importing a text file into VFP 6 with 1 field per line:- field 1 field 2 field 3 field 4 field 1 field 2 field 3 field 4 field 5 There are 4 or 5 fields for each record, separated with a blank line. I thought of importing text to a database...

Hello, I wish to insert a JPG image on a form in VFP 6, I've done this many times in a report but not within a form Thanks

Hello, I wish to find the value of 2 numbers in a text field of variable length. These numbers appear in brackets at the end of the text:- xxxxxxxxxxxxxx (2,9.5mm) xxxxxxxxxxxxxxxxxxxxxxxx(10,10mm) The first figure can be 2 chars in length and the last figure can be whole or with decimal of .5...

Is there a quick way or a function in VFP 6 which displays dates in the following format:- 19JAN2014 Thanks for your help.

Hello, I'm using VFP 6 and have a character field in a database which contains text and ends with a number or letter/number like so:- xxxxxxxxxxxxxxx 123 xxxxxxxxxxxxxxxxxx 236 xxxxxxxxxxxxxxxxxxxxxx R551 etc., etc. I wish to put a code one space before the end code, eg:- xxxxxxxxxxxxxxxx (DD)...

Hello, I have a large database file with a char field containing codes for example; AB123, ABC567 etc. I need to separate the letters from the numbers by inserting a space. Is there a quick method for achieving this? Thanks for your help.

Hello, I use VFP version 6 and I am trying validate a textbox where the user may type 1, 2, 3 or 4 but how do you restrict the user to just typing in one of these 4 numbers. Any tips on validation as I don't have any manuals. Thanks

Hello, I have a large database file with a field for the address. Unfortunately the postcode has been input together with the town:- Warrington WA14 1BQ, Chester CH12 3GG etc. Is there a quick way to separate the town from the postcode and place the postcode in a new field? I am currently...

Hello, I have a database file with just a few fields that require totalling into a totals field eg 'replace totals with field1+field2+field3' etc. there are only five fields to be totalled at the moment but this may increase to at least fifteen. Is there a betted method of totalling many fields...

In a recent thread I was advised to use the crosstab file VFPXTAB which works beautifully for all of my data. However it inserts 'C_' in front of the fields across the top from right to left, eg the account numbers now look like C_1001 instead of 1001. All I would like to do is change them to...

Is it possible to convert several account numbers contained in records from a dbf file into individual fieldnames in a temporary table or dbf. I am currently using Visual FoxPro version 6.0 Thank you.

I have recently migrated to Visual FoxPro version 6 and want to know if it is possible to centre text within a form. I can't find a property for the alignment of text. Thanks for your help.

I am using VFP 6.0 and am trying to change the colour of the border around a USER defined window. It remains blue like the system window. Even using a colour scheme doesn't make any difference. Is there any way of changing the border colour?