Recent content by MrBaRRon

Thank everybody very much for your help

I think it will help me. Thank U very much ag ain for your help ; )

ok I will check. Thank U again for your help

I need more details because when I call the variable from the report code by example (with msgbox) , the value is blank and not the one I set.

Ahhh Thank U very much. It's clearer now. Thanks ; )

Hi everybody, I have to declare a Globale variable in VBA so that I can reuse it in another function (sub). What is the syntax please ? Can I declare it everywhere in my project ? Thank U

Ok. thank U very much but which sub must I call and from which sub, and what is the code I must to link with the button for printing ? Thank U for your interest !

Yes but their are various reports to print simultaneously and each one doesn't have the same number of page. If I do like that, for each report printed the page number restart at zero. But all those reports make one general report.

Aaaah !! Thank U very much and thanks for your interest. By the way is it possible to insert an auto page number on each page printed ?

Hi everybody, I need to print various Access reports (about 6 reports) in VBA. Does anyone know the function or the syntax to do it ? Thank U

Ok you are right, their is no need to create a field in the table to make the sum... I have tried as you say and it's ok. Thank U very much for your interest.

Hi everybody, I would like one field in an Access table be the sum of two others fields in this table. Thank U.

but it don't works" means it returns me that the object is not in the collection.It don't find any object with this name.... Thank U for your interest.

I have tried but it don't works. It is very surprising if their is not a good syntax no ? Thank U for you help.

Thank U Gerry for your interest. In fact , i Would like to do something like that: ActiveDocument.FormFields("text3").Result = "TEST" With ("text3") as variable, by example: Dim namefield as string namefield = Recordset("field_table") ActiveDocument.FormFields("namefield").Result = "TEST"...