Search results

Thanks thats what a thought.

I am a firefighter who has been tasked with creating a database to track repairs and inventory on breathing apparatus(SCBA). There are several(5) related pieces of equipment that I think should go on the same table. Three of these will have nearly identical fields. The other two will have...

I have 3 forms that are derived from a single query using a parameter box. I would like to build a single 3 tabbed form to view the information from. I can build the form with 3 different queries. Is it possible to build this type of form from a single query.

Fix It Okay, I fixed it. I just had to move the rank and battalion fields out of the sort table and tie everything to the personnel table. I thought that having the employee number fields tied together that Access would make the connection from the personnel table to the rank and battalion...

Pat, Thanks, that allows me to add a new records, great. I still cannot get the linked tables to update completely. "tblPersonnel" doesn't update the rank. "tblSort" doesn't update shiftnum. I built this query and the form with the wizard. I don't understand why everthing is not linked...

Firtst I need to thank Wayne, Pat and everyone on this board for taking the time to assist me with my sorting issue. I now have that solved. My problem now is adding records to "frmPersonnelInput". Initially I did all my input directly into the table. Now have built a form to make adding new...

Okay I made some more progress. On the form "frmCaptain" I moved the text boxes for "sequence" and "hours" and the command button for "update" into the header part of the form, DUH. Then I made an unbound combo box of "qryRank" Then I tried to tie to combo box to the form record source by...

Partial Solution Wayne, I played with the program you and it wasn't quite what I needed. I do appreciate your effort. I may have found a solution. I have attach the file. It has been hacked up a bit for security reasons but it should have enough information to work with. If you have time...

Wayne, I have a solution that seems to work on paper but I am unsure how to put it in Access. Have a two part numbering system. The first number will be a "DateDiff" number starting at the previous day. So today would be 001. The second part of the number would be the order in which that...

Wayne, Well here is an abbreviated version of the database. It only has a partial Captains list, but it should be enough to play with. I can't tell you how much I appreciate you taking the time and effort to try and help. Thank you very much. I go home tomorrow at 8am but I will check this...

Wayne, We have 3 separate lists, one for each rank of Captain, Operator, and Firefighter. People are listed in order of when they last accumulated 24 or more hours of overtime. The most recent person to accumulate 24 hours of overtime will be the last person on the list. When an overtime...

Wayne I tried to do what you said in your earlier post. But the list is not sorted by number of hours. A person who has accumulated 5 hours of overtime can be above or below someone who has accumulated 10 hours. The break point is 24 hours. Once someone accumulates 24 hours or more, they...

Thanks Wayne, I work on Thursday, I will try it then and let you know how it works. Mike

Okay. Can I create a "Sort" field that contains a sequetial number to sort the records, then when the "Hours Worked" field reaches 24, an arbitrary number will be added to that "Sort" field so that the specific record will be sorted to the bottom of the form. And then build another macro that...

The list has no real order as it changes continuously. I have said that I want to move a record to the bottom after that person accumulates 24 hours. Would it help if I reversed the order of the list and rotate records to the top. The more I try to make this work, the more I think that Access...

The sort will almost never be in order unfortunately. A person can have any number of hours of overtime, but will not rotate to the bottom of the list until they accumulate a total of 24 hours.

The form is essentially a list of names. The number of records only changes as personnel change. We use the list to rotate overtime though the personnel list. Once a person accumulates 24 hours of overtime their name is rotated to the bottom of the list. Right now we use a card file. I...

I have a continuous form consisting of records that have the following fields. Names, phone numbers, and a caculated field of hours worked. I want to add a button, that when clicked will take the specific record and send it to the bottom of the form. This record is not always at the top of...