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

    InfoPath 2007 Repeating Table

    Does anyone know how to display just one instance of the values in a repeating table? I am trying to display a list of items and I am getting the values listed many times in the table. Thank you very much for your help!!!! Jimmy Shaw
  2. jrshaw03

    Excel Plotting Problem

    Hello All, I am attempting to construct a 2D polar plot of a radar tracking event. The data X-Axis should be represent 0-360 Degress, but my data values look like this: 220 250 340 10 30 Passing 360 degress complicates things. The only way I can think to do this is to add 360 to each of the...
  3. jrshaw03

    Show Images Dependent on Field

    Hello all, I have a simple form that shows some data from a main table and 1 OLE Object. The OLE object is 1 of 5 images of the US all in different colors. The image that is shown depends on the value of a "Rating" field. Also the images are stored as records of type OLE OBJECT in a seperate...
  4. jrshaw03

    Opening .tiff outside of IE

    After some playing around awhile I tried using: document.location.href= "Target File" I was scanning through .tif files so I used a variable for the target file, and it worked like a charm. Since the file associations were already correct, it turned out to be very little work. Thanks for...
  5. jrshaw03

    Opening .tiff outside of IE

    Ok just so I understand. I would create a WSHshell, Activate the Office Imaging program and then pass the .tif file to it.? Does that sound semi-correct? Thanks again, Jimmy
  6. jrshaw03

    Opening .tiff outside of IE

    As a part of a tech manual a js funtion calls a tiff file and attempts to open it inside Internet Explorer. If the users could install the AlternaTiff plugin for IE this wouldn't be a problem but security limitations prevent it. As a solution I would like to pass the file to Microsoft Office...
  7. jrshaw03

    Change Font Color in SQL Query

    Sorry, poor job of explaining. There are more than General Items and APP. There is Procurement, Enineering..., total of 9 different names that all need to be intermixed alphabetically to yield the correct order. Thanks, Jimmy Shaw
  8. jrshaw03

    Change Font Color in SQL Query

    Thanks for the suggestion, but this doesn't do it for me. When I look at the data in the query, it is in the correct order, but when I take it to the report everything goes to alpha order. The report does have Ascending sorting on Category under the sorting and grouping option, and I cannot...
  9. jrshaw03

    Change Font Color in SQL Query

    I am using an SQL query which unions all of my fields together soas to preserve a certaing format: Heading (A) Field Entry 1 (for A) Field Entry 2 (for A) ... Heading (B) Field Entry 1 (for B) Field Entry 2 (for B) ... To do this I use: SELECT DISTINCT "a _GENERAL ITEMS" as Category, [General...
  10. jrshaw03

    Exporting Memo Fields containing over 255 Characters to Excel

    Replace all of your UNION fields with UNION ALL. This may give you other problems later on, but it should get you down the road. Jimmy
  11. jrshaw03

    Select Query Character Limit

    No worries, I should have closed out this topic last week. I ended up finding the UNION ALL answer through some better searching. Jimmy
  12. jrshaw03

    Large Union query truncates memo field

    Cypdog, Hopefully you are still active on the forum. Could you please post some of the SQL you used to overcome the truncation problem? Thank you very much, Jimmy
  13. jrshaw03

    Union Concatenation Question

    When I do this, I am put over the 255 char threshold thus the concatenated part is not concatenated. Jimmy
  14. jrshaw03

    Union Concatenation Question

    I have a large Union query, where I am joining many fields together so they display as follows. Header Entry 1 Entry 2 Header Entry 1 Entry 2 Entry 3 My problem is that each entry is limited to 255 chars even though it is based on a memo field. To get around this I have tried to use this...
  15. jrshaw03

    Select Query Character Limit

    dRahme, I want my information to be displayed in a newsletter format, with: Heading Entry 1 Entry 2 Heading Entry 1 Entry 2 Entry 3 .... The problem is that these entries extend beyond the 255 character limit. I was thinking of splitting the fields into part 1, 2, 3... So I...
  16. jrshaw03

    Select Query Character Limit

    I have many select commands all linked together by unions. For example: SELECT "a _GENERAL ITEMS" as Category, [General Items] as Item from [Mk 36 01Jan Source] UNION SELECT "c _OPN FUNDING", [Blank Space] FROM [Mk 36 01Jan Source] UNION..... My problem is that my fields (ie General Items)...
  17. jrshaw03

    Report with Combined Fields Instead of List

    Thank you very much, this works perfectly. Jimmy
  18. jrshaw03

    Report with Combined Fields Instead of List

    I have a database that holds a newsletter. Users enter their information in the database in fields such as General Accomplishments, Upcoming Events, etc. I would like to create a report that has a heading: General Accomplishments, and under it everyones input in a list. Next Upcoming Events...

Part and Inventory Search

Back
Top