koustuv
03-10-2010, 02:08 AM
Hello,
I am building a form where I have a fetch button and a submission button. There is a table which has 7 columns like Order num,taskcode,co#,employ id,fetching time,submission time,fusion id.out of all these columns the first three column has data.
now I have a form where I have order num,taskcode,co# field and a fetch button.There is one more field called employee id on the top of the form. So employee puts his id and hits the fetch button, it should pull data from the table from those respective fields which are above mentioned and should paste the employee id and fetching time in the above mentioned columns in the backend table. same way one should be able to submit a particular fusion id and should take the submission time which would be pasted in the last two columns.
Once the fetch button is hit, that particular row should be locked so that nobody is able to fetch the same data. Because this tool will be used by many people simultaneously. can anyone tell me if this can be done in access or you need to wirte VB for this?? Can you help me with the code??
I am building a form where I have a fetch button and a submission button. There is a table which has 7 columns like Order num,taskcode,co#,employ id,fetching time,submission time,fusion id.out of all these columns the first three column has data.
now I have a form where I have order num,taskcode,co# field and a fetch button.There is one more field called employee id on the top of the form. So employee puts his id and hits the fetch button, it should pull data from the table from those respective fields which are above mentioned and should paste the employee id and fetching time in the above mentioned columns in the backend table. same way one should be able to submit a particular fusion id and should take the submission time which would be pasted in the last two columns.
Once the fetch button is hit, that particular row should be locked so that nobody is able to fetch the same data. Because this tool will be used by many people simultaneously. can anyone tell me if this can be done in access or you need to wirte VB for this?? Can you help me with the code??