-
- 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
-
- system messages (sendmessage api)
by fvp4ever
- 6 Replies
- Last post
by fvp4ever
- I'm going to get system messages sent to my forms for example wm_devicechange which sent by os but I do't know how to do that. any idea thanks
-
- date question
by dvidal
- 5 Replies
- Last post
by dni
- Hi,
I have two questions about managing dates. First, anyone has a code example of how to work with date controls. Second, I don't know how to make jump a cursor in a text control. For example, the date must be entered in the format: dd/mm/yyyy and I want that when the user types dd, the cursor will be in the position mm (in other words, I want that the user don't type '/' character).
T
-
- Locate Command
by Ahsan Amin
- 7 Replies
- Last post
by hangover
- I have to locate the CourseID field from a table. I have a combo box that list the CourseName field.
CourseID CourseName
------------- -------------------
1 SE
2 VFP
3 ASP
Now if use select VFP from the Combo i want the courseid 2. I am using the follwoing code
LOCATE FOR a_Courses.CourseName = thisform.cb
-
- Indexed field problem
by Ravindra Patil
- 3 Replies
- Last post
by Ravindra Patil
- hi generous friends,
i m using vfp 6. I have a form with data environment having a table that is indexed on 3 fields with tagname reg_no, name, surname. my form has four record navigation commandbuttons viz. top, prev., next and last.
When any navigation button is clicked I want to move the record pointer in sequence of the first tag i.e. reg_no. So i have given command "Set Order to re
-
- Not Enough Memory o Complete the Operation.
by AlexBB
- 14 Replies
- Last post
by AlexBB
- There is a chance that this is not the forum where I will ultimately get an answer since I do not know where the root of the problem is but still I am asking for everyone's attempt to brainstorm.
It is actually a continuation of the previous notorious PACK <tableName> thread. Since I felt that I ran into a stonewall I devised a DEVIOUS (!) plan to crack the problem. It appears to ha
-
- Modify Structu Ctrl Arrow-Up and Arrow-Down
by rwsgy
- 3 Replies
- Last post
by Craig McGuff
- Using VFP6 and 8, I remember when modi stru a table, I was able to use the Ctrl-Arrow down and up to move fields up and down. But now it doesn¡¯t work. Any idea how to make it work TIA (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&
-
- 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.
-
- Code in VFP9 runtime application scrolls on screen.
by Derek Dowle
- 3 Replies
- Last post
by Naomi Nosonovsky
- I have a routine in an application to export data to an Excel Workbook that runs as designed in the development environment but not in the runtime environment.
When exporting data there are two particular errors that need to be trapped.
The first is when the name of the file already exists. In this case VFP appears to be able to resolve the problem automatically, without the n
-
- Errors running FoxPro Stored procedures in .NET windows app
by TechMate
- 10 Replies
- Last post
by TechMate
- Hi
I want to run a stored procedure in user selected database which basically creates two new tables to be persisted in the same database. I am able to call this stored procedure but I keep getting the same error "One or more errors occurred during processing of command." There are no details of what the error is specifically about. I am able to run the same stored procedure using Mic
-
- Sterling Pound Sign...
by Pablo Jord
- 2 Replies
- Last post
by dni
- Hi All,
I am printing some dividend cheques at the moment for a customer of ours. I am using PCL codes through FoxPro for Dos. For some reason when I try to print the ¡ê sign to denote the conversion to sterling the pound symbol will not print. I can print the symbol on my laster printer but it will not print on our printronix printers. Has anyone had this problem Thanks for your help.
-
- odbc driver
by vhockz
- 2 Replies
- Last post
by Alex Feldstein
- im using visual foxpro 7, and need to add odbc driver, but there was an error that i need to install current version of odbc driver. The problem is i didn't know rhe specific file that i need to download. tnks
-
- reading a directory for a existing files
by Novelle
- 14 Replies
- Last post
by Novelle
- hi there!
im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames.
can someone tell me how it works in vfp it will really be great... thanks in advanced!
novelle
-
- Printing Query Results
by Dohko
- 9 Replies
- Last post
by Naomi Nosonovsky
- Hi
I have a table that has one column with numbers 1 to 51.
I would like to know how can I write a statement that will let me Count the frequencies of each number and store it in another column in the table.
I would also like to access this data with a variable for example
n=1
for n=1 to 51
numbers
frequencies
endfor
Thanks
-
- do I have to close tables in DE?
by Lightening
- 9 Replies
- Last post
by Naomi Nosonovsky
- I have several tables in the DE of a form.
When I close the form, do I have to
Select myTable
Use
.....
to close these tables in the Destroy or Release event
Or do they automatically close by themselves when the form is released
-
- textbox length
by Ahsan Amin
- 10 Replies
- Last post
by PB_UK
- when i enter something in the text box the cursor automatically moves to next record ater entering 30 characters. I have not set it's lenth. so what's the reason
-
- Data environment with MDI
by Victor BA
- 5 Replies
- Last post
by AndyKr
- I have an MDI form with a child form, in the MDI i have 1 textbox and 1 button, and i want to search for a record in a table (which is connected with the child form), but the results must be in the controls on the child form...i would think of this like...manipulate the data in another form, how can i do this
Thanks
-
- FoxPro SQL help for Date Formats.
by Robeen_S
- 11 Replies
- Last post
by CetinBasoz
- Hi,
I'm using this SQL in FoxPro:
Select field1, field2, field3, substr(DTOC(datetimefield_1),1,10), substr(DTOC(datetimefield_2),1,10) from mytable.dbf where field1 = "searchvalue"
It works.
But I would like to specify that I want the datefields to be displayed in mm/dd/yy format rather than use the substr() function to truncate the datetime at the end of the yyyy. It seems
-
- Why my VFP exe file cannot be launched?
by Lightening
- 9 Replies
- Last post
by Lightening
- I complied my program under VFP6 into an exe file in the program folder. But it cannot be launched. I believe there is nothing wrong with the code, because I just made a minor change.
The funny thing is that if I copied the file to other folders on the same drive, it works! And even more wear is that some old version VFP exe files could not be launched from within that program folder, either. I
-
- How to avoid "Saveas" dialog box while using IE ExecWb(4,2)
by Tang Jian
- 8 Replies
- Last post
by Claude Fox
- Dear all,
I want to save all contents of a web page to local harddisk automatically, pictures included if any. But while I use the following code, the dialog box shows. Any one have good ideas
*****mycode in vfp9, Windows XP, ie6********
ee=CREATEOBJECT("internetexplorer.application") ee.Visible =.t. ee.Navigate(" http://www.baidu.com/ ") wait window "wait for a
-
- serious problem using VFOX9! INCREDIBLE! HELP! HELP!
by Zava Matteo
- 4 Replies
- Last post
by CetinBasoz
- Please contact me: matteo.zavattari@elmec.it (the alert don't work)
Hi all, we¡¯re facing a serious problem using VFOX9. This problem is not contained in the previous versions of VFP (8,7,6). This occurs when two or more different users share the same table using the optimistic buffering (5). This happens on a network or simply using two different instances of VFOX9 on the same PC. Sharing tab
-
- problem with class
by Fox Me Up
- 3 Replies
- Last post
by Budoi
- i get the error ole error class is
not registered...... what does this mean and
how do i fix it
i read the vfp help files on it but it was too confusing for me.
-
- Not a table message...
by Pablo Jord
- 4 Replies
- Last post
by Pablo Jord
- Hi All,
I have a Visual FoxPro table which I use as a backup table. I have a lot of records in it at the moment. When I was trying to open it yesterday I got the following error: Not a table. I can't seem to open the table at all. The table must have got corrupted etc. Is there any way I can retrieve the contents of this table without having to do a restore from a previous backup.
Pablo.
-
- Separators in toolbars.
by Aleniko
- 5 Replies
- Last post
by Naomi Nosonovsky
- Hi; Is there a way to add a seperator visualy into a toolbar between existing command buttons... WITHOUT GOING INSANE :-) Thanks, Alen.