Recent content by Chauncey7

Thank you!

Thank you! All great suggestions. When putting the excel.visible=true we figured out it might be a timing issue. It looks like it was just the client's operating environment being too slow. We put a break point in between setting the excel object and opening the file, waited a few seconds and...

Thank you in advance for the help.... I'm been getting Error Number: -2147467259, Error Description: Method 'Open' of object 'Workbooks' failed. It happens when attempting to set a workbook variable by opening the file: Set wb = objExcel.Workbooks.Open(<File>) It works on MS Access 2016 and...

Can't do that. Classified info.

Bob that didn't work either. The criteria string actually does work for others that have quotes in the SERVICE. I replaced the code anyway, but still to no avail. I am at my whits end with this thing.:banghead:

This is what the SQL Statement comes out to be: [DataType] <> 'CDMD' AND [VALVE_NO] = 'XX-X-13' AND [SYSTEM] = 'OIL TANK' AND [LOCATION] = '1-11-11-X' AND [SERVICE] = 'VALVE,1 1/2'' BALL,FO STOR TK 5-26-0-F' VALVE,1 1/2'' BALL,FO STOR TK 5-26-0-F' is the service

I wish it were that easy. All of my parameters in the openrecordset statement are generated from textboxes. There is only one value for each textbox, right? I tried simulating the same parameters in a query, thats all. And it worked for the query! So the records are there! its just not pulling...

Yup. I took the values from the text boxes and put them in a query and it worked perfectly. So it's something with VBA, maybe I don't have a reference checked or something? I don't know?:banghead:

Negative, SERVICE is a textbox and there are no lookups defined at the table level. This database is not the best I've seen, I'm trying to help out a friend.

The second set of code I posted was the original. The first is what I tried changing it to but still does not seem to work.

First off thank you all for the help. I made all of the suggested changes: Forms!FrmCompare!CompareFullSubform.Form.Control I also made all of the changes in the last couple posts and it still does not return a record. I took parameters out and the only parameter that causes problems is the...

I realize the form reference isn't correct but it still gives the right values when I have Form_frmName, so I don't think that's the problem. :confused:

The initial code was this: The .FindFirst would not return anything and exit the if statment/procedure. If it did find a record it would change the record with the CDMD DataType and Delete the VHMP DataType. Function UpdateConfigFull() As Integer Dim dbsname As Database Dim...

Negative, I only put the trim in there because I thought the values had spaces, which they do not. This is actually a colleague's and at first he had it set up as: Set rst= CurrentDB.OpenRecordset("tableName", dbOpenDynaset) and he was using .FindFirst I thought moving it to a SELECT...

I have a form in which on a change it looks for a matching record in the same table. I created a query with the same parameters (the parameters are the same values as the variants I place in my SELECT statment). The query returns a record but the VBA does not. I've gone through every possible...