Results 1 to 4 of 4
  1. #1
    WAVP375 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171

    DAO recordset read issues

    Concept is straight forward but coding is something else. Concept: A table containing records with only one field which is the file name of a scaned document. Knowing the path and file name, read that record, display the document, enter selected data from two list boxes and two text boxes, this inputted data becomes the new file name that will be used later for search purposes, then append the new named record to another table used for the searching. I've got it all working exactly the way I want it with the exception i can only read the first recordset record. A loop doesnt work since i have to leave the sub thus loosing track of which record i'm on.I have spent a couple days searching for a solution. The last one explored is the bookmark option. I have not thought that one through but.


    Any thoughts will help. I must display the document in order to know what the name should be. The form i am using is bound to the second table and i am working with the dao environment for the input..

    Thanks

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Why use a second table? Cant you just add fields to the first table?
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    As moke suggested why not have one table with FileName (the one in your existing table), DisplayName (the one you build from the four controls), FileAttributes,FilleNotes, etc. Then you would simply bind the form to the table and do all your editing/searching there.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #4
    WAVP375 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171
    I will give that some thought and give it a try.

    Thanks

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

Similar Threads

  1. Replies: 4
    Last Post: 08-25-2018, 09:57 AM
  2. Read Design & Read Data Issue
    By f15e in forum Access
    Replies: 7
    Last Post: 10-18-2016, 12:44 AM
  3. Replies: 5
    Last Post: 04-22-2013, 12:32 PM
  4. Replies: 0
    Last Post: 03-12-2012, 03:57 PM
  5. Replies: 2
    Last Post: 10-19-2006, 04:37 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