Search results for query: *

I am trying to create a report that would appear to have two separate page header and detail sections. Is that possible? I have a simple query I'm pulling the data from. The query results looks something like this... name address car year joe 123 main street ford 1996...

I tried changing the default printer and that worked. I'm not sure what the deal is with Access and that particular printer but at least I know what the problem is. Thanks!

I did test several of the queries and they are returning what they are supposed to.

Hi, I have a database that has worked for years. All of the sudden two people that use this database are unable to run the reports. I can run the reports and so can several of my co-workers. What happens is that they double click on the report but nothing happens. There is no error, no...

That was it!!! Thanks stix4t2 for the bulk of the code and Ascentient and PHV for cleaning it up!

Thanks Ascentient and PHV. I changed the two lines to: Dim rec As DAO.Recordset Set rec = CurrentDb.OpenRecordset(strSql,dbsnapshot) but I am getting the following error... run-time error '3001' - invalid argument... Private Sub HIC_Exit(Cancel As Integer) Dim cntRecs As Variant Dim...

Thanks PHV, That's closer to what I was hoping to do. The only problem is that it displays only the first duplicate ID and I suspect I'll have more than one sometimes. I would like the message to include all duplicates. Thanks stix4t2, I think you're code is really close. I had to make a...

Again that's much appreciated but not exactly what I wanted. I not only want to tell the user that the duplicate exists, I also want to tell the user which records are the duplicates. For example, the message would say something like 'Provider x hic x combination is already entered at record 16...

That's a good start but it's not exactly what I wanted. I not only want to tell the user that the duplicate exists, I also want to tell the user which records are the duplicates. For example, the message would say something like 'Provider x hic x combination is already entered at record 16 and...

This is my first post and vba is something I dabble in so please excuse my ignorance. I have a form which is to allow duplicate entries. Dups are defined as having the same pnbr and hic. I would like to provide the user with a message indicating which records are dups. I started by...