Search results

Hi all First time using the modern charts in access. I am trying to plot a simple pie chart which depicts how many of courses are still in date and how many are out of date. My query (lets call it qry1) has CertificationDate, ExpiresOn, DaysLeft fields. However, I cannot get it to plot on a...

Greetings, I have a basic table, CourseNameT which looks like this: In the corresponding form, I have txtCourseID, cboCourseName, cboType (can only be either External or Internal), and txtValidFor. I am trying to use NotInList event so that user can add new courses if it doesn't already...

Hi all Is there a way to bulk update training records? For example, let's say I want to update records of 50 employees, where they all received 13 trainings. Using continuous forms, I would usually navigate to an employee, then assign 13 trainings to them. But this is way too long to do for 50...

Hi all I am trying to import some forms from a previous db to a new one, to save me from formatting and referencing, but I get the following error: I have tried to close and reopen the db, as well as compact & repair without any luck. Thanks for the help.

Hi I have a very basic issue with the total query which is doing my head in. Don't think I have had this issue before. I have the following query which works just fine as standard non-total query. When I press Total and do the following, I get an error message saying 'enter parametric...

Hi all In the attached db, I am trying to create a query, MandatoryTrainingDeliveredQ, which takes in info from MandatoryEmployeeTrainingQ and EmployeeXCourse_JT, using EmployeeID as the common field. I am however getting duplicate values. The short description of db is as follows: EmployeeT -...

Hi all Please refer to the db attached. Before I ask the question, here are the details of the db (and apologies for a long thread): CourseListT, EmployeeT, PositionT, and ProviderT are self-explanatory Course_JT (PK DeliverID) keeps records of courses provided by providers e.g., one course...

Hi all In my training db, I have CourseListT and Course_JT tables. CourseListT contains CourseID (PK), CourseName, and ValidFor fields. Course_JT contains DeliverID (PK), CourseID (FK), ProviderID (FK), and other fields. This is to handle the situation where any course may be delivered by more...

Hi all For my training db, I have a CourseListT which contains CourseID and CourseName fields. I have another juntion table called Course_JT which has following fields: DeliverID (PK) CourseID (FK) ProviderID (FK) CertificationAuthorityID (FK) CourseCode TrainingLevel Cost One of the purposes...

Hi all In continuation of this thread, I am looking to have similar function where I can select multiple values and delete them at once, rather than deleting each value individually. My listbox is bound to a table, and as such row source type is set to table/query. Here is my code: Dim i As...

Hi all I have a main single form (MainF) which displays various types of records through use of continuous subforms (SubF1 and SubF2) for an employee chosen on MainF. To prevent accidental changes in records, I have put in an EditBtn which lets the user to change records. I have multiple...

Hi all I have a continuous form which helps me keep track of which employees have passed which course. The way db has been structured, is the data from the continuous form gets saved in a temporary table, and only gets copied to actual table when the data is all OK i.e., all records have...

This question is in continuation to a solved thread: https://www.access-programmers.co.uk/forums/threads/openarge-error-you-cant-assign-a-value-to-this-object.327824/#post-1878884 For the same source and target forms, I am trying to check if the combination of PositionID and CourseID already...

I have seen another post where deleting the target control fixed the issue, but it hasn't worked for me unfortunately so here goes. I have a combo box with PositionID, PositionName on a form with a listbox below which shows related training record to that PositionID. I have another form, a...

Hi I have the following code in one of my forms: Private Sub CloseBtn_Click() On Error GoTo Errhandler If Not Me.Dirty Then DoCmd.RunCommand acCmdClose Else Select Case MsgBox("Do you want to save changes before closing the form?", vbYesNoCancel + vbCritical +...

Hi all I have tried to search for a possible solution to this with no luck so far. I need to attach documents to people's records in the database. With a standard MVF, you can use an inner join between two tables to make it work for you but what can we do with attachments? I am having issues...

Hi I have spent half a day looking at various solutions with no luck. I have a report based off a query which shows expired training courses for each employee. Everything works fine until I try to filter the report with date ranges. Mainly, I have tried working with the following 2 ways...

Hi again As some of you already know I am working on building an employee training record db. I have become stuck at one issue in this db which I believe is down to how I have structured my data. The main functionality that I am looking out of it is to keep record of trainings employees have...

Hi all I have a training database where on the employee form, I have a command button which takes me to another form i.e., Training Records. I have a junction table with EmployeeID and CourseID (PK for this junction table is simply called ID). Issue I am having is that any new data I try and...