Search results

Hi, i need your help: i'm creating a weekly planner. I have a form for insert events and their date and set an argument (a, s, a+s) and a mask who shows a little form for every day of the week. i need to create a button (or some other control field) that permit me to filter by argument: eg i...

I solved writing the formula in the preset value of my textbox field. and than with me.box1 = box1 +1 Can I use Val(NZ(...)) in a query? i have some problems id i think it is a format problem. thank you anyway

sorry but if i try your file the box1 stay void. if i frite some number in the 2 box on the top for example 4 and 5 the box1 is 45 and not 9 (and nothing happens if i click on the button). There is some way to solve that problem? thank you

the button name is "add1" the textbox is named box1 (and i would increase of 1 unit the value for each click on the button i attach a little example than you again

the name of my text box is: box1 i also tried with me.box1 = me.box1 + 1 but it doesn't works. If (in another texbox) i write: me.box2 = me.box1 + 1 it works correctly so I think the problem is the overwriting. box1 is not depending to any table or query thank you for your help. (i'm...

Hi! i need your precious help. i'm using access2003. i have a textbox with a calculated value in a form. i'd like to create one botton who incrase of 1 unit that value (in the same box if it is possible) and one that decrase of one unit. for example the value in my box is "5", i press the...

Hi!, why access and not Outlook? Because my file will have more function (it is not only a week planning), and because it have to be more customizable. bye!

Hi! i need to create an access file that show a "week planning" based on a table of this type: ID_event Data_event Text_event e.g. 09/01/2012 meeting 09/01/2012 dinner with Kate 11/01/2012 gym 25/01/2012 meeting .... i want to see in a form something like this: mon tue...

it works!!!!!!!!! great great great! thank you fot your help and patience! sorry for make you lose time before to post the last file. i wish you have a wonderful christmas!

I have uploaded a new db with some explanations, i hoper i could be useful. have a nice day

hi, i need that clicking on de button, in the main form, a new record will be added in the small one and if possible in the date field of this (always the second) it will saved the date of the event. bye

hi! i'm not sure to have understood. or that my explanation was ok. so i post my file. thanx anyway

i had a form with a button and a subform. i need that pressing on the button a new record in the subform will be added. if possible in the data field of subform i'd like to save the data of that event and in another field copy the value of a field of the main form. if i press again the button it...

Hi! in this case my problem isn't the not edidability of query but it was that if i search on the form something that doesn't exist in the query it block the form( based on a query of a crosstab/field query. i know it isnt editable and is a good thing) i solved using an iff count that if not...

partially solved... in the file I uploaded the allow add property of my form was "no", on your is "yes". i changed it and now it seems work, i have to try also on my more complicaded form. i hope the problem is the same... good night update: one query wich I use behind a form is not editable. I...

hi, my boss loves my database with your code! (i'm near to the end but i have a "little" problem). i hope you can help me again! Alberto

Hi again... i'm still blocked on the same problem. I put the code in my new database and it works but if i write a word on the that not exist in the table it go on error and i have to close and re open my file. (in your original file it doesn't stop to work but simply do not shows record in...

Hi Chris, as you see when the firts subform is open it show "2011" in the last green box but if i want to "call" applyfilter i have to "change" somethin in green box. I'd like that when I open the master form it is filtered by the value of that box. (in the real file I call apply filter by a...

hi! is it possible to modify this code using a combobox for one of filter? (the change event call this sub) Private Sub ApplyFilter() Dim strR As String Dim sFiltro As String sFiltro = "mansione LIKE '" & filtr(Me.filtro_mans2) & "*' " & _ "AND qualifica_man...

no way? can i give any other informations? bye lg