Recent content by lanelouna

in fact it worked when i used the rename form thanks to your code Dim defaultFrmName As String Set frm = CreateForm(, "search") defaultFrmName = frm.Name DoCmd.Close acForm, frm.Name, acSaveYes DoCmd.Rename formName, acForm, defaultFrmName DoCmd.OpenForm formName, acNormal, "", "", ...

Hello, I guess you know how to do this thing, I beleive it is quite simple, but I don't know how to do it. in fact my problem is how to give a name to a form which is created dynamically when the users update years value. this form is supposed to ask the users to enter some values: years and...

I do not know how to create a bound or not control. the =[Formulaires]![Formulairesc01]![investInfraSysTr04]*2) is the "DEFAULT VALUE" I am sorry it is my fault I was all the time trying to use the default value!! it worked when i used the control source thanks for your questions! and your...

How can I REcalculate the display value (the default value) of a textbox based on an input in another textbox. lets say I have text box called: investInfraSysTr04 when I modify its value, I want the value of second textbox: investInfraSysTrAvecMarge07 to change (the default value is always...

it worked! thanks, you helped correct for the missing link missinglinq! thanks a lot

Hello, I have a simple question to many of you, if you can help that would be great. in fact, I have a form where the user is aked to enter a number which corresponds to the number of scenario he wants to analyse. then the user presses the ok button, this will open for him a dialogue box in a...

Thanks alot Hymn it worked I am happy! have a good day Lina

Hello, for many of you my quest may be very simple i would appreciate it if you could help me i have this field in a table that i want to populate with a very very long string, a concatenation of values and strings something more than 255 characters but what i actually do in the code is the...

lol :) when there is a will there is a way u ll get there someday

well it is working sorry to have bothered you with this :) should have used [] Set chp3 = dft.CreateField([fieldname1], dbInteger, 3) anyways thanks Lina

or can i do something similar? it is not working i know but somethign similar dim fieldname1 as string dim fieldname2 as string Do While (i < nbrChamps) j = i + 1 fieldname1 = "n " & i fieldname2 = "rt " & j Set chp3 = dft.CreateField(fieldname1, dbInteger, 3)...

hello I hope someone can help me on this i am trying to create fields in a tabledef but the name of the fields is created dynamically is it possible here is an example of what i am trying todo nd obviously it does not work thanks in advance for your suggestions and help Lina Do While (i <...

well i tried like u said manually to see if it works well unfortunately no thanks anyways for being patient and precise Lina

in fact this is a part of my form knowing that i have around 30 fields i want the field chrono and every other field that comes after it to be placed on another page (section), and i don't know how to do it can u help? Function FDynaReport(i) Dim db As Database Set db = CurrentDb Dim rst As...

thanks for your quick answer however, i am sorry i don't know how to use this property (group), and what is its use if u have an example that would help i hope you can help me thanks Lina