Answer Questions

• Rob Lemmens SELECT statement is showing unwanted display of data and is not passing data to a table.

  I'm using a SELECT statement to pull out data from a table... that is working great. What I'm trying to do is feed the selected data to a different table using REPLACE so that it can be used by a report. All of this is triggered from a command button on a form. Here's the code for the CLICK property of the button: SELECT store, stock, year_1, make_1, model_1, auction1, transport, recon, sold_for, fees, net_check, result ; FROM wholes ...Show All

• Guitarguy Obtaining a web page's title

  I'd like to get the titles of web pages, and would prefer not to do this by loading all the web pages into a webbrowser, because that seems a bit heavy handed. In VB6 I used some APIs to achieve this, but I'm not having any luck in getting it to work in .net. Here's the code I'm trying: Module Module2 Private Const INTERNET_FLAG_RELOAD = &H80000000 Private Declare Auto Function InternetOpenUrl Lib "wininet" Alia ...Show All

• XgenX KeyPress

  Hello everyone, I was trying to use KeyPress to do the same code I have on a command button that runs a report with its preview. The problem is that when I press the key (in this case Enter) and the report execute, the preview doesn't work as when I click the command button. When I'm in the preview (using the command button) the preview show its 12 pages and I can see every single page but when I press Enter, the preview show me the first page a ...Show All

• Garyrg9 HOW TO ADD AUTOMATICALLY A LOT OF .dbf FILE INTO A DATABASE .dbc FILE ???

  Hi! In a folder I have a lot of .dbf file! I want to do the upsize to a MSDE, but I can't do it from a folder that contains the .dbf file....I need a .dbc file! So, when I create a new .dbc file from the project manager, fox can't allow me to add automatically all the .dbf file that are in my folder! I must add one by one...but this procedure is too much slow! Can you tell me how to add automatically a lot of .dbf file into a .dbc If exist ...Show All

• Robin Vermeirsch Accessing FoxPro from C++

  Im about to start a project that requires that I monitor a FoxPro application. In particular I would like to gather information on user entry, ie when someone is entering something into a text box. Ive had a quick look at the API and perhaps could take a look at variables (Load) that the text box writes to but does anyone have any other ideas Regards, Mark Hi Mark, You don't have to write anything VFP sp ...Show All

• Simon Smith Log in

  I need to create a log in screen and need to have 3 levels of access rights for users.  Level 1 user with very limited rights (access to just a couple of forms) up to Level 3 full access to all functions.  I currently have a table with first and last names user names passwords and access rights.  Any thoughts or suggestions Thanks  Hmmmm.... I have it in my VFP 3.0, 6.0, 7.0, but no ...Show All

• JFalcon deployment, building exe problem

  OK, this is the third round. I still cannot run an exec file. I cannot build it properly. When I issue (in the Command Window) BUILD EXE the intellisense prompt appears with my app name. So, I accept the rest of the clause as default. Until today I could generate .exe with no problem but had problem getting it started. Today finally for reason I cannot explain an error appeared during BUILD: Unable to find Unknown ARR . Jus ...Show All

• James Dunn cryptography failure

  I use _cryptapi class of the _CRYPT class library to encrypt limited amount of information: ids and passwords. They are in a table and the table feeds treeview items on demand. Before appearing in treeview the field values are automatically decrypted. Everything has been working fine until I noticed a problem yesterday. I have done most of development on C: drive but recently began moving the whole project to a G: drive since I set a new OS u ...Show All

• ader10 picturebutton in Foxpro 8 and 9

  Hi there, I have a maybe dumb question. I would like to use a graphic as a button with text on it that i can change. This is easy with the button object but on that i am not able to place the text over the graphic, showing only the graphic with the text on it. Text cut just be placed obove, under left and right off the graphic. I tried to use a graphic object with a text label over it,  looks good but the label blocks the mouseclick to the ...Show All

• Kunk New to Word integration using DDE

  We currently are using word integration that involves a foxpro table where each field represents a mergeable item.  The data from the foxpro table is pumped into an excel spread sheet and then into Word.  I want to eliminate excel as well as get around the limit of being only able to have 255 merge fields.  To this end I want to have one foxpro table that contains two fields , the first field will hold all the merge field names, a ...Show All

• mr pitiful MSComctlLib.TreeCtrl.2 Problem

  Working with the treeView Control I ran into an unexpected problem. It appears to be impossible to collapse a node branch programmatically. Collapse is an event, not a method and when I tried to use it as a method I could not get anywhere. I also tried to employ DblClick with the same negative result--the tree does not budge. Aside from Collapse I will need Expand as a method not event, although I am using it as even already. The expansion ...Show All

• Cherming missing object

  In our program, we call form "BB" from "AA" and can refer back to object "AA" from "BB" with no problems.  Now from form "ZZ" call "AA" then from "AA" call "BB", now "BB" cannot refer back to "AA".  Instead, we get "cannot find object 'AA'", even though "AA" is still open on the screen. Thanks in advance. I am not sure how you are referring to each of the forms in question, but I will g ...Show All

• SHBS Main Window Default Size/Location

  I would like to know what determines where the compiled EXE application window opens and what size it is. I would like to have the window: - remember if it was maximized or - remember last size and position Right now it is always starting in the top/left corner and I'm not sure what I did to get it that way. Thanks If you must do the procedure to move the window then set lockscreen to .t. then move the form, t ...Show All

• Fernando Zamora DBclick

  the dbclick event can't be effect after i wrote program in mousedown event in grid control.how can i fix it thank you i can open the form if i delete all code in the mousedown event.but it doesn;t work if i put code in then i can;t open it and  my code is in the text control of the grid here is the whole code: LPARAMETERS nButton, nShift, nXCoord, nYCoord DO CASE  CASE nButton+nShift = 3 &&left button + ctrl    ...Show All

• Martin Ottosen class called

  dear all, i have a class to detect table open exclusive or not in my project. when i put my code at load event it prompt me unknown my class. but when i put it at init event it run normally. thanks in advance. hm ic becoz my company use this class netuse to detect the table is open or not thanks in advance. here is the code SELECT B IF !thisform.utility1.netuse(mdatapath+"FILE14",.F.) RETURN ENDIF ...Show All