Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. 05-10-2018, 10:01 AM #16
    Minty
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,158

    See my edit - I has used the old incorrect code. Sorry !
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓
    Reply With Quote Reply With Quote
  2. 05-14-2018, 02:41 AM #17
    phil123
    phil123 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    22
    Minty,

    Thanks very much for all your help. For some reason the database doesn't seem to like the .Visible part of the code. When I click the command button an error pops up with this part highlighted.

    Any suggestions?

    Thanks
    Phil
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Missing data in export to excel template
    By MissaLissa in forum Modules
    Replies: 1
    Last Post: 08-03-2017, 11:22 AM
  2. Export Query Results to Excel Template
    By laterdater in forum Macros
    Replies: 2
    Last Post: 09-25-2015, 11:20 AM
  3. I need to export table to excel template and save as different name
    By niloufar in forum Macros
    Replies: 3
    Last Post: 07-31-2014, 01:08 AM
  4. export access query into excel template starting from specific cell
    By registoni in forum Import/Export Data
    Replies: 1
    Last Post: 10-28-2013, 12:32 PM
  5. Export table to excel using excel template
    By allenjasonbrown@gmail.com in forum Programming
    Replies: 1
    Last Post: 06-27-2011, 02:10 AM

Tags for this Thread

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums