Results for "Author: stuart roberts"

This is a program which will allow you to test a connection to most databases (SQL,Oracle etc...) and run any SQL query through. The connection to the database is handled using RDO although this could be quite esily changed to ADO if required. To test the connection you will need to enter the desired connection settings like server name, database name and password, DSN name if required etc..

DLL which starts-up with VB and is inserted in the Add-In menu. When run it will close all Open Code and Designer windows from the screen (they are only closed from view, not removed from your project). Quite handy if you like all your windows shut before saving which will speed the time it takes to re-load your project next time around. Modify it to do what you like - this should get you started.

Demonstrates how to write code for most Microsoft Office application without having the code reside in VBA. This is done by writing the bulk of what you want to do in a DLL which is referenced and used by the Office application. This has advantages like being able to use forms that were generated through VB 5 or 6 instead of the poor VBA forms. Read the readme.txt file enclosed with the ZIP for some more info. Cheers

Lots of different function for handling VB strings. Take a look inside, you mightlike what you see...

DLL which starts-up with VB and is inserted in the Add-In menu. When run it will close all Open Code and Designer windows from the screen (they are only closed from view, not removed from your project). Quite handy if you like all your windows shut before saving which will speed the time it takes to re-load your project next time around. Modify it to do what you like - this should get you started.

This is a program which will allow you to test a connection to most databases (SQL,Oracle etc...) and run any SQL query through. The connection to the database is handled using RDO although this could be quite esily changed to ADO if required. To test the connection you will need to enter the desired connection settings like server name, database name and password, DSN name if required etc..

Gives you access to the entire Registry, allowing you to create\delete\modify keys and values. Give your programs a more professional look than if you used the default VB Registry calls GetSetting and SaveSetting. I have written a program that uses the Registry class to output all the code neccessary to link your program to the Registry and could save hours or days of typing repetitive code, like I did! Drop me an email if you'd like to have a look at it.

Demonstrates how to write code for most Microsoft Office application without having the code reside in VBA. This is done by writing the bulk of what you want to do in a DLL which is referenced and used by the Office application. This has advantages like being able to use forms that were generated through VB 5 or 6 instead of the poor VBA forms. Read the readme.txt file enclosed with the ZIP for some more info. Cheers

Lots of different function for handling VB strings. Take a look inside, you mightlike what you see...

DLL which starts-up with VB and is inserted in the Add-In menu. When run it will close all Open Code and Designer windows from the screen (they are only closed from view, not removed from your project). Quite handy if you like all your windows shut before saving which will speed the time it takes to re-load your project next time around. Modify it to do what you like - this should get you started.

This is a program which will allow you to test a connection to most databases (SQL,Oracle etc...) and run any SQL query through. The connection to the database is handled using RDO although this could be quite esily changed to ADO if required. To test the connection you will need to enter the desired connection settings like server name, database name and password, DSN name if required etc..

Gives you access to the entire Registry, allowing you to create\delete\modify keys and values. Give your programs a more professional look than if you used the default VB Registry calls GetSetting and SaveSetting. I have written a program that uses the Registry class to output all the code neccessary to link your program to the Registry and could save hours or days of typing repetitive code, like I did! Drop me an email if you'd like to have a look at it.

Demonstrates how to write code for most Microsoft Office application without having the code reside in VBA. This is done by writing the bulk of what you want to do in a DLL which is referenced and used by the Office application. This has advantages like being able to use forms that were generated through VB 5 or 6 instead of the poor VBA forms. Read the readme.txt file enclosed with the ZIP for some more info. Cheers

Lots of different function for handling VB strings. Take a look inside, you mightlike what you see...

DLL which starts-up with VB and is inserted in the Add-In menu. When run it will close all Open Code and Designer windows from the screen (they are only closed from view, not removed from your project). Quite handy if you like all your windows shut before saving which will speed the time it takes to re-load your project next time around. Modify it to do what you like - this should get you started.

This is a program which will allow you to test a connection to most databases (SQL,Oracle etc...) and run any SQL query through. The connection to the database is handled using RDO although this could be quite esily changed to ADO if required. To test the connection you will need to enter the desired connection settings like server name, database name and password, DSN name if required etc..

Gives you access to the entire Registry, allowing you to create\delete\modify keys and values. Give your programs a more professional look than if you used the default VB Registry calls GetSetting and SaveSetting. I have written a program that uses the Registry class to output all the code neccessary to link your program to the Registry and could save hours or days of typing repetitive code, like I did! Drop me an email if you'd like to have a look at it.

Demonstrates how to write code for most Microsoft Office application without having the code reside in VBA. This is done by writing the bulk of what you want to do in a DLL which is referenced and used by the Office application. This has advantages like being able to use forms that were generated through VB 5 or 6 instead of the poor VBA forms. Read the readme.txt file enclosed with the ZIP for some more info. Cheers

Lots of different function for handling VB strings. Take a look inside, you mightlike what you see...

DLL which starts-up with VB and is inserted in the Add-In menu. When run it will close all Open Code and Designer windows from the screen (they are only closed from view, not removed from your project). Quite handy if you like all your windows shut before saving which will speed the time it takes to re-load your project next time around. Modify it to do what you like - this should get you started.