Search results

how can i create an exe file for my application? i am not sure this is a possible thing, but maybe if there is no way to create executable, maybe there is a possibility to export the whole application to visual basic (with form,reports etc) and from there create exe ?? someone know how to deal...

how can i close a sub form from the code ? and open too! maybe this is not the good way... i will explain what i want to do: i have a list (subform) with data from table A. i have unbound fields, on the main form, and on dbl clck on current item from the sub form, u can see in unbound fields...

I’m trying to filter a bound form according to some fields but without success… I am doing exactly what I always did ( I already did something exactly in the same way and this works!!!) but this time, in 2 forms this doesn’t work… I don’t understand why! Can you look: in form 2 à Private...

hi! i have a form, with some buttons grouped in opion group: a,b,c,d,e,f,....,z and in the form i have edits with people data. i want the following: when i press a button, i will refresh the form with the data people who their name begin by the pressed letter. + refresh instantly. i try...

problem it seems to be the good way: i delete the subform, and now all is on the same form with he option group but there is still a major problem, after go out of the case sentence, on the "Me.Filter = strFilter" i get: run time error 7752 cant apply the filter because all the records are...

hi! i have a form, with some buttons : a,b,c,d,e,f,....,z and i have a sub form with people data. i want the following: when i press a button, i will refresh the subform with the people who their name begin by the pressed letter. + refresh instantly. i try : Private Sub Command22_Click()...

hi! i have a db that sits on network. this is a multi-user db, where i want to lock access to anyone when someone open it. so i try, according to ms-access help, the "open exclusive" . i set the option "open exclusive" instead of "shared" in menu-> options-> tools->"advanced" tab. but this...

i want to unlock a label in a form according to the following condition: i have a subform in the specific form with data linked to the form by the index key of the table. in each line of the details form, i have a field "payment date" in the first form i want to unlock field "real_total" IF...

i want to unlock a label in a form according to the following condition: i have a subform in the specific form with data linked to the form by the index key of the table. in each line of the details form, i have a field "payment date" in the first form i want to unlock field "real_total" IF...

Dim SQLstr As String SQLstr = "INSERT INTO orders ( id_order,money_def,note_def,orderfull)" SQLstr = SQLstr & "VALUES ('" & Me.id_order & "','" SQLstr = SQLstr & Me.money_def & "','" SQLstr = SQLstr & Me.note & "','" SQLstr = SQLstr & Me.orderfullID & "');" CurrentDb.Execute...

hi! i have a form where i choose according to which fields filter a second form i did: Case 3 stLinkCriteria = "orders.supplier = '" & txtSupplier & "'" the problem is that i want to filter my form per supplier like i did but i want to filter the records where the field " payment_date" is...

hi! i have a form where i choose according to which fields filter a second form i did: Case 3 stLinkCriteria = "orders.supplier = '" & txtSupplier & "'" the problem is that i want to filter my form per supplier like i did but i want to filter the records where the field " payment_date" is...

it's work but the problem is: i want to combinate year+index as 4 digits and when i do it i lost the the 4 digits: ydate = DatePart("yyyy", date) orderfullID = ydate & "-" & id_order -----> 2002-1 and not 2002-0001 how can i do that ? i tried: orderfullID = ydatee & "-" &...

i have just one little problem left : how can i set the autonumber part as 0001 0002 ... instead of 1 2... ? :confused:

here my question : i build a little application database-oriented. now i have a problem: if the application will be on the network- on all people computers, so how it will be with the database? how can i set the application as locked or something else to avoid 2 people to use it at the same...

hi! i have a unique key in a table that is an index like this : yyyy-9999 this has to year + "-" + number id as 4 digits how can i force the field to be like this?? and how it will be in the forms? how can i add it as automatic number 2003-0001 2003-0002 ... can someone...