Recent content by BenSteckler

I know this is too late but does your court list need to have the entire permanently deleted, or just temporarily?

Hi Everyone, I have a silly question. I have a table that has a list of products and their revision numbers. I am attempting to write a code that will scroll through the records in the table to find some specific data. I have set up a SQL statement that will query the table and filter it to...

Thanks for the update. I have tried this code to apply the filter to the report itself but I am getting an error. The error states that there is no Report by that name. But I know that the report is named correctly. Could you assist me with this code? This code was placed just prior to the...

I am trying to output an Access Report to a snapshot viewer. The problem I am having is that when I call the OutputTo command, it does not allow me to change the filter. It just opens the whole report. Can anyone look at the following code and tell me what I am doing wrong? Code is written in...

I have just recieved an error that I have never recieved before. (See attached image.) I have run this code all morning and now when I run it, I get this error. It is weird, I did not even change anything it that code. Can anyone help? :confused: Thanks.

Hi, I thought access automatically complied the code when you saved the module? Is that incorrect? I will try what you said about the references. But I thought the Time function was a standard Windows command? Thansk for the help. I will response when I have attempted the correction. BDS

Help Please, I have an access database that is housed on a novel network. There are multiple users that have used this database for more then a year with no problems. But starting Thursday an error started occuring when this code was used: Me.TimeIs = Time() They would recieve this error...

Thank you. It worked perfectly. BDS :cool:

Hi Everyone, Quick question. I am trying to create a report that has two columns. Is there someway to do this using Access? Thanks BDS :D

I figured out where the problem was. I looked at my References and Microsoft DAO 3.51 Object library was the list reference on my list. A co wprker of mine told me to move the DAO reference to the top of the list, or as high up on the list as it will allow. This solved the problem. My co...

Here is a copy of the whole code: Public Sub BuildCorrectTable() Dim dbs As Database Dim rs As Recordset, rsa As Recordset, sql As String, sqlA As String Set dbs = CurrentDb Set rs = dbs.openrecordset("All Products", dbOpenDynaset) '<---Error Occurs Here Set rsa =...

Thanks for the reply, It is an acutal Table in the same database. I Tried to create a SQL statement and use that instead, but I still got the same message. Any ideas? BDS

Hi Everyone, I have a problem. I am trying to open 2 recordsets. But when I run the code, it displays a message "Type Mismatch." Can someone look at my code and tell me what I am doing wrong? Dim dbs As Database Dim rs As Recordset, rsa As Recordset, sql As String, sqlA As String...

I know it is possible, but I am unsure how. I would just go ahead and manipulate it in Excel. Good luck. BDS

Hi rwttm001, If you change your docmd line to acSpreadsheetTypeExcel9 instead of acSpreadsheetTypeExcel97, it should work just fine. The only time you will have a problem is if the spreadsheet is already open by another user, our yourself. Thanks BDS