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
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...
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...
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...
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
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...
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
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...
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...
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
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...
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...
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)...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.