Search results

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

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

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

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

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

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

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

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

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

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

ok, what i'm trying to do is this: In a table, i have 4 fields: team1 team2 team3 team4 each of which contains data type "text" each is a combo box with 'row source type' set to "value list" and in the row source itself is the following: "1st";"2nd";"3rd";"4th" so a position can...

I'm designing a database for a local athletics event, in which there are 4 teams which compete at different age levels in different events. The problem is, it is necessary to keep a running total of the points each team has, i.e. whenever the user enters the number of points a team won from an...

I was wondering if someone could please tell me about radio buttons.I'd like to know what they do, and how you can make them on a form coz they don't seem to be on my toolbox