User Profile

Collapse

Profile Sidebar

Collapse
knodle01
knodle01
Last Activity: Nov 19 '08, 09:35 PM
Joined: Nov 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • knodle01
    replied to VBA Code Help
    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
    See more | Go to post

    Leave a comment:


  • knodle01
    replied to VBA Code Help
    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!
    See more | Go to post

    Leave a comment:


  • knodle01
    replied to VBA Code Help
    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...
    See more | Go to post

    Leave a comment:


  • knodle01
    replied to VBA Code Help
    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.
    See more | Go to post

    Leave a comment:


  • knodle01
    replied to VBA Code Help
    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...
    See more | Go to post

    Leave a comment:


  • knodle01
    started a topic VBA Code Help

    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...
    See more | Go to post
No activity results to display
Show More
Working...