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!

Search results for query: *

  1. accjrf

    Excel2010 Scatter Plot with multiple series

    Using Excel 2010, I am attempting to create an XY scatter platter with multiple series. The series names are arranged as rows in my source table with corresponding X and Y values on each row. Sample data below. Working with this example, I'd like five series (00110, 00401, 00405, 00415...
  2. accjrf

    Excel 2010 link updates return to old value

    Skip, I know that line of code should have nothing to do with any links, however, it is very clear that when that line is executed by stepping through the code, the link that was updated gets reset to the original value. BUT this is only happening in 2010. The links do not have formulas...they...
  3. accjrf

    Excel 2010 link updates return to old value

    I have an excel workbook that is linked to a second workbook. I also have code written in the first workbook that opens a 3rd workbook, copies comments from a textbox, and then pastes them into the first workbook. Here is my problem. In 2007 this works perfect but in 2010 when the code is...
  4. accjrf

    linking a text box from one sheet to another text box on another sheet

    Got it. Thanks!!
  5. accjrf

    linking a text box from one sheet to another text box on another sheet

    Skip, OK, i finally got that to work. i didnt realize that i had to turn on the developer button on my ribbon to get to the active X controls. But here is my problem using that. It doesnt seem like i can hit the enter key in an active x text box and have it return to a new line like i can in a...
  6. accjrf

    linking a text box from one sheet to another text box on another sheet

    Skip, Have you actually tried this code in excel and does it work? I cant get any results no matter what i try.
  7. accjrf

    linking a text box from one sheet to another text box on another sheet

    Skip, How do i get to the properties of the text box to put this as an "on change" command. right clicking on it and selecting the 'Assign a macro' puts it as an "on click" command and then i get an error 438 - Object doesnt support this property or method. Sub TextBox1_Click()...
  8. accjrf

    linking a text box from one sheet to another text box on another sheet

    I cannot find any information on how to do this. The reason that i am starting with a text box is because it allows users to hit the enter key to go to a new line. This spreadsheet is used to have a group of users enter comments explaining why sales trends may be down and they like to enter...
  9. accjrf

    sum in excel

    I didnt realize such a function existed but that is exactly what i need. Thanks!!
  10. accjrf

    sum in excel

    i have a spreadsheet that has a column of names and another column of sales $. I am going to add a 3rd column with an identifier for certain rows that I want to exclude in a total at the bottom. how can i write a sum that looks at a different column to know if it should include/exclude the Sales...
  11. accjrf

    Excel Row Range using a variable

    Unhiding rows that were previously hidden the last time the report was saved, sorting on a given column, and then hiding rows that have a value under $x. I just didnt want to "hard-code" in a range of rows because the report may grow or shrink so i am doing a Find and then getting the value of...
  12. accjrf

    Excel Row Range using a variable

    This is probably easy but i just cant seem to write this correctly. I am trying to select a range of rows in Excel but i want to select it by using a variable. Standard way: Rows("2:12").EntireRow.Select What I want to do: Where IntStartRow = 2 & IntEndRow = 12 Rows( ? IntStartRow : IntEndRow...
  13. accjrf

    Add data to a datatable

    Sorwen, Ok, I think that solved all my issues. Thank you so much for all your help! You def earned a Star!
  14. accjrf

    Add data to a datatable

    I did not realize that I had to drag the DataSet onto the form. I thought it would populate the table and then I could open the table from the .xsd tab. However, this line of code: "Dim workTable As DataTable = Me.DataSet1.Tables("Table1")" does not produce an error at the bottom of the...
  15. accjrf

    Add data to a datatable

    Dim workTable As DataTable = Me.DataSet1.Tables("Table1") I get an error that says "Dataset1 is not a member of the form name that I have the button on to execute the code. Do I have to link them somehow? And you are saying that if I close the form, that my data disappears with it leaving an...
  16. accjrf

    Add data to a datatable

    Sorwen, Answering your second post... Table1 under the tab DataSet1.xsd is the table I created to put the data in to store it. I am going out to an internet page, using variables to hold several pieces of data from that site and I want to stick that data into Table1 at the end of the code...
  17. accjrf

    Add data to a datatable

    Maybe I am missing something. In Access if I have a local table "Table1", I can refer to it in VBA and update records on it. Example: Dim D1 as Database Dim R1 as Recordset Set D1 = currentdb() Set R1 = D1.openrecordset("Table1") R1.Addnew R1("Cust_name") = "John" R1("DOS") = Date()...
  18. accjrf

    Add data to a datatable

    Andy, Thanks for the tips. I was just using a made up example so someone could direct me on how to write what I am trying to do. Any help with how to do it?
  19. accjrf

    Add data to a datatable

    Hi, I am new to VB. I am actually using Microsoft VB 2008 Express Edition so I hope I am posting in the right place. I have used VBA for many years but I am trying to learn VB and I am having trouble with probably the easiest code to most of you. I have searched and read for hours on msdn for...
  20. accjrf

    Remote Desktop Server

    Has anyone ever used VBA code to not only open a Remote Desktop Server but to then control that screen? For example, be able to input to the username and password, and use other controls on the screen without any type of send keys commands (I hate those). Thanks

Part and Inventory Search

Back
Top