General :: Clashing Events With Personnel
Dec 16, 2012
I have a table that stores events and then associates individual people to it. (I do this using a weak table between Events and Personnel) One person can be attached to many events and one event can have many people assigned.
Events.PKEvents - AutoNumber Primary Key
Events.EventName - Text
Events.StartDate - Date/Time
Events.EndDate - Date/Time
I have a second table where I store individual names that attend each event.
MMEventtoPersonnel.PKMMEventtoPersonnel - AutoNumber (Indexed no duplicates)
MMEventtoPersonnel.FKEvents
MMEventtoPersonnel.FKPersonnel (This links to a Personnel table, but I don't think it's structure is important at this stage)
The combination of FKEvents and FKPersonnel is the primary key for the MMEventtoPersonnel table.
What I need to do is flag the record in the subform, if a person is already assigned to an event that includes the date for the current event shown.
For example, Smith is assigned to an event from 12/12/2012 through 12/30/2012.
Someone comes along and want to add him to an event between 12/11/2012 and 12/20/2012. I don't want to stop the entry, (Their might be a good reason why they need to overlap.) just flag it.
I have an "Inclusive dates Query" that lists every date between a start end date using a cartesian product query.
I built a query that selects all events that have dates that exist between the start and end date "selClashPersonnel", I then used selClashPersonnel to count the number of collisions, creating a IIf statement to code and count whether there is a clash.
Problem is that it is requires a specific form to be loaded, and I use the form many other times in the database. Plus I can't get it to update on the forms. I tried DLookUp, but that doesn't seem to be functioning properly.
View Replies
ADVERTISEMENT
Jan 26, 2015
I am fairly new to access, and have the following problem with the attached new DB. Thought I have designed the start of a good database with a "Junction Table". Have 1 problem, cannot enter a new name on the from, gives the error below:
"Join key of personnel table not in recordset" ...
View 2 Replies
View Related
Aug 14, 2015
I have Access 2007 database.
I and trying to link to Outlook 2007 using the "External Data/More/Outlook Folder option and keep getting the "Object Class does not Support the Set of Events" error message.
I can link to a DBF and Paradox file without any problems.
I am running Office 2007 Professional and Access 2007 and Windows 10.
I have also done the following:
1. Removed Office 365
2. Decompiled the Access VBA code and corrected any issues
3. Compacted/Repaired the database
I have attached a screen shot of the references that I have selected.
This is a new setup as I recently purchased a new PC and Windows environment. I still have the old PC running Windows XP with the same configuration and it also experiences exactly the same error message.
View 6 Replies
View Related
Oct 17, 2014
I have distributed my front end on the shared drive for users to copy to their desktops.
In one form I have a formula in the query that show's the word 'Gap' if any of the 15 questions on the form is equal to 'fail'. It runs on current when the user is in a record it shows the word 'Gap' at the top header part of the form.
When the user opens the form they get an error message pop up that says "The expression On Current you entered as the event property setting produced the following error: Object or class does not support the set of events."
Once they click 'ok' they are able to work in the form until they attempt to filter records by their name it pops up again.
I've tested on my end and no errors or issues come up.
View 1 Replies
View Related
Oct 9, 2014
Couple days ago our database was not opening, Access would open but show a blank workspace. Anyhow, we restored the database from Server and it worked on all 5 shared systems on company's network but this one computer. It is giving the error, "Object or class does not support the set of events."
I tried to copy new local folder but nothing. I checked the links and target folder it looks fine.
I tried to import the everything into new database but it said I don't have permission for that.
what's causing this issue and what can I do to fix it?
View 3 Replies
View Related
Aug 9, 2007
Hi
My database is to have a Personnel data area whereby I can store all relevant details for employees within the company.
I plan to incorporate a feature whereby I can alos maintain a history of documentation written and issued including links to the actual documents for that employee during their time with the company.
Has anyone done a similar thing they would be willing to allow me to use?
I figure this would contain links to work documents stored on the hard drive in a specific folder. Selection of a specific item from a historical list - would invoike Word /similar and display the appropriate file...
Any ideas would be gratefully received.
Thank you.
View 6 Replies
View Related
Jul 31, 2013
My desired output of this is to have a database to allow me to quickly check in and out equipment and personnel using a barcode scanner. I am using access 2013 and started with the asset tracking template downloaded from Microsoft. Where I am hung up right now is adding the personnel check in and out (each member of the team will have a barcode attached to their id) I want to be able to just scan their badge when they show up and again when they leave. At the end I will run a report that shows who was on scene (it is for a search and rescue team) during a certain day or time range.
I have added two new tables one check in and one check out the only fields are firedeptID and CheckIn or CheckOut a date/time field CheckIn and CheckOut Auto populatewith Now(). The first problem is that I think I need to turn off (if possible)the auto creation of a new record every time, when I scan in an ID right now that record gets the time stamp of the last time the new record was created IE.Last week when the last person scanned in and the new record was created. I assume I am going the same type of issue when I start working on checking out the equipment.
View 8 Replies
View Related
Jan 31, 2014
I need to display on a report the percentage of personnel deployed.
that is fine: 2 TextBoxes Sum1 and Sum2 and a third set to =Sum1/Sum2 and displayed as percentage in the setting.
My problem is that i need to be able to link the subreport to the main report by the field 'Type' from the table 'Job'
View 4 Replies
View Related
Aug 5, 2013
I run a service related company and I am trying to develop a service database that will automatically calculate the next service due based on the previous service date, the catch is that the service need to happen on the same week day. i.e. if the last service was on Friday 02-08-2013 and it is a monthly service, the next service is due on Friday 06-09-2013. Is there any way that this can be done? PS there are various service periods such as bi-weekly, weekly, 2 weekly, monthly, 2 monthly etc.
View 2 Replies
View Related
Jul 10, 2005
Here is what I want to do:
I'm organising 15 training events, for 60 participants. These 15 training events fall in three themes: running, swimming, cycling. So there are 5 training events held on running, 5 on swimming, 5 on cycling. Each has on average 4 participants, but in reality, some have 6, some 2.
Everybody has to attend each of the three themes, so three of the 15 events.
I have a table called "events". each record contains data on a certain event (place, date, speaker, participants,...)
I have a table of 60 participants, with: their names, their age
Per event, I want to indicate who is participating, with a combobox. Now, the number of participants per event is not limited, so it could be 5 or 30.
Also, it could be nice if the combobox content is limited to the people that haven't been selected yet. So if John Doe is already taking the swimming training in event Swimming1, if I pull down the list of participants in event Swimming2, I do not want to see John Doe's name there.
Also, I want to calculate the average age of all the participants of a certain event.
I want to print out two reports:
1) per training event, an overview
2) per participant, an overview of all the events he has inscribed to
How do I go about this?
Currently I am using 30 comboboxes, and 30 fields in the table "events", called participant1, participant2, participant3,..., participant30
But it is becoming messy, and when I ask for a report per participant, he only gives me the details for the people in participant1.
View 9 Replies
View Related
Oct 7, 2005
Right this is a fundamental issue for me here and I cant get my head around the problem!!!
The database I am working on is a database which records the training courses (run by the NHS) which staff at GP surgeries in our area have attended and acts as a booking system for them.
So we have the obvious tables - one for courses (including the name, cost, etc) and then one for course dates (linked by courseID) and one called training_record which contains who went to what when.
It seems simple but it has come to my attention that for example, "Course A" may in fact take place over 2 days, which could be a week apart. The surgeries are billed in one invoice, i.e. Course A would be £100 for 2 days.
How would you recommend I have this data? I can see all sorts of confusion arising... :(
The only way I have thus far thought would be to put each one in like:
course name: cost date
Course A: day 1 £100 - 29/10/2005
Course A: day 2 n/a - 6/10/2005
Course A: day 1 £100 - 01/11/2005
Course A: day 2 n/a - 08/11/2005
However this seems long winded as some courses may be a few days long and this means adding each person to multiple ones!!!!
Any assistance with getting my head around this would be ace! :)
View 1 Replies
View Related
Feb 15, 2006
Is just me, or are all of the events on tab control tabs disabled?
View 3 Replies
View Related
Jun 23, 2006
Access front end, SQL Server backend.
----
I have a continuous subform (part of a tab control on a main form) whose name and sourceobject are both "sbfCannulae". There are about 10 fields on the subform, and all are bound to fields in a table. The primary key of this table must be generated by combining two other fields, which must happen just before the record is saved. (I know calculated data should not usually be saved in tables, but trust me. In this case it is necessary.)
Right now the user COULD enter data into the primary key-bound textbox, but since the user is me, I make sure not to do that.
When I enter data into all fields except the primary key, I get an error because the primary key cannot contains nulls...of course.
I use the following code to tell me when an event has been triggered.
Code associated with sbfCannulae:
Option Compare Database
Private Sub Form_Activate()
MsgBox "cann activate"
End Sub
Private Sub Form_BeforeInsert(Cancel As Integer)
MsgBox "cann before insert"
End Sub
Private Sub Form_BeforeUpdate(Cancel As Integer)
MsgBox "cann before update"
End Sub
Private Sub Form_Current()
MsgBox "cann current"
End Sub
Private Sub Form_Dirty(Cancel As Integer)
MsgBox "cann dirty"
End Sub
When I enter data into a new record, the Dirty event is triggered, but I cannot for the life of me figure out how to trigger any of the other events. No combination of values and nulls in any fields, clicking in other tabs, clicking to other records, or using the navigation buttons will ever trigger any events but Dirty.
The only msgbox I ever get is the one giving delivering the SQL error about the primary keys not taking null values.
What am I doing wrong?
-Matt
View 1 Replies
View Related
Sep 10, 2006
Dear friends
I request your comments please...
I have a form with bound and unbound fields and have linked the [Event Procedure] on these fields base on there respective action.
Now when I open or click a particular field with the event procedure, the procedure is names are like -
Private Sub Rate_Exit(Cancel As Integer) or
Private Sub Quantity_Exit(Cancel As Integer)
but others events are name like Private Sub Quantity_Enter() simple. Why is that ms access (Cancel As Integer) uses only for specific events only.
View 1 Replies
View Related
Oct 1, 2004
I have a main form that calls several other forms for the user to input data. When the user closes one of the sub forms I would like to know what event is fired when the main form gets the focus back. I have tried several different events and can not figure out which one will work. Hopefully someone knows the answer I'm going crazy tring to figure it out, oh wait I'm already there.
Thank you
View 3 Replies
View Related
Mar 16, 2007
I have a database in which people add little bits to different fields as they go. For instance, person 1 puts in appointment, person 2 verifies info for the customer, person 3 checks the customer in, person 4 takes their money. What I am trying to do in a form is track the time when each department accessed it, and which user. I can do this on a new record, but for some reason, I can't get the event properties to work correctly on my form. I have a field for each department set aside for when they update their part of the record. What I am trying to do is, when the record is updated, having the time autopopulate the field.
Example:
Appointments enters |DATE OF APPT| |TIME OF APPT| Appointment timestamp should = time()
Verification enters |PATIENT INFO| |VERIFIED y/n| Verification timestamp should = time()
Reception enters |PULL TAB#| |CHECKED IN y/n| Reception timestamp should = time()
Cashier enters |AMOUNT COLLECTED| Cashier timestamp should = time()
All of these fields are on the same database (I have 2 linked tables: Customer demographics and appointments linked one to many by account # for the customer), and obviously, there's a lot more to it, but this is just a short example of what each department will enter. Appointments starts the appointment, so their timestamp will work, as they are starting new record. However, all of the following departments will be adding to this appointment record. When the other departments open their form with the fields in which they will be filling out, I want it to timestamp when they update the record as well as inserting their login "currentuser()" into the "updated by?" field for each department. For some reason, when I put time() into the event portion the field, it doesn't work. I tried it on dirty, on exit, after update, and it just doesn't update. Am I missing something?
View 5 Replies
View Related
Jun 19, 2005
Hi guys, ..and girls ;)
i have a calendar that works like a charm, but i would like to add the possibility to add recurrent events in it.
for instance if a user has to perform a task at a choosen time schedule, it is shown in the agenda, like each week or each two weeks or each month.
Anybody any idea how i would aproach this problem or has a sollution?
Thanks
View 1 Replies
View Related
Aug 19, 2005
Hi everyone,
I try to implement a function that looks for broken references in my Access project, so that I won't need to modify the needed references for every workstation. Here's my problem: Where could I put the call of this function so that this code will run before trying to compile the forms and, as a result, avoiding the compile error that access pops-up when a reference is broken or missing.
Thanks in advance! :D
View 1 Replies
View Related
Jun 23, 2007
I have a series of events that have a start date and an end date. How do I write an append query to append an event to a table as an individual event for every day in the given range?
View 2 Replies
View Related
May 13, 2005
I have a start and end date fields plus a txt box called wDays.
I'm trying to make sure the user puts in both dates but end cant be earlier than start and vs versa....
If not provide a message as to which is missing....
If alls well do the calulation with the module "GetWorkDays"
I f everything goes bad, dont save the record at all!
I have this behind a cmdButton. Used to unhide the wDays field because it displays #error otherwise...and to do the calculation... with the BeforeUpdate
Private Sub Command8_Click()
If IsNull(Me.sDate) Then
MsgBox "Please enter a Start Date"
ElseIf IsNull(Me.eDate) Then
MsgBox "Please enter a End Date"
Else
If Me.eDate < Me.sDate Then
MsgBox "End Date cannot be earlier than the Start Date"
Exit Sub
End If
End If
Me.Requery
End Sub
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim myDays As Integer
If IsNull(Me.eDate) Or IsNull(Me.sDate) Then
Me.wDays.Visible = False
Else
Me.wDays.Visible = True
myDays = GetWorkDays([sDate], [eDate])
Me.wDays.Value = myDays
End If
End Sub
Any help would be really appreaciated because I have tried many combonations of code placement to get it working correctly....
View 1 Replies
View Related
May 26, 2005
Hello all:
I have a split, shared database in which the Before and AfterUpdate events on my forms are not working at all. I tried setting a breakpoint to verify this and, sure enough, they are not firing.
Does anyone have any clue as to why this may be occurring?
Thanks so much for the help. I have tried searching the forum with no luck.
View 2 Replies
View Related
Aug 15, 2005
I have a form with a number of controls with code behind - this works as required.
However, recently I decided to use a tabbed control to hold the controls and simply cut/pasted these control onto one of the pages of the tab control. The events now no longer fire as they did and I have no functionality on the form - the code still exists in the design of the form though..... any ideas?
View 1 Replies
View Related
Aug 15, 2005
Hello all,
I have a form where I want to validate enties before moving off the record.
I put my validation in the BeforeUpdate event of the form. If validation fails, then I set Cancel=True. So far, so good.
But if the user closes the form (either with my close button, or the standard close button), or presses 'Page down' to move to the next record, then even if validation fails, the form will close (or move record). What I want is for the user to be left with the form open, on the current record.
Can someoneon point me in the right direction ?
Thanks,
StepOne
View 1 Replies
View Related
Sep 27, 2005
Ii there such a thing as events fired by Navigation?
I have a Form displaying records in a Datasheet which has a Navigation
control and I need to be able to detect when the User selects various parts of this control.
View 1 Replies
View Related
Mar 3, 2005
please help!
I have added a calendar into my site, I have a new table in my access database called: Cal
I want to ADD AN EVENT
The records I have in that table are:
eventID
eventTitle
eventDesc
eventDate
so I designed my ADD NEW EVENT form
my problem is:
what do I put in the form for eventDate (3 select form fields? Day/Month/Year?) it doesn't work??!
View 3 Replies
View Related
May 20, 2014
I am just starting find my way around Microsoft Access However I am currently stuck on something to do with table events (data macros).I added a Before Change and After Update macro to a table and added a RaiseError method to each of them.
I tried to update a record in the table. A dialog appears corresponding to the Before Change method. I deleted the Before Change method and then once again tried to update the table. No dialog box appears The After Update macro does not seem to fire.I tried all the other "After Events" and nothing seems to fire.
View 1 Replies
View Related
