Search results

  1. A

    Populating Combo Box Bases on Previous Combo Box Selection

    Well..i dont wanan use query because there is no table with these values.so i would prefer a List given to rowsource
  2. A

    Populating Combo Box Bases on Previous Combo Box Selection

    Hi ..I would appreciate if come one help me I have Two Combo Boxes "Case Action","Case Action Comment".Therr are four possible Values for "Case Action" Combo i.e "Accepted","Screen-Outs",Rejection","Denial".I want to achive that when Ever user Select "Accepted" in "Case Action" Combo he will be...
  3. A

    Drop Down Box Populated with Query

    Hello Guys..i will be very thankFul if u can help me I Have a Drop Down Box.Which is Populated with a Query.Problem is I acn See the Name in Drop Down but i cant Select any one other the one on Top and secondly when it saves it in Table it saves the Key Value against that Name not the Actula...
  4. A

    Validating a Field

    I have 3 dates Field "M11Qdate","DateSubmitted","DateDue" I want to apply Validation On It 1)Cannot Left "DateSubmitted" Blank (user should not be able to go to next Control until there is a Date in "DateSubmitted" 2)"DateSubmitted" Cannt be less then "M11Qdate" 3)"DateDue" cant be greater then...
  5. A

    Field Validation

    I have 3 dates Field "M11Qdate","DateSubmitted","DateDue" I want to apply Validation On It 1)Cannot Left "DateSubmitted" Blank (user should not be able to go to next Control until there is a Date in "DateSubmitted" 2)"DateSubmitted" Cannt be less then "M11Qdate" 3)"DateDue" cant be greater then...
  6. A

    Restrict date

    its a Access data base...and field is set to be Date/Time in DB
  7. A

    Restrict date

    the Date is coming from Data Base..which is set to be Date/Time and i want this function to be on updtae..could this be the case...?
  8. A

    Restrict date

    No just the Date....
  9. A

    Restrict date

    When i enter the Todays Date it Say's "Must Be Greater then Todays date"... why is that?i need the date should be less or equal to todays' date
  10. A

    Restrict date

    It works for Dates Greater then Today..but i want user to allow date equal or less then Today's date..what i have to change...
  11. A

    Restrict date

    Hi ..I have a Date/Timew Field on my Form.How i can Restrict user to enter a Date Before or Equal to Today's date. Thanks
  12. A

    Checking More then One field

    Thanks ..u are great and really helpful
  13. A

    Checking More then One field

    Thanks a Lot....ok what i have to do add the third Field which is date/Time.Let say it [M11Q Date]: plz write the strLinkCriteria like above Thanks
  14. A

    Checking More then One field

    Ok one of them is "Date/Time" and Third is "Number" Type Data.But when i tried the "Number" Type Data Field..like this: stLinkCriteria = "[Social Security Number]=" & Me![Social Security Number] And "[Case Type]=" & Me![Case Type] it Give Run Time Error Type 13..Type Mismtach.. and when i...
  15. A

    Checking More then One field

    Hi I have a Small Issue.i am taking SSN from a Form,Validating it with the Table and Opening a New Form if the SSN Match using the Code Given Below: Private Sub Mutual_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Mutual" stLinkCriteria = "[Social...
Back
Top Bottom