Search results

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

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!

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

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

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

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

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

Hi, all -- here's the situation: 1. I have a table called People with fields called ID (the primary key) and Employee_ID. 2. I have another, imported table called Enrollment that also has an Employee_ID field. 3. I'm trying to put the data from People.ID into a new Enrollment.ID field. Since...

Help! I'm trapped in query hell! My database has three tables: People, Agency Training, and External Training. I want to be able to create a report showing each person and both their Agency and External trainings. I can run queries that give me a person's Agency training or their External...

Hi -- first of all, forgive me, I'm a librarian pretending to be a database programmer. Hoping you can help me. I've got a form that allows users to pick a type of training from a Training Type combobox. If they pick "External," I want a "Cost of Training?" control to become visible. I've...

Hi, all -- please forgive this possibly basic question from an Access newbie. I'm trying to sort records in a report using a custom order. Specifically, I want the records in this order: Supervisor Training Individual Supervision Group Supervision Staff Training TF-CBT I have the files sorted...