Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: white605
  • Content: Threads
  • Order by date
  1. white605

    Issue installing vfp9 server 2016

    Has anyone successfully installed vfp9 on windows server 2016. The setup.exe is starting and then just dies with no reference to the process in the process explorer. This old world keeps spinning round - It's a wonder tall trees ain't layin' down
  2. white605

    Form Update - using Remote View mysql odbc

    When i create a database and put a remote view from the avaliable sources selecting a mysql connection i created with the connector, I can browze the view and see/navigate the records. When i use this database/view for the source of a form, put elements on it, create a next/previous button, i...
  3. white605

    Extracting a String

    This code uses regexp to extract a string, in this case a domain without the dot com. I will eventually use this type of code to extract a large string (newsstory) from an even longer string (source of webpage) 1. is there a way to get at the submatches without the for/endfor loops as I dont...
  4. white605

    Automatic Fitting of Text to entire column

    Hello, I have a doc that has four equal columns. Eventually thru automation I need to insert text from an outside source into each column and have the font size adjusted to fit each column. The inserted text will be of different lengths. I have tried Using a bookmark at the top of each column...
  5. white605

    Adding records to Remote ODBC view

    vfp9 I have a database with a remote view based on mysql on webserver. Send sql updates is checked. I copied the structure of the view to a temp file Prepared and added records in the temp file I want to add the records to the remote view and update the mysql table on the server. open...
  6. white605

    AutoFilter

    Hello, I worked thru the previous thread and came up with Sub copythis() Selection.AutoFilter Field:=1, Criteria1:="<>,", Operator:=xlAnd Sheets("sheet1").[A1].CurrentRegion.SpecialCells(xlCellTypeVisible).Copy _ Destination:=Sheets("sheet2").[A1] End Sub When I watched the code work, it...
  7. white605

    Passing Variables from VBA instance to Non-Vba Application

    While working through various ways to pass a variable such as a "username","password", or entire "entire connection string" from word or excel to another application after first exiting the original program I have worked thru the following methods. Hard Way - create a new registry key and rite...
  8. white605

    Trifold indivual pages of report with BizHub

    Has anyone had to mail a letter or statement to each person in a database, sent the print job to the printer with tri-fold set in a finisher only to find that the printer wants to stuff every single page into the same envelope, discovers he cannot fit them in and decides not to fold any of them...
  9. white605

    Acess Extended BizHub Print Settings

    Is there a way to programatically get to the extended print properties of BizHub that folds, staples, booklet, etc etc. When recording the following macro i have clicked printer propreties and changed the settings but those changes are not being recorded. Sub Macro4() ' ' Macro4 Macro ' Macro...
  10. white605

    Retrieve auto increment value

    When we insert a record with sql and the record has an autoincrement field for id how do we return the value of the id for us in the same script to enable us to select that same record back for further processing? wjwjr This old world keeps spinning round - It's a wonder tall trees ain't layin'...
  11. white605

    PHP mail() function problem

    I'm having a problem using the php mail() function. I've been googling and experimenting for two days trying to figure it out to no avail. Basically, I'm unable to send an email using the mail() function. The interesting part is that our company website (which we bought from a third party) uses...
  12. white605

    Forcing Email out of Outlook

    Using VFP9 SP1, Outlook 2003 w/MapiLab Advanced security In Click events I have been using code like o=createobject("outlook.application") oNameSpace=o.GetNameSpace("MAPI") oitem=o.createitem(0) oteim.subject="subject" oitem.to="email@whatever.com" oitem.body="body of email" oitem.send o=.null...
  13. white605

    Test for existance of Word temporary file

    When i use word automation to create the file Doe.Jane.40090H.obt.doc from a template file a temporary file is created in the same directory - ~$e.Jane.40090H.obt.doc Is there an easy way to test for the existance of this temporary file to stop people from opening a second read only version of...
  14. white605

    Grid on Page of Pageframe goes Blank

    I am pointing to a record in table1 (pre.dbf) and displaying data on the top of page5 I have grid1 on page5 of pageframe 1 on my form grid1.recordsource is set to a table (thisone.dbf) grid1.recordsourcetype is set to 0 - table grid2.readonly=.t. I put a command button above the grid with the...
  15. white605

    Can Page of Pagframe be Modal

    windowstate property of form allows the choice of modal Is there a like property of a page in a pageframe, if so im missing it completely. or can the visible property of the page be used to do the same thing? My ultimate goal is to "stick" the user on a page until they click an update button...
  16. white605

    SQL Order By

    Working VFP 9 I have the followind code which gets the desired result mdate=CTOD("04/01/07") medate=CTOD("04/30/07") SELECT * ; FROM sch; WHERE (BETWEEN(S_DATE,mdate,medate)) AND type=[G] ; ORDER BY SCH.S_date ; into table current.dbf SELECT * ; FROM sch; WHERE...
  17. white605

    Outlook Security

    Has anyone tried MapiLabs solution at http://www.mapilab.com/outlook/security/ to avoid the pop up windows from outlook? wjwjr
  18. white605

    Wininet code in Server 2003

    The following Code runs well in W2k but Fails in server2003. Is there some sort of default security setting in server that stops this code? *TEST FOR INTERNET CONNCETION Declare Integer InternetCheckConnection In wininet; STRING lpszUrl, Integer dwFlags, Integer dwReserved #Define...
  19. white605

    Getting PPT slide show to execute

    The following code in a click event on a form will open and display a ppt file with powerpoint, not the viewer installed on this computer, however the slide show does not play, it just sits there on the first screen for the time in the wait command. I saved the file with one second intervals and...
  20. white605

    Import from Scanner - Filesize

    Ive read thru the forum - searchging for file size. Are there any rules of thumb for importing paper forms via scanning to adobe for later fill-in form creation that will help with limiting the resultant filesize? thanks wjwjr

Part and Inventory Search

Back
Top