Search results for query: *

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

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

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

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

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

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

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

hello all perhaps you passed through the same problem so i am gonna post it here with a database access95, or the same base opened with access 2000, i can connect to oracle, and attach tables from (machine data source?) however creating a base in 2000, and then trying to attach tables, that...

hello all i tried this code and it give me error on the line (with bold font) Set rprt = CreateReport with rprt .RecordSource = &quot;ListY&quot; .Caption = &quot;List_Y&quot; .Section(acDetail).Height = 500 .Section(acHeader).Visible = True end with can anyone tell me why...

hello again i really need your help in this i know this might sound very silly question, but i don't know much about reports, and vba codingof reports my question is this: first: when we create a report using vba, not all sections appears, in fact it is missing report header (page header is...

hello everybody if anyone can give m a push in this task that would be great. i have been looking for a vba code, an exemple code, of creating reports based on results of queries, since i don't know how, andi can't find any. i know that the reports i will be creating would be based on a query...

hello i have a simple question i hope someone can answer in access 2000 the expression: dim db as Database doesn t work? why it keep giving me error what is weird is that it works with a base i upgraded from access95 (version 7), in access 2000, howeveri f i create new base in 2000, or i...

hello everyone i need your help on this if you can it was working, and somehow, for a reason i don't know it stopped working i have a recordset, and i am trying to sum the values in the fields, (the fields name is [closed 1], [closed 2]... startP is an integer as well as endP knowing that...

hello can ayone help me on this small problem i have this code which is not working: it tells me that there are too few parameters, (the line where the error is, is in bold) Set RS = db.OpenRecordset(&quot;CCA3TSurpIVDR&quot;, dbOpenDynaset) Do Until RS.EOF RS.Edit lIVDR = RS!IVDR strSQL =...

hello everybody I h ave a question please, which i managed to resolve but i am looking for a better coding i want to simply say this If p = RS!SCOD Then nameOfCr = p & &quot;_CR_&quot; & code defautCrC = Forms![myForm]!nameOfCr however i had to do...

hello all plz help is needed ASAP my form doesn t seem to work unless i have microsoft visual basic on, and any module open, that is the command buttons, or option groups don't do anything unless a module is open how come? plz help thanks in advance Lina

hello everybody I have a table with fields such as ifClosed_A ifClosed_B ifClosed_C... as well as fields called CRV and CRC my aim is to obtain from this table, only the fields where: ifClosed_A or IfClosed_B or ifClosed_C = 1 and CRV or CRC < 94 for example Ident ifClosed_A ifClosed_B...

hello everybody I have a table with fields such as ifClosed_A ifClosed_B ifClosed_C... as well as fields called CRV and CRC my aim is to obtain from this table, only the fields where: ifClosed_A or IfClosed_B or ifClosed_C = 1 and CRV or CRC < 94 for example Ident ifClosed_A ifClosed_B...

hello everybody I have a question please has anyone created an array with a name that is created dynamically is it possible to do something similar to: for p = 1 to counter myArray & p() next p thank you Lanelouna

hello everybody I have a question please has anyone created an array with a name that is created dynamically is it possible to do something similar to: for p = 1 to counter myArray & p() next p thank you Lanelouna