Assuming note is required, the following 303 results were found.
-
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub Splitbook() Dim xPath As String xPath = Application.ActiveWorkbook.Path...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
wrong way round, the compass cable seems to go across the unit unless I have the top sticker wrong Legs on Checking vents (note I had masked these before painting as per youtube videos) Possibly my new facebook profile photo My old FC40 looking new(ish)...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
List: Car Notebook Mini-USB mouse (wired) Norton Ghost USB Drive for storage (backing up clients pc) USB Drive with drivers/software/portable apps USB Dongle connecting to an Internet Provider OS disks Document Templates: Service Agreement Template...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
from https://goodereader.com/blog/kindle/here-is-how-you-can-read-pdf-files-on-the-amazon-kindle which I wanted to take note of as it is a process that worked at time of print (6 June 2022) and I wanted to make sure it didn't just disappear or be...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
was step 2 in the below. Otherwise I would always get the error {"code":2,"message":"The request passed is not valid."} Note this is on the EU domain and with the updated Zoho Books API endpoints: /* {"code":2,"message":"The request passed is not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
ones including an invokeUrl and then a colleague gave me the following. I hope it helps someone else out there too... Note that connection zbooks has zohobooks.fullaccess.all and this code is on the EU datacenter: info item; // yields {the correct...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
Basically so that you can set all those SEO settings in the global configuration tab to YES. Note: you need the permissions to rename the file ("htaccess.txt" to ".htaccess" in your website root folder). You'll need ftp access or a file manager with...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
three special characters _ (underscore) . (dot) - (dash) BASE64 Forces the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This article is a quick note on how to change your Joomla CMS "Read More" to "Register to Read More" all without hacking away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for...
- Type: Article
- Author: Joel Lipman
- Category: Microsoft
- Language: en-GB
-
I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories >...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *