Results 1 to 4 of 4
  1. #1
    MichaelA is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    139

    Lookup and Store ISBN Information


    Hold off on this one. The online catalog may no longer exist.

    I found a blog that explains how to set up Access to lookup and store ISBN Information. The explanation, unfortunately isn't clear enough for this newbie. I'm wondering if someone can help me. The blog post is here: https://onemancoder.wordpress.com/2015/06/16/58/

    My first questions:
    Do I set up a table?
    What should the table be named?
    What should the field names be?
    What should the data types be?

    Thank you, in advance!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,967
    Yes, set up a table.
    Name it whatever you want.
    Field names are specified in the blog.
    However, Date is a reserved word and should not use reserved words as names for anything.
    Data types are all text except for date field which would be date/time.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    MichaelA is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    139
    Quote Originally Posted by June7 View Post
    Yes, set up a table.
    Name it whatever you want.
    Field names are specified in the blog.
    However, Date is a reserved word and should not use reserved words as names for anything.
    Data types are all text except for date field which would be date/time.
    Thank you for your help. I'm still trying to find an alternate place from which to lookup information. The web link in the code is dead.

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,123
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 24
    Last Post: 02-01-2017, 07:16 AM
  2. Using ISBN as Primary ID
    By Thompyt in forum Programming
    Replies: 1
    Last Post: 04-17-2015, 02:22 PM
  3. Replies: 4
    Last Post: 12-05-2012, 05:10 PM
  4. Replies: 3
    Last Post: 11-29-2012, 11:00 AM
  5. Replies: 1
    Last Post: 06-02-2011, 04:11 AM

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