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

  1. yimitz

    InstRev function in SQL for HIR

    I have a field of data that looks something like this: C320-EB-17-SOME NAME I need to extract just the part that is SOME NAME. In Access I'd use INSTREV and search for '-' then do a left function from that point. The data is variable so I can't just count on SOME NAME starting at the same...
  2. yimitz

    Vlookup in VBA

    Thanks, I didn't have time to work it through, it was a immediate need sitation. Now that I solved the immediate need I will work on updating the routine to clarify the required range and clean up the approach. Thanks again!! Once I have it completed I'll let you know.
  3. yimitz

    Changing Cell Colour based on the values in a different range of cells

    I thought the color index for red was 3 instead of 45.
  4. yimitz

    Vlookup in VBA

    Just wanted to give you my end result code that works. It's not perfect for every possible situation but it does what needed in a heartbeat. Thanks to Skip for all the assistance! Sub MColorMe() Dim myMatchVariable As Variant...
  5. yimitz

    Vlookup in VBA

    That's the thing, the range will be variable I'm afraid. I think to start I would say it would be no bigger than 13 columns and 500 rows.
  6. yimitz

    Vlookup in VBA

    4 different values so that's fairly easy. The tough part now is walking two columns over and highlighting the values in this column, etc, etc. and then also doing this same walk through for 10 worksheets. Is there a "for each worksheet" routine that would simplify this?
  7. yimitz

    Vlookup in VBA

    That's the ticket! I was using Set P1 = (VBCode for lookup) No more errors. Now I just have to set the background color of the cell based on the value the lookup returned. Thanks for the assistance!!
  8. yimitz

    Vlookup in VBA

    A4 is the exact value. It would be referencing Sheet1!A4 value. my first line of code is setting focus to sheet1 and cell A4.
  9. yimitz

    Vlookup in VBA

    I don't want to add to the worksheet, just change the highlighting of the cells based on walking through the cells with values and doiing the comparison. I was thinking of calling the procedure in an on-open routine(?) make the changes and save it, I haven't really thought that far ahead...
  10. yimitz

    Vlookup in VBA

    I want to look up one value in sheet1 that will have a matching value in sheet2, I have to walk through each cell value and highlight matches. Here's my code: Application.VLookup(Range(myRcdA).Value, Range("A3:D535"), 3, False) Range(myRcdA) will have data in sheet1, I need to match that to...
  11. yimitz

    scripting to find info in browser screen

    Visual Basic but if there is a better, simpler language I'm confident I can pick it up and get an understanding of it.
  12. yimitz

    scripting to find info in browser screen

    Is there an example of a simple script somewhere that I could see and walk through to see how it's done?
  13. yimitz

    scripting to find info in browser screen

    Is it possible to create a batch script or some other script to look at a web page with links within the page, open the link (link is to a file for downloading) and have the script automatically put the linked file (zip file, excel, text, etc.) somewhere on your harddrive?
  14. yimitz

    Need to create table based on selected rows in main form and subform

    That could be an option because then if I wanted to save the selections I could do a make table type query or SQL update query to save the data. I didn't really think about that angle.
  15. yimitz

    Need to create table based on selected rows in main form and subform

    Anyone have an example of doing something like this? I have a form based on a table which relates to another table (subform holds this info) that I want to be able to select a check box and return those selections inthe main and subform to a seperate temporary table. I don't know if I'm being...
  16. yimitz

    Auto formatting in MS-Excel

    Is it possible to have excel change the format of one cell based on what you enter in another cell? Say I wanted to automatically have excel format bold fonts if I enter a number in an adjacent cell greater than 100 as an example.
  17. yimitz

    Processing speed slows when other MS-Access DB link tables

    Has anyone noticed if databases which link into a main database will cause the processing of updates/changes to the main database data to become degraded?
  18. yimitz

    Problem with collecting data from the web - Please help!

    I assumed you have access to the webserver and the folder the DB1 is in. If this is the case you should be able to map a drive to the folder say something like this K:\\webservername\parentfolder\subfolder\db1.mdb Can you do this?
  19. yimitz

    Problem with collecting data from the web - Please help!

    There is no need to download any thing. In DB2 on the tables object view right click the white space and a list of options comes up. Look for the link tables option and navigate to your DB1 when the files list comes up. Open your DB1 and link to the tables you need. Then you can create make...
  20. yimitz

    Problem with collecting data from the web - Please help!

    What I usually do is just link the tables from the "data" DB to a DB on my PC which I end up running queries, reports, updates on. You can write VB code in a module which will open the data DB and create temp tables but not knowing what you are trying to accomplish I couldn't begin...

Part and Inventory Search

Back
Top