-
- Control Excel Application
by MM ROy
- 13 Replies
- Last post
by Naomi Nosonovsky
- I am using Visual Foxpro 6.0. How to change the height, width and caption of excel application using with Visual Foxpro.
-
- Microsoft Visual FoxPro
by tqlashot_kk
- 5 Replies
- Last post
by Claude Fox
- Hi all,
Can anyone tell me if i can use the above on sql server standard 2005 edition...im building a window application (.exe), a costing system for our account dept here...
I've done lots of research on which languages to use, but i find foxpro match my description as it is more to client-server solution...any opinions / ideas would be really great.
really appreciate the hel
-
- Grid class
by Hans L
- 10 Replies
- Last post
by Hans L
- I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column
-
- 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
-
- to read text file thru foxpro
by polachan
- 4 Replies
- Last post
by Rick Borup
- Dear all,
Please help me by providing a sample program tips in foxpro to read a tab seperated text file into a DBF file
example the text file as follows
Code Name Joindate Salry
01 Alex 12/12/2006 2000.00
02 John 13/02/206 100.50
Regards
P
-
- file access is denied
by jan_sc
- 6 Replies
- Last post
by CetinBasoz
- hi all,
i am facing a problem with "file access is denied xyz.dbf" error. my project has 2 forms: one is an inquiry screen (with many users access it to at the same time) and the other one is an uploading form use to upload data from excel to xyz.dbf file. both forms using the same table (xyz.dbf). how can i eliminate the above mentioned error during uploading process, with users
-
- form refresh command?
by JCrum
- 5 Replies
- Last post
by Dan Freeman
- My colleagues have just migrated a FoxPro 2.5 app to Visual FoxPro 9. The app seems to work fine until they start moving the mouse. Whenever they move the mouse part of the main screen disappears. But if the click the mouse over the form that has disappeared then some of the controls start to reappear. Does anyone have any idea what is going on It seems like a refresh problem to me. TIA, Jennif
-
- strtran problem - string is too long
by help11111111111
- 8 Replies
- Last post
by Naomi Nosonovsky
- Hello everyone,
I have some memo fields with carriage returns that I need to strip out. The problem is that some of the fields have more than 255 characters, so I get the error:
[Error Code: 903, SQL State: S1000] [Microsoft][ODBC Visual FoxPro Driver]String is too long to fit.
I am very new to Foxpro but no matter what sort of magic I try I can't seem to figure out how to mak
-
- ODBC data source
by ionutp
- 3 Replies
- Last post
by ionutp
- Hello to all,
How can i create(by code) an ODBC data source
-
- Font Size Randomly Changing
by clut
- 10 Replies
- Last post
by AndyKr
- Has anyone experienced a problem in a FoxPro 9 application, where the font size of some controls on a form change It could happen going from form1 to form2, or form3 to form2. The size changes from 9 to 8, 12, or 18. There doesn't seem to be a pattern, and it could happen today day and not happen for several days later.
-
- prevent exitting...
by boyer79
- 3 Replies
- Last post
by boyer79
- I'm very new to FoxPro as well as to this forum, so if this is in the wrong location I apologize. I have a form with a text field (txtV_benefit) and a command button to calculate the number to be in txtV_benefit. What I want to do is prevent the user from clicking the X to exit the form if that value is 0.00 before hitting calculate. Any advise or direction as to where I can find examples would be
-
- 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.
-
- Append problem
by dvidal
- 3 Replies
- Last post
by dni
- Hi,
I have a problem with append command. In a pc, I have to write the file name enclosed by quotation marks. For example:
append from "pepe".
I want to know how to change fox settings to write:
append from pepe
Thanks,
-
- Get column name in SQL query
by Victor BA
- 14 Replies
- Last post
by Naomi Nosonovsky
- How can i obtain all the records in a specific column like:
select field1 from table
but instead of the name "field1" use a column number i'm guessing :
select 2 from table // The number 2 being the third column (starting at 0)...
is this the right way
Thanks.
-
- A couple questions about the OLE DB data provider
by mbarry
- 12 Replies
- Last post
by mbarry
- Hello! I'm looking to access a VFP database from an ASP.NET web application and I have a couple questions about the OLE DB data provider.
1) Can I use the latest VFP 9.0 OLE provider with a VFP 6.0 free table directory Should I expect any problems
2) Does the OLE DB provider have any dependencies on VFP E.g. could I install it on a machine without VFP and still be able to manipulate my d
-
- Using VFP to bold a row in excel
by mrfitness
- 14 Replies
- Last post
by Alex Feldstein
- I have a program that returns the value of a query and places it into excel. But I also entered a row of static text as headers. I want to bold the columns I want without doing a statement for each individual cell to be bolded. I cannot remember how to bold a selection of more than one cell in one command line. i.e. .sheets[esheet].cells(1,1).Value = "Contractno" &&COLUMN HEADER
-
- Append Records with multiple child tables
by honey1016
- 4 Replies
- Last post
by AndyKr
- What can i do if i will append the records with many child tables and it wil not affect to the database if your already append the records Please give some example of append. Thank you very much
-
- Default values
by Hans L
- 8 Replies
- Last post
by AndyKr
- I seem to have some trouble getting default values to show, in particular in optionsgroups. Where would I state the default value I have one optiongroup with 15 values, and I want no 11 to be the default. I tried to put 11 in .value, but that does not seem to work. Hans L
-
- 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
-
- Finding users who open tables
by Riclo
- 2 Replies
- Last post
by Bruno Yu - MSFT
- I need to know how to find users who have the tables open in a directory. I found a solution but i've get an error message at the registry. If somebody knows how to do this i'll appreciate the help.
Thxs.
-
- Opening VFP tables with Fox2.6 (Dos)
by Foxmonkey
- 9 Replies
- Last post
by CetinBasoz
- Hello. I am a novice user of Foxpro, occaisionally using Foxpro 2.6 for Dos for data manipulation. I am wondering if there is an easy and free way to convert DBF files produced with Visual Foxpro with 2.6D. We get batches of files that are produced by some later version (it signs a "30" in byte zero of the header, while our tables have the "03"). I get a message stating it is
-
- Browse problem
by MikePotts
- 9 Replies
- Last post
by Tamar E. Granor
- I'm currently migrating an application from FoxPro 2.6 to VisFox 9.0
I'm almost complete but have a strange problem with the behaviour of a browse window.
I've defined a window within a form, activated it and used 'browse fields....' to display data in this window. This works fine. However when I mouse down (left or right button) on the form outside the browse window the browse data
-
- Speed with CALCULATE
by Ed W
- 14 Replies
- Last post
by Tamar E. Granor
- I apologize in advance if my explanation and questions do not use the language and conventions of programming professionals, I'm a self-taught amateur. I've used VFP 6.0 successfully for many years and written many programs that have worked well but they certainly lack the sophistication and elegance that professionals would produce.
BACKGROUND: 6 tables are related via a common index
-
- KeyPress ESC (neophyte "programmer")
by lowellnelson
- 14 Replies
- Last post
by ibbm
- I am running a form with a grid. I want KeyPress (from the grid properties) to release the form on ESC; ie IF nKeyCode = 27 thisform.release ENDIF I can assign other keystrokes to KeyPress, and accomplish the task, but nKeyCode = 27 does not respond. What am I missing
-
- Visual FoxPro Report Designer Data Format
by TorrediPisa
- 1 Replies
- Last post
by Zografski
- Good morning
I am a beginner in using VFP and I am making a Report using The VFP Report Designer.
I want to print a numeric data (called w_data) with max length of three characters. Therefore If the number is 2, i would like it to be printed as 002 and
left justified.
I have tried to check the "Left Justify" but the dara remains at right.
Moreover I don't know what to put