Search results

I'm using Access 2010. Explanation of tables: tblCACs = the workers tblConReq (consult requests) = main table that serves to supply a main form tblConReq_CPRSStaff = serves to supply as a subform to main form tblConReq_MedRecs = same as above tblConReq_QualMang = same as above...

My database consists of tables with employee info, where they work, training modules, & the respective junction tables. For the training modules, there are employee completion dates for all of them. Naturally, I wrote a query that calculates the due dates for each module as follows (for...

Apparently, I've hit a 255 character limit with my previous union queries. So my next thought was to break up the union queries into smaller chunks & have an option group invoke a specific query which is also filtered by the EmpID field on the same form. Here's what I mean: the...

I haven't been able to find a non-VBA solution to this problem, but here we go... There's an employee form that has the person's name & some other info. Within this form is a subform with the training modules the employee has completed & their dates. The main form's & subform's data properties...

Just a few more humps to get over... Only using one line of VBA (which I don't know), I was able to accomplish the following: -Built a form based on a junction table which contains employees, the work areas they're assigned to, the training modules they've completed, & the completion dates for...

Hello, Without VBA (if possible) I want to achieve the following for my end users: Give them the ability to update only some of the records in a table. For example, a workplace with 50 employees, in which they only want to update 25 people at one given time or something like that. Later on...

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

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