Results for "Author: chris shell"

From CShellVB http://www.cshellvb.com Change the style of a normal textbox so that it will only accept numbers. Better then evaluating keypress events and very fast. This call works on the fly and it is wrapped into a function for you.

I hate having to open my browser to access my Internet Favorites...urrg! So I wrote an application to run in the SysTray that lets me access my favorties anytime. Also, I hate having to open another link and it launches in the same window. This app lets you choose new window. You can also manage your favorites from this Application. I used a few samples from this site in this application and they are noted in the code. I hope you enjoy the application, if so, vote for me! Works with Internet Explorer 4.0 or greater only! Thanks, CShell www.cshellvb.com

Formats SQL Strings so that they can be placed into you code quickly and easily. How many times have you spent several minutes formatting a SQL statement in your code. You know, you get the SQL working in Access, SQLTalk, or Query Analyzer and then you need to add it to your code and make it do something. You have to store in a variable and in order to accomplish this you need to assign it to the variable. This means going line by line (and getting errors in VB) and formating the SQL statement so that it gets assigned to the variable. With my new program you never have to do that again! It does it all for you, check the screen shot and then start using it everyday! If you like it then vote for me and visit my site www.cshellvb.com! There is a Tool out there that does this (I won't mention the company here) but is part of a suite and costs $299! I did not need the suite so I wrote the tool myself!

Version 2.0 Bigger and Better! I had posted v1.0 yesterday but found some big improvments. The formater is now smarter when it comes to SQL. It knows where the SQL clauses are! Formats SQL Statements for you so they can be inserted into your code! Saves tons on time in development! - You create your SQL in whatever program is easy for you (i.e. Access, SQLPlus, TOAD, Notepad). - Then you launch FormatSQL - Then paste your SQL into the 'String to be Formatted' section. - Then choose your options and click on 'Format String'! - Now you select your output Clipboard or Notepad and hit 'OK' - The results are now ready in your desired location. - This program saves tons of time. I wrote out of a huge need of mine. I was sick of formatting SQL in the code window, it was tedious and redundant! I saw this program in another suite of tools that costs $299. Now you can have it for FREE! - Please Vote me if you like!

This code passes all form variables by creating hidden copies of every form variable that was passed to it. This is great for gathering information over multiples forms (i.e. Order Processing).

I hate having to open my browser to access my Internet Favorites...urrg! So I wrote an application to run in the SysTray that lets me access my favorties anytime. Also, I hate having to open another link and it launches in the same window. This app lets you choose new window. You can also manage your favorites from this Application. I used a few samples from this site in this application and they are noted in the code. I hope you enjoy the application, if so, vote for me! Works with Internet Explorer 4.0 or greater only! Thanks, CShell www.cshellvb.com

From CShellVB http://www.cshellvb.com Change the style of a normal textbox so that it will only accept numbers. Better then evaluating keypress events and very fast. This call works on the fly and it is wrapped into a function for you.

Formats SQL Strings so that they can be placed into you code quickly and easily. How many times have you spent several minutes formatting a SQL statement in your code. You know, you get the SQL working in Access, SQLTalk, or Query Analyzer and then you need to add it to your code and make it do something. You have to store in a variable and in order to accomplish this you need to assign it to the variable. This means going line by line (and getting errors in VB) and formating the SQL statement so that it gets assigned to the variable. With my new program you never have to do that again! It does it all for you, check the screen shot and then start using it everyday! If you like it then vote for me and visit my site www.cshellvb.com! There is a Tool out there that does this (I won't mention the company here) but is part of a suite and costs $299! I did not need the suite so I wrote the tool myself!

Version 2.0 Bigger and Better! I had posted v1.0 yesterday but found some big improvments. The formater is now smarter when it comes to SQL. It knows where the SQL clauses are! Formats SQL Statements for you so they can be inserted into your code! Saves tons on time in development! - You create your SQL in whatever program is easy for you (i.e. Access, SQLPlus, TOAD, Notepad). - Then you launch FormatSQL - Then paste your SQL into the 'String to be Formatted' section. - Then choose your options and click on 'Format String'! - Now you select your output Clipboard or Notepad and hit 'OK' - The results are now ready in your desired location. - This program saves tons of time. I wrote out of a huge need of mine. I was sick of formatting SQL in the code window, it was tedious and redundant! I saw this program in another suite of tools that costs $299. Now you can have it for FREE! - Please Vote me if you like!

MDB Code Generator What is it? This program generates code based on an access database. It creates snippets of code that are commonly needed in applications. The focus is on ASP code but many snippets will work in VB also. This is monotonous code and should not have to be written by brillant minds so i wrote an app to do the work for me....Real VB programmers don't write code they aquire it. Does it create applications? NO. It only creates poritons of code to assist in database developement. How do I use it? 1. Pick an Access database. 2. Choose a Table from the list or "All Tables" option. 3. Pick code type needed and fill in options. 4. Click "Generate Code" 5. Copy and Paste generated code as needed. What code does it make? Use it, look at the code and see for yourself. Basically it.... Creates Table Constants based on fields in tables (This is so you can use indexes rather than names which speeds performance.) Creates Varibles based on field names. Some people like to open a recordset, assign all fields to varibles then close the recordset and just use the varibles. Creates ASP Form Code. Just makes the assignment code (i.e. rs("fieldname") = Request.QueryString("fieldname")) Creates COM Interface code. Makes the assignement code as above, and the loading and saving code that you would have with a basic COM Interface. (i.e. objTable.fieldname = Request.QueryString("fieldname")) What is COM Interface? Take a VB class and come back later. Enjoy! Vote for me if you like. Give your feedback please, I can take it :)

This code passes all form variables by creating hidden copies of every form variable that was passed to it. This is great for gathering information over multiples forms (i.e. Order Processing).

From CShellVB http://www.cshellvb.com Change the style of a normal textbox so that it will only accept numbers. Better then evaluating keypress events and very fast. This call works on the fly and it is wrapped into a function for you.

I hate having to open my browser to access my Internet Favorites...urrg! So I wrote an application to run in the SysTray that lets me access my favorties anytime. Also, I hate having to open another link and it launches in the same window. This app lets you choose new window. You can also manage your favorites from this Application. I used a few samples from this site in this application and they are noted in the code. I hope you enjoy the application, if so, vote for me! Works with Internet Explorer 4.0 or greater only! Thanks, CShell www.cshellvb.com

Formats SQL Strings so that they can be placed into you code quickly and easily. How many times have you spent several minutes formatting a SQL statement in your code. You know, you get the SQL working in Access, SQLTalk, or Query Analyzer and then you need to add it to your code and make it do something. You have to store in a variable and in order to accomplish this you need to assign it to the variable. This means going line by line (and getting errors in VB) and formating the SQL statement so that it gets assigned to the variable. With my new program you never have to do that again! It does it all for you, check the screen shot and then start using it everyday! If you like it then vote for me and visit my site www.cshellvb.com! There is a Tool out there that does this (I won't mention the company here) but is part of a suite and costs $299! I did not need the suite so I wrote the tool myself!

Version 2.0 Bigger and Better! I had posted v1.0 yesterday but found some big improvments. The formater is now smarter when it comes to SQL. It knows where the SQL clauses are! Formats SQL Statements for you so they can be inserted into your code! Saves tons on time in development! - You create your SQL in whatever program is easy for you (i.e. Access, SQLPlus, TOAD, Notepad). - Then you launch FormatSQL - Then paste your SQL into the 'String to be Formatted' section. - Then choose your options and click on 'Format String'! - Now you select your output Clipboard or Notepad and hit 'OK' - The results are now ready in your desired location. - This program saves tons of time. I wrote out of a huge need of mine. I was sick of formatting SQL in the code window, it was tedious and redundant! I saw this program in another suite of tools that costs $299. Now you can have it for FREE! - Please Vote me if you like!

This code passes all form variables by creating hidden copies of every form variable that was passed to it. This is great for gathering information over multiples forms (i.e. Order Processing).

From CShellVB http://www.cshellvb.com Change the style of a normal textbox so that it will only accept numbers. Better then evaluating keypress events and very fast. This call works on the fly and it is wrapped into a function for you.

I hate having to open my browser to access my Internet Favorites...urrg! So I wrote an application to run in the SysTray that lets me access my favorties anytime. Also, I hate having to open another link and it launches in the same window. This app lets you choose new window. You can also manage your favorites from this Application. I used a few samples from this site in this application and they are noted in the code. I hope you enjoy the application, if so, vote for me! Works with Internet Explorer 4.0 or greater only! Thanks, CShell www.cshellvb.com

Formats SQL Strings so that they can be placed into you code quickly and easily. How many times have you spent several minutes formatting a SQL statement in your code. You know, you get the SQL working in Access, SQLTalk, or Query Analyzer and then you need to add it to your code and make it do something. You have to store in a variable and in order to accomplish this you need to assign it to the variable. This means going line by line (and getting errors in VB) and formating the SQL statement so that it gets assigned to the variable. With my new program you never have to do that again! It does it all for you, check the screen shot and then start using it everyday! If you like it then vote for me and visit my site www.cshellvb.com! There is a Tool out there that does this (I won't mention the company here) but is part of a suite and costs $299! I did not need the suite so I wrote the tool myself!

Version 2.0 Bigger and Better! I had posted v1.0 yesterday but found some big improvments. The formater is now smarter when it comes to SQL. It knows where the SQL clauses are! Formats SQL Statements for you so they can be inserted into your code! Saves tons on time in development! - You create your SQL in whatever program is easy for you (i.e. Access, SQLPlus, TOAD, Notepad). - Then you launch FormatSQL - Then paste your SQL into the 'String to be Formatted' section. - Then choose your options and click on 'Format String'! - Now you select your output Clipboard or Notepad and hit 'OK' - The results are now ready in your desired location. - This program saves tons of time. I wrote out of a huge need of mine. I was sick of formatting SQL in the code window, it was tedious and redundant! I saw this program in another suite of tools that costs $299. Now you can have it for FREE! - Please Vote me if you like!