Search results for query: *

Greetings, I am trying to auto-populate an email content to auto create an email. I am using Microsoft Lists (I am not a programmer). My employer only allows outlook office 365 to be used over the web so we are not using the local outlook which it if we were I was able to find a code to auto...

Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null" values... Basically sf_role_id PK is also at table st_useraccount_roles and tables st_user and st_useracount_roles have a matching PK named sf_user_id...

Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null" values... Basically sf_role_id PK is also at table st_useraccount_roles and tables st_user and st_useracount_roles have a matching PK named sf_user_id...

Hi Everyone, I had this thread on SQL Server forum and was told since I am using MySQL to ask for this request here: I am a newbie getting started with SQL and did some search online but so far have not been able to solve and gather the data I need. I need to get all users last login data so...

Hi Everyone, I am a newbie getting started with SQL and did some search online but so far have not been able to solve and gather the data I need. I need to get all users last login data so I may then delete user accounts that not logged in for a long time as I have reached the max license...

Hi Everyone, Will try my best to explain my situation. Below I have on column A data that repeats itself like AACE001N and so forth. In the same excel I have another sheet with data on column A which I need to match from the other sheet column A and then copy the data to sheet 1 column B...

Hi Support Team, I am running the below command in PowerShell and getting below error message but still the data gets copied over: PS C:\AWARDS> Get-Content .\AACE001N.txt | Foreach-Object { copy-item -Path $_ -Destination C:\AWARDS\AACE001N\} [highlight #CC0000]Copy-Item : Cannot bind...

Hi Support Team, I am running the below command in PowerShell and getting below error message but still the data gets copied over: PS C:\AWARDS> Get-Content .\AACE001N.txt | Foreach-Object { copy-item -Path $_ -Destination C:\AWARDS\AACE001N\} [highlight #EF2929]Copy-Item : Cannot bind...

Hi Everyone! I found below code online and would like to tweak it to do the following: Column A has multiple equal values and column B have different values I would like to have a code that will see the data on column A (which has multiple equal value) Find the range of equal value then create...

Hi Everyone, I have the below vba script (attached the spreadsheet), which is running perfectly, it does a loop on sheet name MID YEAR REVIEW looking for numeric values found on Funds then copy the data to another sheet named Nav Export, once it finds another numeric data from another fund it...

Hi Everyone, Below I have the following code and highlighted upon researching and tweaking the quarterly data I would like to retrieve but the results give me data from Oct 1st- Dec 28th 2016. I would like to be able if possible to change the year and quarter of the year so I may choose...

Hi Everyone! I have a priority column which can give only 3 different results (High or Normal or Low). I have another column named Hour Diff which gives me hours difference between date time difference from two other columns. Basically I would like to do the following: Based on Priority...

Hi I have the following macro script which is running as expected but I would like to add two more values to the export sheet named NAV Export. I have attached the spreadsheet which you can see that at the moment it is only giving me data from FUND 1 GENADMIN showed under the NAV Export sheet...

Hi I have the following macro script which is running as expected but I would like to add two more values to the export sheet named NAV Export. I have attached the spreadsheet which you can see that at the moment it is only giving me data from FUND 1 GENADMIN showed under the NAV Export sheet...

Hi Everyone, 1st, sorry for this long thread I have this power-shell script (made spiceworks user Martin900-Martin Pugh - https://community.spiceworks.com/scripts/show/2244-email-users-that-their-password-is-expiring) that gathers users AD that have their passwords expiring based on date(s) I...

thread68-1577295 Hi guys, I need to do the following: Sheet1 name: AD - Column A Sheet2 name: Exchange Mail - Column B I would like to to a search or a look up for matches on both columns and if there are matches, populate AD sheet column D with Yes otherwise with No. AD sheet Column A...

thread68-1577407 Hello Everyone! I took a look at the thread above and made the following code: This is the value located under column E203 CN=Oscarlemile,OU=Users,OU=Tanzania,OU=1_Africa,DC=TNS,DC=ORG I used this code under column AH203...

Hello everyone! I have the following fields: Name Date Terms Pay Date Marc 05/25/05 30 Nancy 05/21/05 60 Peter 05/23/05 20 Mary 04/21/05 90 Paul 03/01/05 120 Vinny 02/10/05 15 What I am trying to get is a calculation from the terms field and the Date field, to have the...

Hi all, I would like to have all my data sent to a microsoft word file from a continuous subform. At this moment I can only send one record. This is my code below: Private Sub Command143_Click() On Error GoTo markerr: Dim objWord As Word.Application Set objWord =...

I have been searching and I found out this code: objWord.ActiveDocument.SaveAs FileName:="C:\MyPath\" & [MyDocName.doc" It did not work, it is saying [compile error] [Syntax Error] I need to save each document using a field value[field name = Company] located under my current form. Private...