Search results for query: *

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

hello All I hope you can help me on this i need a simple way to tell the report to go to the next page (horizontally speaking) when he gets to a certain field in fact assume i have these fields beg end time chrono set i want my report to show beg end time on a page and chrono set on the next...

i meant to say great help! thanks

i know i know i didn't pay attention to the name of the module it was the same as the name of the function, forgot to add &quot;fun&quot; thanks a million for the million times! Lina

Hello Micheal thanks for your help, however istill get the same error on the line reseauxArray = CreateResArray() in the call function it gives me: compilation error variable or procedures expected, and not a module any ideas? thanks (you ve been a great lately) Lina

hello all i am trying to return an array from a function however it is not working i am not sure why here are the functions, the functions that returns the array and he call function any comments?any ideas? thank you Lina Option Compare Database Function CreateResArray() As Variant Dim db...