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

    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:
    Code:
     =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
    Location
    Nevada, USA
    Posts
    21,935
    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
    www.BaldyWeb.com

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