Hi, I am working with Ms access 97 on a form with two (2) text Boxes, lets name them TextBox1 and TextBox2, i will put values in it (numbers) like "1"or any other number.Example: TextBox1 = 2 TexBox2 = 2
I want the value in TextBox1 to be added every day to the value in TextBox4.
That means that after 5 days TextBox2 will show a total of "12".
I think the program has to be tide in to the computer system Date and Time.
And I don't know how to do it.
If anyone can help me, please reply to this forum or my personal email.
There should be only 2 textBoxes, textbox1 and textbox2.
they could be unbound to runnned with vba code ,if they are bound the code should go to the control source textbox on the properties sheet,thats what i think.
Thanks for the idea,i will try to use that.Also if a "Loop" will work?, count the value in textbox1(must add up every day) and display the total it in textbox2.
I'm doing this just as a hobby.
I created a database to record all the house expenses,then i copy(burn)the database to a cd when i open the database on the cd i get a prompt"warning this database is "Read Only" you wont be able to make any changes" or something like that,and it does not allow me to make any changes.
when i change the attribute from read only to archive it switches back to "Read Only" and I am logged in as the administrator.
I thank you all for your help.
I'll keep looking for a solution.