How do automatic sequence number in Crystal Report (Visual Basic 2008)

(Thai Version)

A sequence of numbers we found in numerous reports in daily life. We see how the number sequences automatically in the report in Crystal Report.

Step
1. Open or create a report to report.
2. Field Explorer, right-click "Running Total Fieids" - New

3. Configuration.
3.1 Select Field to set (number 1).
3.2 Click to select Custom Field values (number 2).
3.3 Select "Type of summary" to set (number 3).
3.4 Set "Evaluate"  (number 4).
3.5 Set "Reset" (number 5).
3.6 Click OK. 
 

4. Drag the Field to the area to the report.

 

5. Testing program will work as needed.

Applied to the report.

Thank you,
Worawut  Bunwang

Code does not ask Login ID and Password in the Crystal Report (Visual Basic 2008)

 

Programmers to develop applications with Crystal Report would have a problem ask the Login ID and Password while processing program before opening the report.

We see the sample code to solve the problem, ask to not reporting hours.

The code to solve the problem.

Variables in the code.

strServernameRpt = name server connection

strDatabaseNameRpt = name database

strUserNameRpt = username

strPasswordRpt = password


When the test program again. Program Login ID and Password do not ask anymore.

Thank you,

Worawut  Bunwang

(Thai Version)

NetBeans™ IDE 6.8

NetBeans™ IDE 6.8 offers best-in-class support for the entire Java™ Platform Enterprise Edition 6 specification and the Sun GlassFish™ Enterprise Server v3 platform. Simplify Java application development with Java EE 6 language features: less XML configuration and more POJO-like development; easily target and deploy to GlassFish v3.

NetBeans IDE continues to be the tool of choice for top development languages, and this release includes new features and improved support for PHP 5.3 and the Symfony framework, the latest JavaFX™ SDK 1.2.1, C/C++, Ruby, Maven and more. Integration with Project Kenai, a collaborative environment for hosting open-source projects, now offers full support for JIRA, as well as improved issue tracker integration. As always, the NetBeans Platform provides a rock-solid application framework that can save years of development time.
Supporting Java EE 6 improvements first, NetBeans IDE 6.8 boosts developer productivity and lets developers take advantage of today's latest languages and platform features.
NetBeans IDE 6.8 is available in English, Brazilian-Portuguese, Japanese and Simplified Chinese.

Release Highlights

Java Enterprise Edition 6

• JavaServer™ Faces 2.0 for web interfaces and the ability to use EJB™ software in web applications
• Java Persistence JPA 2.0 and RESTful web services support
• Deployment, debugging and profiling with GlassFish v3

JavaServer Faces 2.0 (Facelets)

• Code completion, error hints, namespace completion, documentation popups, and tag auto-import for Facelets
• Editor support for Facelets libraries, composite components, expression language

JavaFX

• Support for JavaFX SDK 1.2.1
• Improved navigation, code completion, and editor hints

PHP

• PHP 5.3 support
• Symfony framework support

Kenai.com: Connected Developer

• Full JIRA support
• Improved issue tracker integration

Maven

• Improved support for Java EE 6, Groovy, Scala projects
• Customizable dependency exclusion in dependency graph

Ruby

• Support for Rails 2.3.4 apps with dispatchers, JRuby 1.4, Ruby 1.9 debugging, RSpec 1.2.7
• Improved rename refactoring, type inference, and navigation

C/C++

• Profiling: New Thread Microstates indicator and Thread Details view
• Faster synchronization during remote development

Download NetBeans IDE 6.8

Thank you,
Worawut  Bunwang

Windows Live Writer tool for bloggers

Windows Live Writer tool for bloggers. Easily as Windows Live, Wordpress, Blogger, LiveJournal, TypePad, and many others (http://download.live.com/writer)

We tested the same
Set the following for our blog
1. When you open the program first will set up wizard.And click Next to setup.

2.Select a blog to set (if a blogspot to select "Other blog service").And click Next.

3.Set your blog's URL, Username and Password, then click Next.

4. Application process.

5. If no error to name the program will let “Blogs nickname” which is the default, then click Finish.

6. We are ready to write a blog.


7. Bloggers successfully. The final step is distribution. Click the toolbar "Publish", then the program will be processed to Upload. What if no error, we will be able to publish works on demand.

Tool of choice interesting. For Bloggers.

Thank you,
Worawut  Bunwang

Set Cursor moves to the desired location in VB2008

Writing the code requires Cursor moves to the desired location that is writing code to facilitate users in data entry program. Steps are as follows

Samples : when the input "Serial No." Then Paul hit the keyboard "Enter" and then to move the Cursor "Task No."


Step.

1. Into writing code objects to do is sample "txtSerial" event "KeyDown".
2. Writing code has the following 2 formats.
 Option 1 The name of the object to move the Cursor

 
 
Option 2 Use "Sendkeys" will work as we hit the keyboard "TAB" This must be set to the number of Tab Index sorted correctly with.

 

 

Applied to work to get the program easier to use.
Thai Version
Thank you,
Worawut   Bunwang

"Google" I received your letter and then.

Thank you very much,
Worawut  Bunwang

Convert files from MS Access2007 database is SQL Server 2005

Convert files from MS Access2007 database is SQL Server 2005
  that can be done easily. We learn to do the following steps.
1. Open MS Access database file you want converted.
2. Select toolbar Database Tools -> SQL Server.

3. Select "Create new database" and click the command button "Next".

4. Set Database Sever, Login ID, Password and database name and click the command button "Next".

5. Select the Table to convert and click the command button "Next".

6. Click the command button "Next".

7. Click the command button "Next".

8. Click the command button "Finish".

9. Application process to convert the database to SQL Server.

10. Program will report results showing the conversion database to SQL Server.

11. What if no error, we will have a database SQL Server as needed.

Applied work!!!
Caution : Must be more careful what type of data that is being converted to check around to get the maximum performance, such as size, type of data.

Thank you,
worawut   bunwang
( Thai Version )

Software Engineer

Today I recommend blog about software engineering, especially the development team of my own.
http://se-th.blogspot.com/
thank you,
Worawut  Bunwang

Touch wall : Menu on the table (developed by Thai people)

Yesterday I activity to "The New Efficiency" organized by Microsoft (Thailand) in a range of lectures offered Techno Touch wall technology that made way "Menu on the table",which can select and order food. Developed by Thai people.

I support this idea. Hope to develop and can be used in daily life in Thailand.

Thank you,
Worawut Bunwang

How to resolve error: Procedure or Function has too many arguments specified in VB 2008.

If you find an error "Procedure or Functionhas______________too many arguments" specified in VB 2008 (database : SQL Server) now I have a solution.

RESOLUTION: to add a line. SqlCommand Name.Parameters.Clear ()

Try to fix the error.

Thank you,

Worawut  Bunwang

Writing the code C / C + + The old and new tools.

I write code for parallel C / C + + by using the same tools, Visual C + + 6.0 and using the new Visual Studio 2008, I think that might be useful for inexperienced programmers and Student computer lines.

Visual C + + 6.0
Ex1_1

 
 

 
 
Visual Studio 2008
ex1_2

Example 2 has the same results.

Thank you,

Worawut   Bunwang

Introduced the concept of The New Efficiency

Introduced the concept of The New Efficiency in the form of seminars and demonstrations in positive solutions. Tuesday, November 17, 2552 at Queen Sirikit National Convention

Introduced the concept of The New Efficiency in the form of seminars and demonstrations. Positive solutions by bringing the products of Microsoft to strengthen performance together perfectly. Helping to reduce costs and improve efficiency of processes is also part of the launch of several new products including Windows 7, Windows Server 2008 R2, Exchange Server 2010, System Center and Microsoft Forefront.

The event will be held on Tuesday, November 17, 2552 at the National Convention Center Rio BANGKOK SPORTS CLUB. From 9:00 am to approximately 17:30 pm with no charge. Which will have an appropriate topic. The IT Manager, IT Professional and Developers to come up with a down and out the Technet and MSDN it here with. And the solution. Partner of Microsoft, all you have to touch also. Do not forget to have met at. Prior to the launch of Windows Server 2008 R2 on this new work in The New Efficiency this will take us to introduce the features of Windows Server 2008 R2 together a few write. Windows Server 2008 R2 has been developed to work with Windows 7 that makes the work more effective. With costs down. Resulting from technological importance. Virtualization and User Experience in a superior edge over the original. With new features like Branch Cache, Direct Access and AppLocker to allow different areas to work quickly. And easy to manage. The administrator of the company.

Sort in MS Excel format: Leave the cell or cell box space (not a simple type)

     Today I presented in MS Excel Tip sequence which forms the desired cell or cell box space (not a simple type)

Steps are as follows
1. Insert cells to 2 cells, using formulas in MS Excel cells in the first sequence. And set the default to make the cell sorting patterns, an example is Cell A and B, respectively.

2. Cell type formula in the desired order by model example is the Cell B7:
=IF(MOD(A5,2)=1,A5+1,"")

3. Copy the formula as needed.

4. Select the first cell and set the hide.

5. You can format as needed

Try applied job.

Thank you,
Worawut  Bunwang

Google Analytics : enterprise-class web analytics made smarter, friendlier and free

Enterprise-class web analytics made smarter, friendlier and free.

Google Analytics is the enterprise-class web analytics solution that gives you rich insights into your website traffic and marketing effectiveness. Powerful, flexible and easy-to-use features now let you see and analyze your traffic data in an entirely new way. With Google Analytics, you're more prepared to write better-targeted ads, strengthen your marketing initiatives and create higher converting websites. ( http://www.google.com/intl/en/analytics/features.html )

Thank you,
Worawut  Bunwang

Books for developers Visual C++

     I am developing with MS Visual  Studio 2008 I think is a tool for developers to be highly effective learning.


Today, I recommend the book fun to read about these 2 books.
 
     1. Visual C++ 2008

     2. Visual C++ 2005

I think this book should occupy no one owns. Next time I will come to view demo.
Thank you,
Worawut  Bunwang