Search results

  1. C

    Creating Reports for single records

    This is great thanks, the only problem now is I can't seem to add new records to the form.
  2. C

    Creating Reports for single records

    I can't seem to get it to work. I've attached a copy of my database if you want to look and see what I've done wrong. I am trying to get it so that when you select save choices on the options form you are given the option to print the choices you have just made in the options report. If...
  3. C

    Creating Reports for single records

    I've looked through the watch thing in the debug menu and have found something that says : Text : <You can't reference a property or method for a control unless the control has the focus.> : String : Form_Option Form.Command30_Click will i have to focus back to student ID before I run the report?
  4. C

    Creating Reports for single records

    I cant seem to get this to work. Would it be any easier to output the selection to word/excel and print them from there? Or run a query that returns the student id and the options they have selected?
  5. C

    Creating Reports for single records

    If MsgBox("Do you wish to print your choices?", vbYesNo, "Print?") = vbYes Then strDocName = "Options" strWhere = "Student_ID=" & Me!Student_ID DoCmd.OpenReport strDocName, acPreview, , strWhere DoCmd.Close Else DoCmd.Close...
  6. C

    Creating Reports for single records

    strWhere = "[RunID]=" & me!RunID In this part of the code do I need to substitute something in place of RunID?
  7. C

    Creating Reports for single records

    ah i should have said. that code is on a form that saves the changes to the entry, then as they select this i want the yes/no to appear and if they select yes i want to print a report for the record selected in the form. edit: just read what you've put again and realised i misunderstood. will...
  8. C

    Creating Reports for single records

    If MsgBox("Do you wish to print your choices?", vbYesNo, "Print?") = vbYes Then ******** DoCmd.Save DoCmd.Close Else DoCmd.Save DoCmd.Close End If This is the code I currently have, I've set up a report called options that will need...
  9. C

    Creating Reports for single records

    I have a form in which students enter their student ID codes then make their choices of modules with each module being a field which they have to select using a tick box accordingly. Once they have made their choices I want to be able to print off a report of just that one record that displays...
  10. C

    How do I make a button appear only if certain conditions are met

    I am creating a form in which the user (student) has to make selections from 7 choices (each 10 or 20 credits) which must equal a total of 30 credits. I want the save button to appear only if this criteria has been met. What is the best way of doing this? Thanks.
Back
Top Bottom