Recent content by jabjab25

  1. J

    query to find results for two people

    thanks brian that worked a treat for me
  2. J

    query to find results for two people

    that seems way to complicated to me is there an easir way to do it as i have to replicate something like this in an exam and this is the final session so im likely not going to remember that is there an easir way, like something you can type into the criteria
  3. J

    query to find results for two people

    what do you mean by that i have a paramter on there atm which when you press run you enter the student id and i finds just 1 student id i cant get it to find 2 students that i need i have attached the database and the query you need to look at is the qryReport one take a look and see what i...
  4. J

    query to find results for two people

    [SOLVED] query to find results for two people hi there so here is the story to the problem i have created a parameter query which will find a students best and worst time for each exercise they have done. so you enter the student ID when you run the query and it works fine but i have a problem...
  5. J

    turning the month into a number using vba

    ill give that a shoot and see what happens thanks for the help
  6. J

    turning the month into a number using vba

    hi bob fitz atm i dont have it set as a combo box just as an ordinary text box so the user would have to input the month themselves but in the exam i would ofcourse change the text box for a combo box would this make a difference in the type of code i would need to use. in my exam model for the...
  7. J

    turning the month into a number using vba

    hey catalina nice idea but in my case i dont see it working on my form i have the following text boxes : TestID, TestMonth, TestComments, Test Year. so the user will input the test year and the test month ie may. the user will then click the test ID button and the code behind the button should...
  8. J

    turning the month into a number using vba

    hi there im doing my ict unit 7 edexcel ict exam atm and as one of the tasks we have been asked to generate the testid. the test id consits the year a underscore and then the number of the month so for example if a test happened this year and this month the test id should be 2013_5. i can get...
Back
Top Bottom