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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vb6novice

  1. vb6novice

    Visio Controller Dimension Format

    My Visio Controller Dimension objects display dimensions in feet, inches, and sixteenths of inches (e.g. 16'-2 7/16") when the Units in the Precision & Units dialog box is set to Feet-Inch (1'-0"), regardless of precision. I want to create a custom format so that dimensions will display as feet...
  2. vb6novice

    How to get shape ID for later use

    Thanks,John I wanted to draw 4 lines and join them because I am trying to render an architectural perspective/isometric from a listing of coordinates which represent the corner points of a building's walls and windows, and similarly for the roof sections. Every wall and roof section has...
  3. vb6novice

    How to get shape ID for later use

    Long Time VBA user - new to VBA in Visio - still haven't figured out how to refer to shapes and their properties (or is that Cells ?) I have code that draws 4 lines on a page, then selects the 4 lines and joins them. After the join, I want to fill the joined shape with a color. I recorded a...
  4. vb6novice

    Formula in File Name Argument of TransferText action in Macro

    lameid, Thanks for the response. A VBA module was my first choice, however, the creators of the database are also the users and they have no knowledge of VBA coding. 90% of our Access DB's were created by people who are insufficiently trained to do so and in this company there is categorically...
  5. vb6novice

    Formula in File Name Argument of TransferText action in Macro

    Is it possible to use a formula or the value of a text box on a form as the File Name argument of a TransferText action in a Macro. The user needs to export a number of similar files from a table with slightly different criteria. He wants the Transfer text to increment the output file each time...
  6. vb6novice

    Read Binary file records where length varies

    Ascii = 13 Here's a sample: 12815886397 A0000001009684 0220717381 8134805304 12816320455 A0000003428B6D 9999999999 NA A00000010171AC 000000001 5059777417 NA A0000001018694 000000001 8044566537 12805591940 NA 0520759191 4045566294 The apparent spaces between the values...
  7. vb6novice

    Read Binary file records where length varies

    Thanks for the input Bong, Actually the file I received does not have an extension, so it isn't really a .txt. When I open it with UltraEdit, however, it appears as though there is some sort of line ending character at the end of each line. When I use the Line Input #1, it tries to read in...
  8. vb6novice

    Read Binary file records where length varies

    I want to use VBA in Excel to open a .txt file in which length of each string of characters varies from record to record. The goal is to peel off either characters 1 to 11 if they are numeric, or some other other set of characters if they are not. What is the best way to read in each line if...
  9. vb6novice

    Another request for query help

    Is there a way to get all of the records in table X that do not have a corresponding record in table Y? Here's some details: Table X fields: POKEY EXTERNKEY MODEL QTY Table Y fields: POKEY EXTERNKEY MODEL QTY Table X contains all receipts for 1 week and can have many records (typically 8-10)...
  10. vb6novice

    How to determine the .mdw that a db is set to

    Is there a way in Access 97 to open a database and determine what .mdw file the database is using for security settings?
  11. vb6novice

    Complex Database Security Problem

    There is a SYSTEM.MDW file in the same folder as the DB, however there are also 2 other mdb files in the same folder which do not have any security. Would it be a good or bad assumption that that SYSTEM.MDW file is the right one?
  12. vb6novice

    Complex Database Security Problem

    Please understand that my knowledge of Access security is scant. There is an Access 97 database which was created (and used) by someone who is no longer an employee. An unknown level of security is applied to the database, which resides on a server at company headquarters. Users are at a...
  13. vb6novice

    Alias data labels

    Thanks lbass, I didn't know I could specify a sort order by group. Since my data already had a field with the 3-day abbreviation, I just had to make it the group field and specify an order.
  14. vb6novice

    Alias data labels

    My CR XI report is a 3D Bar chart showing the number of Help Desk calls by hour of day and day of week. The underlying data has the day of week as an integer: 1 for Sunday, 2 for Monday, etc., so the values that show in the axis on the chart are 1, 2, 3, 4, 5, 6 and 7. The data includes a...
  15. vb6novice

    Can Chart Title be modified by Parameters/Formula

    Thanks lbass. That works great. Now why didn't I think of that.
See more

Part and Inventory Search

Back
Top