Accpac Guy ..

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - To inpute lines in win.ini file I want to input some lines in win.in file. for eg: I want to add 'Run =backup.exe' under [windows] braces. Is there any code under in vf9. ? pls write with code thanks in advance Sameer Tag: Accpac Guy .. Tag: 211308
  - 2
    - VBA in VFP, how to determine the selected table index I have 8 table in one document and has been point cursor to one of the table by bookmark. How do i determine the table index of current cursor position ? Tag: Accpac Guy .. Tag: 211302
  - 3
    - receive pop mail I wish to make a free .pop. e-mail client, simple. I know to send e-mail using CDO, but how to get it from server? I've tried some winsock examples, but always got message "Class is not licenced....." nothing works... Found a few ocx on web, but they are not free... Please help... -- Tag: Accpac Guy .. Tag: 211297
  - 4
    - How to call Outlook Express from VFP I am making an application to send mail thru Outlook Express I want to call Start Outlook Express and set the To Email, Subject, and add a attachment to the Outlook Express. After that the outlook express would leave it for the user to enter message detail and send out manually. Does anyone know how to do it. ? Tag: Accpac Guy .. Tag: 211292
  - 5
    - Import BTR files? I have in the past imported files from an AS400, and files from MS SQL, or access etc. Now I have a need to import the customer master table from a pervasive database. Having no experience with importing these types of files Iwanted to ask first. Can it be done, what do I need to know etc? Thanks you (the files end in .btr) Tag: Accpac Guy .. Tag: 211280
  - 6
    - FRX to PDF os: windows xp pro sp2 vfp: 6 sp5 hi, how is the best and fast way to do PDF reports and free? :D TIA, AP Tag: Accpac Guy .. Tag: 211278
  - 7
    - Select Alias vs Data Session I have a strange problem here: In my app (VFP 7), I have a bunch of tables opened. Let's say Table1 is opened in area 1 as alias Table1, and Table2 is opened in area 2 as alias Table2, from DatabaseABC. I have Form1 in which Table1 is the source of data. In Form1, I click on one of the listed items and this opens Form2 with the details coming from Table2. To show data from Table2, I do a SELECT TABLE2. The data is not showing properly. I kept the Data Session window opened to see what is happening and after I issue SELECT TABLE2, the alias TABLE1 is still highlighted as selected. How could this be??? (To go over this, I issue a BROWSE, and only then TABLE2 is selected... stranger, no?) Please help... I'm supposed to ship this app to my client this weekend! Pat Tag: Accpac Guy .. Tag: 211273
  - 8
    - VFP9 and vfpcom.dll Any one here know when the vfpcom.dll will be fixed to work with the VFP9 runtime files? Thanks and regards - Bill Tag: Accpac Guy .. Tag: 211268
  - 9
    - How to read Windows User-id Can you give me some vis fox 6 code to read the Windows user-id? TIA. Joe Kelly Tag: Accpac Guy .. Tag: 211264
  - 10
    - Install application on Windows 2003 SBS We are attempting to install a VFP 8 application on the above mentioned Windows 2003 Small Business Server. We get a problem during installing the runtime file, namely the following error message appears when trying to upgrade STDOLE2.tlb. Error 1931: The Windows Installer Service cannot update the system file: C:\Windows\System32\Stdole2.tlb because the file is protected by Windows. You may need to update your operating system for this program to work correctly. I understand what the error means but the installation file build usind the version of Installshield that came with VFP 8, uses the MS supplied merge modules to install the VFP runtime files and their dependencies. Does anyone have any ideas on how to get around this error? TIA John Tag: Accpac Guy .. Tag: 211255
  - 11
    - question about limitations etc over vpn? I am considering helping/consulting a small oilfield company to have a "specific to their operation" VFP program developed that will allow them to enter information about maintenance details on Pumps and Compressors etc, and have it create automated Work orders etc. They have looked at several canned programs, but all offer way more than what they want. The question is, if it is written in fox pro, will it easily handle say 2 to 25 users simultaneously using it, and even more important is that not all users are in the same building. Their company is connected via ADSL. Right now this ADSL connection affords them the connectivity to use their existing business system, so the connectivity I know is good. Feedback greatly appreciated. As well, if there are any experienced developers (that can allocate the time) that are interested in a project as such. Dan Tag: Accpac Guy .. Tag: 211250
  - 12
    - ZIP files Hi, Do you know how to use windowsXP library to make ZIP programaticly from Foxpro? Thanks Tag: Accpac Guy .. Tag: 211249
  - 13
    - ZIP files Hi, Do you know how to use windowsXP library to make ZIP programaticly from Foxpro? Thanks Tag: Accpac Guy .. Tag: 211248
  - 14
    - Here's a question you don't see everyday! Thanks in advance for the help... I'm sure most of you know that if you press Ctrl-F in the VFP IDE you get a "Find" window. Is there any way to move the Find window using the keyboard? Those of you that are curious as to why I would need to do this can read the rest of this message. I have two monitors connected to my PC and there are times when I use gotomypc to work remotely. gotomypc only displays one of the monitors (the one on the left) and I usually keep VFP on the one on the right. I have no difficulty moving VFP itself using the keyboard but the Find window always re-opens in the last place it was opened which in this case is on a monitor that I can't see. Thanks, Jeff Tag: Accpac Guy .. Tag: 211245
  - 15
    - select multiple printer option dear members i have created a report in vfp9 using one printer say (HP640). But If I select different printer by using (SET PRINTER TO NAME) from the network, it is going to the previous one which i used to create. I want to send to both printer(more than one). If any member can help me in this matter, I would be thankful. Regards, Sameer Tag: Accpac Guy .. Tag: 211241
  - 16
    - RUN command fails Hi All, The follwing flash executes successfully from the command window, but gives an error when tried through vfp8 tmp = "RUN /N3 " + filepath + "Demo\Demo.swf" &tmp Error message: RUN|! command failed. An attempt was made to load a program with an incorrect format. Any help would be greatly appreciated. Thanks. kd Tag: Accpac Guy .. Tag: 211239
  - 17
    - VFP9 Multiple table Report Question Hi, I am using VFP9. I have two tables, both are unrelated. Table1 with 3 records & TABLE2 with 3 records. I need to print in my report: TABLE1 TITLE Table1 Record1 Table1 Record2 Table1 Record3 TABLE2 TITLE Table2 Record1 Table2 Record2 Table2 Record3 How can I print the records of two tables in a single VFP9 Report? Thanks in advance. Regards, Derek Tag: Accpac Guy .. Tag: 211238
  - 18
    - Ole error code 0x80020006 - Unknown Name Hi All, I seem to be getting an OLE error, the error code is 0x80020006 and the error message is "Unknown name". I have added an Activex Control (of type "Shockwave Flash Object") to one of the pages in the pageframe control of my form The error ocuurs when the url property of the ole control is set. dirname = "C:\Proj\" filepath = dirname + "Showtime\Demo.swf" this.oleAlAreen.url=filepath If anybody knows how to fix this error, please reply ASAP. Thanks. kd Tag: Accpac Guy .. Tag: 211236
  - 19
    - Cursor Adaptor and Stored Procedures with Output parameters I want to call a SQLserver SP that has both input and output parameters with a cursor adaptor, how do I write the selectCmd? VFP8 thanks LH Tag: Accpac Guy .. Tag: 211231
  - 20
    - Locating "My Documents" folder Hi to all, I'm trying to locate the current "My Documents" folder programmatically to point the default directory when I call PUTFILE() function. How can I do this? I've tried GETENV() but it doesn't give me the "My Documents" folder... Any help would be much appreciated... Thanks. Allan Tag: Accpac Guy .. Tag: 211222
  - 21
    - dumb question I have a form that I add a slider to through form designer (VFP 9). For some reason the activex control will not become visible until I click on it. If I put the activex control on a blank form I don't have any problems with it. I've tried hardcoding the activex object in the load of the event, creating it with the drag and drop feature in form designer. The property visible is set to .t. and it is the topmost control of the form. Once the control is clicked on it stays visible and works properly but I am stumped on this one. Thanks for any help Tag: Accpac Guy .. Tag: 211221
  - 22
    - Automating Excel Chart Creation from Microsoft FoxPro In an Excel workbook, I have a long macro in VBE that creates a chart and sets properties of axes, series collections, etc. I want to automate the process from within FoxPro. I copied the VBE code into FoxPro and much of it works but not all. What do I need to know about getting the VBE code to work from within FoxPro? Any help will be gratefully received. Thanks. Peter Tag: Accpac Guy .. Tag: 211218
  - 23
    - Excel and Word as attachments hello, i have built an app to create word and excel file after user intervention. if i just print these doc's all is fine. once i select them to e-mail, the excel sheets seem to loose formatting of Font size and merged cells go away. with word, the reciever of the Mail will see the icon of the attachment with titla and all, double click and nothing appears, however if they print it, its all there. very strange things are going on. it varies from computer to computer. is there any way to set formatting of this so they wont get crushed or any other ideas? TOm Tag: Accpac Guy .. Tag: 211217
  - 24
    - Doug Hennig at LA Fox May 10 -- Mine for Code in XSource Mine for Code in XSource Visual FoxPro comes with source code for most of the "Xbase" tools that ship with the product, including the Class Browser, Code References, Toolbox, and Task Pane. Looking at source code written by top VFP gurus often gives insight into new, powerful coding techniques. This session looks at various files in XSource to show you cool ideas you can incorporate and even better, code you can directly use in your applications today. Jump Start Topic: Update your application over the Internet using Inno Setup -- Michael Cummings Inno Setup compiler is a FREE setup creation utility. It is actually easy to use and powerful too. We will look at a few lines of FoxPro code that will make your application do a version check on startup, and prompt the users to install a new version. We will then look at even *fewer* lines of code that will download and install the latest version of your application using Inno Setup. The really cool part is that you can launch your Setup program from within your application, so the upgrade is seamless to your users. This is not only cool, it is very easy to do. See you at LA Fox!! http://www.lafox.org Tag: Accpac Guy .. Tag: 211212
  - 25
    - How to get VFP 9.0 in french from Canada Could somebody tell me if there is a way to get VFP in french from Canada? Also, could somebody tell me if i will be able to develop complete french version with the VFP english version? Daniel Massé Tag: Accpac Guy .. Tag: 211208
- Next
  - 1
    - vfp8 parameters and variable question hi all. i am new to foxpro programming. I am not sure that this is the best place for my question but i am not able to find "working" newsgroup and/or forum about foxpro (btw, any hint appreciated) . my problem: I have a form defined procedure and would like to call it and receive 2 parameters back. i tried with: thisform.myproc(parm1,parm2) but it does not work (i read that in this way the parameter are passed by value and not by ref...) so i tried with DO thisform.myproc WITH (parm1),(parm2) ... but it does not work...myproc is not recognised (even without thisform.) so what can i do??? i tried with global variables and it worked but i do not want to use global variable for this kind of stuff...but...it is not possible to define the variable scope for the form? only for the procedure itself or global seem to be the possibilities... if somebody knows other resources for my problem, plese let me know. thanks and ciao. Tag: Accpac Guy .. Tag: 211195
  - 2
    - - How do I make shape object semitransparent? Is there a way to make Shape object semitransparent (transparency factor)? If not, could someone suggest an alternative. Tag: Accpac Guy .. Tag: 211194
  - 3
    - Formsets in Foxpro I am using Formset in an application .. but every form I open sets its size to the Form open previously .. How can I Stop this to happen. Tag: Accpac Guy .. Tag: 211193
  - 4
    - check if drive exist Hi, I have this little code to check if a drive exist yes or no, but it fails on a pentablet. I get an error specifying "Drives does not exist". This pentablet has a drive (the server) only when it is docked (and connected to a lan). And this is just exactly what I want to prevent and checked if it is docked or not to perform some syncronisation with tables on the server. function checkdrive lparameters chkdrive_ o = Create('Scripting.FileSystemObject') lreturnvalue = o.Drives(chkdrive_).IsReady release o return lreturnvalue Anybody a workaround to check when a drive exist (and is ready) ? thanks in advance regards christophe -- Tag: Accpac Guy .. Tag: 211184
  - 5
    - VFP 9 Installshield question Hi, I am using VFP9. Which minimum Objects/Merge Modules do I need to include in my application distribution? Is it OK if I use the VFP8 Installshield wizard? Thanks in advance. Regards, Derek Tag: Accpac Guy .. Tag: 211183
  - 6
    - VFP 9 Have a grid with a check box on a logical field. How can I update the grid programatically to clear the check box. i.e. check ten items perform something on just these ten items and then clear the checkbox I have tried thisform.grid1.column1.checkbox.value=0 it does update the underlying cursor if i interupt the program at this line the records referenced have had the logical field set to false. But as soon as my grid displays again, the check boxes are checked and the underlying cursor once again have the logical field set to true. Thanks for any assistance. Tag: Accpac Guy .. Tag: 211180
  - 7
    - Displaying Two Browse Windows on Same Screen in Foxpro 2.6 Dos ? How can I show Two browse windows of different tables at the same time, I tried following. Define window win1 from 1,1 to 20,39 Define window win2 from 1,40 to 20,70 Activate window win1 Use Rent brow in Window win1 Activate window win2 Use Contract brow in Window win2 But I only see one brow window at a time, where am I mistaken, please help ? Best Regards, Luqman Tag: Accpac Guy .. Tag: 211175
  - 8
    - Treeview and System ImageList Is it posible to associate the system image list with a treeview control? I've been playing with Shell_GetImageLists but no luck so far. Tag: Accpac Guy .. Tag: 211165
  - 9
    - Treeview and System ImageList Is it posible to associate the system image list with a treeview control? I've been playing with Shell_GetImageLists but no luck so far. Tag: Accpac Guy .. Tag: 211164
  - 10
    - System Image List Is it possible to associate the System Image list with a Treview Control in VFP? I've been playing around with Shell_GetImageLists, but no luck so far. Tag: Accpac Guy .. Tag: 211163
  - 11
    - Events at Run time Dear sirs I've created in my Form some objects (Buttons) at run time, the question is: how can I handle their events (Like: Click Event) at run time best regards thanks Mohammed Abdel-Razzak Tag: Accpac Guy .. Tag: 211161
  - 12
    - Problem with ADO.Net Using VB.net with .Net Framework 1.1 and using Fox Pro OLEDB to connect to a fox pro database. When I try to load a dataset from a FoxPro database on the network running this line of code for path (\\servername\share\data\abc.dbc) dbAdapter.Fill(dbDs) I get: "The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value." This code works perfectly on the local copy of the FoxPro Database (example c:\data\abc.dbc) any idea why? The people in dotnet.framework.adonet suggested I post here. Tag: Accpac Guy .. Tag: 211159
  - 13
    - More VFP7 to VFP9 woes I use the below code to create a background image on a Foxpro app. This image is always visible in my test environment, but when I run it on Terminal Services (W2K) in Production, several of my forms clear this image. What Commands/Functions could possibly clear this image?? This never happened with the app when it was compiled with VFP7. Thanks for your help *! Example Code ------- _SCREEN.addobject('logo','image') WITH _SCREEN.logo .picture = 'BackGroundImage.jpg' .width = 220 .height = 160 .backstyle = 1 ENDWITH = updscreen() _SCREEN.logo.Visible = .T. *------------------ PROCEDURE updscreen *------------------ WITH _SCREEN.logo .left = (_SCREEN.width-220)/2 .top = (_SCREEN.height-160)/2 ENDWITH ENDPROC Tag: Accpac Guy .. Tag: 211155
  - 14
    - VFP Based PM (preventative MTC) program for oilfield industry Does anyone have any first hand experience or recommendation for a program that would be used in the oilfield or gas industry for tracking and managing maintenance on field equipment? Dan Tag: Accpac Guy .. Tag: 211152
  - 15
    - Strange issue importing text file I am a SQL Server DBA that has a client using FoxPro v8. When the client imports CSV text with character fields delimited with double-quotes, they have random records shift from time to time for no apparent reason. The source records are clean meaning they do not contain commas or double-quotes. Ironically, the same CSV text file imports into SQL Server, ACCESS and other databases without any issues. Has anyone else run into this type of strangeness? How did you resolve it? Thanks! Tag: Accpac Guy .. Tag: 211150
  - 16
    - SQL SELECT is not executing VFP 8 SP1 on XP Pro SP1 This is the most bizarre thing I've seen in a long time. I had some code in a form that constructed a SQL SELECT statement as a string, then runs the command via macro substituion (&). This was working fine. I decided to move this code into a class. Now, when the macro substitution line is executed, nothing happens. Here is the string that is supposed to be executed: SELECT Employee_name AS fld1, UPPER(Employee_name), Ssn AS fld2, UPPER(Ssn), Employee_id AS fld3, UPPER(Employee_id), Dob AS fld4, UPPER(Dob) INTO CURSOR rptCurs FROM empGrpCurs ORDER BY 2, 4, 6, 8 The source cursor (empGrpCurs) exists and contains data. After this instruction is executed (or not executed in this case), the destination cursor (rptCurs) does not exist and _TALLY has not been updated from the prior value. No error is raised. It's like this instruction never happened. I then placed the actual SQL SELECT statement (rather than the macro version) in this same method a few lines lower and the result was exactly the same - no error, no cursor created, _TALLY unchanged. I'm convinced I'm just missing something very obvious, but lack of sleep must be blinding me. Any ideas? -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: Accpac Guy .. Tag: 211128
  - 17
    - VFP 9, Class definition is cyclical error Have a container-class which contains two custom-class pageframes, one is placed on the others page. inputctrl1 <or one of its members>. Parent : Error loading file - record number 1976. FWPAGEFRAME_B1 <or one of its members>. Parent : Cannot add FWPAGEFRAME_B1. Class definition is cyclical This error occurs when running the application, not during class editing. With only one instance of the pageframe class in the container-class the application runs fine. It also works if the second pageframe is not placed on the other pageframe's page. As far as I can tell this does not match: "You have attempted to specify a class in an ADD OBJECT statement whose class definition is the same as the class being defined. " Any idea's ? TIA Michael S. J. Tag: Accpac Guy .. Tag: 211100
  - 18
    - Printing a BMP bitmap Hello all and thanks in advance for the help. How do you print a bitmap where the bitmap that you will be printing is to be decided at runtime? Can you use the VFP report writer? Is there another way? Thanks. Jeff Tag: Accpac Guy .. Tag: 211093
  - 19
    - Convert 3.0 resource file format to 6.0 I have a VFP8 exe file which runs every night on two separeted Win2003 servers. One of them is OK. The other sometimes /not every time/ stops and there is the following question on the screen: Convert 3.0 resource file format to 6.0? /YES or NO/ Could anyone explain me why do I have this message? Many thanks -- Sandor Tag: Accpac Guy .. Tag: 211090
  - 20
    - Frontpage Automation - Help I need to automate FrontPage to update a website i.e. to publish it. How does on do this from within VFP? Some Code Samples would be help Thanks in Advance Regards Mahmud Abdulla Tag: Accpac Guy .. Tag: 211087
  - 21
    - dbf to excell Can I export a large dbf to excell to use multiple worksheets in excell. The file is to large for only 1 worksheet. thanks sherry Tag: Accpac Guy .. Tag: 211085
  - 22
    - Consuming a dataset in a web service I have successfully consumed an XML from a web service from VFP8. Now I need to consume a dataset in a web service. Can someone point me in the right direction? I've been searching Microsoft site but nothing pops up. Thanks, Tag: Accpac Guy .. Tag: 211079
  - 23
    - accessing VFP data for ASP.net pages We had (gone now) a developer who wanted to have access to our VFP tables (several hundred mb worth) for "live" queries on a low-traffic web site. His solution, doing all his development in ASP.net, was to create duplicate tables on an SQL server and import the VFP data on a schedule which allowed as up-to-date data for the queries as was possible (perhaps every 15 minutes, but no less than once an hour). I objected to this scheme as being inefficient in that it moved many thousands of times the amount of needed data across our various links (a shared 10 mb pipe to the web server was the bottleneck), when he could have accessed the data directly from ASP.net using OLEDB. His only point was that this allowed him to use SQL stored procedures. Can anyone give opinions on the pros and cons of these 2 approaches? Thanks. Tag: Accpac Guy .. Tag: 211077
  - 24
    - How to dial a phone number from VFP? Hi All, Does anybody have a sample code for using a telephiony API from VFP? Where can I find the examples on how to implement auto-dialing from VFP application? Thanks, Andy Tag: Accpac Guy .. Tag: 211073
  - 25
    - using controls in grid causes problem i am using combo1 that contain faculty,student,staff as combo1 items.... according to i choose the item in combo1 the grid is displayed..... i have insert checkbox1 and combo2 in the grid also...... the combo1 and the grid is in the same form.......initials the grid is set as visible false.... now when i run the form it shows the controls (checkbox1 and combo2) in the grid for frist selection but when i switch the selection in combo1 it does not shows the controls in the grid.......... i have tried thisform.grid.refresh thisform.grid.column1.refresh thisfrom.grid.column2.refresh thisform.grid.column1.checkbox1.refresh thisform.grid.column2.combo2.refresh can anybody help me...... -- Message posted via http://www.dbmonster.com Tag: Accpac Guy .. Tag: 211069

Do not know whether it is a propper forum or not but want to know about any
person having some expertise in Accpac Version 7.?

Top