Search results

  1. D

    Screen Resolution

    Hi, I built an Access DB on a machine with screen resolution of 1920 x 1080. Well I just tried to play it on a machine with a max resolution of 1360 x 768. You guessed it, the lower (approx) 20% of the input form is cut off. Is there a fix?:confused:
  2. D

    One field determining the value of another field

    Hi, Thank you for your help. Could you recommend any resource that dedicated to Access command syntax.
  3. D

    One field determining the value of another field

    Hi, I tried what you suggested and it worked with the addition of a query. However, I just had to try to figure out how to make my approach work. I finally got it to work. Thanks for your help
  4. D

    One field determining the value of another field

    Hi, In desperation to try anything I changed your code to: Private Sub SelectFA_BeforeUpdate(Cancel As Integer) Select Case Me.SelectFA Case 25 Me.MemType = "F" Case Else Me.MemType = "A" End Select End Sub I should...
  5. D

    One field determining the value of another field

    The following was placed in BeforeUpdate. SelectFA is the name of the option group. Private Sub SelectFA_BeforeUpdate(Cancel As Integer) Select Case Me.SelectFA Case 1 Me.CurrDues = 25 Me.MemType = "F" Case Else Me.CurrDues =...
  6. D

    One field determining the value of another field

    No, can never have Memtype=A and Dues=25 or Memtype=F Dues=15
  7. D

    One field determining the value of another field

    Hi, I believe this to be an exceptionally simple problem. So simple that I can’t figure it out. This is the situation: Table 1: has 3 fields: id(auto), dues, and memtype Form: Contains fields for “dues” and memtype Memtype: can be either “A” or “F” Dues: can be either 15 or 25...
  8. D

    New guy

    Hi there, I'm semi-new to Access. I know just enough to be dangerous. Much of what I know has been self taught usually through forums like this or YouTube. Great to be a part of the group.
Top Bottom