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 Chriss Miller 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: *

  • Users: traceyr
  • Content: Threads
  • Order by date
  1. traceyr

    how to determine the order of shapes in CDR X3 VBA

    I'm using a VBA macro in CDR X3 to replace multiple shapes in a document by png images. Almost everything is working, but I can't understand how to determine the order (i.e. from the back to the front) of overlapping shapes, so that I can apply the same order to the images. Since there can be a...
  2. traceyr

    IE plugin / MS Java / VRML

    I hope that this is an appropriate forum. If not, perhaps someone would advise me on which forum to post this question!! I have a bespoke application, written for a friend 10 or so years ago, which uses Internet Explorer 7, Microsoft Java and Blaxxun VRML (all long since obsolete, but they...
  3. traceyr

    IE plugin / VRML

    I hope that this is an appropriate forum. If not, perhaps someone would advise me on which forum to post this question!! I have a bespoke application, written for a friend 10 or so years ago, which uses Internet explorer, Microsoft Java and Blaxxun VRML to create, edit and display 3D models of...
  4. traceyr

    Using a global Dictionary to share data between programs

    I have a small application (about 8 Forms) which uses Dictionaries to store small amounts of data e.g. abbreviations of country names (index) and the full name (value) in each of several languages (one Dictionary per language in this example). I have several such Dictionaries which are identical...
  5. traceyr

    Outlook 2007 Save as text file breaks long text lines

    I regularly receive emails in Outlook 2007 with text in the mail body. If I copy/paste the body into a text editor, the text file retains the original line lengths (in this case up to 131 characters). However if I use File/"Save as" to a text file, Outlook inserts line breaks at or near char. 72...
  6. traceyr

    MS Word 2007 formula editor / publish PDF

    Vista system: When using the MS plug-in to Word 2007 to publish a PDF file from a doc which includes formulae created using the formula editor, the resulting file, when opened using Acrobat Reader, shows corrupted formulae with super-sized numerics (i.e. perhaps 100pt). Creating a PDF file using...
  7. traceyr

    'Array of columns' in DataGridView?

    I'm about to create a DataGridView which, in addition to an ID column, will have 66 columns, with column headers numbered from 1 to 66, the rows to hold integer values. It would be time-consuming to define each one manually in the form definition, so (how) can I generate these columns...
  8. traceyr

    HTML: Superscript and subscript in same character position

    Hi, I'm trying to create a numbered list of publications for a scientific website. Unfortunately, some entries refer to isotopes using notation in which a superscripted Atomic Number and a subscripted Neutron Number immediately precede the element symbol, i.e. one above the other in the same...
  9. traceyr

    How to find the ColorIndex of words within a cell?

    I have a column of cells containing text and a macro which counts the number of words within a marked range. What I'd really like to do is to count only e.g. blue words in all cells within the range and ignore text of other colours. If a cell contains words of different colours, ColorIndex...
  10. traceyr

    Updating in an Append Action Query (Access 2000)

    I have a simple Append query which adds records to table3 when it finds matching records in table1 and table2. In table1 and table2 there is a boolean field 'Matched' which I need to set to True whenever a match is found (to prevent processing a second time). Is it possible to do this? On...
  11. traceyr

    Connect.It query on target DB

    Can anyone point me to a description of how a Connect.It scenario can query e.g. the AssetCenter DB, and use the information returned to determine a course of action? I have seen that this can be done but haven't found where it is described (RTM, with reference, welcome!!). many thanks in advance.
  12. traceyr

    Excel:replace filename in cell with the file's contents

    Hi all, I have a spreadsheet with several columns containing the names of text files (all of which are in subdirectories of the current directory, e.g. spreadsheet in \A1\A2\, files in A1\A2\A3\). Some cells are empty; if there is an entry, it is a valid filename. The columns are currently 401...
  13. traceyr

    D-Link AP in Repeater Mode

    Config: XP Pro with ETH link to Belkin DSL Gateway Router 54g. This works fine with notebooks using (a) a Belkin Airplus 54G card, (b) an Artem card (811b with 11Mbps) and (c) an Artem USB adapter (811b with 11Mbps). WEP is disabled at present, DHCP enabled. The signal is too weak to reach...
  14. traceyr

    Send email with attachment from AC4.3

    We have a requirement to generate a csv file from AC4.3 (we can do this) and send this file as an attachment with an email. Have any of you done this, or have you any suggestion of lines of approach? Many thanks for your time. Tracey
  15. traceyr

    using amRevCryptPassword() in AC4.2

    Has anyone managed to use amRevCryptPassword as described in the ProgRef and Knowledge Base entries? Our attempts so far have not been successful. The Knowledge Base states that the way to compare a user-defined password (i.e. not the user's login password) with an existing (encrypted) one is...
  16. traceyr

    Deleting empty cells in Excel

    I have a large spreadsheet (20 cols x 16,000 rows) which represents a hierarchical cost centre structure; the parent cost centre is in col 1 and the children across the page. Where a level is not present there is an empty cell. I would like to process each row, deleting empty cells and shifting...
  17. traceyr

    Non-Unique model names on migrating AC3.6 to AC4.2

    Hi! Our 3.6 DB contains products with non-unique model names, e.g. (fictitious) Brand=IBM Model=3400 and Brand=HP Model=3400, in the same category. In 4.2 there is a uniqueness constraint on a Model's name/full name, leading to a DB error (on full name).: 2003/05/23 10:06:42.405 3 1 (-2004)...
  18. traceyr

    AC integration with Outlook

    We would like to create Outlook deadlines from within AssetCenter, e.g. from Work Order resolution dates. Has anyone done this? Any ideas? Thanks

Part and Inventory Search

Back
Top