Recent content by alexkong2003

Hi guys, Thanks for the code! i made it!! the automatic display of the age had been done! u guys are genius! Best Regard alex

Hi, I got a problem of displaying the age calculation... with a new entry form i have a field 'DOBirth' after user input the Birthday then the age will automatic calculate... the format no problem and age is able to count.... BUT there is unable to display the age after my calculation~~~...

Wayne, Thanks for the reply, wayne.... The purpose i would like to prevent duplicate and storing in the record is because i want to use these no. as future use... actually i am writing something looks like a lucky draw program... these no. is using to do the calculation like buying 1 number...

Coyote, Take reference from the following website and the code as well.... http://www.flipcode.com/articles/article_win32skins.shtml Regards, alex kong

Hi Wayne, I did it! Thanks for the Tips u giving me, the following is the code that i made it... but it comes out so many duplicate record... May i know how to remove those duplicate one? and how could it be able to store every no. in my record ? Thanks Regard, alex kong Private Sub...

Hi Wayne, I had try already, it is good! Thanks.... Actually i wish the code always return 4 digit in the rows but no duplicate, by input 4 different digit(exp 1234, 8790) the code will return perfectly 24 combination on it, how bout i use duplicate digit like 1123, 2224 then the code...

Wayne, I had try to replace those Replace(Last, Mid(Last, 2, 1), "") by Mid(Last, 1, 1) & Mid(Last(3, 2)) but the code still not work.... Could you please just show me how is the code work? Thanks

Hi, Thank for the precious reply wayne~~~ Finally i got some idea continue my code already ~~~~ but i found some problem on it... when user key in 4 different no. the code work prefectly , but when a duplicate no. appear (exp 1123, 2224) then the combination getting problem already !~~~ I...

Ops i miss the message of bob~ sorry ... Actually my concept is user could only input 4 digit from 0000 to 9999...

Thank for the Link ... I just made some change of my Mixing number... Actually i could use my number as a 'text' data type instead of 'number' data type, because i don use it to any of the calculation. So it would be something like text orientation... is it much more easier to figure it out...

Thanks Bob~ Hope that you may also able to solve my critical problem on the following thread~ Cause i can't go further without solving the problem... http://www.access-programmers.co.uk/forums/showthread.php?t=136310 Million THANKS!

I don't know is it a stupid question or not... I really don hav any idea how to do it... I just need to do an input of always update the data in same record... For example, while i open my form then they will always showing the first record and able to update it but not creating a new record...

Nice suggestion Larson~~~ how bout some of the tricky user they always change the windows date? For an example, When the first time user open the file the date had set 01-Oct-07 then the expired date will be 30-Oct-07... The database won't work if the user changing the date before or after the...

ok... thank you for trying for a help... really appreciate on your consideration for helping me..

Thanks for the reply larson~~ yes, you r right~~~ I would like to do the possible combination of the a number and store all of them to the table automatically by the program. i had search all over the threads and the internet as well but still can't get any of the idea how to do it... Thanks.