Search results

  1. J

    Cancel Record with No Data Entered

    Hi There, I have a form that I wish to write code for. I want it to do the following: If any fields in the form are blank, to cancel the record and not save anything. I don't know code very well and I am unsure of where to start. Does any one have some examples of this? I have attached an...
  2. J

    Requery Duplicating Records

    hi There, I have a form that I input some information, but in the query it is duplicating records. I have attached the db for the problem. The query is called Duplication. I entered the data: "To Stop a theif" Video, 02/02/03 (date), 1 hr (course lenght) and only one person "sheryl...
  3. J

    Table Structure Help

    Hi There Again. I need help trying to figure out how to create my table correctly. I have not been using Access for a while now, and I have been trying to get my form to save the data correctly. If anyone can help me sort out what goes where, it would be great. I am trying to save Course...
  4. J

    Records not displaying properly

    Hi There, I am having problems with my database not showing the records properly. I know the records are there, but they will not show up in my forms properly. I have attached a sample of what I am trying to do. The main problem is in Oreination, it is not showing the people to the course...
  5. J

    Requery Question

    Hi There, I am having trouble figuring out how to requery my form to get rid of an error I am getting. Run-Time error 3070: The Microsoft Jet Datbase engine does not recognize TrainingID as a valid field name or experession. I press ok and it still works. This error occurs when I pick...
  6. J

    Continuous Form Question

    Hi There, I have a Continuous Form (it is in a subform): Has the following fields: Person Date Course When you choose the first person, Date, and Course, The next person I choose, the Date and Course stay the same. How do you do this? EG. Person Date Course Jen July 12...
  7. J

    Problems with a subform

    Hi There I have a form and a subform. I have a combo box called Combo16. I am trying to choose an option from Combo16 and then it appears in the subform Combo box - Combo10. Combo16 = Combo10 Problem: I get an error saying it can't find the subform. I have made sure that all spelling is...
  8. J

    SubForm Problems

    Hi there again, I have changed my form and used a subform, but I can't figure out how to still link the multi selection employees to the subform. Please help. Thanks, Jennifer
  9. J

    Can not get my code to save muti selection

    Hi There, I have been trying to get this form to work for a while now. I have Three list boxes. LstFrom = Employee's LstTo = Employee's that are selected are to go here TrainingCompleted = Training Courses Offered _________ Combo Box CourseLength = Length of the training courses ___________...
  10. J

    multi selection list boxes problems

    Hi There, I am having a hard time figuring out how to save my muti selection list boxes from one table and courses and a couple of other items from another table. I thought I might need a temp table to save the data there and then put it into my main table. 1 table is Employees 1 table is...
Back
Top Bottom