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. ScorpioX

    Find matching cells on two worksheets, then copy the data over

    Hi Tammy23, Yes actually I did get help with this. I ended up using a query to do it. If you have VBA code that does it. I would be interested in looking at it. If you need my help feel free to ask. Basically the query was pretty simple. I added the two tables joined them using the same field...
  2. ScorpioX

    Find matching Cells, then copy data over to another Worksheet

    Thank you Skip! I got it working! I was making it way to complicated and your advice worked like a charm. I'm now using a query it works awesome. Thanks again, ScorpioX
  3. ScorpioX

    Find matching Cells, then copy data over to another Worksheet

    Yes I think so. ADUsers has the data that needs to be copied into Raw_Data based on matching Raw_Data ColumnD to ADUsers ColumnA. ScorpioX
  4. ScorpioX

    Find matching Cells, then copy data over to another Worksheet

    Hi Skip, I did actually try that but it does not seem to be working correctly. This is what I tried. All it does though is copy everything over. It does not seem to be matching just importing everything. SELECT `Raw_Data$`.User, `ADUsers$`.EmployeeNumber, `ADUsers$`.Department FROM {oj...
  5. ScorpioX

    Find matching Cells, then copy data over to another Worksheet

    Hi Skip, I'm kind of new to this. Well actually really new not kind of. Anyway. I don't think I really get what you're saying. =================================================================== Sheet1 ColumnA ||ColumnB ||ColumnC ||ColumnD ||ColumnE ||ColumnF Model ||Date...
  6. ScorpioX

    Find matching Cells, then copy data over to another Worksheet

    ScorpioX (MIS) Ok here we go. Not sure I'm explaining this right. So I will try the best I can. I have Two Worksheets within the same Workbook. One is named Sheet1 the other is Sheet2. Sheet1 Has six columns (A, B, C, D, E, F)with 1000 rows. Sheet2 Has three columns (A, B, C) with 2000 rows. I...
  7. ScorpioX

    Find matching cells on two worksheets, then copy the data over

    Ok here we go. Not sure I'm explaining this right. So I will try the best I can. I have Two Worksheets within the same Workbook. One is named Sheet1 the other is Sheet2. Sheet1 Has six columns (A, B, C, D, E, F)with 1000 rows. Sheet2 Has three columns (A, B, C) with 2000 rows. I would like to...
  8. ScorpioX

    Windows did not start sucessfully

    HI All, Does anyone know what tells Windows it did not start sucessfully on the last attempt. Basically I have a sysprepped image and don't want to have to rebuild it or repackage it. Everything still works it just waits at the Advanced menu options until a choice is made or it times out. More...
  9. ScorpioX

    Check to see if network path exists

    PopulateListControlFromFile is a function used to populate a List box or Check box on your form. With the data from a text file. 1)Create a form. 2)Create 3 list boxes on the form named List1 List2, List3. 3)Create a TxtArray on the form, named TxtArray. 4)Create 2 command buttons, one named...
  10. ScorpioX

    Check to see if network path exists

    Thank you that worked like a charm as well. I will use that instead as it is written better. Thanks, again, Scorpiox
  11. ScorpioX

    Check to see if network path exists

    HarleyQuinn, Thank you for your time and your posts. I did get it to work though. I added an On error statement and now it works like a charm. Not sure if it is the right way but it works. Below is the changes incase your interested. Private Sub Form_Load() On Error GoTo NoPath_Error...
  12. ScorpioX

    Check to see if network path exists

    The error only happens when the path is not valid. Do I need some kind of boolean or false statement other then Else maybe? Scorpiox
  13. ScorpioX

    Check to see if network path exists

    I tried that as well. I used "\\Cluster1\ComputerImages\" but it keeps erroring out with bad file name or number. ScorpioX
  14. ScorpioX

    Check to see if network path exists

    That was what I thought also. Never tried it using a network path though. The value is "\\Cluster1\" no quotes though. Scorpiox
  15. ScorpioX

    Check to see if network path exists

    sorry that would probably help. It errors at the If statement on List3. Keeps coming back as bad file name or number. I can get it to work if I put a path in there but I need to use a variable for it and I can not seem to get it right. Thanks, Scorpiox
  16. ScorpioX

    Check to see if network path exists

    Hello, Sorry I have been searching and can not seem to find what it is I need. I think I have come close but seem to get errors everytime. I am looking to check and see if a network path exists. If it does I want to populate a box. If not, show a message and end the sub. Below is what I have...
  17. ScorpioX

    Trim Search value on Data Access Page

    Here is the working code in case you are curious and or someone else is having this issue. The code below Searches the Default Recordset in this case "tblMachines", returning the matching record to the DAP. It searches The "SerialNumber" field within "tblMachines" using the value that is...
  18. ScorpioX

    Trim Search value on Data Access Page

    Hi AndyinNC, Just wanted to drop you an update. I did get this working. I actually used both approaches and it is working like a charm. Thanks again for all your time. ScorpioX
  19. ScorpioX

    Trim Search value on Data Access Page

    Hi AndyinNC, The code you suggested above the VBScript, does actually return the correct value within the MsgBox, but does not return a record. I had thought I read something somewhere on using the like command. So I will try to find that again. I will also try your sugesstion using Sql if...
  20. ScorpioX

    Trim Search value on Data Access Page

    Hi AndyinNC, I tried as you stated and it does not seem to be working. It comes back with the wrong type error like it did above. Sorry I thought this would be easy. Got any more ideas? ScorpioX

Part and Inventory Search

Back
Top