MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 user for debug purposes. Why? It's similar to javascript's message box or confirm box, only Android let's you redesign the dialog. For my purposes I have used an XML as the layout. How? This displays a standard Ok/cancel message popup which you attach...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 user and for it to replace a displayed image in an ImageView. How? More as a reference for myself but this displays an AlertDialog designed by an XML layout file ("res/layout/dialog_edititem_photo"). The ImageView exists in another XML with an...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 "popup window", "height=150,width=300"); If you want to do this on the click of a link, include the URL parameter zc_LoadIn=dialog: Click Here to Popup my Notification Dialog Additional This is optional but it allows your client/users to edit the text...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Making a CD copy with only one drivehttps://www.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 which is a minimum of a CD Writer and you want to make a copy of a CD. Insert original CD in the drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER Right-click on the CD drive and select OPEN Go to EDIT > SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 Report, which in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below as it was copied from...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 Setup project, View -> User Interface. For both the install and administrative install, right-click on End and select "Add Dialog". Select the "read me" dialog. Drag the "read Me" page to be above the "Finished" page.

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 Deactivate the account by deselecting "include this account when receiving mail or synchronising" in the account properties dialog. Add an account by selecting 'Accounts' tab and then clicking on 'Email' with the plus sign. Add your account and tick...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 to different buttons on the toolbar. Ctrl+Shift+J Opens Developer Tools. Ctrl+Shift+Delete Opens the Clear Browsing Data dialog. F1 Opens the Help Center in a new tab (our favorite). Address bar shortcuts Use the following shortcuts in the address bar:...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 for IE7 Run the "iexplore.exe" program found in the IE6 download to run IE6. It will return v7 on the "about" dialog but I felt this was because I already had IE7 installed. Note that a lot of websites have reported that installing IE7 standalone breaks...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 on the Excel Format Options when you export the report. Because our report is exported via a web-based system, this extra dialog doesn't appear when our users export their reports. Not that it solved it as only some different headers appeared on the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 Go to Tools > then select "Take a picture". Wait a few seconds (default is 15) for the program to do it's business and a dialog should alert you when it's done. To see the image it created, go to File > and then select "Open Images Folder". Help If you...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $010D Const WM_IME_ENDCOMPOSITION = $010E Const WM_IME_COMPOSITION = $010F Const WM_IME_KEYLAST = $010F Const WM_INITDIALOG = $0110 Const WM_COMMAND = $0111 Const WM_SYSCOMMAND = $0112 Const WM_TIMER = $0113 Const WM_HSCROLL = $0114 Const WM_VSCROLL =...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 with the parameters specified just after the name of the procedure. The trick is not to use any of these and to use the GUI dialog of the "Dataset Properties" for that stored procedure. The variable values will be prefixed with @ for SQL Server and not...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 and then expand that instance. Right-click the database to change, and then click Properties. In the Database Properties dialog box, click the Options page. From the Restrict Access option, select Single. If other users are connected to the database, an...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 specify the Variable "User::SourceExtractFile" (based on this example) and keep the Index at 0 (zero). OK to close the dialog Edit your Data Flow as per usual, selecting your dynamic connection manager as the Flat File Source. Done.

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 as a system administrator > Go to Setup > Users > Click the pencil icon (top-right most) to edit any profile On the user's dialog/popup in the bottom left, there will be a link saying "Manage Fields" Add a picklist field type called "Department" with...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 hover over the function you just made and select "REST API" Enable both OAuth and REST API Click on "Save" to close the dialog box Client script to show/hide tabs Login as a ZohoCRM administrator and go to Setup > Developer Hub > Client Script > New...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Display a thumbnail of a Google Drive videohttps://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 on, it will display a link such as: https://drive.google.com/open?id=, where is the file ID. If not the "Share with Others" dialog will popup and the file ID will be in the link: https://drive.google.com/file/d//view?usp=sharing, where is the file ID.

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB