Results 1 to 4 of 4
  1. #1
    fahdalani is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    2

    New Access user

    Hi all
    I need help plz
    I have an Excel file include 4 columns
    Column 1 patient code
    Column 2 patient name


    Column 3 date for first time visit
    Column 4. Hyperlink with pdf ( to click on the cell and directly open the pdf file for the scanned documents for patient)

    Can i have a simple program to search by name to get all the data and the pdf file ???

  2. #2
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Quote Originally Posted by fahdalani View Post
    Hi all
    I need help plz
    I have an Excel file include 4 columns
    Column 1 patient code
    Column 2 patient name
    Column 3 date for first time visit
    Column 4. Hyperlink with pdf ( to click on the cell and directly open the pdf file for the scanned documents for patient)

    Can i have a simple program to search by name to get all the data and the pdf file ???
    We are happy to help you with any problems you have while building your program but we don't build them for you thats my feeling don't know about others.

    mick

  3. #3
    fahdalani is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    2
    Thanks for your reply
    Let me make my point clear
    I dont want someone to build it for me
    But as i mention ( I am a new user ) so i dont know how to start
    So if someone can tell me how to start and i will try to doit my self

    Thanks again

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    First, I would recommend that you check out this page by orange - there are several/many articles in this link related to Database Planning and Design that may be helpful.
    Then I recommend you work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in the link. You can work through a tutorial in about 30-45 minutes and what you learn/experience/refresh can be used with any database.
    You should be able to tell everyone (in simple terms - no jargon) about the things involved (your subject matter and eventual tables) and what relates these things.
    Finally, you should use paper/pencil, a whiteboard, a window, anything to write on to design your tables/relationships BEFORE jumping into Access.

    Once you have a design, post back and let us review the design.

    Happy reading!

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

Similar Threads

  1. user access to access 2016 database
    By jassie in forum Access
    Replies: 3
    Last Post: 02-15-2018, 08:37 PM
  2. Replies: 3
    Last Post: 09-28-2016, 03:11 AM
  3. Replies: 2
    Last Post: 01-16-2015, 06:43 PM
  4. Replies: 1
    Last Post: 04-02-2014, 06:46 AM
  5. Replies: 13
    Last Post: 11-18-2013, 02:20 PM

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