Recent content by Headwinds

Mike-- Thanks for your suggestion about INLIST(). If definitely helped clean up my nasty scrawl. (Eventually, I'll put that list of words to skip out into a text file to make it easier to maintain.) The problem was in the inner DO WHILE loop, where I kept advancing the counter even after I'd...

FUNCTION find_acro_work2 CREATE CURSOR acrolist (acronym C(9)) CREATE CURSOR holder_lb (thistext C(254)) SELECT holder_lb m.target_file = GETFILE("Text:TXT") m.target_path = LEFT(m.target_file, RAT("\", m.target_file)) IF NOT(EMPTY(m.target_file)) m.dostring = "SET ALTERNATE TO '" +...

I've got a function that searches a text file, locates strings that appear to be acronyms, and outputs a spreadsheet listing the candidate acronyms. It runs fine in development mode, but when I compile it and run it from the .exe file on the same PC on which I have VFP installed, it hangs...

I've got a VFP 7 application with a report that contains a letterhead logo that's in color. The color shows when the report is previewed, and it prints in color to an inkjet printer. But it prints black and white to an HP color laser printer. Is this normal? I've got the latest update to VFP...

Yes. That works beautifully. Thanks for your instruction.

I'm stumped on something that I think should be very simple. I have two combo boxes in a subform. If the user selects a particular value from the first combo box, the second one should have the same value; otherwise, they are independent. So, on the first combo box, I've written an On Change...

Got it. The problem appears to have been that the search path returned to the primary data set, found the .dbf file that I was trying to create, and objected to doing it again. To get around this, I temporarily reset DEFAULT to the location of the alternate data set, and that's where the new...

I have a VFP7 application that is used by a church group to register attendees at conventions, record payments and meal preferences, print nametags, and so on. Last year, while it was still a VFP6 application the group started using it for registering attendees at several different kinds of...

I'm trying to make a report that prints a chart in a format other than the default. I'd like to (1) cause the chart to be a line graph instead of a bar chart, (2) drop the legend, and (3) show the values on the X-Axis. The following BeforeOpenTables method of my report charts the data from a...

Many thanks to the folks who sent helpful suggestions about this issue. After spending several days experimenting with their suggestions, I thought I’d report briefly on the results. (1) Using the Access MSysObjects table. This works fine, but there are a couple of prerequisites needed before...

I would like to be able to use VB.NET to search MS Access databases for basic schema information (table names, column names, etc.). I can get the names of columns in an Access table by connecting to an Access database, defining a select statement like "SELECT * FROM [tablename]&quot...

John, if I could give you five stars I would. Can't believe how long I looked for this information, and how easy it makes things.

A type of Windows form that I frequently need to use has a combobox at the top and a number of textboxes and checkboxes whose values should change depending upon the selected item in the combobox. I can bind the combobox to a column in a table in a DataSet, and I would like the textbox and...

Thanks, John! I just wish there were a few more "Perform" possibilities. I'm coming to VB.NET from Visual FoxPro, in which one can call any method from any other method.

This may be too late to help, but try the following (I'm assuming your variable is a string). Dim thisstring As String = "2,6" MsgBox("thisSTring was initialized to " & thisstring) thisstring = Replace(thisstring, ",", ".") MsgBox("thisSTring is now...