Military Watchbill Creator

I am trying to create an automated watchbill creator.

Watches (for those that dont know they can be treated like shift work).
We stand 2 differant watchs a day.
8 hours watchs. 1 starts @ 1600., 1 starts @ 0800.
We are in 4 sections - so that mean each section has about 20 people.
10 that can stand the first watch, and 10 that can stand the second watch.

Currently I have 3 tables
Personel, Excuse Log, Watch

SSN (Last4)
Last Name
First Name
Duty Section
Watch (watch they stand) (sdo, dd)

Excuse (its basically for people who are on leave, school, ect)

Watchs. (this one I am not to sure how to do.)
right now I have

I have input all the users in the personel table.
Which is great for right now, setup basic query for duty section, watchs they can stand.

What I wanted to do was have it autogenerate a watchbill for each duty section. So 4 sections requiring 5 people per day. Dont know how hard that is, or feasible by myself.

I hope I explained it as best as I could.

View Replies


Subtracting Military Time

My new job requires me to use access so I'm learning as I go. :confused:
I have already used previous threads from this forum to answer another problem I encountered. Thanks for providing this forum to the public!

I am attemping to run a query that will subtract military time. (I am not allowed to change the format of the times in the original tables. )


Column A Column B
1111 6.5

I need 1111 - 6.5 in Column C

View Replies View Related

I Need To Create An Appointment Creator?


i need to create and appointment creater.

basically i want acalendar where you select your day and another calendar for the time. this should then automatically be put into next appoint ment label for the patient.

my situation is this:

i have a table "tblpatientdata" and a form "frmpatientdata" and on that form i want to put command button which takes you to a form which contains some sub forms that choose theday and time and then you click OK and it should update the next appointment section.

i dont knw how to do this and i do not want to make it too complex but could some one help me or give me a different easier idea....


View Replies View Related

Tracking Down The Creator Of A Table - Version: 2003 (11.0)

I have found a table in an *.mdb fle and can not figure out where it came from! I'm assuming that some other Access database maketable query created it but how do I find the creating query. Any suggestions?

View Replies View Related

Free Transparent Icon Creator - Version: 2002 (10.0) XP

Just as I found how to paste transparent background gifs into access my free trail version of Icon XP has expired. I thought this was an excellent program but the company I work for are not willing to pay for the full version. Does anyone know of free programs out there that I can import an images into, change the background to transparent and then output it as a .Gif

Alternatively, does anyone know how to reset the IconXP back to the beginning of the trial period? I've tried uninstalling & had a look in the registry but can't find anything.


View Replies View Related

Difference In Minutes Using Military Time? - Version: 2003 (11.0)

Hello everyone,

Please help!! I am trying to find (control source) minutes using military time?

Database: Dispatching Police Officers to calls ~ assisting other agencies

Dispatch Time - Clear Time - Total Minutes
13:12 13:20 8 (control source??)

Thank you


View Replies View Related

How Do I Get Military Forms In Access Reports? - Version: 2003 (11.0)

I know what you might say right off the bat, which is "turn it into an image blah blah blah" Well that isnt the case, I need something that looks sharp and can resize so I can customize it, I have seen these forms put into access like a regular report would be put into access, and all the text and fields were divided up. I mean EVERYTHING, is there any way to do this thats not going to take ages? or am I just chasing a ghost


View Replies View Related

Computer Lab SignIn For Civilian And Military Clients - Version: 2002 (10.0) XP

UA Members,
I'm hoping someone can help me. When I select an assigned computer for a client, I need that computer to move out of the computer "Stations" list and into the "Unavailible" list. When the client is signed out, I need that number to move back to the "Stations" list, as to be availible again.
I'm also having problems with some Macros, but we'll get to that later.
Thank you so much for your time.

Tables: CompId, CompUsage, CivSignIn, MilSignIn
Columns in CompId: Stations(PrimaryKey), Availible (Yes/No), Unavailible(Yes/No)
(DropDown In CivSignIn Form)
Query (BookedStations) Does show "No" under Availible where LName and FName are selected for those Stations.

Hope you're not confused. Is there some syntex you can help me with??
Thanks again.
DBase: to big to attach (496 KB)

View Replies View Related

Function Or Code To Insert User Name Of Record Creator/updater I - Version: 2003 (11.0)

Is there a built-in function that I can use in either a table or a form to automatically (via an expression in the Default Value, perhaps, or using code) insert the user name on each record created? I am already using security so that each user has to log in, it works fine. When a new record is created, I would like a field to record which user created that record. If the record is updated, change that value to the user name of the person who updated it. I'm SURE there is a way to do this. I tried using the CurrentUser method, but that just gave me the user looking at the DB, not who created or updated the record. I'm sure this is very simple, but I can't seem to find it.


View Replies View Related

Making A Rotating Watchbill - Version: Any Version

I am in the military and i am responsible for making a watch bill for all the personell in my section on the days i have Duty. I want to auto mate this with a Database in Access. The hard part is people take vacations and some get sick so not everyone is always there. Is there a way to use a form to enetr missing peronell and still have it generate a report with the watch bill missing the people you specify. Any help would be appreciated.

View Replies View Related

Copyrights 2005-15, All rights reserved