Search results for query: *

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"...

Hi everybody, I would like to refresh , update the data of a table without closing the form linked to this table. Indeed I would like when I open another form from the first form, that It shows the new data I filled in the first form. Is it clear or I must explain better ? Thank U

Hi everybody, I would like in a Access database to make one account able to modify and delete the others users's account password. Is it possible ? So that , only one account or a group manages the security of the databe. Thank U

Thank U very much RoyVidar , I think it's an issue for my problem. I will try it ! Thanks.

Aahhhh Thank U very much PHV, It's exactly what I need. I would like to know for the access form wether the function returns the date of the last modification of the structure of the form or of the datas displayed in the form because I need the date of the modification of datas. Thank U again.

Hi everybody, I would like to get the date of the last modification in wrod and excell file. Besides, I wouldlike the same things for an access form, I mean, when the user modify datas dispplayed in an Access form, I would like to get the date. Thank U .