Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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