Search results for query: *

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

Suppose I have a Windows Form containing a button SetValues, and I have written code for the SetValues.Click method that assigns values to a number of variables. However, I would like the SetValues.Click code to execute when a user performs some other action as well--say, when she clicks in...

Does that work for you? When I paste the commands from your post into the Command Window and run it, I still get a blank line at the start of the message. (Shrug)

Thank you! This assignment: lcMail = "mailto:bill@bonzo.com" + ; "?&Subject=Tomorrow&Body=See you." now gets the address into the To: line and the body into the body--although the body is preceded by a blank line. But the Subject: line is empty. To get the subject...

I'm using ShellExec to prepare some e-mail messages. It works fine in Outlook 2000, but not in Outlook Express 6. In Outlook Express, the entire string ends up as the address. That is, if I set: lcMail = "mailto:bill@bonzo.com" + ; "&Subject=Tomorrow&Body=See you.&quot...

I have a DataGrid on a Windows form bound to a DataTable in a DataSet. The DataTable query retrieves columns including the OrgName and Orgid from a database table Organization. The Orgid is a meaningless sequential number, so the query orders the results by OrgName to help users easily locate...