Windows Tech >> Visual FoxPro >> Page 172

Topics

Replies

Last post

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