Search results

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

Hi Everyone, I am attempting to run this code, but I keep recieving this error. Type Mismatch I have refered to the Help section and other source code, but I am still unable to find out what I am doing wrong. Can some one assist me? Here is the begining of my source code: 'Set up...

Hi Everyone, I am looking for a way that I can automatically detect who is logged into the system by refering to their Active Directory ID. Does anybody have a sample code that will return a string value of the Active Directory ID? Thanks :p

Thank You! Thank Cosmos75 and Cogent1, I have dropped the size from 144 MB to 800KB. I appreciate the help, BDS

No, I have never hear of compacting a database. Can you breifly explain? I was thinking that maybe for some reason, when running a delete query, Access does not actually delete the data but stores it in a 'recycle bin' of some sort that is hidden in the database. Thanks for the quick reply. BDS

Hi Everyone, Quick question. I have a database that runs a Macro that runs a couple of Make Table Querys. When it finishes, I run a few Delete Querys to empty out the tables. But the problem comes in when I start the database, it starts with a size of 9.1 MB. But when I finish, it has grown...