Results for "Category: Databases/ Data Access/ DAO/ ADO"

Allows the programmer to create an MS Access table in Visual Basic where the primary key’s field data type is set to AutoNumber. It is not like creating the primary key field in Access where you can select AutoNumber date type. In VB 5 and 6 you can’t request AutoNumber for a field type in the SQL Create Table string, it does not exist. So to create a table in VB where primary key’s numeric field type will be AutoNumber, you have to do it the way the included source code shows. Hope this helps.

Class that allows to create or edit connection strings using datalink of ADO. Suggestions and commentaries are welcome. Vote me!!

This code/tutorial is a beginners guide to connecting to your own SQL Server database.

This is in response to a 'Request for Code' in the discussion forum. It's similar to lots of other submissions of address book style apps. It shows how to create and access a database without any data controls - just by referencing 'Microsoft DAO 3.6 Object Library'. Purely an introduction to databases - nothing more. A simple address book in 160 lines of code, easily expanded, with lots of comments to guide a beginner through the code.

This is an utilitary program. You can open an Access database (97 or 2000), and by selecting a table, the program lists the fields with its data properties. (Once more, I'm sorry about my english)

This little application uses SQLDMO to script out objects in SQL Server 7.0 databases (tables, stored procedures, views, defaults, UDTs, full text indexes, etc.), as well as SQL Agent Jobs, Server logins, Operators, Alerts and Backup Devices. It even lets you save DTS packages as Structured storage file. Can be run in GUI mode or unattended/scheduled from the command-line. The code is a nice example of the use of SQLDMO objects, but even if the code doesn't interest you the application should be useful for SQL Server developers/DBAs who want to generate scripts of their DB objects in a more automated way then SQL Server EM lets you. ------------------------------------------------------------ A short text-file describing use is included. ------------------------------------------------------------ This is not drool-proof paper! Use at your own risk. Don't use on production servers unless your local DBA god has given you explicit permission. Dependencies are described in the included text file. ------------------------------------------------------------ A short (third-party) review of this tool and an executable-only download can be found at http://www.myitforum.com/articles/18/view.asp?id=3117 ------------------------------------------------------------ (Update 20020517 (v2.0.1): Added options to the /DB command-line switch to script out only the user or system databases) ------------------------------------------------------------ (Update 20020701 (v2.1): Server names, login names and authentication modes are now remembered between GUI sessions)

To remedy difficiencies in ADO, namely single criteria in the .FIND method. We encapsulated an ADODB.Recordset within a vb6 class module, and created four methods (FindFirst, FindLast, FindNext, FindPrevious) which allow for more that one criteria.

This will show new people to VB or Vb and Database's the basic's of using ADO with VB and access databases. *PLEASE VOTE*

This is to show developers (mostly new ones) how to use XML / ADO technologies from within VB. I got the XML source code from a project on this site and put it to use! I hope that this will help someone out!

This is to show new developers to Databases how to develop applications with VB and ADO. It is very well formated, step by step. And if you like it Please vote!

Store Files to Access-DB and restore them from DB to File and more...

I started this application in order to gather somewhere all the code I receive every day from Planet Source Code (actually I gather the URL’s). There are a lot of improvements in this version, plus some bug fixes. Some of these are: importing PSC e-mails directly from the net, importing PSC e-mails from Outlook, better error handling and trace routines. Check out readme.htm for more details. The database now contains e-mails from Dec 14 1999 until Jun 19 2000. I have change (again) the database, so be careful.

One of the most wanted feature from users point of view in MS SQL Server is capability to generate INSERT scripts for MS SQL Server data. But call it Microsoft's ignorance, this feature not supplied since quite long. And even worse, there is no public domain application to do that. This feature is usually desperately required in situation like sending test data to somebody or supply sample data. So I decided to write my own. It's still isn't the perfect and can't handle all of the possibilities but it could be your best bet with supplied source code! This application is right now in state of easy installation but no on-line help is available. You may freely contact me for assistance however.

Example on how a template can drastically accelerate development time for a Database app. With this template, you just have to drop the text controls you want on the form, modify their tag property (see file _Notes.txt) and modify the SQL string that the form uses to get data and voilà. The code will take care of the MoveFirst, MovePrevious, NewRecord, MoveNext, MoveLast, SaveRecord, DeleteRecord, Undo, Requery, EditRecord and CloseForm. It will automatically enable/disable the controls based on what the user is doing and his location in the rescordset. There is even options (in the tag property) to set default values and field validation (alpha or numeric). Since it's the tag property that drives most of the features of the app, the code is very portable/reusable. The template only uses UNBOUND forms (i.e. there is NO Data Control) and is well commented.

This code creates and maintains a database of multiple users that may use your program. This supports user flags that YOU specify and define as well as a checkpoint system that YOU build! Documentation and sample projects included.

select any access database then select the table you want then select and insert any fields to a richtextbox then preform a mail merge like MSWord. you can then browse through the database while viewing the merged data.

This is an advanced autocomplete function that will autocomplete for a textbox, a listview control or a listbox all from 1 function. I have seen code on this site before that had inspired me to create this function since I need it in a lot of my projects. I tried to comment everything as well as I could. if you have any questions email me and I will do my best to help you. oh yeah - Please vote for me if you like this code. thanks

Since MS-Access doesn't support accent insensitive queries by itself (MS SQL Server does as far as I know), I had to create a function that would fix the problem. With this function, it is possible to turn any SQL query into an accent insensitive query. With a few little modifications, it works great with ASP too!

Well, I was trying to make a address book and I couldent think on an interface. So I thought for like 1 hour and I made one and I decided for thoes people out their that want to make an address book, that they could you my interface! If you use this please give me credit and you can re-arranfge it, and do aything to it!

Created for a barcode scanner. it stores the price, barcode and product name for an item. You can do a search for items by product name or by barcode. Also has an attempt at a registration enabled program which requires a valid username and password to register the program.