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 strongm 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: *

  1. postmanplod

    Open PDF in new Window

    Hey Folks, I'm trying to figure out a solution to this problem that has been hanging over my head now for a while. Basically we have grouped lists of PDF's and when the user clicks these, we want them to appear in a new window. Now I know you can go into Acrobat Reader and untick to open in...
  2. postmanplod

    Data on one line

    Hey folks, Our ERP systems uses Crystal Report X1 R2 and I am wanting to create a report that will show customers and contacts all on one line. For example: Cust Add Add2 ConName ConPhone ABC 123 Street Bilbo Baggins 123456 ABC 123 Street Lord Vader 567890 Needs to be...
  3. postmanplod

    Crystal reports suppress using a where statement

    Hello, I have the below data in a report (dates in dd/mm/yy), grouped by job: Job: 123 OP SEQ Desc: Type: Date 20 Stamping 01/02/11 30 CNC 01/03/11 40 Hand Dress...
  4. postmanplod

    Append list box and Text box

    Hello, I have a list box and a text box on a form. When I user clicks a button, the highlighted fields from the list box are appended to a table. However, how would I also append the contents of a text box at the same time? For example if a form had the following: TextBox Listbox 2...
  5. postmanplod

    List Box append to a table

    Hello, I have a form with a list box (lstSerial) and a button on it. I have set the list box to extended multi select. The list box brings in one column of data from a table (tblSerial.SerialNo). When the user clicks on the button I would like it to append the selected data from the list...
  6. postmanplod

    Use values from list box to append to a table

    I have a list box and have set the multi select property to Extended. How do I append the values that a user selects from a list box to a table of my choice? Thanks, Michael
  7. postmanplod

    Group Sum By

    Hello, I have a report whereby it lists parts with a stock valuation. I have been asked if this figure can be placed under a 'bucket' on the report depending on the last transaction date. There are 4 buckets - 0-6 months, 6-12 months, 12-18 months and 18+ months. Also, if data existed for...
  8. postmanplod

    autopopulate

    Hello I have created a form based on one of the standalone user-defined tables - UD06. However, how do I code this so it auto-populates data if someone enters data in the key 1 field and presses the tab key? Michael
  9. postmanplod

    RMA Disposition

    Hello, Does anyone know if it's possible to add another value to the RMA\DispType drop down on the RMA Disposition form. Current values are: INS-MFG - Issued to Mfg ( Job Material) INS-STK - Received into Stock (Inventory) INS-REJ - Failed I want to add an option - INS-CUS - Issued to Customer...
  10. postmanplod

    Service Connect and SQL

    Hello, We are currently running Vantage 803.406 on Progress. I want to master service connect and see what benifits it can offer. We have a spare server (2003) with SQL 2000 running on it. From my understanding Service Connect talks to SQL. My question is, how do I configure SQL to talk to...
  11. postmanplod

    New record via BPM

    How do I create a new record via BPM. For example, when the Part type is changed to 'M', I need to populate the part rev and op table with new records.
  12. postmanplod

    BPM query

    Hello, I need to show an informational warning box when the receiving stock via Job Receipt to Inventory. However, the warning should only appear when the total booked in i.e. sub total of Part Tran\Tran Qty by Job No is greater than the Job Head\Job Prod. I have created a BPM rule based on...
  13. postmanplod

    Row rule or Similar

    Hello, We added a new sheet to the Part screen called 'Design' with some fields, two of which are Part.CheckBox10 and Part.NetWeight. We now want to put a rule in place to state: When Part.Check10 = True, Then Part.NetWeight is disabled, else Part.NetWeight is enabled. I first attempted via...
  14. postmanplod

    Message Box

    I'm a total newby to C # and am trying to customise our ERP system (Epicor Vantage). I want to add a message box that will prompt the user, using the following code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using...
  15. postmanplod

    Change DNS settings via netsh on remote XP computers

    Hello, I'm using netsh to try and change the static DNS ip's remotly (from a server 03 logged in as admin) using the following: C:\Documents and Settings\User\Desktop>netsh -r Computername interface ip set dns name="Local Area Connection" static 192.168.1.5 But receive the following: The...
  16. postmanplod

    Form Event Wizard

    Hello, In the Part screen I need to create an event where by when Part.Checkbox10 = TRUE, Part.Netweight becomes disabled. I've tried the following to no avail: Select Case args.Column.ColumnName Dim CheckBox10 AS String Dim NetWeight as String Case "True" IF TRUE THEN...
  17. postmanplod

    Rolling Dates\Qty

    Hello, I am unable to work the following out: From a Part Transaction table, (connected via XML), we have Part Qty and Part Date. I have been asked to calculate the total of the qty for the past six months, based on today's date - this will obviously change every day. I also need to calculate...

Part and Inventory Search

Back
Top