User Profile

Collapse

Profile Sidebar

Collapse
firecomm911
firecomm911
Last Activity: Feb 22 '20, 03:28 AM
Joined: Feb 12 '20
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • firecomm911
    replied to Can't Return back to starting value in rotation
    in Access
    I have 3 tables that I am using TS, CFS, and Wreckers. Those tables have a relationship between the ID field in wrecker table and the AssignedWrecker field in CFS and TS. What I would like to do is assign a wrecker to either CFS or TS and the next time I open either table it show me next wrecker available to pick up a vehicle to make sure i am fair on giving work to those wreckers.

    I hope this helps. sorry for not being to clear
    See more | Go to post

      Leave a comment:

    • firecomm911
      started a topic Can't Return back to starting value in rotation
      in Access

      Can't Return back to starting value in rotation

      I have created a rotation log for selecting wreckers, when i get to the last wrecker it will not return back to the first wrecker in the rotation, I am missing something any HELP?

      Code:
        'Setup variables for holding unique id place holder
    
    Dim tsLastRecordID As Integer
    Dim cfsLastRecordID As Integer
    Dim wrckLastRecordID As Integer
    Dim wrckFirstRecordID As Integer
    Dim tsLstWreckerID
      ...
      See more | Go to post
      • firecomm911
        started a topic Wrecker Rotation LOG
        in Access

        Wrecker Rotation LOG

        I have an apartment complex that i want to create a database for and the one thing i am stuck on is creating a wrecker rotation log. I would like to be able to create a job ticket assigning the next wrecker in the rotation not sure on how to go about it. I have created the job ticket table/form as well as a wrecker table/form.
        See more | Go to post
        No activity results to display
        Show More
        Working...