Search results

Did some more troubleshooting & I got it to work this way: 1. In the main form, create a combobox for the item (for example, Unit) 2. Open the subform in design view 3. Create another combobox for Unit 4. Go to the properties of the new combobox 5. Under Data, make sure the control source is...

I think I may have a similar issue. I made sure the master/child links were correct (in my case, EmpID) between the parent form & subform. What I want to do in a data entry form is to select the area where the employee works in the parent form & have that locale automatically fill in the same...

Yeah I'm not going to lie; I built the command button, got into the VBA console, & I'm not sure if I built the append query correctly. Help? :confused:

I'm going to try this early tomorrow. I'll let you know how it goes.

I've tried searching the forums for an answer but there were a lot of dead ends unfortunately. I have a main form (data entry) which my users are able to use to add new employees. Within the main form is a subform (also data entry) which my users utilize to add the new employee's work area &...

I wanted to also thank you for giving me a new perspective. I think you're correct; perhaps I should associate training items to the hospital floors & then to the employees themselves. It gets a little trickier than that because all of the training items for a particular floor would each have...

:eek: The training requirements (or "items" in this case) are bound to the hospital units that the employees work on; however, the same training requirement on one floor could be due more often on another floor. Is there any way I could explain it better? Thank you for your input thus far.

Anyone answer this question yet? I'm having the exact problem.

So, the overall structure of my database has been wrong this entire time? :banghead: Attached is another try. The first pic is of course the new relationship structure. If I have it correct, I do have a question about entering data into the junction table. In addition, I attached part of the...

Thank you for your reply. I didn't see it when I replied to the other poster. I'm going to have to troubleshoot this sometime this week. I'll let you know how it goes. Screenshots helpful?

I've read up on normalization before but obviously there's more to it. I will look it up. Another reason why I created so many tables for training is because the same training item could potentially be more frequent on different hospital units. For example, IV insertion training could be done...

The reason for the four separate tables is because of the calculations that go with them. For example, for annual I have to calculate 365 days (etc, etc.). I used to have it the way you explained until I found out that different calculations were going to have to be separate though.

Spike, Ignore "Floor" & "Unit" in the employees table; I'm going to delete those. I'm also going to migrate "Manager" in the employees table to its own table as well. Thank you for your help.

Hello, I've been building this database since last February & it's killing me, hence why I'm here. This relational database is supposed to track hundreds of employees & their compliance with training (specifically, in a hospital setting). I've run into various problems in the past but have...

I'm from the States but please don't hold that against me. This is my very first time posting on this site. From all of the Google searches I've been doing this seems like the place to be. My background is technical in various fields but Access is a new monster to me. Since starting this new...