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