run button countinous form with one click

[adilos]

hello everybody,



i need your help pleas.

i hav countinous form with button for every record, wich has a VBA code. my question is. i want to put Button in header form, when i click it, then should run all button in countinous form. how can i do that.

thanx in advance

[ItsMe]

...all button in countinous form...

Controls in Continuous forms are only good for the Current or Active record/row. I do not recommend using controls in the detail of Continuous forms.

[SMC]

You could always have the VBA run AfterUpdate of the last item that gets filled in for each record.
Basically just get rid of the command button and do it automatically. Since you want a button that updates it all at once, I suppose it won't matter that it occurs automatically.

[adilos]

yes u r right, bnut in my situation i miss use countinous form

[adilos]

hallo Ninja,

u meant that i muss put the vba-code in the Button "After Update" and not in "ON click", and when i will load the counitinous form, all buuton, will run automatically???

[June7]

First of all, please understand there is only ONE button, as can be seen in design view. If the button is in detail section, it is replicated for each record in continuous view but it is still the SAME button. What exactly does this button do? If you just want to set the value of a field in every record to True or False, then have the code run an UPDATE sql and refresh the form

CurrentDb.Execute "UPDATE tablename SET fieldname=True"
Me.Refresh

[adilos]

hello thax for reply,

my vba code copy the record. So in countinous form i mus click all button and i dont want that. there is no way, how it can run all button automatically, when the form it loaded. it means for exampl the button muss be automatically clicked

[June7]

Again, there is only ONE button - there is no 'all button'. You now want a button that will copy all the records? Copy them where - into the same table? Why would you want to copy all the records? Is this form opened to a filtered set of records?

[adilos]

yes exactly this form opened to a filtered set of records. how can i do that pleas automaticlly. and i want to that in this form not in table?? do hav any idea???

[SMC]

u meant that i muss put the vba-code in the Button "After Update" and not in "ON click", and when i will load the counitinous form, all buuton, will run automatically???

No, I was suggesting that you just remove the button and either make a global button in the form header/footer, or just have the last entry to each record, whether it be a text box, check box, tic box, combo box, a note to Santa Claus or w/e it is run the VBA after update. Once that field is updated have the VBA commence.

Do this by clicking on the last field to be updated per record in design mode and going to the properties and adding in an event that in the AfterUpdate section.

[June7]

What do you mean 'not in table'? How can you copy records without saving to table?

Language barrier very wide.

Maybe with button in form header, VBA code:

CurrentDb.Execute "INSERT INTO tablename " & Me.RecordSource

This assumes:

1. no unique ID fields, no autonumber field

2. form RecordSource is an SQL statement.

If these assumptions not true, this can get much more complicated.

[adilos]

pleas just think about that. i want when my counitnous form loaded should the button run. or one button in header form when i click it, should be run buttons in countinous form. . thnax in advance

[SMC]

is it possible to upload the database? save a copy of it, delete all the data out of it and upload it to the thread. It's difficult to understand what exactly you are trying to do. I feel that myself and June7 have answered your question with several possible routes.

[adilos]

i dont hav problem with my vba-code. my vba- code run very good when i click the button. Pleas just thinck about that. when my form it opened then i muss click all button to copy all records(my VBA-Code it is to complex to describe it here). now My Problem it is (Pleas thinck just about THAT), i want when my counitnous form loaded should the button run. or one button in header form when i click it, should be run all buttons in countinous form. Just that. it is 100% easy for u

[June7]

There are no 'buttons' (plural) in the continuous form detail section. There is only one button and it has the same code for all records. CANNOT make another button in header run the 'buttons' in the detail section because there is only one button in the detail section.

So please, stop asking for code that will 'run buttons in continuous form'.

Just tell us what is the final result you want.