Multiple records update

[thakur]

I am using access database in my VB project I can update shift shedule for an employee on daily basis I would like to know wheather it is possible to update six records (for whole week) so that i can save my time for next 5 days I tried the from date and to date values but i can not get data in between these two entries.
thank you.

 

[IonelBurtan]

Please be more specific, and put some code in your request, and tables structure.

Thanks,

Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://home.domaindlx.com/ionelb

 

[thakur]

Sorry for not being specific.
I have Employees table and i have to asign all the employees of that table to a specific shift e.g.morning,afternoon or night and these shift only change after a six day week. Insteed of asigning the shift daily which i do now i want to say the program that a perticular employee is in morning shift from monday to saturday. if you can get it now pl help.

 

[IonelBurtan]

I am not very clear with your request. What I get from your request is that you need an update query.But it is still too general for me(maybe I need some more coffee).It would help if you can tell:

1. Where is the database stored(what kind of server). you access it through ADO?
2. Structure of the tables implied (field names and types)
3. Any other restriction to your query

Thanks,
Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://home.domaindlx.com/ionelb

 

[thakur]

Thank you for the reply
I am beginer with VB and database my project will run on a stand alone machine and no server is needed
Employee will have a unique ID i want to use that in the other table as one-to-many type relation and save the shift say employee number 309 on 06/08/2001 worked in morning shift i can do that in access and in VB also but what i need is insteed of a single day i want to save above information for the whole week so that tomorrow i will not have enter the same thing again. so i want to save seven records like emp.no.309 will be working in morning shift from 10/jun/2001 to 16/jun2001.
sorry for the trouble
and have a nice coffee.
thank you very much once again
by the time one more question how to populate records in a dropdown list in dbgrid column i could only insert button with dbgrid1.columns(1),button=true.