Answer Questions

• Joe Zott main menu problem

  hi guys...im working on my thesis and its a library system...ive already created a main.prg wherein it loads the login form and then when the user enters the correct password, it shows a splash screen and then shows the main menu that i have created...what i want to happen is that, when i press a key, example is F2, a form that ive created will open automatically without clicking the menu to open it..will it be possible please help me guys...thanks :) If your form is also callablefrom menu set its shotcut key (accelarator) to F2. define bar 1 of myPopup prompt "My form" key F2,"F2" It is available in menu designer (can't describe exact place now, ...Show All

• mrbelk How to add my own objects to a grid programatically

  Hi all; I'm using this method to construct the columns within the grid. I need however to construct the grid so the cells are my own class objects. WITH thisform.kgrdledger1 .columnCount = -1 .RecordSource = "CurRpt" .addcolumn(1) .columns(thisform.kgrdledger1.ColumnCount).name = "colAmount" .colAmount.controlsource = "curRpt.Amount" .colAmount.header1.caption = "$ Amount" *****===>>> Here I would like to add object class 'mytxt1' instead of text1 endwith Thank you all. A couple of issues here. First, as Cetin said, assign the controlsource to the COLUMN not the textbox. Second you are not maki ...Show All

• Jonathan Stratford SCREEN RESOLUTION

  HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IF YES, PLEASE TELL ME HOW set display to vga25 Thanks but do any webiste teach how to create OOP framework Do a search for VFP Resizer classes on Google or other search. You can drop one of these classes on a form, set a few lines of code and it does all the work for you. It is not as elegant as Anchors but it works. Yes. But don't do it. This is one of the few areas where software CAN break hardware. If you set a video mode that the video card can't support, you run the risk of frying the user's equipment. I won't use software that behaves that way, and I wouldn't blame your users for doing the same. ...Show All

• Hokgiarto How to add my own objects to a grid programatically

  Hi all; I'm using this method to construct the columns within the grid. I need however to construct the grid so the cells are my own class objects. WITH thisform.kgrdledger1 .columnCount = -1 .RecordSource = "CurRpt" .addcolumn(1) .columns(thisform.kgrdledger1.ColumnCount).name = "colAmount" .colAmount.controlsource = "curRpt.Amount" .colAmount.header1.caption = "$ Amount" *****===>>> Here I would like to add object class 'mytxt1' instead of text1 endwith Thank you all. >> *****===>>> Here I would like to add object class 'mytxt1' instead of text1 YOu need something along these l ...Show All

• Jiajia MyEditor (Edit Control) Validation in VFP-9: STOPPING Menus, etc?

  I'm trying to *stay within myEdit control(s)* until *pProcessing* is finished. I seek *better ways*, per se, from any of you (besides making the form(s) modal). Here are some of my awkward (non-bulletproof) workarounds. In myEditor.VALID ... If pProcessing This.SetFocus * Return .F. Endif To STOP Menus... In _msysmenu: set skip for pProcessing (for every menu bar()... ) OR SET SYSMENU SAVE SET SYSMENU TO ...when pProcessing is finished SET SYSMENU TO DEFAULT (I'd prefer to make _MSYSMENU/SYSMENU just *freeze* ... in a modal (myForm.windowtype=1) manner and not have it *blink* off and on ) To prevent oApp.oToolbar... If pProcessing oApp.oToolbar.enabled=.F. Endif Hiding forms until pProcessing is completed, Etc. Etc. Thanks in adv ...Show All

• qayoom Weird "IIF" problem

  Hi, I seem to be getting a problem running the IIF statement using this particular code: "iif(((maturity)-(m.dday1)) between 365 and 730, 1, 0) as TERM" Basically Foxpro is saying that I'm missing a comma in this particular line of code. However, I can't seem to figure out where to place the comma. Thanks in advance! thanks so much! works like a charm! :) IIF() is an XBASE command. You are mixing with the BETWEEN SQL construct. Try using the BETWEEN() xbase function instead: Iif(Between(maturity-m.dday1,365,730),1,0) ...Show All

• Lee boon gan Working with field General!

  Hi, all! Help me to update field type General: append object, edit, open,... in VFP from program control with bottom command. (use line command MODIFY GENERAL <field gen> don't open object) Thank! If you 'have to' store in table then use memo (foxpro 1.0 and up, VFP9 BLOB). Microsoft VFP group should have realized that General field grows too fast. Almost unusable! Why they still keep this field type there. Alex Feldstein wrote: ... Instead: - Use BLOB fields (VFP9) or - Use a text field to keep the path+filename and keep the original file on disk You'll be glad you did. PS: Did I say ...Show All

• JohnGalt Cannot execute program outside VFP9 IDE.

  I have built my VFP9 application into both .app and .exe files and when I execute them, the VFP9 IDE starts up and runs the program inside of the VFP9 programming environment. As a result I cannot see how the program behaves on its own as if it were installed on a client's machine who does not have VFP9 installed. Could someone please indicate how I can run an application on its own without it having to run within the VFP9 IDE Thanks Place exe and other needed files to a folder. Rename your development folder (if you didn't write code that removes dependency to development folder). Dblclick the exe in explorer. Hi, To hide VFP main screen, you can put code below at your ...Show All

• Jehan Badshah Error Problem in FoxPro application

  Hello all, I am trying to open an application that was build using FoxPro and when I open it, I got this error message. I have no clue at all that it means. And if I click "Ignore" the application will run just fine. Here is the message error that I am getting: Error #1429 in Init line 27 OLE IDispatch exception code 0 from Nodes: Element not found.. Call Stack: 7 Surveys001.Oletree.Init (..\..\..\..\..\program files\tfhudgins\compressormanager\source\surveys.sct) 6 Cmstatemanager.Cmformcollection.Add (..\..\..\..\..\program files\tfhudgins\codemine\common50\cmstate.vct) 5 Cmstatemanager.Openform (..\..\..\..\..\program files\tfhudgins\codemine\common50\cmstate.vct) 4 Tbrlaunchpad.Chktoollaunchbutton1.Launchform ( ...Show All

• DevboyX Report strategy

  Hi everyone; I am going to develop quite a few reports for a customer. They want to develop a report engine that would let them customize reports both in the scope and in the format of the report. I am wondering if I should use a third party product like CR. Can someone give me some pointers ergarding the benefits of using CR or other reporting engine, and also how difficult is it to incorporate such reports into my application, and letting users customize reports Thanks. Aleniko wrote: How easy is it to customize fields in a reoprt if I am using CR If you're referring to the fields from the database, it's as simple as dragging and dropping onto the report in which ...Show All

• cgkitab Help creating a folder!!

  I am trying to create a folder with Visual Fox Pro, using the MD commnad, and i the name of the folder to be the currnet date, anyone has an ideea md date() doens't work Thank you, it works. Yes thank you both, it works. But now i wanna copy the database in this folder i just made, with the name as he current date. This doens't work: COPY FILE "receptii.dbf" TO (m.lcFolderName)\ Any ideea how Thank you. lcFolderName = dtoc(date(),1) && or ttoc(datetime(),1) to include time md (m.lcFolderName) You can even do this in one shot: lcFolderName = 'backups\' + dtoc(date(),1) md (m.lcFolder ...Show All

• Abdul Aziz Caps lock ON when application activate.

  Can I trap the 'activate' of my app I want to turn on caps lock every time the user selects the VFP application. I don't want to do this at the start of the app because the user may minimize the app and then get back to it. Thx. force capslock() = .T. check the status of capslock whenever some events occur and if capslock() = .F. U FORCIBLY TURN IT ON. DISPLAY A MESSAGE UR APPLICATION WILL NOT WORK WITHOUT CAPSLOCK ON. LOOP IS FORCE THE USER TO TURN CAPSLOCK ON, IF HE DOES'T DO THEN APPLICATION WILL NOT WORK. THANKS Maybe you didn't understand what Aleniko was saying. He says loop is unnecessary when the next command is enddo. ie: do while somecondition *.... loop & ...Show All

• Mark Jewett - MSFT Backup Options for newbie to VFP9

  Can someone please advise me on how to perform backups to either a CD or a memory stick from a menu choice Referring to a previous thread re the zip libraries, how would I call these libraries then actually perform the physical backup to the CD or memory stick The users want VFP9 to completely run this routine for them without any intervention except either inserting a CD or placing the memory stick in the USB. Previously, the 2.6 app used the run pkzip then copied the file to a disk drive. Thanks Sammy32 Thanks everyone for your assistance. I'll get the users to schedule a backup, but I'll zip the files using the zip utility you mentioned. Sammy32 ...Show All

• NessDan Listbox causing error

  Hi I have a listbox in which I fill with values from a SQL based on a selection chosen by the user. The listbox allows the user to select the value they want from the list and enter payments for that person. However my problem occurs in instances where the list box contains more records that are shown in the main listbox window and the user has to scroll down the list. This is usually 500 or more records. When the user selects any of the records nearing the end of the list, the entire application closes with an error saying "Syntax error" and it is going straight to the read events. It however does not tell me where the syntax error is. For any of the records closer to the beginning, everything works fine. Help please. ...Show All

• grellsworth Excel to cursor SPT problems

  I am using a SPT solution to take information from a .xls file and importing it to a cursor with this solution: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 However, I am now receiving problems where before I had not. Now I am getting Error 1466: Connection handle is invalid. Any ideas guys I can't see what the problem is but it occurs at the sqlstringconnect( ) line. Thanks! Dave's code is a subset of what I've posted and I think I have posted it before (not sure). If it's coming during SQLExec() makes more sense, because as I said before you shouldn't trust all tables in Excel are named "Sheet1$". For example: use customer copy to mycustomer.xls type xl5 Open the xls in Excel and ch ...Show All