• WSgchutrau

    WSgchutrau

    @wsgchutrau

    Viewing 15 replies - 76 through 90 (of 108 total)
    Author
    Replies
    • in reply to: textbox as value, not text (2002) #718764

      it seems that this does this does the trick:

      Private Sub x_spacing_Change() ‘ x_spacing is the textbox
      Dim userinput As Integer
      userinput = x_spacing.Value
      Sheets(“hidden_data”).Range(“xspace”).Value = userinput
      End Sub

      But I am surprised that although having and advanced user interface like the properties window for the textbox, that it slipped from the developers, that textbox user input could be formatted there as an option! Recognizing user input as text , numbers, etc and sending with that format to the linked cell should be straight forward and automatic.

      Thank you

    • in reply to: textbox as value, not text (2002) #718765

      it seems that this does this does the trick:

      Private Sub x_spacing_Change() ‘ x_spacing is the textbox
      Dim userinput As Integer
      userinput = x_spacing.Value
      Sheets(“hidden_data”).Range(“xspace”).Value = userinput
      End Sub

      But I am surprised that although having and advanced user interface like the properties window for the textbox, that it slipped from the developers, that textbox user input could be formatted there as an option! Recognizing user input as text , numbers, etc and sending with that format to the linked cell should be straight forward and automatic.

      Thank you

    • in reply to: textbox as value, not text (2002) #718713

      User input in a textbox (inserted from the Control Toolbox and linked a spreadsheet cell) always defaults to text?

      There is no way to overide that? Not even with code?

    • in reply to: textbox as value, not text (2002) #718714

      User input in a textbox (inserted from the Control Toolbox and linked a spreadsheet cell) always defaults to text?

      There is no way to overide that? Not even with code?

    • in reply to: textbox as value, not text (2002) #718699

      That would work.

      But,,,, problem: I have several formulas that refer to A1. And replacing A1 in the formulas , for Value(A1), would add a lot of text in my formulas and make syntax difficult to understand. (I have several cells that are linked to several textboxes. These cells provide numeric data to the formulas)

      Is there a way I can format the text box so the cell receives the numbers that the user is typing , already as numeric data, so I dont have to edit the formulas?

      Thank you

    • in reply to: textbox as value, not text (2002) #718700

      That would work.

      But,,,, problem: I have several formulas that refer to A1. And replacing A1 in the formulas , for Value(A1), would add a lot of text in my formulas and make syntax difficult to understand. (I have several cells that are linked to several textboxes. These cells provide numeric data to the formulas)

      Is there a way I can format the text box so the cell receives the numbers that the user is typing , already as numeric data, so I dont have to edit the formulas?

      Thank you

    • in reply to: Make table query expression – following record (2002) #715551

      I have an Excel spreadsheet to load gridded data from a map (a point set), and trim down a certain number of “nodes” based on spacing in X and Y.

      My data comes from an ASCII file consisting of 3 columns : X coordinate , Y coordinate and altitude.

      But excel is limited by the amount of rows you can load, so I guessed that the same task could be done with Access.

      I linked the ASCII file to a table. I have a query to extract the max and min X and Y. I have another “make table query” with an expression that will yield true or false if X or y are multiples of a “spacing” that I supply to trim down the data. This make table query uses as input for the expression, the fields in the first query.

      In that way I can trim my data to keep only for example, a 10 * 10 X-Y spaced grid.

      But I also want to keep the node data that belongs to the end of each rib of the new grid (imagine mapping an ice cap; I want to keep the data corresponding to the end of each data line in X and Y, where the ice cap actually ends). In Excel, my data is sorted by X and Y, and I have a formula that checks the value of X (or Y) in each row, and the value of X immediately above. If it is not the same, it flags the row, sow I can eventually keep that row in my final listing, with the autofilters.

      I thought that with Access, I could query a sorted table, and have an expression that would mimic the formula I have in Excell to flag the records where my X (or Y) value changes in the sorted list.

      Excel works fine with small datasets, but ASCII with 100,000 lines (real life) are dificult to handle

      Comments, suggestions? Thank you

    • in reply to: Make table query expression – following record (2002) #715550

      I have an Excel spreadsheet to load gridded data from a map (a point set), and trim down a certain number of “nodes” based on spacing in X and Y.

      My data comes from an ASCII file consisting of 3 columns : X coordinate , Y coordinate and altitude.

      But excel is limited by the amount of rows you can load, so I guessed that the same task could be done with Access.

      I linked the ASCII file to a table. I have a query to extract the max and min X and Y. I have another “make table query” with an expression that will yield true or false if X or y are multiples of a “spacing” that I supply to trim down the data. This make table query uses as input for the expression, the fields in the first query.

      In that way I can trim my data to keep only for example, a 10 * 10 X-Y spaced grid.

      But I also want to keep the node data that belongs to the end of each rib of the new grid (imagine mapping an ice cap; I want to keep the data corresponding to the end of each data line in X and Y, where the ice cap actually ends). In Excel, my data is sorted by X and Y, and I have a formula that checks the value of X (or Y) in each row, and the value of X immediately above. If it is not the same, it flags the row, sow I can eventually keep that row in my final listing, with the autofilters.

      I thought that with Access, I could query a sorted table, and have an expression that would mimic the formula I have in Excell to flag the records where my X (or Y) value changes in the sorted list.

      Excel works fine with small datasets, but ASCII with 100,000 lines (real life) are dificult to handle

      Comments, suggestions? Thank you

    • in reply to: mouse over, show information (2002) #710038

      (Edited by WendellB on 15-Sep-03 12:55. activate hyperlink)

      I didn’t try the last trick , but http://www.soniacoleman.com/Tutorials/Powe…quicktricks.htm%5B/url%5D is an excellent link.

      There is a trick there that can do the job too, without the animations (that gets very tedious , if I have a large set of text help boxes).

      The trick involves creating a bookmark to the same slide and use the bookmark text help tips to display the additional text!

      Thank you very much

    • in reply to: mouse over, show information (2002) #710039

      (Edited by WendellB on 15-Sep-03 12:55. activate hyperlink)

      I didn’t try the last trick , but http://www.soniacoleman.com/Tutorials/Powe…quicktricks.htm%5B/url%5D is an excellent link.

      There is a trick there that can do the job too, without the animations (that gets very tedious , if I have a large set of text help boxes).

      The trick involves creating a bookmark to the same slide and use the bookmark text help tips to display the additional text!

      Thank you very much

    • in reply to: turn off underlining hyperlinks (2002) #712818

      It will not underline an URL interactively if I type it.

      But if I insert a link or bookmark , it will underline it and turn to the color scheme color assigned to hyperlinks

      Thanks

    • in reply to: turn off underlining hyperlinks (2002) #712819

      It will not underline an URL interactively if I type it.

      But if I insert a link or bookmark , it will underline it and turn to the color scheme color assigned to hyperlinks

      Thanks

    • in reply to: turn off underlining hyperlinks (2002) #710572

      sort of…

      the alternatives are:

      1. have just one word or letter (or special additional character) carrying the link
      2. insert an object (visible or not) with the attached link or bookmark

      good! Thank you

    • in reply to: turn off underlining hyperlinks (2002) #710573

      sort of…

      the alternatives are:

      1. have just one word or letter (or special additional character) carrying the link
      2. insert an object (visible or not) with the attached link or bookmark

      good! Thank you

    • in reply to: turn off underlining hyperlinks (2002) #710235

      It didn’t work.

      thanks anyway

    Viewing 15 replies - 76 through 90 (of 108 total)