Recent content by timeh

  1. T

    help please

    yeah, that didn't work either :(
  2. T

    help please

    yeah, none of them are missing, and if i open a different database (which works) the same ones are checked
  3. T

    help please

    i've recently been writing a program in access2000, however when i came to open it recently, none of the buttons worked, all producing the following error: ------------------------------------------------- The expression On Click you entered as the event property setting produced the...
  4. T

    password problem

    hello, this may sound a bit basic to some of you, but could someone please tell me if it's possible to make a button on a form to allow the user of a database to change the password? I would be very grateful if anyone could tell me how to do this Thank you in advance Tim
  5. T

    differences in functions

    hi, I was just wondering if anyone could tell me the difference between "Me.refresh" "me.requery" and "me.repaint" - Does anyone know which are suited to different situations? thanks in advance Tim
  6. T

    visible buttons problem

    thanks thank you :)
  7. T

    visible buttons problem

    hi, i'm writing a database, and on one of my forms, i've created two buttons to go to "previous" and "next" records. What I would like to be able to do is make it so that if there is only 1 record, the "previous" and "next" buttons go invisible, does anyone know how to do this? Also, could...
  8. T

    dateadd function

    hi, i'm writing a query for a mailmerge which i want to be produced when the date is a week before a date already set in a date field. i.e. Field name = Date Criteria = ? I think it has something to do with the dateadd function, but i'm not sure exactly how to do it any help is much...
  9. T

    mailmerge query

    ta very much mate, i really do appreciate the help :)
  10. T

    mailmerge query

    hi, i am currently writing a database for a local football club Now, each member has an "annual fee" field, and this has to be paid yearly Each member also has a "membership began" field, stating the date on which they became members of the club Now, what i've done is create a query which...
  11. T

    Advice on Table Structure

    thanks Pat, thanks a lot for the advice. I'm going to try to do what you suggested. First off, i'm not sure what your mean when you say "add a flag" Do you mean a field from which you can select if the 'person' is a member or visitor? Yes - i have abbreviated the field lists for name and...
  12. T

    Advice on Table Structure

    hi, I am currently writing a database for a local squash club. I've tried to design it a few times but i seem to come unstuck along the way with the same problems. The database stores member details such as name, address, telephone number etc. I put these into a table called tbl-members, which...
  13. T

    creating input masks

    pitou mate, thank you very much for taking the time to do all that, i really do appreciate it. I've started a new database to test out your idea before trying to incorporate it into my own. The only problem arises when i input the code you suggested for the drop down box, i.e...
  14. T

    creating input masks

    Thanks mate, i've done what you sed, however, i'm not sure what code to put in the 'after update' field on the combo box. You select the position from the Combo box for say 'team1' - i then want the corresponding points to appear next to the combo. For example, if "1st" was selected, i would...
  15. T

    inputting values to fields...sorta

    Ok, here's the problem: What i've got is a database which stores contract details . On one form, I have the following fields, joining fee - (entered by user) annual fee - (entered by user) additional fees - total fees due - (sum of above 3 fields) Now, the three 'fee' fields are added to get...
Back
Top Bottom