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

    Barcodes for Verifying Counts

    Is there a stand alone unit to verify and print out a report of which items are stored on a shipping pallet? I am shipping to a particular customer and they say that my pallet contents are not correct when we have triple checked the order. Is this a possible solution through bar coding? Thanks...
  2. jercisneros

    Excel Startup VB Macro Problem

    Everytime I start excel a message pops up that is titled Microsoft Visual Basic and the message reads Compile Error: Can't find project or library. The only options are Ok and help. The screen right behind it is titled GWXL97.xla - Startup Macro (code). and under the Sub SetLanguageStrings()...
  3. jercisneros

    Excel - Converting numbers to text

    I am trying to convert some number in an entire row to text, I have right-clicked the file and format cells and in the category I set it to text. The problem is, I am using it as a source through an ODBC and the program that I run requires that the cell contain an apostrophe ' in the beginning...
  4. jercisneros

    Changing PO Information

    I have installed the groupwise software on computer connected with novell. There are 12 other existing computer with client software and groupwise functioning correctly. The installation of groupwise went fine, but when it is trying to connect to the post office it uses a non-existing post...
  5. jercisneros

    Multimedia for a web site question

    Hi all, I am a newbie for web site design. I couldn't find a better place to post this message so I posted it here. I have created simple sites with pictures and text. But I want to find out what I need, to have multimedia on my site, for instance, I would like to find out how I could broadcast...
  6. jercisneros

    Greater than 30 days dating parameter

    Hi all, I need to create a parameter that will give me invoices that have greater than 30 days dating, but would like to have a paramater that would also let the user select 60, 90, 120, and 150 days dating for aging invoices. I have a field {AR_INVOICE_DET.INV_DATE} and would like to use it for...
  7. jercisneros

    Halftoning in Illustrator

    Is it possible to create a halftone simulation on vector art? I want to be able to print a gradient but the detail of the gradient is too fine, I want the halftones to show more when it is printed. Thanks in advance, Jerry
  8. jercisneros

    Spot colors from PS to Illustrator

    I am doing color separation for some art and the art contains about 5 different colors. What I want to accomplish is being able to send the spot colors from PhotoShop to Illustrator in seperate layers and want to be able to modify or change the colors in illustrator. Is this possible? I have...
  9. jercisneros

    Color Separation Setup Dialog Box

    I have heard that Illustrator has the capacity to create positives or proofs by using the separation setup dialog box. My question is the following: Do I have to do anything special so that it becomes enabled for me to go into the dialog box? Because right now it is grayed out or disabled. Any...
  10. jercisneros

    Selecting First Record by Formula

    Hi all, I have a table that contains all the order information. I want to create a report that tracks new stores entered into the system ({Customer.Date_Created}). Then I want to be able to show the first two shipments only since the creation of the customer. There might be more than two...
  11. jercisneros

    Record selection criteria - First two orders

    Hi all, I want to create a report the shows the customer creation date: {CUSTOMER_MASTER.DATE_CREATED} by Customer ID: {CUSTOMER_MASTER.CUSTOMER_ID} and want to report when this customer ships the first and second orders only. The shipping information would be in a table: {SO_MVMNT.TABLE} and...
  12. jercisneros

    Displaying only one string entry in group header

    I need to display a string entry ("DOT Reg. No.") in the group header only once. I have created a report that has a parameter query. For instance: I enter 2 sales orders in the parameter and it brings up the information for those to orders. Right now it displays ("DOT Reg...
  13. jercisneros

    How to insert the path for a workbook

    I have a lot of excel files that get lost on our network. I can put the filename but I also want to be able to put the full path at the footer of the page. I tried using help for this but shows nothing. Is there a way to do this in excel? Using Excel 97 Any help would be greatly appreciated...
  14. jercisneros

    Printing date ranges as report title

    I have created a parameter "{?Date Range}" and I want to display this field as a report title. The parameter is set to Allow multiple values and Discrete and Range values. I have created a formula like: "Date Range: " + ToText({?Date Range}[1]) " to " +...
  15. jercisneros

    Formula to exclude empty fields in select expert

    How do I make a formula to exclude null or empty fields in the select expert portion of the report. What I want to do is get the information based on {CUST_ADDR.STATE}, but sometimes this field is empty and want to exclude this on my report. Any help would be appreciated.
  16. jercisneros

    How do I include all data based on a parameter

    I have created a parameter that will select discrete and ranges of stock codes. But once I create that parameter if I don't enter anything in the parameter the report will refresh empty. Is there a special character that will include all stock codes when entered into the parameter? Any help...
  17. jercisneros

    Grouping Multiline Comments

    I am having a problem trying to place the comments below the detail section that show the products purchased. I am using two tables; Sales Order Table that is grouped by {Sales_Order.Order_Number} and the Comments Table that contains the field: {Comment.Description} whith multiple lines. The...

Part and Inventory Search

Back
Top