Results for "Author: gazman"

Microsoft Indexing Service is a service that provides a means of quickly searching for files on a machine. The most familiar usage of the service is on web servers, where it provides the functionality behind site searches. It provides a straightforward way to index and search your web site or machine. This simple app. provides a way of accessing that functionality via VB. My initial reason for looking at Index Server was so I could search for documents in a particular directory that I have set up. If you create your own Catalog and add certain Directory's (collectively the dir's. are called the 'Scope') to that Catalog, you can then specify which Catalog to search in. Handy if you have documents that need to be kept in separate folders etc. (see the Help file) Included is a handy ListView builder which only needs a recordset and the target ListView, and an Internet Explorer imbedded in a form used as the Help file. I hope you find all of this useful and if so (or if not!), please leave a rating and comments. Regards....

This example Excel spreadsheet shows how to get live datafeeds for Stock using Excel Querys. I have password protected the workbook, but I will give that to you, so you can see the 'Protection' functionality in use. (Password = 'stockquotes'). There are hidden sheets that contain the Listings for each industry sector (this is set at startup of the workbook), but these could be parked in a database such as Access or SQL if you liked. I have used a ListView to manage the stocks that you need quotes on. Anyway, I hope that this is useful! It could be adapted for other markets, which is why a database of sectors/markets would be handy.

This is the second part of the ListView Builder sample. There is some more functionality that works with the ListView object. Updating a database from a ListView etc. Keywords: Drag and Drop (OLEDragDrop), ListView, TextBox, array, ADODB.Connection, HotCode... By request, I have added a function 'RecordDetails' that will do a SQL selection based on an item in the ListView...

This app. will merge data from Access to a Word document and then send the document out as an attachment using Collaborative Data Objects (CDO). Some Keywords: Outlook, MAPI, NameSpace, MailItem, Recipient, Attachment, FileSystemObject, ADODB.Connection, ADODB.Recordset, ADO 2.6, Word.Application, MailMerge, OpenDataSource, SQL creation, Array, HotCode, Spaniel (you have to find it) You will have to do a bit of work to get set up (if you don't have CDO/Exchange Server), but you can adapt the Outlook function I have in order to do the emailing. Any questions, then please drop them on the site and I'll endeavour to get back to you. Cheers, and if there are any bugs, stodgy code etc then let me know and I'll try to fix. I hope that you find this interesting and if you do and like the cut of my code, then give me a rating. Cheers Regards, The GazMan

This example Excel spreadsheet shows how to get live datafeeds for Stock using Excel Querys. I have password protected the workbook, but I will give that to you, so you can see the 'Protection' functionality in use. (Password = 'stockquotes'). There are hidden sheets that contain the Listings for each industry sector (this is set at startup of the workbook), but these could be parked in a database such as Access or SQL if you liked. I have used a ListView to manage the stocks that you need quotes on. Anyway, I hope that this is useful! It could be adapted for other markets, which is why a database of sectors/markets would be handy.

Microsoft Indexing Service is a service that provides a means of quickly searching for files on a machine. The most familiar usage of the service is on web servers, where it provides the functionality behind site searches. It provides a straightforward way to index and search your web site or machine. This simple app. provides a way of accessing that functionality via VB. My initial reason for looking at Index Server was so I could search for documents in a particular directory that I have set up. If you create your own Catalog and add certain Directory's (collectively the dir's. are called the 'Scope') to that Catalog, you can then specify which Catalog to search in. Handy if you have documents that need to be kept in separate folders etc. (see the Help file) Included is a handy ListView builder which only needs a recordset and the target ListView, and an Internet Explorer imbedded in a form used as the Help file. I hope you find all of this useful and if so (or if not!), please leave a rating and comments. Regards....

This is the second part of the ListView Builder sample. There is some more functionality that works with the ListView object. Updating a database from a ListView etc. Keywords: Drag and Drop (OLEDragDrop), ListView, TextBox, array, ADODB.Connection, HotCode... By request, I have added a function 'RecordDetails' that will do a SQL selection based on an item in the ListView...

This app. will merge data from Access to a Word document and then send the document out as an attachment using Collaborative Data Objects (CDO). Some Keywords: Outlook, MAPI, NameSpace, MailItem, Recipient, Attachment, FileSystemObject, ADODB.Connection, ADODB.Recordset, ADO 2.6, Word.Application, MailMerge, OpenDataSource, SQL creation, Array, HotCode, Spaniel (you have to find it) You will have to do a bit of work to get set up (if you don't have CDO/Exchange Server), but you can adapt the Outlook function I have in order to do the emailing. Any questions, then please drop them on the site and I'll endeavour to get back to you. Cheers, and if there are any bugs, stodgy code etc then let me know and I'll try to fix. I hope that you find this interesting and if you do and like the cut of my code, then give me a rating. Cheers Regards, The GazMan

Microsoft Indexing Service is a service that provides a means of quickly searching for files on a machine. The most familiar usage of the service is on web servers, where it provides the functionality behind site searches. It provides a straightforward way to index and search your web site or machine. This simple app. provides a way of accessing that functionality via VB. My initial reason for looking at Index Server was so I could search for documents in a particular directory that I have set up. If you create your own Catalog and add certain Directory's (collectively the dir's. are called the 'Scope') to that Catalog, you can then specify which Catalog to search in. Handy if you have documents that need to be kept in separate folders etc. (see the Help file) Included is a handy ListView builder which only needs a recordset and the target ListView, and an Internet Explorer imbedded in a form used as the Help file. I hope you find all of this useful and if so (or if not!), please leave a rating and comments. Regards....

This example Excel spreadsheet shows how to get live datafeeds for Stock using Excel Querys. I have password protected the workbook, but I will give that to you, so you can see the 'Protection' functionality in use. (Password = 'stockquotes'). There are hidden sheets that contain the Listings for each industry sector (this is set at startup of the workbook), but these could be parked in a database such as Access or SQL if you liked. I have used a ListView to manage the stocks that you need quotes on. Anyway, I hope that this is useful! It could be adapted for other markets, which is why a database of sectors/markets would be handy.

This is the second part of the ListView Builder sample. There is some more functionality that works with the ListView object. Updating a database from a ListView etc. Keywords: Drag and Drop (OLEDragDrop), ListView, TextBox, array, ADODB.Connection, HotCode... By request, I have added a function 'RecordDetails' that will do a SQL selection based on an item in the ListView...

This app. will merge data from Access to a Word document and then send the document out as an attachment using Collaborative Data Objects (CDO). Some Keywords: Outlook, MAPI, NameSpace, MailItem, Recipient, Attachment, FileSystemObject, ADODB.Connection, ADODB.Recordset, ADO 2.6, Word.Application, MailMerge, OpenDataSource, SQL creation, Array, HotCode, Spaniel (you have to find it) You will have to do a bit of work to get set up (if you don't have CDO/Exchange Server), but you can adapt the Outlook function I have in order to do the emailing. Any questions, then please drop them on the site and I'll endeavour to get back to you. Cheers, and if there are any bugs, stodgy code etc then let me know and I'll try to fix. I hope that you find this interesting and if you do and like the cut of my code, then give me a rating. Cheers Regards, The GazMan

Microsoft Indexing Service is a service that provides a means of quickly searching for files on a machine. The most familiar usage of the service is on web servers, where it provides the functionality behind site searches. It provides a straightforward way to index and search your web site or machine. This simple app. provides a way of accessing that functionality via VB. My initial reason for looking at Index Server was so I could search for documents in a particular directory that I have set up. If you create your own Catalog and add certain Directory's (collectively the dir's. are called the 'Scope') to that Catalog, you can then specify which Catalog to search in. Handy if you have documents that need to be kept in separate folders etc. (see the Help file) Included is a handy ListView builder which only needs a recordset and the target ListView, and an Internet Explorer imbedded in a form used as the Help file. I hope you find all of this useful and if so (or if not!), please leave a rating and comments. Regards....

This example Excel spreadsheet shows how to get live datafeeds for Stock using Excel Querys. I have password protected the workbook, but I will give that to you, so you can see the 'Protection' functionality in use. (Password = 'stockquotes'). There are hidden sheets that contain the Listings for each industry sector (this is set at startup of the workbook), but these could be parked in a database such as Access or SQL if you liked. I have used a ListView to manage the stocks that you need quotes on. Anyway, I hope that this is useful! It could be adapted for other markets, which is why a database of sectors/markets would be handy.

This is the second part of the ListView Builder sample. There is some more functionality that works with the ListView object. Updating a database from a ListView etc. Keywords: Drag and Drop (OLEDragDrop), ListView, TextBox, array, ADODB.Connection, HotCode... By request, I have added a function 'RecordDetails' that will do a SQL selection based on an item in the ListView...

This app. will merge data from Access to a Word document and then send the document out as an attachment using Collaborative Data Objects (CDO). Some Keywords: Outlook, MAPI, NameSpace, MailItem, Recipient, Attachment, FileSystemObject, ADODB.Connection, ADODB.Recordset, ADO 2.6, Word.Application, MailMerge, OpenDataSource, SQL creation, Array, HotCode, Spaniel (you have to find it) You will have to do a bit of work to get set up (if you don't have CDO/Exchange Server), but you can adapt the Outlook function I have in order to do the emailing. Any questions, then please drop them on the site and I'll endeavour to get back to you. Cheers, and if there are any bugs, stodgy code etc then let me know and I'll try to fix. I hope that you find this interesting and if you do and like the cut of my code, then give me a rating. Cheers Regards, The GazMan

Microsoft Indexing Service is a service that provides a means of quickly searching for files on a machine. The most familiar usage of the service is on web servers, where it provides the functionality behind site searches. It provides a straightforward way to index and search your web site or machine. This simple app. provides a way of accessing that functionality via VB. My initial reason for looking at Index Server was so I could search for documents in a particular directory that I have set up. If you create your own Catalog and add certain Directory's (collectively the dir's. are called the 'Scope') to that Catalog, you can then specify which Catalog to search in. Handy if you have documents that need to be kept in separate folders etc. (see the Help file) Included is a handy ListView builder which only needs a recordset and the target ListView, and an Internet Explorer imbedded in a form used as the Help file. I hope you find all of this useful and if so (or if not!), please leave a rating and comments. Regards....

This example Excel spreadsheet shows how to get live datafeeds for Stock using Excel Querys. I have password protected the workbook, but I will give that to you, so you can see the 'Protection' functionality in use. (Password = 'stockquotes'). There are hidden sheets that contain the Listings for each industry sector (this is set at startup of the workbook), but these could be parked in a database such as Access or SQL if you liked. I have used a ListView to manage the stocks that you need quotes on. Anyway, I hope that this is useful! It could be adapted for other markets, which is why a database of sectors/markets would be handy.

This is the second part of the ListView Builder sample. There is some more functionality that works with the ListView object. Updating a database from a ListView etc. Keywords: Drag and Drop (OLEDragDrop), ListView, TextBox, array, ADODB.Connection, HotCode... By request, I have added a function 'RecordDetails' that will do a SQL selection based on an item in the ListView...

This app. will merge data from Access to a Word document and then send the document out as an attachment using Collaborative Data Objects (CDO). Some Keywords: Outlook, MAPI, NameSpace, MailItem, Recipient, Attachment, FileSystemObject, ADODB.Connection, ADODB.Recordset, ADO 2.6, Word.Application, MailMerge, OpenDataSource, SQL creation, Array, HotCode, Spaniel (you have to find it) You will have to do a bit of work to get set up (if you don't have CDO/Exchange Server), but you can adapt the Outlook function I have in order to do the emailing. Any questions, then please drop them on the site and I'll endeavour to get back to you. Cheers, and if there are any bugs, stodgy code etc then let me know and I'll try to fix. I hope that you find this interesting and if you do and like the cut of my code, then give me a rating. Cheers Regards, The GazMan