Recent content by darkone

Tried I tried to do the form as binding it to query but them I can't add records at all. I just need it to copy based on the name chosen like Rick tech level 6 to the level column of the input table. The tech level comes from the ntechlevl sql john sent. Rick

Yes in reference to another post I am sorry I didn't get back with you I was out of town for new years. It is in refernce to that query. How do I bind the form to a query instead of a table? Rick

Hello, I have a form with all the information I need and it goes into a table called input. There is an additional column there named level, now what I need is for it to lookup the level information from a query and copy and paste it into the column of level in the table of input. How would I...

Backup The reason I was wondering if I could do that is that way I will have data in the database for 6 months at a time but still wanting to keep a backup incase I need to go back and review it later (like an export to excel or a file) of the data that was there before. Basically like house...

Again thank you! I will try that when I get home! :D Since your this good do you have any info on like doing a backup of data into a file (without erasing a previous backup) automatically and erasing the info that was in the database. This way I won't have records longer than 6 months in...

Thank You!!!!! Worked like a charm, I really appreciate it! However, I have 1 more request on that code if possible: Is there a way to cap it? In other words I want it to go up 1 point every 3 months which it does now but I don't want to exceed 10. Is that possible? By the way I used the...

date addition Yes i can add a date field. Basically what I need is say an individualis hired on 12-1-04 and every 3 months his tech level would go up by 1. So in turn when hired he is tech level one and in 3 months it will automatically goto 2 etc. thank you

I need a query or vb function that I can put in that will increase a number by 1 every 3 months. example below this is a table [FIELD1] [FIELD2] John Doe | 3 so in 3 months time that 3 will become a 4. I don't have a date field in my forms or tables if that matters. Thank you