Search results

How do you Remove ADO RecordSet from a ListBox? How does one go about removing a recordset from a ListBox? I have a list box that I want to toggle between using a query and an ADO RecordSet to populate the values. Once I set the listbox .RecordSet property to the ADO.Recordset, I can't...

Hello. I have found some discussions on this site about how to execute a stored procedure. I have followed the examples and even had a DBA run a trace while I executed the SP. The follwoing code runs fine until after I issue the .Execute method and assign it to an ADODB.Recordset object; the...

Hello, I am trying to figure out how to build a weekly report to count the number of computers that have entered a defined process. I have four processes and I need the report to show counts for each process even if it's zero. The report is supposed to show the history of each process and not...

Hello, I have searched online for a solution to this and haven't found anyone with my exact issue. I have a database that has a linked table from another Access database named BuildSheetFolderList. I can run queries off that table in the query builder all day long with no issues. But when I...

Hello all, I have a bit of code that uses collections and transactions with a backend SQL server that I don't have access to. The database tracks installed software on computers. The software information comes from an external script and is saved as a delimited text file. It is then parsed and...