i want to know about the data bases and query in visual basic 6
121455
Once a new UserConnection object has been inserted into the project, you can add new Query objects to it. These query objects can be either stored procedure calls or user-defined SQL statements. Each query object defined at design-time will automatically be available as a method of the new UserConnection class.\n\nTo add a Query object, click the leftmost button on the toolbar. The new Query object is added hierarchically below the UserConnection object, and its Properties Window appears.\n\nSelecting Stored Procedures\nSelect Insert Stored Procedure to view the available stored procedures on the database. The UserConnection designer attempts to establish a connection to the database, using the connection properties you entered. If successful, it enumerates the available stored procedures on the database, allowing you to select one to define the Query object:\n\nQuery Properties dialog box\n\n\n\nInserting User-Defined Queries\nChoose Based on User-Defined SQL to create a local query against the remote database. This enables the SQL property box, into which you enter SQL statements to define your query.\n\nAlternatively, you can click the Build button, which opens the MS-Query query design tool. MS-Query provides a visual interface that allows you to drag and drop database tables and fields, define conditions and set relationships to define the query. When you exit from MS-Query, your visually-designed query is automatically translated into SQL code and inserted into the User-Defined SQL property box.\n\nFor More Information   For more information about using the MS-Query query builder, see MSQry32.hlp which is installed in the &#92;Program Files&#92;Common Files&#92;Microsoft Shared&#92;vba directory.\n\nSetting Other Query Properties\nIn addition to the defining properties discussed above, the Query Property Page has two additional tabs for defining Parameters and advanced properties.\n\nThe Parameters tab on the query property page allows the developer to adjust properties for each parameter in the current query.\n\nParameters properties\n\n\n\nThe parameters shown in the Parameters list box are determined automatically from the query source, and cannot be changed here. Parameters are generated for each parameter marker in the SQL statement for the query (or call statement for stored procedures). Parameter markers are designated by a "?" in accordance with the ODBC specification. For example, the following query would contain two parameters:\n\nSELECT * FROM authors WHERE state = ? AND zip = ?\n\nThe parameter properties that can be changed here are the Name, Direction, ODBC Binding Data Type, and Visual Basic Data Type.\n\nThe Name property can be changed to allow your Visual Basic code to recognize the parameter by a familiar sounding name, if its actual name is complex or not intuitive.\n\nSetting the Direction of a parameter may be necessary for some ODBC databases for which the driver is not capable of determining the direction (input, input/output, or return values). The same is true for the data types, and you may wish to override the default type conversion into Visual Basic data types for use with your code.\n\nAdvanced Query Properties\nThe Advanced tab of the Query Properties page allows for fine-tuning the query by setting limits and thresholds.\n\nAdvanced properties\n\n\n\nThe Call Syntax text box lets you change the call syntax that RDO will use to call the stored procedure. This can be edited to adjust the number of parameters and presence of the return value. Editing the call syntax is an advanced operation and should only be done by developers who understand the ramifications.\n\nUsing the UserConnection Object in Your Code\nYou can insert the UserConnection object into your Visual Basic code just as you would with any class, by creating an object variable and instantiating it with a new instance of the UserConnection class you have defined. For example:\n\nOption Explicit\nPrivate MyConnect As M
459387
You need to learn some programming. You can do this from within access by using the built VBA (visual basic for applications) code editor by hitting alt-f11.\n\nYou can also use a full blown application development environment such visual studio .net which can then connect to your database and do what you want.\n\nBoth options require a fair bit of work on your part in learning to program if you don't already have such a background and my guess is if you are asking the question your programming experience is limited. You will also need a logical mind in order for programming to be a rewarding experience as programming hits disorganisation and you will wind yourself up in knots.
198916
Try here http://www.gdatabase.com
574035
Sounds like the Dewey Decimal System done in Visual Basic, to me.!
364055
1. Field\n2. Retrieval\n3. Flat File\n4. Record\n5. DBMS\n6. Query\n7. Updating\n\nHope that helps!!
124517
vc++ is much more tougher to handle than it's compatriot : visual basic. As the saying goes: "vb is fun, vc++ is shit hard work!!".\n\nok..\ni'll give u da steps to create 2 edit boxes and to get the sum : )\n\nhere we go:\n\n1) open ms vc++\n2) go to file ->new and under the projects tab, select mfcappwizard (exe) , enter name and choose location to save project\n3) now, the wizard pops up.\nStep 1 : select dialog based  (since the addition thing is fairly simple, we'll go for this)\n4) press next for step 2 and once again for step 3 (which means u r accepting the default values in those steps).\n\nFinally, u get a dialog showing the summary of the application.\n\nif u have come till here..gooood!! u have created a "skeletal application" .. and this, buddy , is the true essence of MFC programming.\n\nok.. now that u have created the skeleton application , its time i teach u how to put two text boxes and if ya click a button, the sum would be displayed in another :::\n\n\n\n\n* now, on ur left, u should see a "workspace" window. its one containing a list of files in your application.\n\n* in that, select the resources tab (tab is found at bottom of workspace window)\n\n* open the tree listing. in that u would find a "dialog" sub tree\n\n* open that. and u would find a "IDD_..." thing . double click on that, and presto, u would get a blank dialog.\n\n* now, that blank dialog would be accompanied by a toolbox if u dont see the toolbox, right click on the toolbar on top of vc++ window, choose toolbox.\n\n* if u see the toolbox, good. now, choose the edit box (text box) and draw three text boxes on the dialog. now, choose the button and draw one button on the dialog.\n\n* the text boxes would have the name IDC_EDIT1 , IDC_EDIT2 and IDC_EDIT3 and button would be IDC_BUTTON1(u can see the names by right-clickin on the component and choosing properties.)\n\n* ok, now , go to view- > class wizard (a very very very important tool in vc++)\n\n* move to "member variables" tab. u can see the components that u have added.( if u have not, just try flickering with the drop down dialogs that u see there). \n\n* now, double click on IDC_EDIT1 and another small window appears , asking u the variable name it would ve already displayed "m_" DONOT remove the "m_" jus add something to it like : "m_number1" . repeat same for the other two edit boxes and make sure u remember the variable names.\n\n* u have come till here?? awesome!! ; )\n\n* now close the class wizard window.\n* double click on tha button and.. u get a prompt something like onbuttonclick (somethin like dat) ..whatever comes, press ok. and presto, u go into the coding wonderland.\n\n* remember the varible names ?? goood. and u kno how to put an addition statement?? awesome!! . jus do that.. eg: m_number3=m_number1+m_number2;\n\n*CAUTION : while giving variable names , make sure u <<CHOOSE THE int TYPE>>\n\n* phew.. take a break and come back cos u r gonna watch ur creation come to life ; )\n\n*goto project->build xyz.exe\n\n* wait till it completes compilation and shows the sweet words "0 errors 0 warnings" on the bottom window of the screen (watch window).\n\n* press ctrl+f5 and voila.. u get ur own summing application created using MFC and with help of appwizard,classwizard and moi, ANAND ; )\n\n\n\n\nIF u have encountered any problem anywhere enroute to success, worry - not. Send me a message Y! id: anand_87123\ny! mail : anand_87123@yahoo.com\nput the subject line as vc++ - Y! answer\n\nok??\n\nP.S : if ya feel i have helped ya, i dont mind my answer being voted as the best answer by u!!\n\nand also, i can prescribe 2 books for ya :\n1) MFC programming by JEFF PROSISE and \n2) David J Kruglinski, Scott Wingo :: "Programming Microsoft Vc++ Fifth edition"\n\nthey are available for download from da net (illegal ofcourse ... ; ) ) try searching
600819
Hi,\ngo to the Webpage www.vbforums.com and check there your question. I am sure that this question is there already answered. It is the biggest vb-forum in the world. More then 40.000 programmers are in it (for example me)\n\nnice greetings
37779
This can be done without too much trouble. Start by creating a text box on the page, then on the button click event, query the database based on the textbox content, for example if the box will contain a name or fragment of the name, then use this as your command text:\n"SELECT * FROM [table] WHERE [field] LIKE '%" + TextBox1.Text + "%'"\n\nThis query will return anything that starts with, contains, or ends with the text in box 1.  Then you display that data by binding the datatable the contains the new data with your datagrid. \n\nGood Luck!
556235
i go here for all my VB.NET questions\nhttp://www.xtremevbtalk.com/forumdisplay.php?f=97
290074
Writing software for the Windows Operating System might be a start.\n\n\nStart learning Visual Basic .NET.  Start with the Teach Yourself Visual Basic .NET in 24 hours, then Teach yourself Visual Basic .NET in 21 (a more comprehensive book) and then find a book on Advanced Visual Basic .NET.\n\nEvery application involves databases now, and there is no way around it.  But if you read those three books that I mentioned, you will have a great understanding of software engineering (and computer programming) and will be able to start writing your own software applications.\n\nEngineering is just a term that involves creating designs.  So what a software engineer does is creates a layout or design of a program to show how the program will work.   Then you take that design and write code to fit the design.
622160
search for it from the microsoft site .. its visualbasic 6 runtime files
379818
OpenOffice has a forum where you can put your query... they shall be able to help you out.... quickly.
43251
What you need to dig into is SQL for database inquiry and update.
257900
buy the book visual basic for dummies
453945
ok I give some hints\nIf you want to refer to a database from Excel you need to add the ADO 2.8 objects Library. \nHow to proceed?\nFrom the Visual basic editor, click on tools (menu bar) and then reference. look for Microsoft Activex Data objects 2.8 library and tick it.\nNow you should have access to ADO objects.\nTo learn how to use these objects try the msdn microsoft website, full of advice and templates\n\nIf you want an example from me, give me a valid email address where i can send you an excel workbook and small access data base for it takes too long to explain
115653
The language itself is capable of more than Visual Basic 6 and the development environment is improved greatly.\n\nApplications developed with Visual Basic .NET (2005 Express) use the .NET framework, so there is still a run-time that needs to be installed on the client machines.  (Although updates for Windows XP and Windows Vista will have these.\n\nOut of the box, you can use Visual Basic .NET to create console applications, class libraries and Windows forms applications.  While there is not a project template for VB.NET Windows services, you can still create them.\n\nVB.NET can still use 3rd party dynamic link libraries (DLLs) and COM/ActiveX controls and components.  You do have to download a separate 'Express' product to use Visual Basic .NET for Web development.\n\nOf course, the best thing about Visual Basic 2005 Express is that you can download it for *free*.  I've included the link below.
109359
A database is a collection of information similar to a filing cabinet on the computer. \n\nYou come up with questions and then answers.\n\nThink about the Powerpuff Girls.\n\nWhat are the names of the Powerpuff Girls?\nButtercup\nBubbles\nBlossom\n\nWhat color of dress does each wear?\ngreen\nblue\npink\n\nWhat hair style does each have?\nshort\npig tails\npony tail\n\nWhat color of hair?\nblack \nblonde\nred\n\nThen if you have  a question, you can have the computer search for you. Yes this database was so small, you could just look at the paper, but if you had lots of questions and lots of answers--you would need the computer help.