Search results

Sorry, I think I had it in the wrong place. I justed typed it straight into the event_afterupdate box in properties. I think that you meant it to go into the VBA code on the control [Event_procedure]. I moved it to the VBA. The query values on the form do not change regardless of combo box...

Error message: Microsoft access cannot find the object 'me'

Query Criteria [Forms]![frmDBCPIMSDataErr]![cmbCommandSelect] Combo Box Code Private Sub cmbCommandSelect_AfterUpdate() DoCmd.OpenQuery ("qryDBCPIMSDateMismatch") End Sub Form is based on query ("qryDBCPIMSDateMismatch") Combo is unbound and rowsource is tblCommand, which list available...

You're absolutely correct! the "vice versa" part isn't working. Hopefully I can fix that part. I am pretty sure that I had it working before I started to rework this query. I changed all of the reserved name into [brackets] and the combo box is still not working. The combo box's source is...

Hello all, This is what I am trying to do. Compare two tables. Find associated records in table 1 that do not match records in table 2 and vice versa. Next be able to further filter those results based on a combo box selection. I am trying to do this all in one query. Data is being pulled from...

You guys are awesome!! Fixed problem. Even was able to use conditional formating to color code my results. Thanks again

Hello all, I am having some issues with this error showing up on my forms. I have a calculated field that is the result of 2 queries. The first query gives me the count of assigned and trained personnel and the second query divides the results and displays a percentage. Both of the queries run...

Thanks so much worked like a charm!! Spent the last 2 days searching web and forums on how to fix it, to no avail. Much gratitude and thanks. Scott

Hello All, Does anyone have an idea on why the following is causing a run time error 1004? Method Range global. objXLApp.Columns("A:A").Select objXLApp.Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote...

Figured it out. DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel12, "tblCPIMS", ExcelFilePath, True

Hello All, I am in need of some help on this one. I am trying to import a "user selected" excel file into an access table. I have been able to some of what I need using. DoCmd.RunSavedImportExport ("Import-CPIMS-Belt-Report") But this only works on my machine becuase I created the Saved...