Creating a Microsoft Access 2010 Runtime App

Posted on September 20, 2012 by

Once you’ve got something working in Access you might want to make it available to others without buying a version of Access for everyone.  You can download Microsoft’s free “Runtime” version of Access for this purpose.  First, though, you’ll need to create a form with buttons or a Navigation form.  Set this form as the startup form (File, Options, Current Database, Display Form, select your menu form).  Now when users double click on the database file, your menu will come up and they can go from there.

To create a Navagation form, select the “Create” tab, then “Navigation”.  Click on the first button and change its name.  Then switch to Design mode, right click the button and select “Build Event…”, “Macro Builder”.  Now you can run a macro or ask for a certain form or table using “OpenForm”, “OpenTable”, etc.  Add other buttons to expose useful forms, tables, and so on.  This menu form will always be available in the upper left corner of Access’s menu bar when you’re loaded with the Runtime version.

Posted in Uncategorized | Comments Off

Introduction to Using Eclipse Debugger with PHP

Posted on September 9, 2012 by

Eclipse PHP – VC6 Build, 32 bit
New, PHP Project
1. Start Eclipse and select c:\inetpub\wwwroot as workspace.

2. Select File -> New –> Project –> PHP Project

3. Type the name of the folder that contains the source files into the Project Name field.
(Note I have not tried this with folders that are hidden deep within the folder hierarchy),
e.g. “aClairWwb”

4. Choose “Create new project in workspace”.
Do not choose “Create project at existing location (from existing source”.

The following text is displayed: “The specified external location already exists.If a project is created in this location, the wizard will automatically try to detect existing sources and configure the buildpath appropriately.”

5. Click Finish.

The project should now have been created with your source files inside. I am not sure why the “Create project at existing location (from existing source” does not do this, but that is the way it works as of today.

Upper right, Click “Debug” for debugging or “PHP” for editing, error msgs In Debug context, look for panel with debug buttons, run (rt arrow head), step (down arrow), etc. Also look for panel called “Variables” and “Breakpoints”, select “Variables” In PHP context, look for tab “Problems” to see errors and warnings. Double click left column to toggle break point – or right click in left column Run, Debug As, PHP Application (or use button that looks like a bug) F5 step into F6 step over F7 out F8 resume running

Window, Preferences
PHP Executables – Add
c:\php\php.exe
c:\php\php.ini
CLI
XDebug
Call it “PHP 5.3.5″ or whatever

PHP, Debug
XDebug (9000)
Default PHP Web Server
Document root of server: http://localhost
Path Mapping
Path on server: /
Local path: c:\inetput\wwwroot

Name from above (“PHP 5.3.5″)

PHP.INI (c:\php)
——-
[xdebug]
zend_extension=”c:/php/modules/php_xdebug.dll”
xdebug.remote_enable=On
xdebug.profiler_enable=0ff

Posted in PHP, Programming | Comments Off

Introduction to Using Javascript in Eclipse

Posted on September 9, 2012 by 
Run Eclipse
    File, Change Workspace
File, New, Java Project
       "   Package
       "   Class
Upper right, Click "Debug" for debugging or "Java" for editing, error msgs       
    In Debug context, look for panel with debug buttons, run (rt arrow head),
            step (down arrow), etc.
        Also look for panel called "Variables" and "Breakpoints", 
             select "Variables"
    In Java context, look for tab "Problems" to see errors and warnings.
Double click left column to toggle break point - or right click in left column

Run, Debug As, Java Application  (or use button that looks like a bug)
    F5 step into
    F6 step over
    F7      out
    F8 resume running
Posted in JavaScript, Programming, Uncategorized | Comments Off

Javascript Change Text of a Control

Posted on September 9, 2012 by 
function changeText(id, text)
{
    var node1 = document.getElementById("id");
   if (node1.hasChildNodes()) 
   {
       node1.replaceChild(document.createTextNode(text), 
            node1.firstChild);
   } else {
       node1.appendChild(document.createTextNode(text));
   }
}
Posted in JavaScript, Programming, Uncategorized | Comments Off

Javascript Hide A Control

Posted on September 9, 2012 by

Hide a control:
document.getElementById(“myControlId”).style.display=”none”;

show it again:
document.getElementById(“myControlId”).style.display=”";

Posted in JavaScript, Programming | Comments Off

Javascript Strings Summary

Posted on September 9, 2012 by

Javascript Strings
charAt() Returns the character at the specified index
concat() Joins two or more strings, and returns a copy of the joined strings
indexOf() Returns the position of the first found occurrence of a specified value in a string
lastIndexOf() Returns the position of the last found occurrence of a specified value in a string
match() Searches for a match between a regular expression and a string, and returns the matches
replace() Searches for a match between a substring (or regular expression) and a string, and replaces the matched substring with a new substring
search() Searches for a match between a regular expression and a string, and returns the position of the match
slice() Extracts a part of a string and returns a new string
split() Splits a string into an array of substrings
substr() Extracts the characters from a string, beginning at a specified start position, and through the specified number of character
substring() Extracts the characters from a string, between two specified indices
toLowerCase() Converts a string to lowercase letters
toUpperCase() Converts a string to uppercase letters
valueOf() Returns the primitive value of a String object

Posted in JavaScript, Programming | Comments Off

Introduction to Debugging Javascript with Firefox Firebug

Posted on September 9, 2012 by

Quick Summary, How To get Firebug to show javascript errors…
Run Firefox and Install Firebug
Click on Firebug icon in upper right
Enable All Panels
Set “Firebug Location” to bottom
Refresh a page with javascript code (using Firefox Refresh icon or F5)
In the bottom panel
Click on “Script”
For external .js script files, select the down arrow in the title
bar above the page source to the right of the page name.
Select the .js file, right click in the source to set a breakpoint.
Click on the icon with the horizontal lines
(“Show Command Line Popup”)
Javascript errors will show up here in the command line now
Right click on source lines to set break point
Use the Run and Step buttons to debug.

Posted in JavaScript, Programming | Comments Off

Editing Problems in WordPresss

Posted on May 1, 2011 by

If you’re having problems with the text editor in WordPress and you’re using Internet Explorer, try using a different web browser, such as “Google Chrome” or “Firefox“. The new version of Internet Explorer, version 9, has some javascript problems with text editing it seems.  Firefox also works better for dragging widgets in the Widget area of the Dashboard of WordPress.

Go to the Firefox website

Posted in Featured, WordPress | Comments Off

Using Windows Live Writer to Blog

Posted on May 1, 2011 by

You can use Microsoft’s “Windows Live Writer” to create posts on your WordPress website. Here’s the link to install Live Writer:
http://explore.live.com/windows-live-writer?os=other

Install and start up the Writer. Select the upper tab, “Blog Account“, then “Blog Options“.
In the Blog options menu, enter: Blog Service: WordPress
Website address: Your WordPress website URL.
Enter your username and password for the WordPress dashboard.
Enter a title and some blog content. Then select the large “Publish” button in the Home tab. Go to the blog page of your website and find your new post.

To create another blog account, go to the Home tab and click on the WordPress icon and select “Add Blog Account”.

Posted in Featured, Programming, WordPress | Comments Off

Using PHP code in WordPress

Posted on April 30, 2011 by

You can use PHP code in WordPress without turning off the friendly text editor, which tends to scramble code. The scrambling is the problem with the PHP plugins that allow entering PHP code in the edit window. Using the “php-code-widget” plugin, on the other hand, allows you to move the code to new PHP widgets that are like text widgets. These custom widgets can then be dragged to the sidebar. Using another plugin, “widgets-on-pages“, allows you to insert your widget anywhere on a page using the “[widgets-on-pages ID=myLabel]” mechanism.

On the sidebar, use the PHP function is_page() to determine if it should appear on a certain page.

Here’s an example of including HTML code on the server side using PHP include. Drag a PHP Text Widget to the sidebar Widgets-on-Pages container, open it, and enter the code. The example page then just contains the “[widgets-on-pages ID=myLabel]” statement. See the results in the Example page.

?php 
    include (ABSPATH.'SampleTable.html');
?>
Posted in PHP, Programming, WordPress | Comments Off