Recent content by john527

I have a field name cust_birthday Data Type Date/Time Input Mask 99/99/0000;0;_ I have a field name cust_age Date Type number What I can not do is to have cust_age calculate the persons age based on the cust_birthday. Can...

can dot get it working. Hi, gemma-the-husy can you help me. I did the compiling, no err came up. I also try to do step through it line by line. Still can not get a returen, So I did an add watch with intEstAge = DateDiff("yyyy", dteDOB, dteBase) The value ( out of context ) ??? what can I do...

Hi all I have another code Problem, Can someone help me with this. I have two fields One called cust_birthday ( date field ) And one called cust_age ( text field ) The code below I put in a module name age function. The Problem, is I get no return from this code. What is wrong with this...

I have a question to put out thery. About a new application. I am building 4 databases with access 2003. My question is do I build 4 different database, or Build one database, for all forms, Customer Form Vender Form Catalof Form Employee Form John527

Tab order . Hi, Mr Ruralguy Thank you again you have solved a problem for me. I sincerely appreciate your help. It is work grate. John527

Don’t Understand why , tab index change’s All 55 fields are in the same order as the tables. The field is custname the frist fiels. Go to my Customer form Thery are 55 fields, The frist field is ( custname ) I go to the properties Then I go to tab index And I type in 1 Then I exit. Save form...

Debugger . Hi, no I do not know how to single step my code with a debugger to see what is going on. Do you think you can explain it to me, would appreciate it. Thank You For your Time John527

Hi Ruralguy, Wow-O-Wow That was Grate after so many weeks working on this code. ( WORKING FANTASTIC ) And it was such a small detail, Again I thank you for all your time and patience. I have another problem, on Oct, 11 I post a new thread ( now to calcutate a person’s age ) No one...

here is the full database, sorry only attached the form on last one

No Problem. Used winzip and created a zip file. Let me know what you think or if any further information is needed. I hop e i zipped everything you needed, please let me know if not.

Not Working ???? Ruralguy Hi, I put the code in the AfterUpdate event of the Combo449 control. Went to Customer Form Went to the field called cust_credit_reply_1 ( combo449 ) Went to the properties Went to Event Went to the After Update Private Sub...

Combo449 Hi Ruralguy, Hope i did what you wanted me to do. Went to cust_credit_reply_1 ( combo449 ) Went to property Went to Other Name Combo449 Allow Autocorrect yes Tab Stop yes Tab Index 97 Ime Hold no Ime Mode no control Hope that this will help. Thank s Again John527

Still No Return My mistake, So new at this so and so different from unix. I but the code in cust_credit_reply_1_combo449 Went to cust_credit_reply_1_combo449 Went to Event Went to afterupdate And put in the code Select Case Me.[cust_credit_reply_1 combo449] Case "[Bad Credit]"...

cust_credit_reply_1 combo449 = ( multiple choice - Bad Credit - Good Credit and so on ) cust_credit_score_1 = ( answer 5 - 10 - 15 and so on. ) Hope this helps sorry if i confused you. John

Hi all , I am trying to calculate a person’s age. Went to Customer Form Have a field called cust_birthday ( date/time ) ( 99;00;00;\>LL;0; ) Have a field called cust_age ( Number ) Went to Madules / New / then add this code, Public Function Age(dteDOB As Date, Optional SpecDate As...