FoxPro adding Footers in Adobe Acrobat?

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
    - problem with a VFP 9 COM server I have a COM server I've written, starting in VFP 6, using the combination of Session and OLEPublic classes. This is used by other apps such as WordPerfect and Word to retrieve some data from our foxpro tables, and has worked well for years in VFP 6, 7, and 8. Now, when I try and compile it in 9, it is taking approximately 30 seconds to close the running instance of it, when it's used, and this leaves a white square on the display of the calling app, and renders it unusable during this time. Until now it's closed almost instantly. Does anyone have any guesses as to what's going on and what's different about VFP 9? This is run under win2k and Win XP. Thanks. Chip Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217117
  - 2
    - Please help - remote view problems Posted this before with no resolution. I have a VFP app that uses the MS-ODBC SQL driver to connect to remote data. The intent is to have the view refresh every five seconds with the latest data (very dynamic). I created a view that give the info I need but I keep getting SQL deadlocks. The VFP 6 error codes returned when using the view are 1526 or 13. Can I continue to use views and develop around this? Is there any way to make the view read-only and prevent a deadlock situation? Here's some code: *!* Establish connection Create CONNECTION MyConn; DATASOURCE alltrim(config.sourceodbcn); USERID alltrim(config.sourceodbcu); PASSWORD alltrim(config.sourceodbcp) *!* Create View Create SQL VIEW 'vMyView' ; REMOTE CONNECTION 'MyConn' ; AS SELECT * ; FROM tablename tablename *!* Use the data within a controlling loop that fires every five seconds If !USED('vMyView') Use vMyView IN 0 Endif Select vMyView *!* the I read the results, etc... Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217114
  - 3
    - Using table with CursorAdapter - how can I get the ID of latest record? Hi, I have an application and I use CursorAdapters for all tables. I have the following problem: I have to create a new record in a table, find it't id (integer auto-increment) and pass it to another module Specifically, user create a master record, then (before they save and exit) they can also create one or more child records in several other tables. So when they open the forms for the child tables, I havre to know the ID for the master record, and pass it to the form handling the child table, to set it as foreign key. The problem is I have troubles finding the ID. I use a very odd method right now, which works, but I'm not happy with it. Can anyone give me so thoughts on how to get this done in an elegant way? Thanks, Bogdan Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217113
  - 4
    - VF6 Objects? Hi, all I'm a Visual Basic 6.0 Programmer and I was wondering if Visual Fox Pro has an exportable object library the VB6 could use as an embeded object in an application (like Microsoft Excel Object library). If so, Which files should I use? -- Rick Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217111
  - 5
    - Using MS Access with Foxpro tables When I am in MS Access and attempt to link to a Foxpro table in dBASE IV format, even tough I navigate to the file with Access, when I click on it I get the error message The Microsoft Jet database engine could not find the object 'xxx.dbf'. Make sure the object exists and that you spell its name and path... Any ideas? Thanks in advance for your help Fred Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217099
  - 6
    - append from dynamic file name.xls 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 Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217098
  - 7
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217097
  - 8
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217096
  - 9
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217090
  - 10
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217088
  - 11
    - Is there a New York City Foxpro user group? I haven't heard from PADD for quite a while. Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217084
  - 12
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217082
  - 13
    - view designer and union could view designer specify a union? There is only a join tab, no union. Tag: FoxPro adding Footers in Adobe Acrobat? Tag: 217081
  - 14
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217079
  - 15
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217075
  - 16
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217074
  - 17
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217073
  - 18
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217072
  - 19
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217070
  - 20
    - '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: FoxPro adding Footers in Adobe Acrobat? Tag: 217054
  - 21
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217046
  - 22
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217044
  - 23
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217040
  - 24
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217033
  - 25
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217030
- Next
  - 1
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217021
  - 2
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217013
  - 3
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217008
  - 4
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217002
  - 5
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 217000
  - 6
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216995
  - 7
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216984
  - 8
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216976
  - 9
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216975
  - 10
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216966
  - 11
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216965
  - 12
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216948
  - 13
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216947
  - 14
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216944
  - 15
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216941
  - 16
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216937
  - 17
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216925
  - 18
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216910
  - 19
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216904
  - 20
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216903
  - 21
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216902
  - 22
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216901
  - 23
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216890
  - 24
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216882
  - 25
    - 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: FoxPro adding Footers in Adobe Acrobat? Tag: 216873

Mike Gagnon was so helpful on my last question regarding Adobe Acrobat - now
I need to have FoxPro add footers to my Acrobat files. I'll have
ALLTRIM(lastname)+", "+LEFT(firstname,1)+" - " in the center of the footer,
and the page no. on the right, with a left margin of 5.8" How would I go
about that?
Thanks so much!

Top