Results for "Author: richard mewett"
This utility is used to script a database. You can generate SQL Script for Query Analyser which is useful for migrating a JET (Access) database to SQL Server. You can also generate VB Source code to create a target database via DAO objects or DAO SQL Execute statements. I wrote this VERY quickly a few years back for a SQL migration project. I will update for ADO if anyone interested!
(Uploaded fixed zip) For adding filetypes to the Windows XP Search Tools Text Search. On Windows XP the facility to look for text within a file only works against filetypes that have a filter defined. This means that .BAS, .CLS, .CTL, .FRM, .VBP (etc.) files are NOT scanned. This utility allows filetypes that have no associated search filter to be searched with the standard Text Filter. I have knocked this up very quickly as one of my colleagues just asked me why he couldn't find a subroutine in our libraries on his new (Windows XP) machine when it was found on his old (Windows 98) machine! I hope it may be useful for someone else. NOTE: You can also remove a Filter association from a filetype but you should not do this unless you have a specfic reason! You must reboot the PC for the changes to take effect.
Very small code library containing some of the basic building blocks to get started in creating VB applications (not intended for experienced developers) Includes Get/Put Ini file, KeyPress filter, Folder Browser, File & Folder Exist functions & assorted control code. I may be off the mark with this one but I hope some may find it useful! Feedback is welcome (but please make it on the basis that this is a SAMPLE for LEARNING)
(Uploaded fixed zip) For adding filetypes to the Windows XP Search Tools Text Search. On Windows XP the facility to look for text within a file only works against filetypes that have a filter defined. This means that .BAS, .CLS, .CTL, .FRM, .VBP (etc.) files are NOT scanned. This utility allows filetypes that have no associated search filter to be searched with the standard Text Filter. I have knocked this up very quickly as one of my colleagues just asked me why he couldn't find a subroutine in our libraries on his new (Windows XP) machine when it was found on his old (Windows 98) machine! I hope it may be useful for someone else. NOTE: You can also remove a Filter association from a filetype but you should not do this unless you have a specfic reason! You must reboot the PC for the changes to take effect.
Very small code library containing some of the basic building blocks to get started in creating VB applications (not intended for experienced developers) Includes Get/Put Ini file, KeyPress filter, Folder Browser, File & Folder Exist functions & assorted control code. I may be off the mark with this one but I hope some may find it useful! Feedback is welcome (but please make it on the basis that this is a SAMPLE for LEARNING)
Fast API based file finder. Class scans a path (with Attributes, Mask, Date, Size filter properties) and returns the files & folders by raising events. Optionally scan nested sub-folders and sort results. Created to make File Utility creation very rapid. Hope it may be useful as example of API file handling and WithEvents. I welcome feedback!
- Updated in response to feedback 11 Nov 06 - Owner-drawn ComboBox that provides multiple columns in a ListView (in Report View) style display. Features include Item CheckBoxes, Item Images, dynamic Column Sorting/Resizing, Item Formatting (ForeColor, FontBold etc), datatype aware sorts, custom sorts and auto-scrolling (when mouse dragged out of control). Supports native XP Themes & emulation of XP/Office XP Themes. Feedback welcome (votes appreciated!) Credits in source for PSC authors who have helped make this possible. NOTE: This control has partial Unicode Support (Editable Mode does not support Unicode Data Entry due to VB TextBox) UPDATE: This Control was formerly called ComboView - renamed for consistency with my other controls.
This utility is used to script a database. You can generate SQL Script for Query Analyser which is useful for migrating a JET (Access) database to SQL Server. You can also generate VB Source code to create a target database via DAO objects or DAO SQL Execute statements. I wrote this VERY quickly a few years back for a SQL migration project. I will update for ADO if anyone interested!
Added FormatCells method for fast bulk formatting and per cell Fontname properties. Owner-drawn Grid. Features include CheckBoxes, Images, Multi-select, dynamic Column Sorting/Resizing, Cell Formatting (BackColor, ForeColor, FontBold etc), datatype aware sorts, custom sorts, Independent Row Heights, Word Wrap, Column Drag, Cell Images and auto-scrolling (when mouse dragged out of control). A Control Binding System allows external controls to be used for editing Cells (ComboBox, DateTimePicker etc). Supports native XP Themes & emulation of XP/Office XP Themes. Feedback welcome (votes appreciated!) Credits in source for PSC authors who have helped make this possible.
Two little MSFlexGrid enhancers. A single class adds simple Edit functionality. The principle is to make it quick and easy to update existing code and/or create new code in a consistent and resuseable way. The Subtotal Control allows a simple subtotal row for any combination of the columns. Please feel to modify as you need. As always feedback is welcome....
Fast API based file/folder scanner. Single File solution with no dependencies to add file processing to any Utility Project in single step. Scans a path (applying optional Attribute, Mask, Date and Size filters + multiple file extensions and simple pattern matching). Can also optionally scan nested sub-folders and/or sort results. Returns the files & folders by raising events. I originally created this a few years ago when I was creating many File Utilities. Hope it may be useful as example of API file handling and WithEvents. I welcome feedback (votes always appreciated)! UPDATE: Fixed a resource leak and simplified the use of extended file details.
Generates DBMS Scripts (SQL Server Query Analyser) or VB6 Source Code from a database. Uses either ADO or DAO to connect to database depending on the output required. Query Analyser scripting is useful for migrating a Jet (Access) database to SQL Server. It migrates Tables, Indexes & Constraints (for Default Values etc). The VB6 code generator produces ADO or DAO Object based code to create the database in code or create Class Objects to encapsulate the Tables. Also creates Project & module to integrate all the build code. I intend to expand the langauges and DMBS it can script to. Hope it may be useful to some! Feedback welcome and votes always nice ;) - 23 Nov 05 New Upload
This utility is used to script a database. You can generate SQL Script for Query Analyser which is useful for migrating a JET (Access) database to SQL Server. You can also generate VB Source code to create a target database via DAO objects or DAO SQL Execute statements. I wrote this VERY quickly a few years back for a SQL migration project. I will update for ADO if anyone interested!
(Uploaded fixed zip) For adding filetypes to the Windows XP Search Tools Text Search. On Windows XP the facility to look for text within a file only works against filetypes that have a filter defined. This means that .BAS, .CLS, .CTL, .FRM, .VBP (etc.) files are NOT scanned. This utility allows filetypes that have no associated search filter to be searched with the standard Text Filter. I have knocked this up very quickly as one of my colleagues just asked me why he couldn't find a subroutine in our libraries on his new (Windows XP) machine when it was found on his old (Windows 98) machine! I hope it may be useful for someone else. NOTE: You can also remove a Filter association from a filetype but you should not do this unless you have a specfic reason! You must reboot the PC for the changes to take effect.
Very small code library containing some of the basic building blocks to get started in creating VB applications (not intended for experienced developers) Includes Get/Put Ini file, KeyPress filter, Folder Browser, File & Folder Exist functions & assorted control code. I may be off the mark with this one but I hope some may find it useful! Feedback is welcome (but please make it on the basis that this is a SAMPLE for LEARNING)
This utility is used to script a database. You can generate SQL Script for Query Analyser which is useful for migrating a JET (Access) database to SQL Server. You can also generate VB Source code to create a target database via DAO objects or DAO SQL Execute statements. I wrote this VERY quickly a few years back for a SQL migration project. I will update for ADO if anyone interested!
(Uploaded fixed zip) For adding filetypes to the Windows XP Search Tools Text Search. On Windows XP the facility to look for text within a file only works against filetypes that have a filter defined. This means that .BAS, .CLS, .CTL, .FRM, .VBP (etc.) files are NOT scanned. This utility allows filetypes that have no associated search filter to be searched with the standard Text Filter. I have knocked this up very quickly as one of my colleagues just asked me why he couldn't find a subroutine in our libraries on his new (Windows XP) machine when it was found on his old (Windows 98) machine! I hope it may be useful for someone else. NOTE: You can also remove a Filter association from a filetype but you should not do this unless you have a specfic reason! You must reboot the PC for the changes to take effect.
Very small code library containing some of the basic building blocks to get started in creating VB applications (not intended for experienced developers) Includes Get/Put Ini file, KeyPress filter, Folder Browser, File & Folder Exist functions & assorted control code. I may be off the mark with this one but I hope some may find it useful! Feedback is welcome (but please make it on the basis that this is a SAMPLE for LEARNING)
This utility is used to script a database. You can generate SQL Script for Query Analyser which is useful for migrating a JET (Access) database to SQL Server. You can also generate VB Source code to create a target database via DAO objects or DAO SQL Execute statements. I wrote this VERY quickly a few years back for a SQL migration project. I will update for ADO if anyone interested!
(Uploaded fixed zip) For adding filetypes to the Windows XP Search Tools Text Search. On Windows XP the facility to look for text within a file only works against filetypes that have a filter defined. This means that .BAS, .CLS, .CTL, .FRM, .VBP (etc.) files are NOT scanned. This utility allows filetypes that have no associated search filter to be searched with the standard Text Filter. I have knocked this up very quickly as one of my colleagues just asked me why he couldn't find a subroutine in our libraries on his new (Windows XP) machine when it was found on his old (Windows 98) machine! I hope it may be useful for someone else. NOTE: You can also remove a Filter association from a filetype but you should not do this unless you have a specfic reason! You must reboot the PC for the changes to take effect.