UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Only Display Available Records, Access 2013    
 
   
vanzie
post Sep 11 2019, 05:51 AM
Post#1



Posts: 9
Joined: 29-January 19



Hi everyone

If there is any similar topic, please direct me to it.

Im designing a database where we use firearms. In this DB, you have the officers who will book out a firearm and then you get the DFO (Designated Firearms Officers) who will handle which firearm will be assigned to which officer.

I have a separate table with all the firearms info such as make, model, serial etc. And another table with the info of the officers with a field "Assigned Firearm".

If a officer gets registered by the DFO, they should assign only the firearm serial to that officer. What i want to do is that if another officer should get registered, the new officer should not be assigned with the same serial number. Is there a way to hide the serial from the combo box if it has already been assigned?

Any help will be appreciated

Thank you
This post has been edited by vanzie: Sep 11 2019, 05:52 AM
Go to the top of the page
 

Posts in this topic
- vanzie   Only Display Available Records   Sep 11 2019, 05:51 AM
- - Larry Larsen   Hi It would be of interest to us to see what you ...   Sep 11 2019, 07:06 AM
- - projecttoday   If you have a separate officers/firearms table the...   Sep 11 2019, 07:23 AM
- - BruceM   To add a little to what Larry wrote, it would be p...   Sep 11 2019, 07:32 AM
- - vanzie   The tables in my DB is tblFirearms with the inform...   Sep 11 2019, 07:42 AM
- - nvogel   If the rule is that a firearm can only be assigned...   Sep 11 2019, 08:19 AM
- - GroverParkGeorge   As a general rule, it makes sense to implement con...   Sep 11 2019, 08:48 AM
|- - projecttoday   It is likely that you will have several of each ty...   Sep 11 2019, 11:18 AM
|- - projecttoday   If you don't need to maintain a trail of who w...   Sep 11 2019, 11:21 AM
|- - MadPiet   This design will work... Used it a long time ago w...   Sep 11 2019, 11:33 AM
|- - projecttoday   I have a program written in Visual Basic .Net.   Sep 11 2019, 12:09 PM
|- - vanzie   For the purpose of the DB, it will be used for whe...   Sep 12 2019, 12:08 AM
|- - vanzie   Okay ive tested something: On my firearms table i...   Sep 12 2019, 12:29 AM
|- - vanzie   Here is my final code when clicking save: Dim...   Sep 12 2019, 01:39 AM
|- - projecttoday   Looks like you're using unbound forms. Why do...   Sep 12 2019, 06:43 AM
|- - BruceM   If you are using Access for the data tables, if As...   Sep 12 2019, 12:28 PM
|- - vanzie   @projecttoday most of my DB i design i use unbound...   Sep 13 2019, 12:34 AM
|- - projecttoday   DoCmd.RunSQL and CurrentDb.Execute do the same thi...   Sep 13 2019, 05:13 AM
|- - BruceM   To add a little to that point, I would use Execute...   Sep 13 2019, 06:39 AM
|- - vanzie   Thank you for all your advice and comments. i wil...   Sep 13 2019, 07:03 AM
- - MadPiet   Nick, It would seem that a firearm can be issued t...   Sep 11 2019, 11:14 AM



Custom Search


RSSSearch   Top   Lo-Fi    17th October 2019 - 09:08 AM