Search results

still need help sorry guys, I thought I had it solved any further help with getting a template andrewm

thanks and waiting many thanks McAbney and Gabriel awaiting template from Gabriel. I can use excel, but I still think Access can help and if I can get around it, it will be superior than excel Andrewm

entering data thanks for the help for the table.. I appologise if i do not explain myself clearly. I want to use bound combo boxes to retieve info ( emp, dept etc ) and save it into the roster table. ( to make it user friendly ) I see the links between the tables. I still do not know the...

still no use Hi, Ive tried to normalise etc. still no avail. Has anyone got a template table and form (with combo boxes) for a weekly roster to get me started. Is there an example template on the net? andrewm

template thanks, yes I need a date ( week starting date ) and would like to keep historical data so to do queries on it ( eg. what I particular person had done in the past year etc ) ta andrewm

thanks, yes it is like a spreadsheet. I tried excel, but wasn't that user friendly for the secretary. I thought using access and with combo boxes it could be user friendly. essentially - monday to friday, and allocating a person to each allocated area. Then eventually doing queries etc to...

attachment sorry - will attach file now. the main table is obviously where I will save the data. the other is where a combo box retrieves the data. andrewm

database example Thanks, attached is the database file (form not finished) - help will be appreciated. email to andrewm@senet.com.au andrewm

Im new at it thanks, I tried more than 1 table and combined using a query - the query is huge and doesn't allow it. also how do I do a form based on a relationship ( I am trying to do a weekly roster with 350 "field" excel is "ok" but access should cope with it ) andrewm

unfortunately I am making a form using more than 255 fields which is the max for access 97. I tried using more than 1 table but still no help. what can I do? will upgrading help? thanks andrewm

thankyou many thanks andrewm

I have two tables which several update queries are used related to several fields. Can I make it simple by puting all the queries into one Andrewm

sorry I am new to update queries I would like to change a 2 different fields depending on two different criteria in another field. in this table - in a field called name if it is " andrew " I want a field called monday to be updated to " yes " if it is " John " I want a different field called...