Visual FoxPro

Page 214




  • Topics
    Replies
    Last post
  • Create an event schedule on a calendar
    by Bob Gatto
    3 Replies
    Last post by Alex Feldstein
      • I'm working on a project where a user wants to show there scheduled events on a calendar. The way they want to show it is, displaying a bar across the days that the event takes place. They want this on a web page and in Word. I'm using VFP 9.0 and I know it has web tools, but I've never used them. Could someone please point me in the right direction of how to do all of this Thank!
  • Any way to print multiple copies of a report from within the reportlistener
    by ControlNode
    5 Replies
    Last post by Naomi Nosonovsky
      • I have a table that the reportlistener uses for determining the printer that a report is sent to and that is working fine, but now the requirement has been added to adjust the number of copies of a report to print, or to disable a report all together. The settings screen and table have been updated to support "Print Count". The disabled part seams easy, if the Print Count = 0 have loadre
  • VFP 9 Macros puzzle
    by ZRK
    2 Replies
    Last post by ZRK
      • In my menu I have DEFINE PAD Program OF _MSYSMENU PROMPT "\<Program" DEFINE BAR 12 OF program PROMPT "\<Elections" DEFINE BAR 5 OF elections PROMPT "Voting \<Demo" I am using macros to start the demo {ALT+P}ED or {ALT+P}{ALT+E}{ALT+D} neither works MANUAL KEY ENTRY ALT+P E D works fine KEYBOARD "{ALT+P}ED&
  • VFP9 applications running much slower than VFP6 and VFP8
    by xuyca
    6 Replies
    Last post by Tamar E. Granor
      • I have same vfp application program. But I found that it run much slower than previous version when loading a form in vfp9 compiled application. Anybody have same problem
  • 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
  • REPLACE command help wanted
    by AlexBB
    14 Replies
    Last post by AlexBB
      • If not mastering counter intuitive VFP object manipulation was not hard enough in the past until I finally got a handle of it, now trying to do it from OleDb .NET code is like moving through heavy water--it is 10 times more difficult. I thought I reached the promised land when I finally made PACK work but my joy was premature. Now INSERT gives me the same trouble. I really prefer to
  • 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
  • fox $
    by Fox Me Up
    4 Replies
    Last post by LeoLems
      • what do most companys charge per hour if a client wanted a custom applications writtin in foxpro
  • problem setting up a ODBC data connection more questions.
    by Fox Me Up
    5 Replies
    Last post by CetinBasoz
      • ok im trying to set up an odbc connection to my database. i am using MS SQL SERVER 2005 Express on my labtop that is running windows xp. on the labtop i went into control panel - admin tools - data sources (odbc) and then under the user dns tab i added a sql server with these values in the fields name: MyFoxData Description: [i left empty] Server: TESTING\SQLEXPRESS then i hit next then i have che
  • SQL Join question.
    by Aleniko
    3 Replies
    Last post by Naomi Nosonovsky
      • Hi; I have 2 tables. polgr.dbf and po.dbf. I want to query all the records from polgr and some matching info from PO. The problem is that in some cases there will be 2 records in PO with the same PO#. The following query produces duplicates if there are 2 records matching in PO. select polgr.qopen,po.acct from polgr left join po on polgr.pono = po.pono Is there a join condition or other way to avo
  • OLE DB driver for Vista 64bit
    by JohnSLG
    1 Replies
    Last post by Cindy Winegarden
      • Does anyone have any experience with OLD DB drivers on Vista 64bit. I downloaded ver 9 & my data load that used to work under Vista no longer works under Vista 64bit. I was wondering if it was the driver. Thanks.
  • Summary band in reports - VFP9
    by Aleniko
    5 Replies
    Last post by Aleniko
      • I am trying to add a 'disclaimer' at the bottom of invoices. The thing is that the disclaimer should always print at the bottom of the last page. If the last page has only one item, the disclaimer should still print all the way at the bottom. The disclaimer is not a single line but a bunch of lines, and it may change. I've added it to the summary band and I've tried to set the 'field position' to
  • 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
  • image
    by dalegoble
    5 Replies
    Last post by Aleniko
      • On a new record I would like for my customer to be able to pick a photo from somewhere on his system, after he selects the file it would copy the file and save it to a image dir. in the program dir, link this image to that record and show this picture when ever the record comes up on the form. Is this possible Thanks Dale
  • Remote SourceSafe
    by Darren Woodford
    9 Replies
    Last post by Darren Woodford
      • Hi Guys Has anyone got any feedback they would be willing to share on 'Source Anywhere for VSS' (http://www.dynamsoft.com/Products/SAW_Overview.aspx ) by Dynamsoft. I am thinking particularly of integration with various versions of VFP. I tend to have all of my projects using the IDE integration and am hoping that this will work with this product. I am currently working from home on an acce
  • VFP Compiler for .NET
    by NozFx
    2 Replies
    Last post by Naomi Nosonovsky
      • Hi all, Stumbled across this company's web site and wondered what peoples opinion of it is: www.etecnologia.net They are currently building a .NET compiler that will take VFP syntax and compile it into IL code. Basically they state that you can write VFP code and run it within the .NET framework. They even state they are aiming at being able to compile existing VFP app's int
  • Align controls at runtime
    by Victor BA
    3 Replies
    Last post by CetinBasoz
      • How can i align the controls at runtime (instead of using the Layout toolbar), because in code i change the place of a button and a label, but they are not centered alike, in design mode i choose the "Align Horizontal Centers" option, but can't find something like that in runtime, what can i do Thanks
  • Report to HTML output problems.
    by Aleniko
    7 Replies
    Last post by Aleniko
      • Hi; I'm wondering if some of you experienced problems with how HTML reports are generated in VFP... I was experiencing small problems like information in the title band not showing etc, but yesterday I got this problem: An html output is generated perfectly on my XP pro machine. But when I deploy the program on a win2003 server, the result of a generated html are all messy and ugly. This happens w
  • Check permissions of directory
    by teeth777
    8 Replies
    Last post by Christof Wollenhaupt
      • Hi all, I'm after a way to check the write access the user has to a particular directory. Pref. a way to do it that doesn't require non foxpro objects (ie wsh/fso). doing an fcreate to create a dummy file then deleting it isn't suitable. It's not really elegant and there are instances where the user might have create rights but no delete rights & there'd be a bunch of dummy files in the dir. a
  • SQL Server Express & Foxpro-populating SS from Foxpro
    by drhoades32
    7 Replies
    Last post by AndyKr
      • I've placed more of the code at the bottom of this message. The problem is with the Insert command with SQLEXEC. If I use: lcStr = ["INSERT INTO SAUTHORS(firstname,lastname) values ('] + m.firstname + [','] + m.lastname + [')"] lnResult=SQLEXEC(m.lnConn, m.lcStr) The error I get says: Connectivity error:...Could not find stored procedure 'INSERT INTO SAUTHORS(firstname,lastn
  • 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
  • Cursor adapters, ADO and Native VFP Data
    by CChalom
    14 Replies
    Last post by CetinBasoz
      • Hi, I've been using Remote Views to access native VFP DBC's.through ODBC. As I want to use some of the new functionalities of VFP data, AutoInc, Varchars, Blob fields, I was recommended to try using ADODB with Cursor Adapters. But I've found no samples using VFP native data... Can someone recommend be some kind of literature for that I was told that accessing data using AD
  • Properites window
    by Hans L
    6 Replies
    Last post by Hans L
      • Working in the regular properties "manager" is not very easy. You cannot stay in one object's window and jump around to others, even if just to look up a name. Objects in a form cannot be sorted. Etc., etc. Is there any better VFP-native way to do the same work as you do in Properties If not, and even if, where can I look for free and commercial products that greatly enhances the Proper
  • GETDIR() in Windows Vista only displays Local Drives
    by JDM0759
    4 Replies
    Last post by PB_UK
      • Hi all, I've created a small application (EXE) using VFP9, SP1 and copied it to Windows Vista Business edition and a Windows Vista Ultimate edition machine. This application has a few command buttons to have the user select a mapped network drive path. I have tried GETDIR(), GETFILE(), and even stepped out of the normal VFP function realm and used BrowseForFolder method of the oShell object. No
  • image resize
    by NILKAMAL
    7 Replies
    Last post by Naomi Nosonovsky
      • hello! i ceate simple form with image now i want to image resize in my imagecontrol can i do that also how do i do to change background color of my application thanks