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 strongm 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. romeerome368

    Parsing Data from a String based on an adjacent cell

    Hello Everyone, I have trying to parse a value from a string based on the value of an adjacent cell in Excel 2010. My data looks as follows: UOM[tab]Package Content EA[tab][tab]EA-1;BX-10;CA-40 BX[tab][tab]EA-1;BX-10;CA-40 CA[tab][tab]EA-1;BX-10;CA-40 I am trying to use SEARCH in addition to...
  2. romeerome368

    Access Creating Hyperlinks in Excel Worksheets

    Hello Everyone, I have some code that I'm working on. I think that my syntax is correct, but I am getting a run-time error 9 - Subscript out of range error message. Below is a sample of the code that I am running. What this code ultimately does is create hyperlinks for four (4) items to...
  3. romeerome368

    Speed up VBA Code

    Hello, I have created code to help me write large amounts of data to an Excel 2010 file. The code works great, but it's working slower than what I would like. It ran for 2 hours and only posted 40,000 records which is way to slow for my fast paced environment. I have a recordset that has...
  4. romeerome368

    For Each Loop Help

    Hello Everyone, I am trying to create some VBA code to help create and ending date for my records. I have start dates, and the end date should be the next start date - one day. For example: Start Date: 2/25/2011 Next Start Date: 4/30/2011 End Date for 2/25/2011 Start date should be...
  5. romeerome368

    Refreshing Excel Pivot tables from Access 2007

    Hello Everyone, I have an Access 2007 database that I generate reports in Excel. The data in the database gets refreshed everyday at 5 am in the morning, and I have a scheduled task that runs the refresh of my backend database, and a task that refreshs my Excel spreadsheet as well. My code...
  6. romeerome368

    Tabbed page reference

    Hello All, I have a tabbed form, and there is a combo box on Page1 using Access 2007. I want this combo box to be a filter for a query and return data to a list box on Page1, but my reference to my combo box is not working. I'm not quite sure how the syntax needs to be entered in the criteria...
  7. romeerome368

    Using Access to send multiple receipents their excel reports

    Hello, I have a database where I am creating a recordset to pull a list of receipents, and then generate an excel file with their own individual data as an attachment via VBA. The problem that I am running into is that I get an error message that states that it can't find my SQL statement...

Part and Inventory Search

Back
Top