Locking down individual cells by date in access

[sycogrim08]

Hey pp

does anyone know of a rule that can lock down cells by date in access for example:

Cell A = Day 1
Cell B = Day 2
Cell C = Day 3

Now say we are currently on Day 1 I want Cell A to be available for me to input data however this is the catch I need to make sure that the other 2 cells are inaccessible until their day has arrived for them to unlock themselves.

So on Day 2 cell A will lock down therefore not allowing any data input and on Day 2 I want Cell B to unlock for me to insert my data.

Is there a variable rule, Macro etc... that I can use to implement this into the Access database table? and im talking about Microsoft access

Thanks

 

[sycogrim08]

So i take it no one knows Microsoft Access that well???

 

[FarligOpptreden]

I just think that what you want to achieve by using Access alone is nigh on impossible. Your best option would be to write a custom app to achieve the results for you.

 

[Necuno]

heh wtf !?

you could do this in excel through vba....

 

[BT6LW]

You won't be able to do this in a table.

However not too difficult to create a form, and write a little bit of vba, which enables or disabled the box to enter info to said cell.