Search results for query: *

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

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

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

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

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

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

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

I can put a Visual FoxPro .exe file on our LAN server, give all the clients a shortcut to it, and it runs fine for all users, accessing SQL Server on another machine. If I build a VB .NET Windows Forms project, other users (with the .NET CLR) can run the project without having it installed so...

Seeing the handwriting on the wall, I'm beginning to retrain myself from Visual FoxPro to VB.NET. I'm reading Database Programming with Visual Basic .NET and Programming VB .NET: A Guide for Experienced Programmers, but now I need some actual software to reinforce what I'm learning. I can get...

I'd like to have FoxPro pop up the Outlook mail reader and display a completed e-mail message that the user can review, edit, send, or abandon. The following code gets me almost there--but the user still has to click Ctrl-V to paste in the message. The insertion point is already positioned...

We have a VFP6 application using SQL Server 7 as the back end. We just rewrote the whole thing (96 forms, 60 reports) to use SQL passthrough commands instead of SQL remote views. Everything's working, but about once or twice a day, a user gets the "Database object is being used by someone...

I have an extract-transform-load job that the user starts by clicking a button in a form. The form contains an EditBox that displays the contents of a memo column in an updatable cursor. As major events occur in the ETL job, I concatenate new lines of interesting and informative stuff about...

I need to find the path of a linked table in an Access 2000 database that I have open as an object in VFP6. In VFP, I open the Access database as follows: oAcc = CREATEOBJECT("Access.Application") oAcc.Visible = .T. oAcc.DOCMD.maximize && Maximize the project #DEFINE...

Is there any way I can switch the RecordSource of a grid without losing nondefault grid controls? Failing that, is there any way I can programatically reestablish the methods of my nondefault grid controls after I've rebuilt them with AddObject() code? I'm reengineering a VFP6 app (SQL Server...

I'm in the process of upgrading a large application from VFP3 to VFP6. When I try to run a report, a messagebox tells me that FoxPro is "unable to find _fpreset.prg". Sure enough, there's a field on the report that says "preset_____". It's there in the VFP3 version also...