Search results

Figured it out. I am sure it was a no brainer but I forgot about the 'Nothing' keyword. I was trying to set the .RecordSet property to null which was throwing errors. Set listbox.RecordSet = Nothing

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

I put <ServerName> in as a place holder for the server name, as that is standard for designating that that symbol should be replaced with the actual value and I wanted it to be clear that it's just a place holder when putting code online. I don't put in the actual server name in the examples...

Hi JHB. No. I haven't gotten it to work yet and have been upable to put my full attention to it as I have needed to put out other fires and provide other functionality for my users. I will talk with my DBA who has full access to the SQL server to reconfirm that there are no errors on his end...

Yes, this is in the example code that was on the Microsoft site that I added to my form. Using the same connection parameters, I can issue a "SELECT * FROM <table>" query without issue.

So I copied that example into my Access frontend, changing the appropriate attributes and I still get the "Operation is not allowed when the object is closed." message. Perhaps there is somehting with the Stored Procedure on the server side? Feeling really frustrated with Access (or myself)...

Thanks for the reply JHB. "lstAssignedWorkstations" is an Access ListBox. I am attempting to assign the record set to the list box as one would assign a DAO.Recordset to a ListBox. I am new using ADO and am only using it because that is the only way I can get results from a Stored Procedure...

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

Thanks for the answer plog. I was thinking this to be the case but hopping that there was some function builtin to Access that I didn't know about. I guess they will just have to live without having the zeros.

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

Found the problem with my code. It was an Id10t error on my part. After spending too much time looking at my code on Friday, when I came back Monday and gave it another go I realized that the line of code immediately following the line I thought was giving me an error was causing the issue. All...

Thanks for the reply pr2-eugin. Yes. I have done a debug.print with the result of: SELECT BuildSheetFolderList.[FSU Area] AS REQ_DESC, BuildSheetFolderList.[Pay Crew] AS PER_FULL_NM, BuildSheetFolderList.[Work City], BuildSheetFolderList.[Work Address] AS NOTES FROM BuildSheetFolderList WHERE...

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

@boblarson, Thanks for the info. I will play around with the parent property. Being that Access seems to be working with the code as of now, I will move on as I have a ton of other requests to put into this "Application". @lagbolt, Yes, breaking processes into smaller, self-contained subs is...

Still getting the wrong number of agruments error with the added comma. The MSDN documentation does not have information regarding that many number of parameters. So I am still a little confused about this. Thanks,

Thank you for the replies. I tried adding the following code: If rs Is Nothing Then Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot, dbSeeChanges) Else rs.OpenRecordset strSQL, dbOpenSnapshot, dbSeeChanges End If But on the rs.OpenRecordset strSQL, dbOpenSnapshot, dbSeeChanges...

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