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!

Register Log in
  • Congratulations derfloh 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: PBREP
  • Content: Threads
  • Order by date
  1. PBREP

    After invoking delete page macro, the custom footer page number format is incorrect.

    Hello VBA developers, The code you see below performs customized formatting layouts (code not shown). The main problem is that blank pages are shown (Print preview and save to PDF). The “Sub headerFooter()” had some edits to complement the new “Sub DeleteBlankParagraphs()” section in the...
  2. PBREP

    How do I Remove Text from Even Page Header - Section 1 in a Word doc (2013) using VBA?

    History: I have a macro (not shown) that deletes the blank page that comes between the cover page and the proprietary page of a Word document that is generated from RoboHelp. However, the cover and the proprietary pages become the same section and the footer section (macro driven as well) is...
  3. PBREP

    Delete Blank Pages macro

    Hello VBA Programmers, I have the following macro which deletes blank paragraphs from a Word document (e.g. user can see blank pages in Print Preview). I loop through all sections in the document, and if the section does not contain the table of contents, then I delete the blank paragraphs in...
  4. PBREP

    Using Windows CE to download files from an FTP site

    Hello all: I am aware of a FTP client software, "Scotty" however, I need to know if there is a correct setting I need to configure in my Windows CE 2.0. I tried accessing a ftp by typing in the address bar, no go. Anyone had any luck? Thanks, ~PM
  5. PBREP

    Problems Copy an field value into a Array

    Hi All: Using VFP 8.0 PROBLEM: Need my Swog Weight to rate. SWOG stands for Ship With Other Goods. It is used to ship several smaller items within a larger container to the same destination. This information is stored in the shipping software I'm using, it lets you track which shipment a...
  6. PBREP

    Changing a Registry Value Using Fox v5.0

    Hi Guys: Here I have to use "VFP 5.0" to code in. A)What am I atepeting to do: Change the value from 2 to 3. Target: Registry Path = HKEY_LOCAL_MACHINE\SOFTWARE\PitneyBowes\Ascent\CustomerUpgradable Registry Key: Value Name = CustomerUpgradable LOGIC: If the Value Data = 2 Then Value Data =...
  7. PBREP

    File in Use error

    Hi Gurus: I'm attempting to create a program that would do a directory prompt (which I get) for the user to select their cus_main.prg file and it would automatically back up the prg & fxp files prior to recompiling. The purpose for the Getdir() is so that the Copy File command will know where...
  8. PBREP

    SQL/VFP 5.0 problem

    Hi All: I have been trying to use a PADL function. My problem is applying this to the ‘Prompt’ for the ODBCLink script I written. I cannot get it to work within my Select statement – I’m not sure if my syntax is incorrect, or if I am limited because of the field I am working with. Please see my...
  9. PBREP

    unable to get the freight to calculate correctly for multi-pkg

    Hello All: To summarize, the cus_main.prg creates an export text file containing the daily shipping data for importing into customers AS400 host. An important feature of this cus_main is to consolodate multi-pak shipments into one record. This is the feature that is not working. However, it...
  10. PBREP

    Capturing data from a memo field

    Hi All: I have a memo field (i.e. TrackNo, data come in and I would like to capture the data between the carots (^)and copy it to another field (i.e. AnyText). I.e. 1234^56789^9876 = Need to grab "56789" Anyone know the best command in VFP 7.0 to do this? Thank you, ~PM
  11. PBREP

    Please help with List Box

    Hello All: I need to have a list box appear, user selects a service type (i.e. G, GR, 2D, etc...). I have a table called 'Custcode.dbf' that has the service types entered in a field called 'code'. I need to pull all from custcode.code and when the user double-clicks their service type, it will...
  12. PBREP

    Command contains unrecognized phrase/keyword

    Hello all, using VFP 5.0, a syntax problem I came across. Thank you & Happy Thanksgiving to the USA folks! ~PM && create a cursor directly from MS Access. Procedure Ship_Via() lcmdb="c:\C:\ASCENT\ODBCLINK\nonorm.mdb" store SQLSTRINGCONNECT(; 'DBQ='+lcmdb+';'+; 'Driver={Microsoft...
  13. PBREP

    Two-dimensional array - help

    Hello all: OK here's the scoop... Maybe you know another way (ref. Purpose)? Thanks, ~PM PS - Happy Thanksgiving! PURPOSE:I mapped a field (via ODBC) from MS Access called Ship_Via to my SA_CUS[1] array. From there I am attempting to create a procedure that will call/view the information...
  14. PBREP

    Error Msg: "Variable is not Found"

    Hello all" I'm bombing out on my dblClick procedure. I would like to see the rocord/acct# I selected from my liost box, write it to my array sc_ship_a_ship[80] and to my field 'Card' located in my upsman.dbf table (ref. upsman.Card) Thank you Error#: 12 Error Msg: "Variable is not...
  15. PBREP

    SetFocus/GotFocus question

    Good afternoon Foxpro Gurus: Trying to implement Function or Procedure for a SetFocus or GotFocus. After the user double-clicks the CustId and selects their customer id (sc_ship.a_cus[1] I need my cursor to automatically move into another textbox (sa_cust[1]) field/array. How can I implement...
  16. PBREP

    How to create a Barcode from a control charater

    Hello Guru's: Using VFP 6.0. Has anybody created a barcode from a control charater before? Trying to implement the <enter> command: &Code39($M) Thanks, PM
  17. PBREP

    Vfp Email problem

    Good afternoon Foxpro Guru's :<) TARGET: To created a small email prg (vfp6.0) that selects all records that contain an 'N' in the &quot;signed&quot; field, along with the resuired fileds to show in the email body and send them to the MS outlook 2000 outbox. Thank you, PM ERROR: MS Outlook...
  18. PBREP

    &quot;Operator/Operand type mismatch&quot; - need help

    Hello Fox Guru's :<) My problem is as follwed: PURPOSE: I'm utilizing the POM3Z.DBF to look-up the sack# in reference to what the user Zip to is. What I want happen is my function to check the Zipcode that the user enters or from their consignee data (ARRAY for this field is 'sa_cust[8]')...
  19. PBREP

    Incrementing a # in a field /array

    Hi all Well, I searched the internet for number incrementing (counter)tips for foxpro and all the example I see are database specific. What I what to do is a simple auto-increment procedure that will keep adding 1 in my display field (ref. array sa_cust[1]) when trigger. For example after the...
  20. PBREP

    Error executing SQL Command for data source

    Hello there: Error Message: &quot;Error executing SQL Command for data source Customers Connectivity error [Microsoft][ODBC Microsoft Access Driver] Too few parameters. expected 2.&quot; First thing I done was created a new ODBC drivere = &quot;made no difference&quot; using ODBC from a...

Part and Inventory Search

Back
Top