Search results

Thanks, John. Good advice on the naming. I still want to add the ID numbers from the People table to the Enrollment table (linked by Employee_ID) -- long, convoluted story. Any thoughts?

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

Thanks, llkhoutx and Bob. The union query worked perfectly (and hey, now I know how to create one!). I'd initially had both types of training in one table but the data is so different that things got unwieldy.

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

YES!!!!! Changing the Trust Center settings totally did the trick. Thank you so, so, so much. Who knew it was something that simple?!

Sure, here it is. Thanks so much again for your help and patience.

Urrgh, still not working. Here's the code exactly as I entered it (and yes, the control names are correct). Private Sub Training_Type_AfterUpdate() If Me.Training_Type = "External" Then Me.Cost_of_Training.Visible = True Else Me.Cost_of_Training.Visible = False End Sub And here's how it...

Linq, it's in Single Form view. Thanks!

Thanks, Mr. B. I don't yet have the vocabulary to tell you what kind of control Cost of Training is, but it's a box that lets users enter the cost of a training. This is my somewhat embarrassing attempt at writing an event procedure. I've put it in the AfterUpdate box (field? What's it...

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

Thanks. Maybe a little more background will help. I have a table called Training Types that DOES have a numbering column. Then I have another table, Trainings, that uses Training Types as a lookup source. In the Trainings table, the record names sort in the correct (custom) order. It's just...

Sure -- I want the records to appear in a specific way, not in alphabetical (or reverse alphabetical) order. That's where I'm getting stuck. Thanks!

Thanks! I did set the sorting using the Group & Sort menu; unfortunately, it will only let me sort from A-Z (or Z-A), instead of in a custom order.

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