Search This Blog

Wednesday, January 7, 2015

Sencha ExtJS , Ext.Component Class

Base class for all Ext components. All subclasses of Component may participate in the automated Ext component lifecycle of creation, rendering and destruction which is provided by the Container class. Components may be added to a Container through the items config option at the time the Container is created, or they may be added dynamically via the add method.

The Component base class has built-in support for basic hide/show and enable/disable and size control behavior.

All Components are registered with the Ext.ComponentManager on construction so that they can be referenced at any time via Ext.getCmp, passing the id.

All user-developed visual widgets that are required to participate in automated lifecycle and size management should subclass Component.

See the Creating new UI controls tutorial for details on how and to either extend or augment ExtJs base classes to create custom Components.

Every component has a specific xtype, which is its Ext-specific type name, along with methods for checking the xtype like getXType and isXType. This is the list of all valid xtypes:

xtype            Class
-------------    ------------------
button          
Ext.button.Button
buttongroup      
Ext.container.ButtonGroup
colorpalette    
Ext.picker.Color
component        
Ext.Component
container        
Ext.container.Container
cycle            
Ext.button.Cycle
dataview        
Ext.view.View
datepicker      
Ext.picker.Date
editor          
Ext.Editor
editorgrid      
Ext.grid.plugin.Editing
grid            
Ext.grid.Panel
multislider      
Ext.slider.Multi
panel            
Ext.panel.Panel
progress        
Ext.ProgressBar
slider          
Ext.slider.Single
spacer          
Ext.toolbar.Spacer
splitbutton      
Ext.button.Split
tabpanel        
Ext.tab.Panel
treepanel        
Ext.tree.Panel
viewport        
Ext.container.Viewport
window          
Ext.window.Window

Toolbar components
---------------------------------------
paging          
Ext.toolbar.Paging
toolbar          
Ext.toolbar.Toolbar
tbfill          
Ext.toolbar.Fill
tbitem          
Ext.toolbar.Item
tbseparator      
Ext.toolbar.Separator
tbspacer        
Ext.toolbar.Spacer
tbtext          
Ext.toolbar.TextItem

Menu components
---------------------------------------
menu            
Ext.menu.Menu
menucheckitem    
Ext.menu.CheckItem
menuitem        
Ext.menu.Item
menuseparator    
Ext.menu.Separator
menutextitem    
Ext.menu.Item

Form components
---------------------------------------
form            
Ext.form.Panel
checkbox        
Ext.form.field.Checkbox
combo            
Ext.form.field.ComboBox
datefield        
Ext.form.field.Date
displayfield    
Ext.form.field.Display
field            
Ext.form.field.Base
fieldset        
Ext.form.FieldSet
hidden          
Ext.form.field.Hidden
htmleditor      
Ext.form.field.HtmlEditor
label            
Ext.form.Label
numberfield      
Ext.form.field.Number
radio            
Ext.form.field.Radio
radiogroup      
Ext.form.RadioGroup
textarea        
Ext.form.field.TextArea
textfield        
Ext.form.field.Text
timefield        
Ext.form.field.Time
trigger          
Ext.form.field.Trigger

Chart components
---------------------------------------
chart            
Ext.chart.Chart
barchart        
Ext.chart.series.Bar
columnchart      
Ext.chart.series.Column
linechart        
Ext.chart.series.Line
piechart        
Ext.chart.series.Pie

It should not usually be necessary to instantiate a Component because there are provided subclasses which implement specialized Component use cases which over most application needs. However it is possible to instantiate a base Component, and it will be renderable, or will particpate in layouts as the child item of a Container: Ext.Component component

    Ext.create('Ext.Component', {
        html
: 'Hello world!',
        width
: 300,
        height
: 200,
        padding
: 20,
        style
: {
            color
: '#FFFFFF',
            backgroundColor
:'#000000'
       
},
        renderTo
: Ext.getBody()
   
});

The Component above creates its encapsulating div upon render, and use the configured HTML as content. More complex internal structure may be created using the renderTpl configuration, although to display database-derived mass data, it is recommended that an ExtJS data-backed Component such as a {Ext.view.DataView DataView}, or {Ext.grid.Panel GridPanel}, or TreePanel be used.

Defined By

Config Options

CSS Class configs

 
The base CSS class to apply to this components's element. This will also be prepended to elements within this compone...
 
An optional extra CSS class that will be added to this component's Element (defaults to ''). This can be useful for ...
 

CSS Class to be added to a components root level element to give distinction to it via styling.

 

CSS class to add when the Component is disabled. Defaults to 'x-item-disabled'.

 
An optional extra CSS class that will be added to this component's Element when the mouse moves over the Element, and...
 

The class that is added to the content target when you set styleHtmlContent to true. Defaults to 'x-html'

Other Configs

 
A tag name or DomHelper spec used to create the Element which will encapsulate this Component. You do not normally ...
 
This config is intended mainly for floating Components which may or may not be shown. Instead of using renderTo in th...
 
true to use overflow:'auto' on the components layout element and show scroll bars automatically when necessary, false...
 
True to automatically show the component upon creation. This config option may only be used for floating components o...
 
The base CSS class to apply to this components's element. This will also be prepended to elements within this compone...
 
Specifies the border for this component. The border can be a single numeric value to apply to all sides or it can be ...
 
An optional extra CSS class that will be added to this component's Element (defaults to ''). This can be useful for ...
 

CSS Class to be added to a components root level element to give distinction to it via styling.

 
The sizing and positioning of a Component's internal Elements is the responsibility of the Component's layout manager...
 
Optional. Specify an existing HTML element, or the id of an existing HTML element to use as the content for this comp...
 

The initial set of data to apply to the tpl to update the content area of the Component.

 

Defaults to false.

 

CSS class to add when the Component is disabled. Defaults to 'x-item-disabled'.

 
Specify as true to make a floating Component draggable using the Component's encapsulating element as the drag handle...
 
Specify as true to float the Component outside of the document flow using CSS absolute positioning. Components such...
 
Specifies whether the floated component should be automatically focused when it is brought to the front. Defaults to ...
 
Specify as true to have the Component inject framing elements within the Component at render time to provide a graphi...
 

The height of this component in pixels.

 

Defaults to false.

 
A String which specifies how this Component's encapsulating DOM element will be hidden. Values may be 'display' : The...
 
An HTML fragment, or a DomHelper specification to use as the layout element content (defaults to ''). The HTML conten...
 
The unique id of this component instance (defaults to an auto-assigned id). It should not be necessary to use this ...
 
An itemId can be used as an alternative way to get a reference to a component when no object reference is available. ...
 
(optional) A config object containing one or more event handlers to be added to this object during initialization. T...
 
loader : Ext.ComponentLoader/Object

A configuration object or an instance of a Ext.ComponentLoader to load remote content for this Component.

 
Only valid when a sibling element of a Splitter within a VBox or HBox layout. Specifies that if an immediate siblin...
 
Specifies the margin for this component. The margin can be a single numeric value to apply to all sides or it can be ...
 
The maximum value in pixels which this Component will set its height to. Warning: This will override any size manag...
 
The maximum value in pixels which this Component will set its width to. Warning: This will override any size manage...
 
The minimum value in pixels which this Component will set its height to. Warning: This will override any size manag...
 
The minimum value in pixels which this Component will set its width to. Warning: This will override any size manage...
 
An optional extra CSS class that will be added to this component's Element when the mouse moves over the Element, and...
 
Specifies the padding for this component. The padding can be a single numeric value to apply to all sides or it can b...
 
An object or array of objects that will provide custom functionality for this component. The only requirement for a ...
 
An object containing properties specifying DomQuery selectors which identify child elements created by the render pro...
 
Specify the id of the element, a DOM element or an existing Element that this component will be rendered into. Not...
 
An XTemplate used to create the internal structure inside this Component's encapsulating Element. You do not normal...
 
Specify as true to apply a Resizer to this Component after rendering. May also be specified as a config object to b...
 

A valid Ext.resizer.Resizer handles config string (defaults to 'all'). Only applies when resizable = true.

 

A buffer to be applied if many state events are fired within a short period. Defaults to 100.

 
Specifies whether the floating component should be given a shadow. Set to true to automatically create an Ext.Shadow,...
 
An array of events that, when fired, should trigger this object to save its state (defaults to none). stateEvents may...
 
The unique id for this object to use for state management purposes. See stateful for an explanation of saving and re...
 
A flag which causes the object to attempt to restore the state of internal properties from a saved state on startup. ...
 
A custom style specification to be applied to this component's Element. Should be a valid argument to Ext.core.Eleme...
 

The class that is added to the content target when you set styleHtmlContent to true. Defaults to 'x-html'

 

True to automatically style the html inside the content target of this component (body for panels). Defaults to false.

 
True to automatically call toFront when the show method is called on an already visible, floating component (default ...
 
An Ext.Template, Ext.XTemplate or an array of strings to form an Ext.XTemplate. Used in conjunction with the data and...
 
The Ext.(X)Template method to use when updating the content area of the Component. Defaults to 'overwrite' (see Ext.X...
 

A set style for a component. Can be a string or an Array of multiple strings (UIs)

 

The width of this component in pixels.

Defined By

Properties

 

Read-only property indicating whether or not the component can be dragged

 
Optional. Only present for floating Components which were inserted as descendant items of floating Containers. Floa...
 
Read-only property indicating the width of any framing elements which were added within the encapsulating element to ...
 
@deprecated 4.0 Replaced by getActiveAnimation Returns thq current animation if this object has any effects actively ...
 
This is an internal flag that you use when creating custom components. By default this is set to true which means tha...
 
This Component's owner Container (defaults to undefined, and is set automatically when this Component is added to a C...
 

Read-only property indicating whether or not the component has been rendered.

 
Stops any running effects and clears this object's internal effects queue if it contains any additional effects that ...
 
Optional. Only present for floating Components after they have been rendered. A reference to the ZIndexManager whic...
Defined By

Methods

 
Component( Ext.core.Element/String/Object config) : void

 

 
addClass( String cls) : Ext.Component

@deprecated 4.0 Replaced by {link:#addCls} Adds a CSS class to the top level element representing this component.

 
addCls( String cls) : Ext.Component

Adds a CSS class to the top level element representing this component.

 

Adds a cls to the uiCls array, which will also call addUIClsToElement and adds to all elements of this component.

 
addEvents( Object/String o, String ) : void

Adds the specified events to the list of events which this Observable may fire.

 
addListener( String eventName, Function handler, [Object scope], [Object options]) : void

Appends an event handler to this object.

 
addManagedListener( Observable/Element item, Object/String ename, Function fn, Object scope, Object opt) : void

Adds listeners to any Observable object (or Element) which are automatically removed when this Component is destroyed.

 
addStateEvents( String/Array events) : void

Add events that will trigger the state to be saved.

 
afterComponentLayout( Number adjWidth, Number adjHeight, Boolean isSetSize, Ext.Component layoutOwner) : void

 

 
alignTo( Mixed element, String position, [Array offsets]) : Component

Aligns this floating Component to the specified element

 
animate( Object config) : Object
Perform custom animation on this object. This method is applicable to both the the Component class and the Element cl...
 
Applies the state to the object. This should be overridden in subclasses to do more complex state operations. By defa...
 
beforeComponentLayout( Number adjWidth, Number adjHeight, Boolean isSetSize, Ext.Component layoutOwner) : void
Occurs before componentLayout is run. Returning false from this method will prevent the componentLayout from being ex...
 
bubble( Function fn, [Object scope], [Array args]) : Ext.Component
Bubbles up the component/container heirarchy, calling the specified function with each component. The scope (this) of...
 
capture( Observable o, Function fn, [Object scope]) : void
Starts capture on the specified Observable. All events will be passed to the supplied function with the event name + ...
 

Center this Component in its container.

 

Removes all listeners for this object including the managed listeners

 

Removes all managed listeners for this object.

 
cloneConfig( Object overrides) : Ext.Component

Clone the current component using the original config values passed into this instance by default.

 

Destroys this stateful object.

 

Disable the component.

 
Handles autoRender. Floating Components may have an ownerCt. If they are asking to be constrained, constrain them wit...
 
doComponentLayout( Object width, Object height, Object isSetSize, Object ownerCt) : Ext.container.Container
This method needs to be called whenever you change something on this component that requires the Component's layout t...
 
doConstrain( Mixed constrainTo) : void
Moves this floating Component into a constrain region. By default, this Component is constrained to be within the c...
 

Enable the component

 
enableBubble( String/Array events) : void
Enables events fired by this Observable to bubble up an owner hierarchy by calling this.getBubbleTarget() if present....
 
This method finds the topmost active layout who's processing will eventually determine the size and position of this ...
 
findParentBy( Function fn) : Ext.container.Container
Find a container above this component at any level by a custom function. If the passed function returns true, the con...
 
findParentByType( String/Class xtype) : Ext.container.Container

Find a container above this component at any level by xtype or class

See also the up method.

 
fireEvent( String eventName, Object... args) : Boolean
Fires the specified event with the passed parameters (minus the event name). An event may be set to bubble up an Ob...
 
focus( [Boolean selectText], [Boolean/Number delay]) : Ext.Component

Try to focus this component.

 

Returns thq current animation if this object has any effects actively running or queued, else returns false.

 
getBox( [Boolean local]) : Object

Gets the current box measurements of the component's underlying element.

 

Provides the link for Observable's fireEvent method to bubble up the ownership hierarchy.

 

Retrieves the top level element representing this component.

 

Gets the current height of the component's underlying element.

 

Retrieves the id of this component. Will autogenerate an id if one has not already been set.

 
getInsertPosition( String/Number/Element/HTMLElement position) : HTMLElement
This function takes the position argument passed to onRender and returns a DOM element that you can use in the insert...
 

Gets the Ext.ComponentLoader for this Component.

 
getPlugin( Object pluginId) : Ext.AbstractPlugin

Retrieves a plugin by its pluginId which has been bound to this component.

 
getPosition( [Boolean local]) : Array

Gets the current XY position of the component's underlying element.

 

Gets the current size of the component's underlying element.

 
Gets the current state of the object. By default this function returns null, it should be overridden in subclasses to...
 

Gets the state id for this object.

 

Gets the current width of the component's underlying element.

 
Gets the xtype for this component as registered with Ext.ComponentManager. For a list of all available xtypes, see th...
 
Returns this Component's xtype hierarchy as a slash-delimited string. For a list of all available xtypes, see the Ext...
 
hasListener( String eventName) : Boolean

Checks to see if this object has any listeners for a specified event

 

Checks if there is currently a specified uiCls

 
hide( String/Element/Component animateTarget, [Function callback], [Object scope]) : Ext.Component

Hides this Component, setting it to invisible using the configured hideMode.

 
is( String selector) : Boolean

Tests whether this Component matches the selector string.

 
isDescendantOf( Ext.Container container) : Boolean

Determines whether this component is the descendant of a particular container.

 

Method to determine whether this Component is currently disabled.

 

Method to determine whether this Component is draggable.

 

Method to determine whether this Component is droppable.

 

Method to determine whether this Component is floating.

 

Method to determine whether this Component is currently set to hidden.

 

Returns true if this component is visible.

 
isXType( String xtype, [Boolean shallow]) : Boolean
Tests whether or not this Component is of a specific xtype. This can test whether this Component is descended from th...
 
nextNode( String selector, Object includeSelf) : void
Returns the next node in the Component tree in tree traversal order. Note that this is not limited to siblings, and...
 
Returns the next sibling of this Component. Optionally selects the next sibling which matches the passed ComponentQ...
 
observe( Function c, Object listeners) : void
Sets observability on the passed class constructor. This makes any event fired on any instance of the passed class a...
 
on( String eventName, Function handler, [Object scope], [Object options]) : void

Appends an event handler to this object (shorthand for addListener.)

 
previousNode( String selector, Object includeSelf) : void
Returns the previous node in the Component tree in tree traversal order. Note that this is not limited to siblings,...
 
Returns the previous sibling of this Component. Optionally selects the previous sibling which matches the passed Co...
 
relayEvents( Object origin, Array events, Object prefix) : void

Relays selected events from the specified Observable as if the events were fired by this.

 

Removes all added captures from the Observable.

 
removeCls( Object className) : Ext.Component

Removes a CSS class from the top level element representing this component.

 
Removes a cls to the uiCls array, which will also call removeUIClsToElement and removes it from all elements of this ...
 
removeListener( String eventName, Function handler, [Object scope]) : void

Removes an event handler.

 
removeManagedListener( Observable|Element item, Object|String ename, Function fn, Object scope) : void

Removes listeners that were added by the mon method.

 
Resume firing events. (see suspendEvents) If events were suspended using the queueSuspended parameter, then all event...
 
Ensures that all effects queued after sequenceFx is called on this object are run in sequence. This is the opposite ...
 
setActive( Boolean active, Component newActive) : void
This method is called internally by Ext.ZIndexManager to signal that a floating Component has either been moved to th...
 
setAutoScroll( Boolean scroll) : Ext.Component

Sets the overflow on the content element of the component.

 

Enable or disable the component.

 
setDocked( Object dock, Object layoutParent) : Component
Sets the dock position of this component in its parent panel. Note that this only has effect if this item is part of ...
 
setHeight( Number height) : Ext.Component

Sets the height of the component. This method fires the resize event.

 
setLoading( Boolean/Object/String load, Boolean targetEl) : Ext.LoadMask

This method allows you to show or hide a LoadMask on top of this component.

 
setPagePosition( Number x, Number y, Mixed animate) : Ext.Component
Sets the page XY position of the component. To set the left and top instead, use setPosition. This method fires the ...
 
setPosition( Number left, Number top, Mixed animate) : Ext.Component
Sets the left and top of the component. To set the page XY position instead, use setPagePosition. This method fires ...
 
setSize( Mixed width, Mixed height) : Ext.Component
Sets the width and height of this Component. This method fires the resize event. This method can accept either width ...
 
Sets the UI for the component. This will remove any existing UIs on the component. It will also loop through any uiCl...
 
setVisible( Boolean visible) : Ext.Component

Convenience function to hide or show this component by boolean.

 
setWidth( Number width) : Ext.Component

Sets the width of the component. This method fires the resize event.

 
show( String/Element animateTarget, [Function callback], [Object scope]) : Component
Shows this Component, rendering it first if autoRender or {"floating are true. After being shown, a floating C...
 
@deprecated 4.0 Replaced by stopAnimation Stops any running effects and clears this object's internal effects queue i...
 
suspendEvents( Boolean queueSuspended) : void

Suspend the firing of all events. (see resumeEvents)

 
Ensures that all effects queued after syncFx is called on this object are run concurrently. This is the opposite of ...
 

Sends this Component to the back of (lower z-index than) any other visible windows

 
toFront( [Boolean preventFocus]) : Component
Brings this floating Component to the front of any other visible, floating Components managed by the same ZIndexManag...
 
un( String eventName, Function handler, [Object scope]) : void

Removes an event handler (shorthand for removeListener.)

 
up( String selector) : Container
Walks up the ownerCt axis looking for an ancestor Container which matches the passed simple selector. Example: var ...
 
update( Mixed htmlOrData, [Boolean loadScripts], [Function callback]) : void

Update the content area of a component.

 
updateBox( Object box) : Ext.Component

Sets the current box measurements of the component's underlying element.

Defined By

Events

 

Fires after a Component has been visually activated.

 
added( Ext.Component this, Ext.container.Container container, Number pos)

Fires after a Component had been added to a Container.

 
Fires after the component rendering is finished. The afterrender event is fired after this Component has been rende...
 
Fires before a Component has been visually activated. Returning false from an event listener can prevent the activate...
 
Fires before a Component has been visually deactivated. Returning false from an event listener can prevent the deacti...
 

Fires before the component is destroyed. Return false from an event handler to stop the destroy.

 

Fires before the component is hidden when calling the hide method. Return false from an event handler to stop the hide.

 

Fires before the component is rendered. Return false from an event handler to stop the render.

 

Fires before the component is shown when calling the show method. Return false from an event handler to stop the show.

 
beforestaterestore( Ext.state.Stateful this, Object state)

Fires before the state of the object is restored. Return false from an event handler to stop the restore.

 
beforestatesave( Ext.state.Stateful this, Object state)

Fires before the state of the object is saved to the configured state provider. Return false to stop the save.

 

Fires after a Component has been visually deactivated.

 

Fires after the component is destroyed.

 

Fires after the component is disabled.

 

Fires after the component is enabled.

 

Fires after the component is hidden. Fires after the component is hidden when calling the hide method.

 
move( Ext.Component this, Number x, Number y)

Fires after the component is moved.

 
removed( Ext.Component this, Ext.container.Container ownerCt)

Fires when a component is removed from an Ext.container.Container

 

Fires after the component markup is rendered.

 
resize( Ext.Component this, Number adjWidth, Number adjHeight)

Fires after the component is resized.

 

Fires after the component is shown when calling the show method.

 
staterestore( Ext.state.Stateful this, Object state)

Fires after the state of the object is restored.

 
statesave( Ext.state.Stateful this, Object state)

Fires after the state of the object is saved to the configured state provider.

JQuery, How to pass parameters in get requests

Just use data option of ajax.. you can send data object to server by data option in ajax and the type which defines how you are sending it (either POST or GET)..default is get method

code

$.ajax({    url: "ajax.aspx",    type:"get", //send it through get method    data:{ajaxid:4,UserID: UserID , EmailAddress:encodeURIComponent(EmailAddress)}     success: function(response) {      //Do Something    },    error: function(xhr) {      //Do Something to handle error    }  });

and you can get the the datas by

 $_GET['ajaxid'] //gives 4   $_GET['UserID'] //gives you the sent userid



Hery - Freelance IT Trainer - 081223344506

Form Valiidation using Html 5 and Css3

Freelance IT Trainer, Bandung, jakarta, Bali, yogya

Tutorial

In HTML5 forms got a major upgrade with the addition of some simple, yet flexible validation attributes. To support these added attributes CSS3 also added several new pseudo selectors styling controls based on their validation state.

Adding validation

To illustrate the new attributes and some of the new input types, we'll be building up a simple sign up form. Every sign up form is essentially the same, you fill in your details and click submit. How many times has the form been reset on you after you've missed a required value or not provided a strong enough password?

initial

To help prevent this, the first attribute we'll be using is the required attribute. Adding this to a input box will prevent the form from submitting until a value has been provided.

<form name="signup-form">      <label for="firstname">Firstname:</label>      <input id="firstname" name="firstname" type="text" required />            <label for="surname">Surname:</label>      <input id="surname" name="surname" type="text" required />            <label for="email">Email:</label>      <input id="email" name="email" type="text" required />            <label for="website">Website:</label>      <input id="website" name="website" type="text" />            <label for="password">Password:</label>      <input id="password" name="password" type="password" />            <input type="submit" value="Signup!" />    </form>  

The next attribute we'll be adding is the autofocus attribute. This attribute automatically assigns focus to the form on page load. This is a simple enhancement, but one that makes life so much easier.

<input id="firstname" name="firstname" type="text" required autofocus />  

Next up is the placeholder attribute. This places a sample value or hint in the input box. Depending on the browser, clicking or typing in the input will automatically hide it, but it will re-appear if the input is emptied again

<input id="email" name="email" type="text" placeholder="jonny@schnittger.me" required />  

HTML5 also introduced a few new input types, the first one we'll be using is the email type. This performs basic validation on the value to ensure it meets standard email format rules.

<input id="email" name="email" type="email" placeholder="jonny@schnittger.me" required />  

Another input type that was added was the url type, as with the email type it makes sure that a valid url including http:// or https:// strings are included.

<input id="website" name="website" type="url" placeholder="http://schnittger.me" />  

The final attribute we'll be looking at is the pattern attribute. The pattern attribute allows you to specify a regular expression that will be used to validate the input value. This gives you the option of doing some pretty powerful client-side validation. In this example, we're going to make sure the password field has at least 1 lowercase, 1 uppercase value and is at least 6 characters long.

<input id="password" name="password" type="password" pattern="^.*(?=.{6,})(?=.*[a-z])(?=.*[A-Z]).*$" placeholder="******" required />  

One attribute that has been tweaked in Chrome and Opera is the title attribute. In Chrome/Opera the title attribute will be appended to the validation error message. This means you can slightly customize the message for your users.

The final form looks like this

<form name="signup-form">      <label for="firstname">Firstname:</label>      <input id="firstname" name="firstname" type="text" title="Please enter your firstname" placeholder="Jonny" autofocus required />            <label for="surname">Surname:</label>      <input id="surname" name="surname" type="text" title="Please enter your surname" placeholder="Schnittger" required />            <label for="email">Email:</label>      <input id="email" name="email" type="email" title="Please enter your email address" placeholder="jonny@schnittger.me" required />            <label for="website">Website:</label>      <input id="website" name="website" type="url" title="Please enter the url to your website (optional)" placeholder="http://schnittger.me" />            <label for="password">Password:</label>      <input id="password" name="password" type="password" title="Please enter a password, it must contain at least 1 lowercase and 1 uppercase character and be at least 6 characters in length" pattern="^.*(?=.{6,})(?=.*[a-z])(?=.*[A-Z]).*$" placeholder="******" required />            <input type="submit" value="Signup!" />    </form>  
invalid

Customizing validation styles

CSS3 introduced several new pseudo selectors to help style forms based on their validation state. We'll be looking at the following four

  • :invalid
  • :valid
  • :required
  • :optional

Using these selectors you can provide clear, visual guides to what exactly is incorrectly filled out in a form. Here I am styling invalid inputs with a red background and valid ones with a green background. I'm also providing a more complex selector to display and asterisk image in required inputs while maintaining the colored background. Finally I'm styling optional fields in a blue.

input:not([type=submit]):invalid {      background-color: #ffdddd;  }    input:not([type=submit]):valid {      background-color: #ddffdd;  }    input:not([type=submit]):invalid:required {      background: #ffdddd url('http://developerdrive.developerdrive.netdna-cdn.com/wp-content/uploads/2013/08/asterisk1.png') no-repeat right top;   }    input:not([type=submit]):valid:required {      background: #ddffdd url('http://developerdrive.developerdrive.netdna-cdn.com/wp-content/uploads/2013/08/asterisk1.png') no-repeat right top;   }    input:not([type=submit]):optional {      background-color: #add1ef;  }  
final

freelance IT Trainer , Hery - 081223344506

Jquery Mobile Dynamic Listview Tutorial Complete Refferences

Freelance IT Trainer , (Hery 081223344506)

  1. jQM - Dynamically Populate Listview from JSON - JSFiddle

    jquery.mobile-1.4.0-beta.1.min.js Remove; jquery.mobile-1.4.0-beta.1.min.css Remove ... <ul data-role="listview" id="movie-list" data-theme="a">. 10. 11. </ul>.
  2. How to populate a jQuery Mobile ListView with JSON data ...

    stackoverflow.com/.../how-to-populate-a-jquery-mobile-listview-with-jso...
    Aug 5, 2013 - Solution. Yes. Its possible to have two pages and use one for displaying your data and one to show up the details of the clicked item. I had to pull in ...
  3. Populating jQuery Mobile ListView with local JSON data ...

    stackoverflow.com/.../populating-jquery-mobile-listview-with-local-json-...
    Feb 19, 2014 - First of all, the return JSON array is wrong, values (properties) should be separated by commas. var data = [{ "name": "test", "calories": "1000", "fat": ...
  4. Generate listview with json jquery mobile - Stack Overflow

    stackoverflow.com/questions/.../generate-listview-with-json-jquery-mobil...
    Apr 15, 2013 - Try this code, $(document).on('pageshow', '#page', function(){ $("#page div:jqmData(role=content) #matches ul").empty(); $.getJSON("test.php" ...
  5. jquery mobile json listview - all the list loaded at one time ...

    forum.jquery.com/.../jquery-mobile-json-listview-all-the-list-loade...
    jQuery
    Dec 31, 2013 - 6 posts - ‎4 authors
    jQuery Support Portal. ... jQuery: Write Less, Do More. jQuery · Plugins · UI · Meetups · Forum · Blog · About · Donate · All Forums · Recent Posts ...
  6. jQueryMobile – JSON feed and dynamic list | John Chacko

    Apr 17, 2013 - How to dynamically populate a jQueryMobile listview from JSON data? Here is a sample application using google news feed and populating ...
  7. jQuery Mobile - Listview | Intel® Developer Zone

    Sep 11, 2013 - Please refer to the jQuery Mobile and jQuery overview articles for .... components of the listview based on the expected JSON data format.

Jual Rumah di Bandung

 
Dekat Cicaheum Bandung, Giri Mekar Permai Cijambe
Jual Rumah - Dekat Cicaheum Bandung, Giri Mekar Permai Cijambe
LB /LT : 80 /119 , Kamar Tidur : 3, Kamar Mandi : 2 , Carport/parkir area: Ada
Instalasi aktif terpasang :
Telepon Internet TV Kabel AC
Χ Χ Χ
Komplek Giri Mekar Permai Blok B Cijambe Ujung Berung
Jawa Barat , Bandung , Cijambe Ujung Berung
Rp 650.000.000 ( Kisaran harga 600 juta - 1 Milyar )
Tanggal Iklan : 30-Dec-14 13:46 wib. Dilihat 46 kali
* Hubungi pemilik iklan melalui Telepon/HP atau Email atau Langsung ke Lokasi

Hotel Murah di Bandung

Cari ,Hotel, Murah, Bintang, sekitar , dekat, dengan, dago, riau , setiabudi, trans studio, pvj mall, lembang, stasiun bandung, husein, bip, banda, kampung gajah, cimahi, jatinangor, ujung berung, cicaheum, soekarno hatta, leuwi panjang, cibaduyut, tangkuban perahu, rumah mode, cipaganti, sukajadi, supratman, gedung sate,

Bandung Hotels, hotwl murah, bandung

Rumah Aria Graha
Rates start from :
USD 76
IDR 744,800
Jl. Aria Barat 3 No 7
Bandung Indonesia

Rumah Dyandra
Rates start from :
USD 98
IDR 960,400
Jl. Pasirjaya V No. 13
Bandung Indonesia

Villa Istana Bunga 6 Bedrooms
Rates start from :
USD 621
IDR 6,085,800
Jl. Kolonel Masturi KM 9 Parompong
Bandung Indonesia



Freelance IT and Management , Personal Trainer, Bandung, Jakarta, Bali, Yogya , 081223344506

Hery Purnama is a Freelance IT and Management , Personal Trainer, Bandung, Jakarta, Bali, Yogya , Call/ sms 081223344506, PinBB - 7DC633AA , hery.purnama@gmail.com , http://freelance-it-trainer.blogspot.com,  15 years experience as Certified Trainer


MANAGEMENT TOPICS
Hery Purnama Management Freelancer Personal Trainer :
Project Management, Marketing, CRM, HR/SDM, Asset & Logistic, Finance , Leadership, Communication, Team Building

IT TOPICS
Hery Purnama IT Freelancer Personal Trainer :
Android Jquery Mobile - phonegap, Excel VBA Macro, MS. Access VBA Programming, Google Map API V.3, Google SketchUp 3D, SMS Gateway, Sencha ExtJS, PHP Ajax Jquery, PHP Yii Framework, Code Igniter, Project Management, Microsoft Project , Oracle DBA, SQL Server DBA, MySQL DBA, Visual Foxpro, VB.Net, ASP.net, Python Desktop and Web Programming , ITIL Foundation V.3 (2011) , RDBMS - Databas Concept, Web Design Concept , UML , Corel Draw, Adobe Photoshop, Adobe Dreamweaver , Adobe Director, Adobe Fireworks, Adobe Flash, Action Script, Lingo Script, Etc.

Most of demands are for Excel VBA Macro , Project Management with MS. Project , Mobile Apps Development for Android using PHP Jquery Mobile and Phonegap

For inquiry do not hesitate to contact me at : 081.223344.506


Thanks,

Regards,
Hery Purnama

SEO , Top Keyword Research 2015

Google's Hummingbird update created a lot of anxiety, but ultimately, it could be a good thing for the industry, because it frees us from the tyranny of competing for a limited number of top keywords. Essentially, the role of the Hummingbird algorithm is to better answer those longer-tail queries users are typing in Google. If your pages are optimized for these more conversational queries, you have a better chance of top rankings. Try a new, niche-based approach to keywords, which allows you to double or even triple the list of profitable keywords in your SEO arsenal.

This article explains the four steps for doing keyword research the modern way, using SEO PowerSuite or other tools.
1. Ideas:

Most search marketers simply think of the main keywords related to their businesses, plop them into a tool like Google Keyword Planner, and then run with the keyword list it delivers. However, search habits vary widely: Searchers may use hundreds of different word combinations to describe the same thing, so this tactic omits hundreds of potentially profitable keywords.

Instead, try a more creative, ideas-based approach to your research. For example, if you hear the phrase office furniture, some associations you may have are chairs, tables, equipment, cubicles, or office design.
Related articles

    5 SEO Strategies That Will Still Work in 2015
    Navigating Secure Search: From Keywords to Content [BrightEdge Share 14]
    How to Win in Organic Search: Tips from Google, Bing and Brands
    How to do SEO for Local Business, WITHOUT Content Marketing
    The 3Ps of Content Measurement: Page Rank, Traffic & Engagement

But none of those associations will show up in Google Keyword Planner, because it shows you only the most closely related search terms. To get ideas based on these niche associations, first use your brain: Come up with as many associations that you can. Check competitors' sites and blogs. You'll be able to find more keyword ideas and also spot if they target just the key phrases from the Google Keyword Planner or if they have a smart keyword strategy.

Next, turn to multiple research methods to come up with still more niche keyword ideas:

    Related searches in Google, Bing, and Yahoo
    Google auto-complete
    Yahoo Search Assist
    Competition Research harvests keywords from your top-ranking competitors' meta tags
    SEMRush provides keywords from its unique keyword database
    Word Mixer shuffles the keywords you enter to build more variants of phrases
    SEO PowerSuite's Rank Tracker automates the search-engine suggestion process

Other good sources for keyword ideas include forum discussions, dictionaries and the thesaurus, and Wikipedia topic categories and articles related to your topic. The more research methods you use, the better. Each method will generate new suggestions.
2. Words:

Now it's time to pick the keywords that are truly relevant. Go through the list and remove the terms that don't seem very relevant to your product or service – even if a keyword tool said they were. Effective as they are, automated keyword research tools are not humans, so the results need to be evaluated by you.

Why not just use the Google Keyword Planner? Certainly, it's quick and easy, but it can be misleading. For example, the average monthly searches metric is just a rough estimate, not an accurate indicator of search volume. As well, search volume can vary widely from month to month. For example, seasonal keywords like "Christmas gifts" may get 350,000 searches in December and 100 in June. Meanwhile, the competition metric reflects the number of advertisers bidding on that keyword; if you're doing organic SEO, this metric can be pretty useless.

Instead, focus on longer, less popular keyword phrases. Those long-tail phrases don't receive huge search volumes, but they are less competitive, so it's easier for you to squeeze into the top 10. They tend to be more targeted and therefore better-converting. As a bonus, they already include the competitive short-tail words, so when you optimize for long-tail, you also optimize for the shorter, "head" words.

If you're looking for keyword phrases that will convert, choose words that signal commercial intent, rather than a hunt for information. Look for quick-sale words including buy, coupon, discount, deal, cheap, or shipping. Product-description words that people use to find out more about the products they are already interested in include review, best, and top 10, as well as product categories, specific products, and brand names.
3. Analysis:

Now that you've developed a solid list of potential keywords and phrases, it's time to do some analysis. Instead of relying on the old search-volume metric, use the more robust keyword effectiveness index (KEI) and Keyword difficulty score to see how hard it'll be to rank for a keyword. These metrics take several niche-based factors into account, thus giving you an opportunity to prioritize your keywords based on their difficulty.

Additionally, you can detect keywords with higher commercial intent by looking at their estimated cost-per-click bids. Some keywords cost multiples more compared to other related ones. This means that more people compete for these words in Google AdWords, since they bring them more conversions and sales.
4. Competition:

To finalize your list of keywords, you need to understand how hard it will be to outrank competitors for each of them. This is the best way to evaluate your true opportunities.

Here are the factors that you need to check for within the top-ranking pages in the search results for your main keywords in Google:

    Backlinks – Identify the backlinks to the search landing page. The search engines consider backlinks as votes for a certain page, so the more links your competitor has, the harder it may be to outrank this site.
    On-page SEO – Evaluate the quality of on-page optimization of the competing pages by scanning their titles, descriptions, content, and internal link anchors.
    Content - Users love unique and useful content - and so does Google. Inspect competitors' page for quality content.
    Domain authority - Finally, check the age of the competing domains, their Alexa rank, and their popularity in social media.

If you are just beginning your modern SEO strategy, you may want to remove all keywords that your competitors have ranked for, even if the KEI is good. With millions of sites competing for rankings for a given keyword, it will take you a while to rank high for the term. Also discard keywords and phrases with the worst KEI; these terms have both intense competition and low search volume, so optimizing for them is not worthwhile at this point.

Out of the remaining keywords, choose the ones with the best KEI. You should now have a list of lucrative, low-competition keywords that will bring you lots of conversions.

If you're struggling with the research, let Rank Tracker easily find these keywords for you. For more information on how to use Rank Tracker to find the best-performing keywords and phrases, read our Ultimate Guide to Keyword Research with Rank Tracker. Happy hunting




Requoted by


SISINDOTEK - IT Training & Solution Provider
Office 1 : Jl. Pelajar Pejuang 45 No.23 , Lt.2 Bandung - Jawa Barat
Office 2 : Jl. Sukasenang VI-6B Bandung - Jawa Barat 40124
Tel. 022-71242266, SMS. 0812.8733.1966
info@sisindotek.com , YM. sisindotek

Monday, January 5, 2015

Ms. Excel , INDIRECT function for dynamic range

INDIRECT Formula used to Total a Dynamic Range of Values

This example is based on the data shown in the image above.

The SUM - INDIRECT formula created by using the tutorial steps below is:

=SUM(INDIRECT("D" &E1& ":D" &E2))

In this formula, the nested INDIRECT function's argument contains references to cells E1 and E2. The numbers in those cells, 1 and 4, when combined with the rest of INDIRECT's argument, form the cell references D1 and D4.

As a result, the range of numbers totaled by the SUM function is the data contained in the range of cells D1 to D4 - which is 50.

By changing the numbers located in cells E1 and E2; however, the range to be totaled can be easily changed.

This example will first use the above formula to total the data in cells D1:D4 and then change the summed range to D3:D6 without editing the formula in cell F1.

MS Excel, Create Running total with SUM

If you're using worksheet formulas, instead of a pivot table, there's nothing built in that will automatically create a running total for you. Fortunately, with a simple SUM formula, you can calculate the running total in each row, to see how your bank account is doing.

Use the SUM Function

In this example, there are withdrawal and deposit amounts in cells C2:C6. We could use the SUM function to total the amounts in column C, and that would give us the current total.

sumcolumn

Instead, we'll use the SUM function in each row, to calculate the running total. We'll be able to see the total after each withdrawal and deposit.

The formula in cell D2 is: =SUM(C$2:C2)

sumrunningtotal01

That $ sign locks the reference to row 2, at the start of the sum, so it doesn't change when the formula is copied down to cell D6.

The ending cell – C2 – is a relative reference, so the ending point changes for each row. For example, in cell D6, the formula shows C6 as the ending cell for the SUM formula.

sumrunningtotal02

MS Excel, Cara membuat saldo berjalan


Berikut adalah cara menghitung saldo berjalan  di Microsoft Excel :

  1. Langkah pertama anda membuat microsoft excel kemudian pilih worksheet yang tersedia atau anda dapat mengisikan data di workbook.
  2. Kemudian anda dapat menambahkan garis sehingga terbentuk tabel pada laporan anda. Caranya anda dapat blok semua data kemudian klik garis untuk membuat tabel.
  3. Selanjutnya pada kolom saldo anda dapat menambahkan rumus, yaitu misalnya datanya  dengan =IF(OR(D2<>0;E2<>0);SUM($D$2:D2)-SUM($E$2:E2);0) . Dengan keterangan kolom debet yang terdapat pada sel D2, kemudian kredit pada sel E2. Dan masukkan kode tersebut di sel F2. Pada dasarnya Anda dapat menyesuaikan kolom debet dan kredit dengan tabel sehingga menganti kode sesuai dengan data yang terdapat di tabel anda. Sedangkan bagi anda yang akan menambah penjumlahan saldo maka anda dapat mengarahkan kursor ke arah bawah kemudian tunggu hingga berubah menjadi +, selebihnya click and drag.

Itulahh cara yang dapat anda lakukan untuk menghitung saldo berjalan di Microsoft Excel sehingga membantu proses kerja anda lebih mudah.

Freelance personal trainer jakarta, bandung, surabaya, semarang, bali, singapore


Hery Purnama +62.81.223344.505 , pinbb : 7dc633aa ,freelance personal trainer for management, marketing, IT, excel vba macro, android phonegap, Sencha extjs, code igniter, yii framework, google map api, google sketchup 3d, php ajax jquery, uml, rdbms concept, project management, ms project, ms access, excel for accounting, ITIL , oracle dba, sql server, VB.net , asp.net, sms gateway, marketing strategy. Pengajar freelance , 15 years experience and certified trainer Call +62.81.223344.506 for invitation or goto http://freelance-it-trainer.blogspot.com

Sunday, January 4, 2015

Excel VBA , Clear Table Formatting

Using the code on Worksheets with only one table you could just use the index number instead of the name:

ActiveSheet.ListObjects(1).TableStyle = ""

Istilah akuntansi dalam Bahasa Inggris

Buat Anda yang sedang buat aplikasi Akuntansi , muingkin istilah berikut membantu

Aktiva = asset
Aktiva bersih = net asset
Aktiva lancar = current assets
Aktiva tetap = fixed assets
Aktiva tetap berwujud = tangible fixed assets
Aktiva tetap tidak berwujud = intangible fixed assets
Akumulasi = accumulation
Akumulasi penyusutan = accumulated depreciation
Akumulasi penyusutan bangunan = accumulated depreciation of building
Akumulasi penyusutan kendaraan = accumulated depreciation of vehicle
Akumulasi penyusutan mesin = accumulated depreciation of machinary
Akumulasi penyusutan peralatan = accumulated depreciation of equipmen
Akun = account
Akuntansi = accounting
Akuntansi anggaran = budgeting
Akuntansi biaya = cost accounting
Akuntansi kemasyarakatan = social accounting
Akuntansi keuangan = financial accounting
Akuntansi manajemen = management accounting
Akuntansi pemerikasaan = auditing
Akuntansi pemerintahan = government accounting
Akuntansi perpajakan = tax accounting
Arus kas = cash flow
Asuransi bayar dimuka = prepaid insurance

B
Bangunan = building
Barang dagangan = merchandise
Barang siap jual = goods available for sale
Beban = expense
Beban administrasi dan umum = administrative and general expense
Beban asuransi = insurance expense
Beban bunga = interest expense
Beban dibayar dimuka = prepaid expense
Beban gaji = salaries expense
Beban iklan = advertise expense
Beban komisi = commission expense
Beban luar usaha = non operating expense
Beban pajak = 
tax expense
Beban penjualan = selling expense
Beban penyusutan = depreciation expense
Beban penyusutan kendaraan = depreciation expense of vehicle
Beban penyusutan peralatan = depreciation expense of equipment
Beban perlengkapan = supplies expense
Beban sewa = rent expense
Beban usaha = operating expense
Beban yang masih harus dibayar = accrued expensed
Biaya angkut pembelian = freight in/transportation in/carriage inward
Biaya angkut penjualan = freight out/transportation out/carriage outward
Bukti pembelian = purchase invoice
Bukti penjualan = sales invoice
Bukti-bukti dokumen = source of document
Buku besar = ledger
Buku besar pembantu piutang = account receivable subsidiary ledger
Buku besar pembantu utang = account payable subsidiary ledger
Buku besar tambahan/pembantu = subsidiary ledger
Buku besar umum = general ledger
Buku persediaan = stock ledger sheets

D
Debitur = debtor
Debet = debt

E
Efek/surat berharga = marketable securities

F
Faktur = invoice

H
Hak atas kekayaan = equities
Hak cipta = copyright
Hak perolehan = historical cost/at cost
Harga pokok penjualan = cost of goods sold

I
Iklan dibayar dimuka = prepaid advertising
Ikhtisar laba rugi = income summary
Investasi tambahan = additional investment

J
Jatuh tempo = maturity
Jurnal = Journal
Jurnal khusus = special journal
Jurnal koreksi = correction entries
Jurnal pembalik = reversing entries
Jurnal penerimaan kas = cash receipt journal
Jurnal pengeluaran kas = cash disbursement/cash payment journal
Jurnal penjualan = sales journal
Jurnal penutup = closing entries
Jurnal penyesuaian = adjustment entries
Jurnal umum = general entries

K
Kartu persediaan = stock card
Kartu piutang = debtors account
Kas di bank = cash in bank
Kas di tangan = cash on hand
Kekayaan = property
Kekayaan bersih = net worth
Kertas saham = worksheet
Keuntungan saham = dividend
Kewajiban = liabilities
Kewajiban jangka panjang = long term liabilities
Kewajiban lancar/jangka pendek = current liabilities
Konsep kesatuan usaha = business unit entity concept
Kredit = credit

L
Laba bersih = net income
Laba ditahan = retained earnings
Laba kotor = gross profit
Laba operasional = operating income
Laba penjualan aktiva = gain on sale of assets
Laba usaha = operating income
Laporan = report form
Laporan akuntansi = accounting statement
Laporan keuangan = financial statement
Laporan laba rugi = income statement

M
Merek dagang = trademark
Mesin = machinary
Modal = capital
Modal akhir periode = ending capital
Modal awal periode = beginning capital
Modal pemilik = owner's equity
Modal pinjaman = debt capital
Modal saham = capital stock

N
Nama akun = account title
Nama baik = goodwill
Neraca = balance sheet
Neraca saldo = trial balance
Neraca saldo setelah pentupan = post closing trial balance
Neraca saldo setelah penyesuaian = adjusted trial balance
Nilai buku = book value
Nilai jatuh tempo = maturity value
Nilai masa kini = current value
Nilai residu = residual value
Nota debet/kredit = debt/credit memo

O
Obligasi utang = bond payable

P
Pabrik = manufacturing
Pajak penghasilan = income tax
Pembelian = purchases
Pembelian bersih = net purchase
Pembukuan = book keeping
Pembukuan berpasangan = double entry book keeping
Penafsiran = interpeting
Pencatatan = recording
Pendapatan = income/revenue
Pendapatan bunga = interest income/revenue/earned
Pendapatan jasa = fees income
Pendapatan jasa diterima dimuka = unearned service revenue
Pendapatan komisi = commission revenue
Pendapatan luar usaha = non operating revenue
Pendapatan sewa = rent income/revenue
Pendapatan sewa diterima dimuka = unearned rent
Pendapatan usaha = operating revenue
Pendekatan neraca = balance sheet approach
Pengelompokan = classifying
Pengeluaran = expenditure
Pengendalian persediaan = stock control
Pengikhtisaran = summarizing
Pengukuran = measuring
Penjualan = sales
Penjualan bersih = net sales
Penjualan kredit = sales on credit/credit sales
Penjualan tunai = cash sales
Penyusutan = depreciation
Peralatan = equipment
Periode akuntansi = accounting period
Periode fiskal = fiscal period
Perlengkapan = supplies
Persamaan dasar akuntansi = accounting equation
Persediaan akhir barang dagangan = ending inventory/stock
Persediaan awal barang dagangan = beginning inventory/stock
Perusahaan dagang = commercial enterprise/trading company
Perusahaan jasa = service enterprise
Perusahaan perorangan = proprietorship/ownership
Piutang bunga = interest receivable
Piutang usaha = account receivables
Pos-pos neraca = balance sheet items
Potongan dagang = trade discount
Potongan pembelian = purchase discount/discount received
Potongan penjualan = sales discount/discount allowed
Potongan tunai = cash discount
Prive = drawing/withdrawl

R
Retur pembelian = purchase return
Retur penjualan = sales return
Rugi bersih = net loss
Rugi operasional = operating loss
Rugi penjualan aktiva = loss on sale of assets

S
Saham = stock
Saldo akun = account balance
Saldo sisa = balance
Sewa dibayar dimuka = prepaid rent
Sistem akuntansi = accounting system
Sistem berkala/terus-menerus = perpetual system
Suku bunga = interest rast
Syarat pembayaran = credit term

T
Tanah = land
Tanda pemeriksaan = check mark
Tata buku berpasangan = double entry
Transaksi = transaction

U
Utang = debt
Utang bank = bank loan
Utang bunga = interest payable
Utang gaji = salaries payable
Utang hipotik = mortgage
Utang pajak = tax payable

W
Wesel bayar = notes payable
Wesel tagih = notes receivable

MS Access VBA how to open Excel File

Sometimes you need to open excel file from your ms access form, here is the code you may try..

Option Compare Database
Option Explicit


Sub OpenSpecific_xlFile()

    Dim oXL As Object
    Dim oExcel As Object
    Dim sFullPath As String
    Dim sPath As String
   
       
'   Buat Excel instance
    Set oXL = CreateObject("Excel.Application")
   
   
'  Handling control Property
    On Error Resume Next
    oXL.UserControl = True
    On Error GoTo 0
   
       
'   Full path file yang akan dibuka
    On Error GoTo ErrHandle
    sFullPath = CurrentProject.Path & "\FILECONTOH_INVOICE.xlsm"
   
   
'   buka file
    With oXL
        .Visible = True
        .Workbooks.Open (sFullPath)
    End With
   
   
ErrExit:
    Set oXL = Nothing
    Exit Sub
   
ErrHandle:
    oXL.Visible = False
    MsgBox Err.Description
    GoTo ErrExit
End Sub





Thanks

Hery (Freelance IT Trainer 081223344506)

Excel VBA activeworkbook refreshall WAIT until finished

Sometimes you need the delay or waiting excel VBA code till all the workbook refreshing methode is finished


For i = 1 To ActiveWorkbook.Connections.Count
    ActiveWorkbook.Connections(i).ODBCConnection.BackgroundQuery = False 'for odbc
    'ActiveWorkbook.Connections(i).OLEDBonnection.BackgroundQuery = False 'for oledb
    'MsgBox ActiveWorkbook.Connections(i).OLEDBConnection.BackgroundQuery
Next
    ActiveWorkbook.RefreshAll
   


Thanks,

Regards

Hery ( Freelance Excel VBA Trainer 081223344506)

Saturday, January 3, 2015

Freelance trainer excel vba macro , bandung jakarta

Hery Purnama 081223344505 , freelance inhouse excel vba macro, android phonegap, google map api, google sketchup 3d, php ajax jquery, project management, ms project, ms access, excel for accounting, ITIL , oracle dba, sql server, VB.net , asp.net, sms gateway, marketing strategy. Pengajar freelance inhouse berpengalaman 15 tahun and certified trainer

Call 081.223344.506 for invitation or goto http://freelance-it-trainer.blogspot.com