incident

<tbody> A B C D E F 1 Name Date Time Incident Type Written description Action taken 2 Emma 05/08/19 14:00 Environmental I was walking across site and saw water gushing out of a pipe near the sheds at the back of the houses. Quite a large puddle had already deveoped and it...

* thats supposed to be 'after UNLOADING userform'... (not 'uploading') sorry, my bad. when the form is opened, it asks for a date range. when a commandbutton is selected, it gets the data from a worksheet ("Seatex Incident Log") and then copies it and pastes it onto a different worksheet...

I have 2 txt boxes on a form which are datepickers. txtDateBox2 is for entering the start date, and txtDateBox3 is for enterning the ending date. When cmdGetReport button is selected I need the code to filter the dates that are in column B on the worksheet ("Seatex Incident Log") in the set...

This isn't an "how do I do something" post (yet), but an "is it possible" post. I don't want to invest a lot of time and effort into trying to create something if it isn't possible, so I haven't even started creating a database yet. My background with MS Access is as a user, not a creator, so I...

I am trying to make an incident column in a log. I have the following formula in the table column cell (is a table so increments): =VLOOKUP(WHSELocation,Hidden!J2:K33,2,FALSE),ROW() Of course this is coming back in error. The idea is it is looking in 'WHSE Location" a name, it matches...

I am looking to extract the SN: from the Cell Regardless of the other Info in the Cell. Is this Possible? <tbody> Serial Number <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Summary Description [TSupport] Incident J3MH200000 routed to...

Hey guys, I'm totally new to Power BI and currently stucked with my work... For you it might only take a few minutes, but for me it would mean a forune! What I would like, to have a slicer that starts from "Service Created". So I only see the Services that has been created before the chosen...

when my userform opens up (it is executed by clicking on sheet tab named 'open edit form') a field is available that prompts the user to enter in a "Incident ID" number. If a match is found, then the form populates with the data from that particular row on the spreadsheet. But, if a match...

Hi there, just wondering if someone can assist, basically I have a spreadsheet containing approx 150,000 lines of event information along with each time a note was added to that particular event ID, Here is an example of a small part of that table <colgroup><col...

basically I cant get the equivalent of the RIGHT formula to work in VBA... Heres what i am trying to do: I have a textbox on a form that gets populated with the string: "INCIDENT ID#: 18-389" Where the '389' part is increased by 1 each time the form is opened (when opened it checks for the...

Hi, I have a column where in each cell there is a summary. I want to be able to delete all the text and number's to the left, including the colon, in the cell with the following text. Full description of Incident: The text before can vary in length. Formula, or VBA, as the column is...

I have text files with "Incident Reports" and would like to get them into Excel. I think this can be done via vba. Below is a sample of the text file that would be two reports. CASE SO11011111 * BLUNDO COUNTY SHERIFF'S OFFICE * PAGE: 1 INCIDENT REPORT INCIDENT TYPE: SUSPICIOUS_ACTIVITY______...

I have a sheet to log incidents and I would like to complete a sheet for daily statistics. For example, if one person (name in cell A1) attended an incident (data validated from a separate list in B1) then on a separate sheet, I would like a total amount of those incidents that the particular...