Search results for query: *

Thank you for your reply. I have solved it by creating a temp table with the results from the find duplicate query, changing that query into an append for that table and changing out the find duplicate query for the temp table inside my query that shows each record. Now I can delete the record...

I have a table with multiple records in it. I have a find duplicates query to find the duplicate records. The duplicate query counts the instances, but I need a way to bring up each individual record. I have another query with both the original table and the duplicates query in it with a...

Thanks for the suggestion. I'll try it tonight.

My 72 year old father has a Windows XP machine. He recently switched to HughesNet for his internet provider. He normally accesses the internet around 4:00 AM during HughesNet's free download period. He has begun receiving a Web Acceleration Client Error 509.2 and his access has greatly...

Thanks for the help. I will definitely give it a try.

I have used the TransferSpreadsheet command before, but I always imported directly into a new table. I now have a situation where I need to import random columns of information that may have different heading names directly into an existing table with defined field names and types. I would...

Thanks Skip! Worked Great!

Can anyone tell me how programmatically assign a chart to a specific location in a worksheet? I've got a number of charts to insert programmatically and I would like them to line up, but Excel will stack them on top of each other. Can anybody help?

What I do is collect taxes. We have to use the interest rates as published by the IRS. When we bill for a tax, the billing will occur in a particular period through say 30 days from now. If the billing occurred in 1998, every interest rate that was in effect from that period until now must be...

I am in the process of creating a database that can compute interest on an amount in my database. I have a custom worksheet function that can do this in Excel, but I can't seem to get it to work in Access. Can anyone give me an idea as to how to call a custom worksheet function such as this in...

Solved It. Thanks.

Solved it. Thanks.

I have a button that will open a report in PrintPreview mode. However, when the report opens it is behind the form that opened it. I don't recall this being a problem in Access 97, but I am in the process of switching from Access 97 to Access 2000 so now it's a problem. How do I make my...

I have a button that will open a report in PrintPreview mode. However, when the report opens it is behind the form that opened it. I don't recall this being a problem in Access 97, but I am in the process of switching from Access 97 to Access 2000 so now it's a problem. How do I make my...