Search results

  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...
  16. T

    simple command button code please

    thx mate thats great
  17. T

    simple command button code please

    ok, this will probably seem stupid to you, but i've got a command button on a form, and i want it to be able to open a specific record on another form i.e. if i have the field "member ID" on both forms (and it's a primary key and autonumber), i want to be able to go to the information from say...
  18. T

    creating input masks

    I am designing a database for a scoring system at a local sports event. There are 4 teams in the competition the user enters a position (chosen from a drop down list) for each team. what i want is for the position to give a corresponding number of points e.g. if the user selected 1st place for...
  19. T

    value list - row source problem

    fizzo mate that's great, hehe, cheers :) if there's nethin i can do that u need help with....er...thats not really very likely is it..hehe thanks neway
  20. T

    value list - row source problem

    thanks a lot , an idea of the code would be useful, i'm gonna try and learn a bit of vb this summer but at the moment i have next to no programming ability
Back
Top Bottom