Recent content by SusanCB

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!