Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dfarland
  • Content: Threads
  • Order by date
  1. dfarland

    Disable msg box when closing a workbook.

    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
  2. dfarland

    PasteSpecial Paste:=xlPasteAll doesn't paste named ranges

    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?
  3. dfarland

    Log-off is very slow.

    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.
  4. dfarland

    XP Incoming RAS connection will not answer the phone

    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?
  5. dfarland

    Appending or updating Access db with Excel??

    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...
  6. dfarland

    Using Excel to update or append Access DB

    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?
  7. dfarland

    SQL statement "=" doesn't work in VBA

    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...
  8. dfarland

    Filtering OpenRecordSet

    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...
  9. dfarland

    Unrecognized Data Format - Get this error...

    Get this error when I run this code. What is up? Sub GetTable2() Dim rs As Recordset Set rs = DBEngine.OpenDatabase("C:\Sales\StoreDB.mdb").OpenRecordset("Objects") Range("A1").CopyFromRecordset (rs) End Sub

Part and Inventory Search

Back
Top