logged

Hey all, I got a few labels on my userform that are editable by users once they login. At the moment they can always change the labels. I would like to disable this until they are logged in. Someone knows what code i need to enable / disable the double click event on a userform?

Greetings! I have produced a query that shows only the names of employees who have not logged in. But, I want the query to also only give me the employees who have not logged in for the current date = Date(). How do I incorporate that into this query I have already produced : SELECT * FROM...

<tbody> a b c d e 1 User ID Login UTC Users 2 1 Yes No 1 3 1 Yes No 1 4 1 No No 1 5 2 No Yes 1 6 3 Yes Yes 1 7 4 Yes No 1 8 4 No No 1 9 5 No No 1 </tbody> What I need to try and work out is as follows as a formula for Column D is a follows :- Colums C is to ="No"...

Hi I have a project with about 240,000 rows of data and 23 columns. There are two columns that I need to compare dates to that are; Date Logged and Date Resolved. The date I compare them to are usually the first of each month from 2017 to present day. I need to track whether or not that case was...

We have a system that we are using to generate login and logout times throughout the day (that you can export to excel), and we also have a manual excel tracker that we use to input the time we logged out and logged back in and the reason we logged out at that time. Now, the official report is...

I just spent about 30 mins on a post and when I went to submit it I got a message saying I had been logged out and had to log in again. As a result, I lost my post. >> Why did it log me out !!!

Hello, I am creating a incident form using a user form, which will feed in data in sheet1 and sheet2. When the user submits the user form, all the data from the user form will be send to sheet 1 and only specific data will be sent to sheet 2. I would like to permanently hide sheet 1 from all...

Hi there, I have a dataset that has a Car ID (Unit ID), the time (and date) the driver logged in and the time (and date) the driver logged out. I am trying to calculate the number to unique units logged on during each 15 minute block of time each day and display it in a table with the date...

Hi, I am trying to evaluate a time value in a query with a calculated column. I have 2 columns; Login Polling Interval and Logout Polling Interval. If the record is considered logged in at 0600 then I want a 1 in the column. If the record is considered logged out at 0600 then I want a 0 in...

Hi All Hope you all are well I have 2 sets of data where agents are scheduled to do an activity and another set of data of what agents actually did I have listed a set of start and stop times for a paticular agent on that day Agents are assigned to a group so there could be 10 agents in...

I am working with a Log file and need to count the number "Days" each User has logged in, not the times the User has logged in. Column "A" contains the email address (Range Name ACCESS -- $A$2:$A$36595) Column "E" contains the date of access (Range Name TimeStamp $E$2:$E$36595) Separated by...

Hello, What I want to do is find the first instance of a "string" contained within a cell based on a grouping of other cells and return another cell... Looking at the table below, I want to find the first "Transfer" in column D for the group of specified ID's in Column A and return the value...

Hi, im currently attempting to create a sheet that logs times and i have the following: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Column = 1 And Target.Row > 1 Then Target.Cells.Offset(0, 1) = Date...

Hai all, I need some help in coding, 1. Code for login into web page. 2. After logging in to login page I need to click some buttons, this I will do multiple times, so, while running code it should check weather it is logging in or not, if it logged in it should go directly to inside the...

:) Hai all, I need some help in coding, 1. Code for login into web page. 2. After logging in to login page I need to click some buttons, this I will do multiple times, so, while running code it should check weather it is logging in or not, if it logged in it should go directly to inside the...

I have a spreadsheet where all the columns are dates and each row is the number of shifts logged by a given volunteer on each date. See <A HREF="http://www.awarewildlife.org/wp-content/uploads/2018/03/example-active-volunteers.jpg">cropped screenshot here</A>. I want a formula to go in AL1...

Good Day, I have a large spreadsheet with multiple columns taken from a data logger. The first column is a timestamp column that logs data every 15 minutes for a full 12 months. I needed to modify this column to reset all data logged between 12:00 and 17:00 so I used this formula...

Hello all, I have a worksheet which contains dates that people have been out on visits and wish to report how many times there was a visit occurrence within a particular month undertaken by a particular individual for a specific reason. Both the individual and reason are also logged on the...

Please go through this query, its quit long, but challenging I wanted a macro to login to a intranet site using my user name and password. I used early binding techniques and created new instance of IE. The code enters my user name and password in appropriate fields. However the login button did...