append from dynamic file name.xls

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
    - cumulative sum of field Dear all, Here's a table: a b --- --- 1 1 2 3 3 6 4 10 5 15 how can i perform the cumulative sum of a in the field b, in foxpro program?? Thanks anyway! Patrick Tag: append from dynamic file name.xls Tag: 217097
  - 2
    - cumulative field Dear all, Here's a table: a ---- 1 2 3 4 5 i would like to add a column b, and write a program so that the following result can be drawn: a b --- --- 1 1 2 3 3 6 4 10 5 15 you see, the field b is the cumulative sum of a. How can i perform this by foxpro program, i am using foxpro 8 Tag: append from dynamic file name.xls Tag: 217096
  - 3
    - textbox.alignment and textbox.inputmask My colleague just complained about a bug? in VFP 9. With textbox.alighment set to CENTER, the numeric value was displayed as 26.00 when the actual value should be "216.00". I couldn't quite reproduced his behaviour. There are codes in textbox.lostfocus(), but he claimed that the codes were correct. Also, changing the code a mere "return" didn't fix the problem. SO is there some gotcha in using textbox.alignment=CENTER? -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.6.13 ^ ^ 21:06:01 up 21 days 23:52 load average: 1.03 1.06 1.01 Tag: append from dynamic file name.xls Tag: 217090
  - 4
    - An Appointment Schedular .. Can anybody recommend me an appointment Scheduler / Calendar view control build natively in VFP. I am not looking for an ActiveX Control like DBI Tech. PIM Professional, I would like the control to be functionally about the same type. I need it quickly if anybody there can suggest me one I would really appreciate it. Tag: append from dynamic file name.xls Tag: 217088
  - 5
    - Is there a New York City Foxpro user group? I haven't heard from PADD for quite a while. Tag: append from dynamic file name.xls Tag: 217084
  - 6
    - Expression Evaluator Failed in TOTAL ON command I think there is a bug in TOTAL command when there is a field rule expression. Am i doing something wrong Greg See the code below:- CREATE DATABASE testdbc lcproc="PROCEDURE mydate_valid"+CHR(13)+"RETURN .T." STRTOFILE(lcproc,'myproc.txt') APPEND PROCEDURES FROM myproc.txt CREATE TABLE testdbf (mydate D CHECK mydate_valid(),myinteger i) APPEND BLANK USE USE testdbf TOTAL ON mydate TO testtotal USE REMOVE TABLE testdbf CLOSE DATABASES DELETE FILE testdbc.* Tag: append from dynamic file name.xls Tag: 217082
  - 7
    - view designer and union could view designer specify a union? There is only a join tab, no union. Tag: append from dynamic file name.xls Tag: 217081
  - 8
    - Use VFP to set page break in Excel Good day everybody, I am using VFP 8.0 and Excel 2002. I am writing VFP program to pass data into Excel. I have managed to fill the data and do some formating via VFP to Excel. Now I would like to set page break. How do I convert the code(see below) recorded via Excel macro to VFP code? ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell I will appreciate it if some one can help me. Thank you in advance. Have a nice day. Best regards, Julie Tag: append from dynamic file name.xls Tag: 217079
  - 9
    - Win98 to Windows XP Hi to all... I had a small problem with my passwword, i created this on Visual FoxPro 7.0 with the OS Windows 98 second edition and It works, How comes that when I change to another OS like Windows XP, my password is incorrect?...Is there someting to copy a library to work with this? Tag: append from dynamic file name.xls Tag: 217075
  - 10
    - Return property name for each object on a form Hi, I want to return the name of all objects on a form, so I can programatically access some of them. I thought the Objects collection might do the trick, but all I get from it is a Count property. Using VFP9, and thanks for any help. Neil Tag: append from dynamic file name.xls Tag: 217074
  - 11
    - CR1 0 & VFP 8 Is it possible to pass parameter values to a View (as opposed to a table)? If so, how??? I have a variable defined in a View that is normally populated by VFP code. Sorry if I have not made this very clear... Thanks!! Tag: append from dynamic file name.xls Tag: 217073
  - 12
    - CR 10 & VFP 8 - Query on Dates New to Crystal Reports. It seems like running a query on dates takes a LONG time, I think because they are not included in the SQL sent to the data source (??). Is there an easy way to speed up these queries? When creating a sql expression field there are no too many choice for date functions. Thanks!! Tag: append from dynamic file name.xls Tag: 217072
  - 13
    - Remote View Indexes Is there a way to create persistant indexes on a remote view. I have a sample table that I upsized to MS SQL server and am trying to go through the existing code that I have switched to access a remote view of the MS SQL data. A lot of the code uses the set and seek statement like the following: SET ORDER TO TAG InvID SEEK Invoice.InvID Is there any way that a remote view will work with that line of code. Any help would be greatly apperciated. If at all possible we would like to not modify this code as it is repeated everywhere throughout the application. Thanks, Curtis Tag: append from dynamic file name.xls Tag: 217070
  - 14
    - 'Select distinct' on records with memo fields, how hello, I need to 'select distinct' on a character field from a table like the following: select distinct char1, memo1, memo2 from table1 order by char1 into cursor cursor1 The memo fields 'memo1 and memo2' are just remarks I put in for the field 'char1', what I need to for 'select distinct' to operate on is only the field 'char1' I understand 'distinct' doesn't operate on tables with memo fields. Now how can I achieve my desired result? Thank you. -- jw Tag: append from dynamic file name.xls Tag: 217054
  - 15
    - Drag & Drop Functionality .. I want to implement a drag - from data in a Grid Control - and drop it on an appointment scheduler ActiveX control ? I have never used a drag and drop before this any help tips will be appreciated. Tag: append from dynamic file name.xls Tag: 217046
  - 16
    - setobjrf what does it do and why was it added to my application When i converted to VFP 8.0 from 6.0, setobjrf was added to my project. what does it do, and why was it added to my project? do i also need _base? it was added to? _environ thanks, Marty Tag: append from dynamic file name.xls Tag: 217044
  - 17
    - VFP6.0 and opening a cash drawer Depending on what type of cash drawer is purchased (parellel, serial or usb) how do you make the register open. Note I know you can setup the register first as to what will be sent to open it for a parellel drawer (such as the bell tone with ??chr(7) ) but the serial and USB have me scratching my head. Rusty OGES Systems Tag: append from dynamic file name.xls Tag: 217040
  - 18
    - Word automation extremely slow sometimes We have implemented a word printing facility in our program. It basically consists of a word template (with tokens) that the user can edit themselves. Then if they want to print an invoice for example they can select a template and an invoice rolls out the printer. We open the document in foxpro (version 7) and then search for the tokens that need to be replaced with the actual values. This all works well but for some reason we now have a problem on some computers. We have a few customers which report that on some computers the process of making the document takes a few minutes instead of the few seconds it takes on other computers. We have tried to simulate the problem here on our test machines but at first we couldn't reproduce the problem. Untill one of us got a new pc. At first it was as fast as normal (few seconds), then after some windows updates and installation of other programs it suddenly took minutes on that machine. We also had reports of customers who installed word 2003 and where the problem was gone. We tried everything from reinstalling word till whatever but we can't figure out why it takes seconds on 1 pc and minutes on the other. Does anyone have ideas or has had similar problems ? Tag: append from dynamic file name.xls Tag: 217033
  - 19
    - How to make accumulated data correct all the time? How to make accumulated data (e.g., total amount, balance) correct all the time? Many years ago, I did an order system and found the total amount was not right sometimes. The order system is pretty complicated and itâ??s not easy to find where it is wrong. I know I can add transaction log for this field. But I donâ??t think thatâ??s the best way. The original code was something like TotalAmount= TotalAmount-OldItemAmount+NewItemAmount. I changed it to Select Sum(NewItemAmount) as TotalAmount. That means recalculate it every time. And then the total value has never been wrong. The biggest problem for this method is performance. We may not able to recalculate everything, say stock on hand. The biggest problem is balance for every account in general ledger. Do you have any ideas to make them correct all the time? TIA. Tag: append from dynamic file name.xls Tag: 217030
  - 20
    - How to prevent leaving textbox Hi, How do I prevent the cursor from leaving the textbox if you press backspace when the cursor is at the start of the textbox. I thought there was a command for doing this, but I can't find it. Thanks Tag: append from dynamic file name.xls Tag: 217021
  - 21
    - simple query returning erroneous results I have a cursor named rpcfgdtl. it is from a Stored Procedure in SQL Server. i am trying this query: Select selected, lookupkey from RPCFGDTL ; where lookupkey= "MATL" ; INTO CURSOR list11 it returns this value for lookupkey; "MATLBS" according to the where clause, it should have not brought this value. Any help would be appreciated. Thanks, Marty Tag: append from dynamic file name.xls Tag: 217013
  - 22
    - Grid columns are loosing names during runtime My code refers to the columns by name. The name was defined during design time. I have asked about this before, but the suggestions did not work out. I am using VFP 8 SP 1 Some of my customers are getting errors when they open screens with grids on them. The code might say: this.Grid1.col_code.setfocus() The code crashes because when the grid was created it named the column "Column1" All of the names of the columns are lost. Someone told me this is because I am loosing the recordsource on the grid, after it has been assigned to the table. I was instructed to set the recordsource = "" before I rebuild the cursor it was associated with. This did not fix the problem. I am getting several customers with this problem. Does anyone have any suggestion that might fix this issue? Also, does anyone know if this is a known issue of Microsoft and if its fixed in VFP9? Thanks for your help -------------------------------- Dan Tallent Tag: append from dynamic file name.xls Tag: 217008
  - 23
    - task bar hi 2 all thanks advance Sir is there any way to remove software form taskbar I mean the software runs and it disappear from task bar. -- Qaiser Me Tag: append from dynamic file name.xls Tag: 217002
  - 24
    - Page headers not repeating?? I'm sure it's something stupid... but at this point I don't know what it is. I have a report that now that there is a LOT of data, the report itself takes 4 pages. There are individual groupings on the report as well, and it works fairly well to just have the individual groups print on separate pages. But, the "text" or "fixed" portion of the header is there for each page, but none of the data that is pulled in for the header info. What am I doing wrong? Thanks! Shawn Tag: append from dynamic file name.xls Tag: 217000
  - 25
    - vfp8 combobox misbehaving We have a combobox class which has rowsourcetype of 5-array, rowsource of this.iatableentries and style dropdownlist. Bound column is 2 because the array (created in the init) has 2 columns, the first being the id and the second being the associated text. This class works perfectly on all our standard forms where the controlsource is set to a table's fieldname. On a form where the controlsource is set to a form property, no initial value is displayed even though the form property has the correct value in it when you look at it in debug. The listindex property is 0 for some reason. We've tried calling the combobox refresh and requery to no avail. Can anyone tell me why the listindex property is 0 as that seems to be the root of the problem. Thanks for any help, Bernie Tag: append from dynamic file name.xls Tag: 216995
- Next
  - 1
    - string transform problem Dear All, Would anyone help me to solve below problem, and point out my mistake :- Character field(18) Numeric Field(4) ctn_no inner_box 11615404545601 1 11615404545601 2 . . . . . . 11615404545601 12 I use command "replace all ctn_no with ctn_no+PADL(inner_box,4,'0')" the result is no any change of ctn_no, it still is "11615404545601" not my expact result"116154045456010001" Thanks in advance VFP Beginner Ah Wa Tag: append from dynamic file name.xls Tag: 216984
  - 2
    - MimarSinan InstallAWARE - Read before you buy! Dear Group My personal review of MimarSinan InstallAWARE Studio 2005 SE as a courtesy for everyone considering evaluating or buying this product. There are many reviews out there praising the products features so I thought I may add my own review, information collected while creating a project in a live environment. I've to say, at first glance this product has a lot to offer and seems to be a better choice than InstallShield Professional which I evaluated at the same time. InstallAWARE's pricing is also very competitive. On overall, this is a product with some quirks. One will get used to them quickly. I appreciate that no produt is perfect and apprecite when a software vendor takes a greater emphasis on robustness rather than the UI and I hope that this product becomes more UI compliant as a user would expect over the years to come. It's most powerful feature are with no doubt the script editor as well as the flexibility in designing dialogs. However, I've reservations and serious concerns about the level of support being available and having received and if I had this known before I certainly would not recommend this product despite its features and price unless there's reassurance by MimarSinan that they will improve in this matter. The company seems to consist of only its founder, Sinan Karaca. At least that is my impression as all support emails I receive come from his email address. This raises concerns what the situation will be if that only person becomes ill. Another disappointing experience was the quality of support received. As I mentioned, as a developer I appreciate that no software is perfect as long as this is backed up by keen and pro-active support striving to resolve any issues. >From my emails to support I didn't get the impression that the company is actually too interested and an 'error by trial' policy seems to be in place. I could tolerate this for complex problems and sure would try this myself before contacting support but if it was in fact the company founder who provided me with this level of support regarding issues that seem to be obviously a malfunction in their application then I start wondering how much they really appreciate their customers apart from just paying for the product. Before you contact support one might however consult the InstallAWARE Help or Support Forum. Help provides basic information to most common questions but I found that many object properties which I came across on a regular basis are not listed. One of the biggest drawbacks after support in my opinion. Consulting the support forum did not yield more answers to my questions apart from not very detailed replies or the information that this has never been reported before and therefore must not be the products fault. In general, most issues seem to be the customers problem and any of my suggestions that it migt indeed a problem with the product and any offered assistance in investigating this issue further were turned down by InstallAWARE with the response that I can either pay for professional consultancy or that I can find the answer in going through their sample applications. May I point out that I never expected them to do my project for me and as having worked in support myself very well know what falls in the category consultancy/training or support. Not satisfiying but tolerable if the sample I'm directed to actually had addressed my problem. However, in one instance for a Button.click event a Checkbox.Value sample was suggested. Summed up, InstallAWARE support email responses might be quick, on average instant to 8hrs but the quality of support, the help and online forum has to be questioned. Just as final point to add, one might stick to email requests as any call to the company I made was answered by an answering machine and the one request for a callback was never returned. Despite InstallAWARE providing the option of phone support on their website. I might also add, that I tried both numbers, the one in San Francisco, California and the one in Turkey which can be found on the MirmarSinan website during the countries respective business hours. I hope that this is informative to anyone considerating or using InstallAWARE. I certainly will keep you updated should I have more information in the future and let you know of any improvements I notice. Please note that my case might be just an exception and I invite everyone to try for themselves. Best Regards, Martin N Feuersteiner Invent2b - Innovative Property Business Solutions Tag: append from dynamic file name.xls Tag: 216976
  - 3
    - VFP 7 Hi 2 all Is I am doing write useing VFP 7.0 I am working an a multi user inventory control software 1 :- The sales invoice saves in a cursor. I append record in sales table from cursor using This command Append from dbf(â??cur_salesâ??)â?? && cur_sales is cursor name Some time in very rare the sales table have not append the record from cursor why this is happens and how to handle it. 2 :- I have a separate function which perform stock deduction I call it in this way SELECT cur_sales && cur_sales is cursor name SCAN nserial=serial ncomp_no=comp_no cbatch_no=batch_no nqty=qty nbonus=bonus ntrad_price=trad_price ntype=1 stock_sale(nserial,ncomp_no,cbatch_no,nqty,nbonus,ntrad_price,ntype) ENDSCAN && stock_sale is a function Is i am doing write or have some other good technique. -- Qaiser Me Tag: append from dynamic file name.xls Tag: 216975
  - 4
    - Writing on an image (i don't know how else to describe it) hi all, here is what I am trying to achieve: I have a form with a picture of a car (a drawing) just like the one's on the form when you rent a car. I' d like to be able to allow the user to use the mouse and indicate damages by circling or Xing the damaged areas. How would I approach this? Any input is greatly appreciated. I am using VFP9 on an XP pro machine. thank you, Hutch -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: append from dynamic file name.xls Tag: 216966
  - 5
    - Getting a map from the internet and displaying it on a form hi all, I have a form that would have a person's address on it, I'd like to be able to send the address to the web and get a map of the address to be displayed in an image control or an ole control. how would I go about achieving this? Thank you Hutch -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: append from dynamic file name.xls Tag: 216965
  - 6
    - getting out of a loop hi all, what is the command to put in a loop that allows me to get out of the loop. I have a loop that goes through about 120,000 records and I want to be able to hit the Exit button and get out of the loop. I can't seem to remember the command that allows VFP to monitor events. Thanks Hutch -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: append from dynamic file name.xls Tag: 216948
  - 7
    - Image control does not display image VFP8 Hi All, We have discovered some situations where images do not display in VFP8. We have tried .BMP, .GIF, .MIX and .JPG. On one system they display fine yet on others you either get a black rectangle or simply see the file name of the image. Any suggestions to solve this most welcome. All system running XP. TIA Jan Tag: append from dynamic file name.xls Tag: 216947
  - 8
    - trouble with form fired from menu We've got an old 2.6 system that we run in VFP5. The screens are maintained from a controls standpoint in 2.6. .SPR's are generated in 2.6 and then compiled and and run in VFP5. Anyway, a foundation read is being utilized. A menu system exists and everything functions quite well. I've created some new functionality in a newly created form. I have added a DO FORM command for the menu item. The form has it's WindowType property set to Modal. The problem is that I cannot access any controls on the form. I can close the form using the "X" and the QueryUnload method is executed. I have been away from Fox for awhile and I am sure it is something very simple that I am missing. Any ideas?? -- Patrick Tag: append from dynamic file name.xls Tag: 216944
  - 9
    - Manipulate Acrobat 6.0 or 7.0? I can bring up Adobe's Acrobat and a particular file using the RUN command, but what I'd like to do is bring up that file and tell Acrobat to add pages from three or four other documents. In Acrobat you'd select Documents / Pages / Insert, then choose the file from the file pick list. How can I automatically do that from a select previously identified group of files? Thanks! Tag: append from dynamic file name.xls Tag: 216941
  - 10
    - Free FoxTalk article: Lisa Slater Nicholls / PrintJobListener This month's free feature in FoxTalk 2.0 ("A Print Job To Call Your Own") is an exciting explanation (with source code) of controlling your own print job with VFP 9, including the ability to send different printer setup info for individual pages or ranges of pages in the report! Lisa Slater Nicholls shows the inner workings of a PrintJobListener class and explains how it can switch settings in the middle of a report run. Thanks, Lisa, for providing this important information and code for the benefit of the community. As is usual with Lisa's articles, this one is full of useful tips and suggestions for how you can add your own specific functionality to this set of code to fine-tune it for your specific needs. BTW, if you ever wondered if there is a good use for the INSERT BLANK BEFORE command, you'll find it here. :-) http://tinyurl.com/amfdz Enjoy! -- David Stevenson, VFP MVP Editor, FoxTalk 2.0 http://www.foxtalknewsletter.com http://talkingfox.blogspot.com Tag: append from dynamic file name.xls Tag: 216937
  - 11
    - Simple graphic on a report to display a percentile Hi -- - I am not a developer, but I use VFP9 (WinXP Pro) quite a bit to do lots of (simple) things connected with my job. I only use free tables. - Could anyone suggest a graphic that I could purchase that would take a numeric variable (1 to 99) and display it as part of a report? - Right now, I'm using a crudely constructed scale (1-99) with an overlay using the REPLICATE function which places an "X" in approximately the right place over the scale to represent a percentile. It looks OK, but it would be nice to have something a little more professional looking. - Thanks very much in advance. - David Tag: append from dynamic file name.xls Tag: 216925
  - 12
    - BINDEVENTS on grid header causing problem VFP8 SP1, XP Pro SP1 I have a grid for which, at runtime, I use BINDEVENT to bind the MouseUp method of the headers to a Form method that creates an index for that column if necessary, then sets the order of the table so that it is sorted by the clicked column. This all works great, but when the user drags a column to a new location, the BINDEVENT also fires. Ideally, I would like to distinguish between the dragging of a column and the clicking of the header. That way, the user could move the column and the table order would not change to the column moved - only a non-dragging click on the header would sort by that column. It seems I always find a solution right after I post the question, but I'm open to suggestions. -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: append from dynamic file name.xls Tag: 216910
  - 13
    - VFP 8.0 Gif Q. When I drag and drop an animated gif on a form, it looks good but in run mode, it doesn't move. Your expertise is greatly appreciated. j morningstar ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: append from dynamic file name.xls Tag: 216904
  - 14
    - Foxpro vfp9 doesn't display @ say's correctly. I am updating a VFP6 custom program to VFP9 that merges data with an old SBT Vision Point accounting program. I want to upgrade the custom program but leave Vision Point alone. Although the Vision Point runs fine under vfp6, it contains a lot of @..SAYs and @... GETs for prompts and buttons., ( because of it's DOS legacy.) The problem is when my VFP9 application runs the Vision Point and displays these @ says and @ gets, the screen display disappears. In other words, the prompts and buttons become invisible. They will sometimes reappear when the user waves the mouse over them. How can I get @says to be compatilble with VFP9? Is there a SET switch? Does it have something to do with the new video GDI+ system? Other than this screen issue, VFP9 runs Vision Point just fine. Tag: append from dynamic file name.xls Tag: 216903
  - 15
    - Editing memo field from grid VFP 9 I have a top level form with a grid populated by a local view that contains a memo field. In the startup I set screen visible to False. When I double click the memo field I'm not able to see the contents. If I set screen visible to True I can see it. Is there a way to have the memo field open in an edit window on the form itself? I'd rather not leave the screen visible. Thanks. Dave Tiffany Tag: append from dynamic file name.xls Tag: 216902
  - 16
    - view with source table as parameter? I don't think it's possible to create a parameterized view in which the parameter specifies the source table(s) rather than a filter condition. I've tried and couldn't make it work. If anyone knows how to do this, please tell me. Thanks. -- You can reach me at: p one six seven (remove spaces and convert words to digits) at comcast dot net Tag: append from dynamic file name.xls Tag: 216901
  - 17
    - send email with shellexecute but crlf in body does not work Hi everybody, I try to send an email with shellexecute in FVP8 on Win2k with Outlook 2000. This the code: crlf = chr(13) + chr(10) t_error_datetime = "2005-10-06" t_error_no = "16" t_error_body = t_error_datetime + crlf + t_error_no t_email = "mailto:myself@myserver.com?subject=something&body=" + t_error_body ShellExecute(0, "open", t_email, "", "", 1) Unfortunately the body text will not show my crlf. How do I have to pass them to Outlook so that they will work in the body part an seperate the message lines? Thanks in advance Andi Tag: append from dynamic file name.xls Tag: 216890
  - 18
    - SQL problem I am using VFP 6 and my problem is that SQL does not seem to allow two inner joins from one table (Tenants) to two child tables (Lettings and Tenacc) The following code works as far as it goes, without Tenacc:- SELECT Tenants.lastname, Lettings.lettingref, Lettings.curr_rent,; Blocks.blockname, Units.garnum, Owners.owner; FROM garages!tenants INNER JOIN garages!lettings; INNER JOIN garages!units; INNER JOIN garages!blocks; INNER JOIN garages!owners ; ON Blocks.ownerref = Owners.ownerref ; ON Units.blockref = Blocks.blockref ; ON Lettings.unitref = Units.unitref ; ON Tenants.tenantref = Lettings.tenantref; ORDER BY Tenants.lastname What I want to do is to join another table Tenacc (with multiple entries for each tenant) to Tenants on tenantref so that I can show against each tenant details from the above select plus all the debits and credits for the tenant from Tenacc. Help please. -- Tim Hobson Tag: append from dynamic file name.xls Tag: 216882
  - 19
    - Reindex/Pack Memo equivalent for SQL backend? Are there equivalent reindex and pack memo commands we should be doing when we have data in SQL Server? Or is that something an SQL Administrator should be doing? Thanks for any help. Bernie Tag: append from dynamic file name.xls Tag: 216873
  - 20
    - VFP - Acrobat PDF Form designer I have a data entry PDF form. I am interested in reading data from objects that are on PDF forms. Is that possible in VFP. Thx Tag: append from dynamic file name.xls Tag: 216867
  - 21
    - Weird file in use problem Hi, We have a VFP8 SP1 app which is running sitting on a network share, 22 Windows XP users each access this application from this network share. This application has been running fine for the past 2 years and then all of a sudden (past 2 months randomly) users have started complaining they can't get access into some forms. They get 'File in use' error and it is always the one 'Members' table which gives the error. We have some debug information which writes out to a log what users have that "members" table open at the time the user gets the error. Now my understanding is that this error happens when the file is exclusively locked, correct? Our logging information shows that the Members table is open on multiple other workstations while this person is getting this error. So how can more than one person have it open and are not getting the "file in use" error. Where as this person is unable to open it. It is not always the same person that has the problem, so it is not machine related as far as we can tell. These forms open up other network tables too, and they never cause problem, so I don't believe it is network related. The server is not showing any errors for connectivity problems either. So random machines, random users, but always the same table. Any ideas what could be going on, its like the file can only be opened by 5 people and the 6th person who tries to open it is getting denied. Is there anything which could cause this behaviour? Thanks Tristan Tag: append from dynamic file name.xls Tag: 216858
  - 22
    - Change Default Printer in VFP9? After selecting the PDF writer from the printer dialog box for the first statement, I want the program to print the remaining 100 (or so) statements to PDF without user intervention. But with this construct... firstStatement = .T. SELECT Members SCAN .... process member's transactions promptClause = IIF(firstStatement, 'PROMPT', '') REPORT FORM Statement NOCONSOLE TO PRINTER &promptClause firstStatement = .F. ENDSCAN ... the program prints the first statement to PDF, as selected in the dialog box, but the remaining statements output to the default printer instead of PDF. How can I print all the statements to the non-default printer (i.e. to a PDF file)?? Steve Meyerson Tag: append from dynamic file name.xls Tag: 216857
  - 23
    - Custom Paper in XP Hi, I am looking for an API function of some sort where I can create a custom paper size in an XP environment (mimics the "Create a new form" in "Print Server Properties" of the "Printers and Faxes"). It will be easy to deploy apps to several XP machines if the creation of a new "form" or custom paper size would be done in codes rather than creating it on the client's PC one by one. Thanks for your help in advance. Allan Tag: append from dynamic file name.xls Tag: 216856
  - 24
    - Foxpro Database Upsizing We are considering migrating some FoxPro database tables to a different database engine such as MS SQL or PostgreSQL. What would be the advantages of going to MS SQL as apposed to PostgreSQL for instance. Mainly I am looking for any coding advantages if there are any ie: native foxpro database calls in foxpro not having to be modified. Any comments or resources would be greatly apperciated as we need to find the best solution possible to utilize the Foxpro code we have but migrate to a better back-end database than the FoxPro database. Thanks, Curtis Tag: append from dynamic file name.xls Tag: 216854
  - 25
    - FoxPro 2.6 on Windows XP Hi. Got a client getting new XP machines. Still wants to run FoxPro 2.6 for DOS and FoxPro 2.6 for Windows. Ran into the following issues: 1) Created a command prompt desktop shortcut icon. Very little available memory in FoxPro for DOS. Don't see any memory option in the shortcut properties. 2) Created a batch file desktop shortcut icon. Plenty of memory in FoxPro for DOS, but comes up in 43 line mode when set to full screen (changing the shortcut property font size does nothing). 3) FoxPro 2.6 for Windows. Sending output directly to printer lpt1 (???) causes general protection fault. Sending output to normal spooler (?) goes to local printer, regardless of lpt?. If anyone has a solution to any of these issues, I'd greatly appreciate the help...Dennis Tag: append from dynamic file name.xls Tag: 216844

Dear All,

I need a form for user input a desire Excel file name from default
directory. And I also need to append data into a cursor from the file. Would
anyone please to tell me how can I do?

Thanks for along support!

VFP Beginner

Ah Wa

Top

Re: append from dynamic file name.xls by Dan

Dan
Wed Oct 12 10:38:19 CDT 2005

If you want to prompt the user for the name of an existing file, see
Getfile() in the help file.

To get data from an existing Excel file, see IMPORT and APPEND FROM in the
help file.

Dan

agogo wrote:
> Dear All,
>
> I need a form for user input a desire Excel file name from default
> directory. And I also need to append data into a cursor from the
> file. Would anyone please to tell me how can I do?
>
> Thanks for along support!
>
> VFP Beginner
>
> Ah Wa

Top

Re: append from dynamic file name.xls by Anders

Anders
Wed Oct 12 19:52:06 CDT 2005

x=GETFILE('XLS')
-Anders

"agogo" <cpcpwy@ahwa.net> skrev i meddelandet
news:%23ul6v4zzFHA.3780@TK2MSFTNGP12.phx.gbl...
> Dear All,
>
> I need a form for user input a desire Excel file name from default
> directory. And I also need to append data into a cursor from the file.
> Would
> anyone please to tell me how can I do?
>
> Thanks for along support!
>
> VFP Beginner
>
> Ah Wa
>
>

Top