Search results

  1. john527

    How can I calculate a persons.

    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...
  2. john527

    calculate a persons age code not working.

    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...
  3. john527

    Question about 4 different forms

    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
  4. john527

    fields tab index changes ??

    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...
  5. john527

    Calculate a person's age not working.

    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...
  6. john527

    Credit Code Get No Return ?

    Can some one help me with this code, I get no return, ??? . Private Sub cust_credit_score_1_AfterUpdate() If [Forms]![Customer Form]![cust_credit_reply_1] = " [Bad Credit]"Then [Forms]![Customer Form]![cust_credit_score_1] = 5 ElseIf [Form]![Customer Form]![cust_credit_reply_1] =...
  7. john527

    can not get code to work.

    Hi, can someone help me with this code I do not get a return ( 5 ) or ( 10 ) ( 15 ). Anyone have a solution,any help would be appreciated. Private Sub cust_credit_score_1_AfterUpdate() If [Forms]![test credit]![cust_credit_reply_1] = " [Bad Credit]" Then [Forms]![test...
  8. john527

    Calculate fields.

    Hi, can someone help me with this formula. i have one field called notice_1 this field is a combo boxs multiple choice ( YES - NO ) Then i have 1 field called score_1 ( if notice_1 = "YES" then let score_1 = 5 else then let score_1 = 10 ) Does this make sense , I am an...
  9. john527

    Page Break Help :

    Can Somone help me Page Break : I have created a form in accress 2002, with two pages, and I place the page break between the two pages , and all I got was ¾ of the second page. I place the page break in other areas on top & on bottom as will in between the pages & I get the same results all the...
  10. john527

    Microsoft Access & Microsoft SQL.

    Questions / Help : What I would like to know about Microsoft SQL Server & Access 2003 : I am a novice at creating my own database. I would like to use Microsoft SQL Server & Access 2003 . I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 . Now I...
Back
Top Bottom