Auto update..how?

[Wolfman24]

Hi...Im working with this database..its an order tracking database.. everytime we received the shipments we have to update the rcvd items.. i have an attachment here... pls i really need help...

How could i do these automated:

1: if i update the Rcvd status (Y/N) "Y" ...how could i make the Date Rcvd automated.. coz what happens is that.. i have to put date in each items that we rcvd and its a waste of time.. what if.. i have lots of rcvd items..

2. how could i put row count.. so i could know how many items i have and on what row are they...

pls help..

thanks in advance....

Eric

 

[Wolfman24]

Pls... help... anyone??

 

[clerics]

1st one : make an event in your Sub Form where you edit data ( after update) then write the code :

Me.Rcvd_date = Date()

*is that what you ask for?

2nd one : may be this code can do it

Dim countnum As Integer
Dim db As Recordset
Set db = CurrentDb.OpenRecordset("type your SQL here")
countnum = db.RecordCount

 

[Wolfman24]

hi clerics.. ill try this one.. .

thank u so much.. i ll keep u posted if this on will work for me...


thanks alot!!

 

[Wolfman24]

Hi again Clerics.. 1st one worked! thank u!! ur a life saver....

2nd one.. what do u mean by ("type your SQL here")


thanks again

 

[clerics]

This is My Answer

Look at this file I attached .may be you can solve your problem .... That is easy sample to know how RecordsetCount work !
Goodluck !