Recent content by dfarland

I am trying to close a workbook from a macro. I get the message that there is data on the clipboard and do you want to keep it. I know there is a way of stopping that message, but I can't remember what it is. thanks

I am trying to use the PasteSpecial method to copy a range along with any named ranges. The named ranges do not paste, any help out there?

Thanks Mertous, I checked the Logitec web site and sure enough they have that listed. Driver to fix coming soon.

My log off is very slow. It takes several minutes. One of the little screens on the network connection keeps blinking then they both blink a little. Then it logs off. Any help would be appreciated.

Check out Infotouch, it has everything you specified.

I have a XP machine with an incoming connection setup. The remote access auto connection service is started. It will not answer a call. Is there some more setup to be done?

Just put a button on the sheet the same size as the cell. Then you can link your macro to that button. You will find the buttons on the forms toolbar. After you put your button on the sheet, right click on it and choose "Assign Macro", pick your macro and click OK. You can also put...

1st scenario: Have a row of data in an Excel workbook that I would like to append as a record to an Access DB. 2nd scenario: Have opened up an Access DB in Excel with DAO and have made changes to a record. Now I would like to update the Access db with those changes. Is there any DAO...

I can't seem to find any documentation on these edit and update, are they, methods? Is there some available?

I know how to open an Access db with Excel with DAO. How can I update any changes or append the Access db with the db in Excel?

I got it working, not sure how, but it is working. I renamed anything that I had simply named date. That is the only thing that makes any sense to me. Thanks for the help.

I do use the break mode a lot to step through code. It really is a nice feature. The value of DateRange is "9/30/2003". Which is what the value of the cell/range named "Date".

Sorry, this sample code will run however returns no data. May be a stupid question, but "break"?

Have an Access DB "StoreDB.mdb, with a table called "data" and a date field called "BusDate". If you replace the {#" & DateRange & "#"} with {#9/30/2003#"}, as an example, it works. The value shown in the locals view is correct. What is up? This...

I am trying to open an Access DB in an Excel VBA. This following code works well, but now I would like to filter the the records by one of the fields in the table "data". Can I add a SQL statement somehow to accomplish that? Here is my simple example: Sub GetTable2() Dim rs As...