Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query (Excel xp, Access XP)

    I have an Excel spreadsheet that does a query to my Access database. I have within vb code asked it to retrieve the query and to look in databasepersonnelhr.mdb. It used to say in my code jersonnelhr.mdb, but like I said I had to change it to database......

    My problem is that within the Query it shows Jersonnelhr.mdb How can I get this to show databasepersonnelhr.mdb?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query (Excel xp, Access XP)

    Could you show the relevant code snippets please?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •