Results 1 to 2 of 2
  1. #1
    bgephart is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2012

    Question about linked Excel table

    I have a database that uses a linked Excel spreadsheet as one of its tables, "Books". Since I have it linked and "read-only", that seems to limit the way I can use it in forms.

    I have created a form based on another table, "Checkouts", that is related to "Books" (Books:review = Checkouts:Book ID). So far, I just have fields from the Checkouts table in my form. (They're actually from a query based solely on the Checkout table.) I found that if I linked in "Books" in any way, I was unable to update anything on the form.

    Still, I would like to include information from a couple of the fields in Books on my form, and have tried using DLookup in the ControlSource for a text box as follows:
     =DLookUp("[title]","[Books]","[review]= " & [Forms]![Check In Form]![Book ID])
    I have gone over this several times looking for errors in punctuation and capitalization, etc., and have tried several variations of syntax, but continue to get "#Error" in the field. Is there something about the nature of the Excel-linked table that's causing a problem? Or is there something wrong with the syntax that I'm not catching?

    In case it matters, I'm building this with Access 2007, but in a 2003 compatible format.

    Thanks for your help.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Nevada, USA
    This would be more efficient if applicable to your situation:

    BaldyWeb - Autofill

    If not, perhaps your syntax is wrong for the data type?

    DLookup Usage Samples
    Paul (wino moderator)
    MS Access MVP 2007-2019

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create a linked table from excel using VBA
    By stigmatized in forum Import/Export Data
    Replies: 2
    Last Post: 08-04-2012, 01:21 AM
  2. Limit rows of linked excel table
    By FJM in forum Access
    Replies: 1
    Last Post: 06-15-2012, 02:43 PM
  3. Replies: 6
    Last Post: 05-16-2012, 12:43 PM
  4. Linked Table Question
    By RayMilhon in forum SQL Server
    Replies: 2
    Last Post: 03-26-2012, 01:19 PM
  5. Excel Linked Table not Updating
    By BillH in forum Import/Export Data
    Replies: 1
    Last Post: 06-09-2011, 08:37 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
Other Forums: Microsoft Office Forums