repeat quantity as per table records quantity!!!

[afekri]

Ok, If I want to write all my calculation here, would be high comfused.

Just renew my question please, and forget every thing.


Let me ask you only:

How to repeat the line : msgbox "hello"

in depend of table AAA record's quantity.

It means if the table AAA have 12 records, by the specific procedure I need to run 12 time msgbox "hello"

If I know it how to do, I will complete my job..



Thanks
Ali

 

[dhookom]

Dim intCount as Integer
Dim intNum as Integer
intCount = DCount("*","AAA")
For intNum = 1 To intCount
   MsgBox "Hello Ali"
Next

Duane
Hook'D on Access
MS Access MVP

 

[afekri]

Yes, Exactly what I needed.
Thanks a lot

Now, If I want to have an event to do it on the form which have record source to the same table like this:

1) open the form on the first record
2) docmd.openquery "sample"
3) go to the next record "up to the end of tables record"
4) if no more records remain close the form else go to 2 again


It means, I want to run the query on each record. because my query need some information from each records on the form.
and this to be repeated up to the end of records.


Your help would be highly appreciated.
Thanks
Ali

t

 

[dhookom]

I think this thread is becoming the same as your other thread thread701-1541536 on the same issue. I won't reply here again since you have the top brains helping you there.

Duane
Hook'D on Access
MS Access MVP

 

[afekri]

Sorry, But still I'm confused that why here no one to help me to do it. and every one want to change my mind to change my method.....

I have some situation which I can't change it and I don't think this my request would be very difficult to make!!!

Anyway, If here no one want to help me, I can not say anything else..

Thanks for your help
Ali

 

[dhookom]

It looks like you are getting the required help in the thread.

Duane
Hook'D on Access
MS Access MVP