Recent content by JenNorthwood

Thank you pat, I finally figured out how to make it work.

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

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

Thank you, It is working great. I truely appreciate the help. Jen

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

Ok, I know my tables are not setup properly. I have been trying to get this one form to work for a very long time. I don't know how to link all the tables properly for it to record all the employees to the course, date and length. I am not a programmer and I have not been working with...

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

I have attached a sample of the problem. Any help would be great. Jen

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

Thank you Pat, Your suggestions worked. I now have it working. Only one last question. I get an error when I try and input more the one course right after one another. I believe all it needs is a requery, but where would I put it? THe error occurs on the lookup combo Set rs =...

I have looked at everything and I can't figure out how to make the date and course work on the one-side. I don't know if I set it up right or not. Can you please look. Thanks for all your help. Jen

Thank you Pat, I changed it all around so that everything is where it is supposed to be, but now the subform isn't working?? I don't get an error message or anything, but the parent form works. Please help. Thank you for your help. Jen

Hi Tried putting the date and course on the parent form, but the parent form is looking up information and I just can't get it to work. I have tried everything I can think of. I have attached a sample of what I am trying to do. I want the date and course to be the same for all the people I...

My fields are bound properly. When I enter in the first row and enter, the next line is blank like a new record. I want the Date and Course field to be the same as the first record that is selected.

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