-
- Copying from one sheet to another within the same book
by Sleepgone
- 3 Replies
- Last post
by CetinBasoz
- I am creating a workbook for a local company using excel. I've got most of the book worked out except that when information is input into the "main" sheet I need the same information - the entire row - copied over to another sheet within the same book depending on certain criteria. In other words, if the value in a column is 2 then copy the entire row to sheet 2, if it's 3 then copy to s
-
- Search Company function: Type any letters to find a few similar company names
by MillBear
- 8 Replies
- Last post
by CetinBasoz
- Hi all
I create the form to search the company name. I have the long list of company codes & names inside the table (company.dbf).
Form Designer
Company Name : <Text1>
<Grid>
Code | Company Name
Search Command Exit Command
For
-
- SEEK() not seeking
by JCrum
- 6 Replies
- Last post
by JCrum
- The help topic for the SEEK() function only states that it will search for "eExpression". Does anyone know specifically what types of "eExpressions" can be used with SEEK() I'm using SEEK() to find a record but the problem is the indexed field is bigint and the eExpression I'm passing it is a string equivalent. SEEK() cannot seem to make this comparison and the results are mis
-
- parent and child table
by honey1016
- 4 Replies
- Last post
by honey1016
- What can i do if want to update the index of the parent table and the child table will be already update Thanks
-
- Cetin Basoz - The Universal Thread Personality of the Year 2006
by SharathMum
- 0 Replies
- Last post
by SharathMum
- Cetin Basoz has been selected has The Universal Thread Personality of the Year 2006 for Visual FoxPro & .NET VFP (2004,2005,2006) & .NET (2005,2006) http://www.universalthread.com/Personality.asp Congratulations Dr. Cetin Basoz (He is a licensed Medical Doctor)
-
- DBF Viewing on DataGrid?
by rattlesnake316
- 5 Replies
- Last post
by CetinBasoz
- How to connect and view a DBF File on the datagrid
What command can be used to SELECT Data on the DBF File
Also what provider to choose to connect to a DBF File
Hope someone could help me.
Thanks in advance!
-
- 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.
-
- converting old fox 2.6 reports to vfp6 errors...
by ibbm
- 6 Replies
- Last post
by Naomi Nosonovsky
- I know this goes a long ways back but does anyone know why would some of my old reports not convert to the new version. Some do but most don't. It just says conversion errror and won't let me look at it. It runs but I cannot make any graphical changes unless I do it through the actual .frx file.
Thanks in advance.
-
- HIDE MENU exposes itself?
by Docpro777
- 2 Replies
- Last post
by Docpro777
- "HIDE MENU _msysmenu" and "DEACTIVATE MENU _msysmenu
... have been failing to keep _msysmenu hidden after certain simple myModal forms are called (via object 'click' methods)
The deactivated (or hidden) _msysmenu seems to abruptly issue a "SHOW MENU" (or something) between 'queryunload' and 'destroy' events of those modal forms ... during their release.
I've tried
-
- Visual foxpro 9 watch hang
by cristi_bd
- 11 Replies
- Last post
by cristi_bd
- I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and&n
-
- using FTP in Foxpro
by Murugan.G
- 2 Replies
- Last post
by Naomi Nosonovsky
- Hi..
How do i connect a file placed in FTP via Foxpro, is it possible to append the file online
-
- Move pointer of a table to last record
by Ahsan Amin
- 12 Replies
- Last post
by CetinBasoz
- Is there any way to move the pointer of a table to last record apart of 'go bottom' func.
Regards
Ahsan
-
- DISTRIBUTING MSCHART
by Mervyn-w
- 12 Replies
- Last post
by Mervyn-w
- I have coded mschart into an application and it works extremely well until I attempt to distribute it.When the distribution disk has been installed and the graph section selected an error message "The item you are trying to load is unavailable. Please insert Proffessional English Disk..."
Obviously I have to attache something else but what Your help will be very much appreciated. Merv
-
- build exe application
by lowellnelson
- 8 Replies
- Last post
by lowellnelson
- I am a neophyte FoxPro programmer, AND I am new to forums such as this, so please bear with me. I have been using a simple program utilizing a few free tables and some report forms, which I have been running within FoxPro. Now I want to generate an exe version for distribution to other computers in my area without installation of FoxPro at those locations. I have used the build command from the pr
-
- 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
-
- Virtual keyboard problems
by RickyPontes
- 4 Replies
- Last post
by RickyPontes
- I'm building a Virtual keyboard in Fox Pro. So far no problem, but now i'm having some problems with the cursor keys and delete key.
This is the code I'm using for the A key click and it's works fine.
DOEVENTS force keybd_event(65,0,0,0) keybd_event(65,0,2,0) DOEVENTS force
but the delete key and cursors key it's not working. I'm using code 46 for the delete key and 37,38,39 a
-
- Report navigation buttons disabled
by Luke2007
- 8 Replies
- Last post
by Naomi Nosonovsky
- Hi Everybody!
I recently upgraded to VFP 9.0 SP2 and recompiled my application.
What I found is that while viewing report from the application the report navigation button is disabled. I only could use PageDown and PageUp keys from the keyboard. Did I do anything wrong or missing anything I used "SET REPORTBEHAVIOR 90" in the program.
Thanks.
-
- New to Visual FoxPro
by youngseanyoung
- 6 Replies
- Last post
by youngseanyoung
- Greetings & Salutations,
I'm new to the software, but the company I recently joined has been using it for ten years to create their proposals. Trouble is, they are using version 0.921.8.
My question is this . . . is it worth trying to find a resource I can utilze to upgrade my datatbase within this old a version, or am I better off just starting from scratch.
-
- Arrange the "character string" numbers in order
by MillBear
- 6 Replies
- Last post
by CetinBasoz
- I use the character string for number input.
What Syntax should I use to sort out the ˇ°character-stringˇ± numbers as below
For example:
To sort out according to the number
1 1
12A 3
3 4
4 5
443546
-
- MD5 File Checksum
by UHTMilk
- 5 Replies
- Last post
by Naomi Nosonovsky
- Hiya, I would be very grateful for any advice anyone could lend on obtaining a file checksum in VFP. At the moment I'm trying to find it by calling the fciv utility with the run command.
Like this: -
Code Snippet
doscmd = "fciv -md5 C:\t.prg" DECLARE INTEGER WinExec IN win32api STRING command, INTEGER param retval = WinExec(SYS(2004) + "FOXRUN.PIF /C " + doscmd,
-
- fast / draft mode printing in vfp
by RavindraPatil
- 14 Replies
- Last post
by CetinBasoz
- Dear friends,
can we print in draft mode as in DOS by using vfp report writer
-Ravi
-
- Query result on textbox
by Victor BA
- 5 Replies
- Last post
by CetinBasoz
- I'm trying to return a value from a query and show it in a textbox, like this:
use table1
private x;
select count(*);
from table1;
into x;
thisform.textbox.text=Str(x)
&& I also tried ..... x=select count(*) from table1;
but doesn't work, what am i doing wrong
thanks
-
- Full Screen Question
by Yin Lai
- 14 Replies
- Last post
by Yin Lai
- I am using visual foxpro 7.0. I need to set my program to full screen and limit the user option. That's mean, user just can use that computer to key data using the program and cannot do anything else (cannot open other program) except if they log out. Hope some expert can help me solve the problem. Thank you very much.
-
- ComboBox Control
by Ahsan Amin
- 14 Replies
- Last post
by Naomi Nosonovsky
- I have to to fill a combo box control with a table fiels with 'Please Select' at top.
-
- application question
by dvidal
- 3 Replies
- Last post
by dni
- Hi,
I have the following problem: when I run a form in fox environment, it runs well. Then, I generate a file with extension .app that includes this form. But when I want to execute the file .app from windows, it executes the form and it disappears immediately. How can i solve this problem
I work in visual fox pro 7.
Thanks,
.