Search results for query: *

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...

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...

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...

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

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...

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 =...

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...

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...

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...

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

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...

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...

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...

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...

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...

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

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...

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]')...

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...

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...