Thank you for all your patience PianoMan. I would be happy to send you my access file that I have so far so that it will be easier for me to show you what I want to happen. I dont seem to be able to upload it onto the site. It isnt very large. I can send it to you if you wanted to private message me an email address to send it to. Thanks again.
David
User Profile
Collapse
-
Good Afternoon,
I dont beleive that is will allow mulitple users to view records but my form currently only pulls the record because I just need the user to see the 10 digit id from the record label. Is it possible for Access to automatically enable a checkbox through the use of VBA code? I have never done this before.
Thanks!Leave a comment:
-
I will try and explain in as much detail as I can. Thanks for the assistance.
I have a db that has a table with 3 fields. The Unique code feild which will have the codes I want the users to be able to view when they pull the first record available. The InUse field which I want to enable automatically as soon as one of the records is pulled. And a Used field so that when someone uses one of the records it wont be pulled by the next...Leave a comment:
-
Thanks PianoMan64 for your info. I posted this into the before update event procedure and it is still not enabling the InUse checkbox when the record is pulled from the report. I am inserting this into the incorrect field? I def. want the code to enable the invisible checkbox so the form will pull the next record that isnt being used.
Thanks in advance.Leave a comment:
-
Thank you for your response. I did figure out how to hide the checkbox thanks to your suggestion. The issue I am now having is:
When the users selects the form I have it populate with the next available record in that table that is currently not in use. The field for the checkbox i want to automactically enable is called InUse. No what I am trying to do is everytime the specific record is pulled I want the InUse checkbox to enable that...Leave a comment:
-
VBA Code Help
Good Morning Group,
I am new to VBA coding and had a question. I am building a database that contains several records that all contain specific individual codes. I have created it to return the new available code in the table but here is my problem. I have 2 check boxes. The first check box is an in use checkbox and the second is a used. I want to hide the in use checkbox and I want this checkbox to be checked or enabled by the system...
No activity results to display
Show More
Leave a comment: