Search results

Bumping up this question. Anyone have any thoughts? Thanks.

OK, I'm not quite sure how to phrase this, so bear with me: My database is set up to collect information via an e-mail form. It works very well. However, I'm going to be leaving the project soon, so the forms should go to a different user. How can I arrange it so the forms will go to the new...

Yes, I'm using Access 2007. Apologies if I have somehow behaved abhorrently.

OK, I'm not sure why this worked, but I just updated the link between the affected table in my back-end database, and the form and combo box now function perfectly. Thanks anyway.

Perhaps, but the checkboxes-in-combo-box method has worked perfectly on another form in the same database. (The settings are identical, so I am really not sure what's happening.) The user can check a selection(s) -- i.e., Bronx and Brooklyn -- and a check mark shows up in the appropriate box...

Hi, all -- I have a combo box on a form that lets the user select one or more locations using a checkbox. However, when the user makes his or her selections and clicks "OK," the combo box doesn't go away. Any thoughts on what might be causing this? Thanks!

Ah -- I figured it out how to fix it with the help of Google and Allen Browne: http://bit.ly/u5psNz. It worked!

OK, I did something dumb -- I accidentally changed the ID field type in tblPeople from AutoNumber to Number. (Can't revert to a backup, either.) I would like Access to automatically assign ID numbers as I add names to the table, so having ID as a Number field won't work. I also want to keep...

Thanks for the speedy reply, Steve. By CourseDate I mean the date of each lesson. I originally had fields in the Training table called CourseDate1, CourseDate2, etc. but I got scolded in this forum for not having normalized my data. Hence the restructured tables. I could easily create a form...

Yes, another dreaded Student Attendance Database question. Sorry to have to ask, but I can’t seem to find a solution to my particular problem. I’ve got a training tracking database. The relevant tables are: People (contains StudentID, FirstName, LastName, etc.) Training (contains...

Thanks, Jeanette, that worked. I have of course done substantial research on building a registration database and my tables match what you recommended.

Hi, all -- not sure if this can be done, but if it can, you're the ones who will know how. I am creating a course registration database, and I want to use a subform that will let instructors check off the dates a student has attended class. On my tblTraining table, there are fields called...

D'oh! As so often happens, I figured out a solution right after I posted this. I put the following code an the AfterUpdate box on the form one uses to enter EBP Trainings. Works perfectly. Private Sub EBP_Training_Category_AfterUpdate() Me.[Training Name] = Me.EBP_Training_Category.Column(1)...

Hi, all. I'm creating a report that shows trainings conducted by employees. Some of the trainings have names, stored in the field [Training Name]. Others are just categories -- such as Individual Consultation -- and are stored in [EBP Training Category]. In the report, if the [Training Name]...

Still struggling with this -- can anyone help? Thanks!

Hi -- hoping you can help me avoid a duplication issue in a form I'm creating. The two tables in question are: tblPeople -- includes FirstName, LastName, ID# (among other data) tblEnrollment -- includes ID# from tblPeople and CourseID# My form, EBP Training, lets users enter details about...

Oh, jeez -- just realized what I'd done wrong: I'd linked the wrong fields between the two tables. Once I fixed that, the query worked like a charm. Sorry for being a timewaster -- I really do appreciate your help and patience. This forum is awesome (believe me, I read about 100 previous posts...

Yes, thanks, that is exactly what I'm trying to do. It's just that my update query is failing. Any advice/pointers on how to do it properly? Thank you again.

Great, thanks again! One of the problems: not everyone in People has an Employee_ID number. So I'm still posing my initial question.

Thanks again for the speedy assistance. People.ID is the primary key from the People table. It identifies each person's record within the database. Employee_ID is a six-digit employee number given by HR. I want to put the People.ID field into the Enrollment table, which shows the classes each...