-
- Grid Column
by honey1016
- 5 Replies
- Last post
by dni
- It is possible in grid column if I will add a new record it will focus to the top row not in bottom row because the record is ascending for example work experience from present to former company. If you have a new job then add a new record and it will go to the top row not in bottom row Thanks
-
- visual foxpro to excel
by Lakshmi N
- 5 Replies
- Last post
by PB_UK
- Sir,
I have 2 excel sheets.
one sheet contains sapcode,sapname,grpcod,prdcod,amt
another sheet contains sapcode,so many other fields and amt
both sheet contains multiple sapcodes
now my job is to
1. read first sheet into a dbf (sum(amt) group by sapcode because multiple sapcodes)
2. read second sheet into a dbf (sum(amt) group by sapcode because mul
-
- ON ERROR causes controls on forms to disappear
by Derek Dowle
- 14 Replies
- Last post
by Naomi Nosonovsky
- I have a routine that exports selected data to an excel spreadsheet that works perfectly. If an excel file with the name chosen already exists then the user is warned.
If the data is being exported to a file that is open then a program error message appears and when help is pressed 'File access is denied (Error 1705)', which is to be expected.
To overcome this I have used the follow
-
- Index On
by Somebody2
- 6 Replies
- Last post
by Naomi Nosonovsky
- I have a form with a listbox and a textbox. The listbox displays the contents of a table and is indexed by a name field in alphabetical order, so it displays all of the names in alphabetical order. I want to text box to modify the selection of the listbox. Is it possible to reindex so that the names would start with a different letter Say for example that I input R. Can I get it to index so the f
-
- New Grid Columns
by dni
- 9 Replies
- Last post
by dni
- I am running a form with a grid with 12 columns. It is working fine. At one moment in a click method I am adding more 8 columns . How can I do that new columns to have the same settings with old columns (header and textbox (font size,font,color,allignment...) I don't like to write 8 times settings for each properties ...
-
- create a key in registry
by le tan duc
- 7 Replies
- Last post
by le tan duc
- Please help me to create a key (Keyname='key name') in it: String name: (defalut) Type: REG_SZ Data: "Agribank" Thanks.
-
- Speeding up Foxpro - New Server - Multicore ? Xp V's Server
by J Garland
- 9 Replies
- Last post
by dni
- Good morning,
I am looking at a new machine to speed up a db i have in foxpro.
My quick question is for speed.
Does Foxpro take advantage of Quad Cores over Duals
and
Is their a performance increase in Foxpro for Server OS instead of XP
With Thanks
Jason
-
- solved, I think! VFP 9.0 - options mostly grayed out, why?
by Birdman
- 4 Replies
- Last post
by Naomi Nosonovsky
- VFP 9.0 options are almost all grayed out, does anyone know why that could be I am a new VFP user. Have installed VFP 9.0, to query someone else's FP database. The installation was on WinXP, without apparent issues. VFP can open the database & I can click on the tables and see what's in 'em, but that's it. Wizard is grayed out so I can't use the query wizard. Almost everything is grayed out.
-
- Why I can not read all kind of registry?
by Nigel36
- 3 Replies
- Last post
by Stuart Dunkeld
- I use the method GetRegKey, but with this, I can read only the registry that type is REG_SZ , but I need to read also the registry that type is REG_DWORD.
With What I can obtain the value of registry whom type is REG_DWORD
I have Windows XP, and use VFP9
Thank you.
-
- Valid event
by dvidal
- 4 Replies
- Last post
by Tamar E. Granor
- Hi,
I need to put a validation to a textbox field. I put some code in valid event. But when users enters a wrong value appears a message generated by visual fox pro: "entrada no valida"; How can I disabled this system message and use a messagebox to display my own messages .
When user enters a wrong value, I write that valid event return false.
Thanks,
-
- How to disable Foxpro screen?
by Joe Au
- 14 Replies
- Last post
by AndyKr
- I have a project with one screen form only. When I run the execute, the screen form is within the foxpro's screen. How do I make the screen form as the only window form shown on screen
Thanks.
Joe.
-
- Export from Visual Foxpro application to excel 2007?
by Yong Ling
- 3 Replies
- Last post
by CetinBasoz
- Hi,
I'm trying to export huge amount of data from visual foxpro application to excel.
Since the old version of excel can only handles up to 65536 rows, so I upgraded to excel 2007.
But after I exported to excel 2007, it still show me 65536 rows only instead of 1M rows.
Why it's still using the xls instead of xlsx
Thanks in advance.
Best regards,
Yong Ling
-
- Foxpro version compatibility
by Econdoc
- 2 Replies
- Last post
by Alex Feldstein
- I have many applications written in Visual Foxpro 6.0. I probably should upgrade to Version 9.0. My major concern is whether my old applications will run in Version 9. Can someone advise me Will I have problems How major Thanks.
-
- Buttons Disappear
by mrpaully
- 10 Replies
- Last post
by dni
- I have a form that submits an odbc query. Once the data is returned to a listbox, a number of the command buttons dissapear if you put the mouse cursor over them. Why is this and does anyone know the fix
-
- VPF 6: Problem sending the item from the combo to report designer
by MillBear
- 8 Replies
- Last post
by dni
- Hi all,
I have a problem sending the data to the report designer after selecting the data from the pull-down combo. There is a field namely lbl_attname in the report designer.
In Click procedure of the command button,
if not(empty(thisform.Combo1.value))
lbl_attname = alltrim(thisform.Combo1.value)
else
lbl_attname = 'To whom it con
-
- How to selectonentry an edit box in a grid.
by Aleniko29139
- 9 Replies
- Last post
by Aleniko
- Hi;
I have a grid with 2 columns: a txtbox and an edtbox.
For some reason the edtbox won't SelectOnEntry no matter what I do.
I've tried to set selectonentry for the column and the control itself.
I've set the format to "K"
I've set DynamicInputMask to "K"
highlight is .T.
Nothing works.
Any ideas
-
- REPOST: NOPAGEEJECT not working in VFP9
by riptramm
- 14 Replies
- Last post
by Tamar E. Granor
- If our OKI Microline 320 turbo printer always ejects a page after the command <<REPORT FORM myreportfile.frx TO PRINTER NOPAGEEJECT>> in a program, is this in all likelihood a VFP 9 software bug or is there a simple solution other than printing to a text file Could it be a faulty installation Also we've found that in printing 40 reports using VFP9 report forms, 3 or 4 will print out
-
- control access to my FoxPro applications within the application
by CowanJ
- 3 Replies
- Last post
by CowanJ
- Hi,
I am researching a way to control access to my FoxPro applications. For whatever reason I am not finding much, I assume I am using the wrong terminology. My goal is to control the number of users that can run my application concurrently. I need to be able to adjust the number of allowed users per site and also be able to add/subtract user count at any time. Believe it or not I have
-
- Retrieve current date data
by espirit
- 9 Replies
- Last post
by Naomi Nosonovsky
- Hi,
Im having a problem to retrieve data based on today date. I'm using Visual Fox Pro 6. My table structure is as below:
name type width
updated_on DateTime 8
I need to retrieve only data that is updated today or current date. For eg my table
datetime is 28/06/2007 12:00:00 PM, and I need to retrieve only data for today
which is 28
-
- how to set focus (or place the cursor) on a field in a form using code...
by ibbm
- 13 Replies
- Last post
by CetinBasoz
- Going back to the olden days I used to be able to move my cursor by using the code _curobj = _objnum(myfield)
How do I do this in Fox 6 What I am trying to do is at the click of the command button, clear my screen and start the user on the first or second field depending on what he is doing.
Thanks in advance.
-
- DBF to CSV conversion
by ram_mv
- 13 Replies
- Last post
by dni
- Hi, I am converting a dbf file into csv file using C#. My program is working fine for file having fewer columns in dbf file. If the dbf file has more than 255 columns, I am getting the error "FILENAME" is not a table. I am using Visual foxpro OLEDB friver. I downloaded drivers from http://www.microsoft.com/downloads/detai ls.aspx fa milyid=e1a 87d8f-2d58 -491f-a0fa -95a3289c5 fd4&
-
- Possible Bug in Foxpro 9
by Anonymous584079
- 3 Replies
- Last post
by Carl Warner
- Foxpro 9 on my laptop seems to loose conection to tables. I will open a database and a table located on my laptop. I browse the the table. I leave my laptop for a few minutes and try to browse again and I get an "Open" table dialogue box. This happens every time on my laptop but never on any other computer. Any Ideas
-
- insufficient memory - foxpro
by pinkstonm
- 5 Replies
- Last post
by Carl Warner
- I have an application I have used every year to do the scheduling for our non-profit youth basketball league and it is not working this year. WHen I execute the application I get the message Microsoft Visual Foxpro Insufficient Memory! Here are the knows Foxpro Runtimes or at least these are the ones I copied into the runtime directory to get around the previous problem where it said it could not
-
- Merge 2 text file
by espirit
- 5 Replies
- Last post
by CetinBasoz
- Hi...
I have to text file. Can anyone advise how to combine 2 text file into one file using Visual Foxpro 6.0. Thank you.
-
- Saving a variable to file
by Kadrin
- 5 Replies
- Last post
by Don Higgins
- Is there a way to save a variable to a text file I need to take a look at a variable inside a program I am debugging and need to do so without the program open.