Search results

  1. S

    Use form button to change value in table

    Oh man... can't believe I totally my database just because I misread that post.... :-( Oh well: at least I'll get some practice reworking it once again. Like I said, for us knowing that there are 3 copies of Book X, and that persons A, B, and C all have a copy of Book X suffices. Of course...
  2. S

    Use form button to change value in table

    It seems I'm in waaaay above my head here. I first had my database the way you described it, but then someone here on the forum explained to me why I should change my database so it would have the calculated field...
  3. S

    Use form button to change value in table

    Hi there, I'm building my first database, to manage a small library. There are multiple copies of certain books, which is represented in the books table in the copies field, which has a certain number in each record. In the new loan form (which is bound to the loan table) want the save...
  4. S

    Library: New Loan Form has book duplicates

    That sounds great! It would mean quite a lot of reworking of my other queries and tables, but that's all in the game. Thank you very much for your reply. I would have never thought of that solution. You reckon thinking about databases like this will get easier over time?
  5. S

    Library: New Loan Form has book duplicates

    I'm sorry, like I said, I'm a real newbie at this, but isn't that the same as doing that in the Properties Field? Like I said, doing that doesn't change anything, because the CopyIDs are all unique. I thought about not using the CopyID in the combo box, and instead just use the Title, but then...
  6. S

    Library: New Loan Form has book duplicates

    Hi there, I've only started building a database in Access a few days ago, so I'm real new at this. Through Youtube videos though I've been able to at least get all tables and queries for my library database in order. The problem I have is with the Form for lending out books. I have a table with...
Top Bottom