>> Visual FoxPro >> Page 182

Topics

Replies

Last post

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
How to Filter Records in a Grid
by msw

8 Replies
Last post by MarciaAkins
- - I have a simple form with a Grid that displays my customer database. I would like to place a combo box at the top of this form and when I start typing in it the records would start filtering down. I Have an index created for Lastname and I can list the records but I can't figure out how to make the filter work as I start typing. Thanks for your help...Scott
NYC User Group meeting on October 4th
by Naomi Nosonovsky

2 Replies
Last post by Aleniko
- - Hi everybody, New York City next User Group meeting will be on Oct 4. Chaim Caron has agreed to make a presentation on error handling, and asks us to consider the following. What are errors What is a bug How do we get bugs and what can we do about them How can I protect my data from errors How can I protect my application (and myself) from errors What is the primary responsibility of an applica
Uploading file or append
by honey1016

3 Replies
Last post by honey1016
- - I want to know what the best syntax when i will append a record to one table For example ID No is the Primary index, theres a 10 records but the 1 record the Primary index or the ID No already exists I want the 9 records will be upload and the 1 record is ignore. Please help me. Thanks
Running MSDOS application from compiled Foxpro
by Eddie N

8 Replies
Last post by Nugroho2
- - My compiled Foxpro project (EXE) runs OK at home. I ported it to a network, and everything goes well except one, i.e. it fails to run an MSDOS (console) application (EXE, Visual C++) called from a procedure. I open the MSDOS (command prompt) window and run the application directly from there, it runs OK, but could not be called from the Foxpro application. What could be the problem I have r
vfp 6 reports
by jmom

2 Replies
Last post by jmom
- - I am using report format environment preview. When through terminal services, people are able to click the print icon, but they are not able to print out their report. Do I need to specify local printer I am newer to using FoxPro
SQL Select to ListBox
by Somebody2

6 Replies
Last post by Naomi Nosonovsky
- - I select data from an SQL database and want to display that information in a list box, but am having trouble getting the data to display. Select Statement - Code Snippet SELECT first, last FROM parents WHERE parents. last = m.lname INTO ARRAY pinfo Now I want to display first and last in a list box, but don't know how. Is it best to save it into an
Inserting and Updating images file from VFP9 to SQL Server 2005
by vkbajoria

14 Replies
Last post by SaleBoy
- - i am developing a form where i am collecting personal information such as name, address and signature of the person as a bmp file........ i am saving the data in the SQL Server 2005 . My front end is VFP 9 forms. i am building a SQL query to insert the record....... the prob that i m facing is that i cannot concatenate the image type with the SQL string that i m building the insert work
select statement with "like" condition...
by ibbm

2 Replies
Last post by ibbm
- - I am trying to do a select query to pull all clients with a fullname starting with a "K". I tried this statement but I get nothing. What am I doing wrong SELECT tmpclients.* FROM tmpclients WHERE tmpclients.fullname like "K" ORDER BY fullname Thanks as always
how do i disable the windows logo key?
by Madix_t

14 Replies
Last post by Madix_t
- - good day to all experts... my internet monitoring system runs fine in more than a year now, but recently i encounter a problem in a latest internet games. At first my form as a wall paper will be always at the top of all open programs at the desktop. When dis-abled at the server that's the time they can use the workstation. but one user yesterday found a hole in my system, that when
Append General Image Problem
by semperego

1 Replies
Last post by Naomi Nosonovsky
- - I have a re-occuring problem when attaching a bmp image into a general field. The image comes in with the image name showing at the bottom while the top is a very pixelated thumbnail. It only happens on some computers. Did anyone encounter such a problem and is there a solution for it
Visual foxpro
by HK_president

6 Replies
Last post by Craig Berntson
- - Dear all, Where can I get the trial of Visual Foxpro
Rotation vfp helpfiles not working
by Fox Me Up

5 Replies
Last post by AndyKr
- - this code is copied straight from vfp 9.0 help files. i just added the two paramateres this code works in vfp and when i run just the application on the computer that has vfp installed. however it is not working on non vfp computers. on a non vfp computer all i see is a wait window that says rendering and its tallying up the pages. PARAMETERS REPNAME,ANGLE_OF_TILT LOCAL oListener o
subtotal field
by NILKAMAL

4 Replies
Last post by NILKAMAL
- - hi! i know this easy question for other but i am new in foxpro how do i do calculation of two field in form e.g field a + fieldb field c = fieldA+fieldB let me know which book good for me to learn foxpro thanks
invisible form
by RavindraPatil

5 Replies
Last post by RavindraPatil
- - Dear friends, I use vfp 6. I have a form with 10 fields and a grid. When I run the form. The form is not displayed at all. But it is there. Because after each tab the cursor moves to the next field. I can see only blinking cursor and neither form nor the fields. please help
Hiding parts of a form
by Kadrin

7 Replies
Last post by Kadrin
- - Hello everyone, I am in the process of creating a form and was curious as to how to hide certain parts of a form and have them appear if a checkbox is checked for example. You see I am trying to avoid the validation for it if it is active all the time. Since, if it is shown, all of the fields (lets say there are 8 fields) must have information entered into them. That means validation to make sur
how do i disable the windows logo key?
by Madix_t

14 Replies
Last post by Madix_t
- - good day to all experts... my internet monitoring system runs fine in more than a year now, but recently i encounter a problem in a latest internet games. At first my form as a wall paper will be always at the top of all open programs at the desktop. When dis-abled at the server that's the time they can use the workstation. but one user yesterday found a hole in my system, that when
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,
Formatting Graphs
by Derek Dowle

9 Replies
Last post by Derek Dowle
- - I am using FoxPro 9 and have inserted a graph onto a page of a page frame of a form. I have been following the principles of the 'How do I create a graph using MSGraph from Marcia Akins white paper Creating Graphs In VFP. This white paper has been very helpful as I did not know where to start before reading it. I have succeeded in populating the graph with the correct data and displ
Upsizing to Firebird
by ionutp

5 Replies
Last post by Naomi Nosonovsky
- - Help me to upsize a database to a Firebird database.
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.
Run stored procedures in SQL using VFP6
by mrfitness

2 Replies
Last post by Carl Warner
- - Below is a task I was asked to do: Have the client application call SQL Server stored procedures and views that run on SQL Server, and only return the data the Visual FoxPro clients needs. Therefore, my program could run stored procedures on SQL Server which accomplish the grouping tasks (2 select statements into cursors), then pull down an aggregated (2 tables medium and high.) Then my code can
merge fields ... right justify
by rwsgy

12 Replies
Last post by Naomi Nosonovsky
- - I want to merge two fields and somehow right justify the second field (dollar amount) so that the decimal places are aligned like this: Record #1 Location = The Palace House Amount = 125.56 Record #2 Location = Convention Center Amount = 1.10 Record #3 Location = USA Wharehouse Amount = 6457.54 then RESULT should be: The Palace House 125
VFP Messagebox on top
by Bit

4 Replies
Last post by Bit
- - Hi, Is there a way to display the messagebox on top of other window (Does it mean I need to use "Wait" or "do Form" ) Thanks, BIT
_Screen.AlwaysOnBottom Not Allowed?
by Docpro777

4 Replies
Last post by Docpro777
- - Masters and / or Friends. Is _Screen.AlwaysOnBottom Not Possible in VFP-9 I really hope to find a way to make myApp.exe appear like WallPaper in Vista. (Note: Vista does not seem to support Web-Pages as WallPaper on Vista Desktop ... XP is no problem) Any suggestions Perhaps a Win32 API function that does 'AlwaysOnBottom' Thank you much for your invaluable thoughts