Search results

Hello all, I am trying to use a magnetic card swipe reader to log staff coming in and out of the building but I am stumped on one thing,( which i know I have seen on these forums but can't find) how do I selct only certain data from the magnectic strip, eg dfsdfsXXXXdtgedwwsmmimshur 123456...

cheers john, thats given me some ideas, the problem I was making was basic..Instead of using multiple tables I was trying to put the info into one(schoolboy error) again cheers Steve..

i have a staff rota to see whos working and whos day off / on holiday etc, all I need to do is show who's working/day off for a certain day or week. which i can do via a query its just how to put the data into a table without having 25000 plus records that leaving me stumped.

morning all, I have 59 employees working a seven day week rota over a four week period, so at the end of the fourth week there rota reverts back to the first week for another four weeks. my question is how to i put this into a table with out having 25000+ records eg employeeName rotadate...

cheers jon k, you have given me some ideas, if I build the form around the book hols query I can use your adapt your query to show what i need..again many thanks

Hi All, I need a query to tell me how many staff are on holiday on the same day..here what i have so far. A query with name, startholsdate,endholsdate, totaldays, etc, etc,, records showing; employee A books 01/01/06 to 14/01/06 and employee B books 10/01/06 to 24/01/06 C books 01/02/06 to...

cheers crash77ash, having read your reply, i found the problem, I made thr basic mistake of name my employees filed Name..changed it to EmpName and all works well. cheers

Hi All I have a form for booking employee holidays and in that I have a subform that displays their current holiday entitlment, which work great until I enter in a new record on the main form to book some holidays and I'm ask for a Name from a parameter box?? which I press cancel or ok at which...

So its not only me who couldn't work this out, cheers for looking..

I have read more post than i care to think about but I can't stil get my head round the following problem. I have created a database (with this forums help) but I am stuck on the following query/form/vba etc.... Our staff holidays run from 01/05/05 until 30/04/06 and i have a query that...

Hi gizzu thanks for the quick reply but unfortunatly the application is going to be used with a touch screen (no mouse or keyboard) so i need to use some form of a button instead of a listbox. its for sandwich labels, they just want to press a button to produce the label but be able to change...

Hi Guys and Girls, Does anyone know if it is possible to have a button assigned a value from a table/query record, (I need to use a touchscreen so can't use a combobox.) eg button one = record 1, button2 = record 2 etc when pressed the value of the record is passed to another field. thanks...

the offspring should follow the amount born field, you code is what i am looking for i tried x amount of samples and couldn,t get it to work,i will try yours and see what happens..should be fine i have been looking at the trees but can't see them cos of the forest....thanks for the help..

helps if i attach the image...

Hi Lagbolt, your Db is what i have done at the moment but what i would like to do as per attached image, the 'amount of babies' field on the breeding details form controls how many fileds are displayed on the babies details form, were i have entered five babies born, i wish to only see 5 fields...

sorry lagbolt, thats what i already do, I should of made my request more descriptive, I have a breding table that has mother father date due etc and an amount field for when they are are born (any thing from 1 - 9) its this part i am having problems with, I have another form that has the mother...

Hi Guys and Girls, While doing a rabbit DB for the missus I have hit a problem, if one of the does gives birth to 3 babies i wish to have the details entered onto a form (not a problem) but i would like to do this: if number of babies = 3 then fields to display to enter details is 3 on the...

Thanks for that I just couldn't see where i was going wrong..

Okay ket me start from the beginning, once upon a time... :) , I need to keep a track of all my staffs work progress throughout the day, they currently pack items into envelopes and count up how many they have done at the end of the day..I have started a database that will scan each package with...