10,991 Topics
 | |
| | hi guys... i have an urgent problem please give an idea about it.. Question#1: I want to know the correct date syntax in query database using MySQL... Question#2: I currenly using the MySQL connector/OBDC 3.51 is their any problem about it?? thxx in advance.... and ned asap reply... thxxxxxxxxxxxx guyzzzzz.. |
| | I have generated on textfile , earlier i am copying it to lpt1 port and get printed. now the problem arise that my printer is attached to usb so the above command is not working please help me in this regard thanks |
 | im getting an error while using Text1.SetFocus the error is invalid procedure call or argument i used this in the form load and i suppose it is used to bring the cursor in the textbox during form load |
| | Hi all, Please somebody tell me the code. I have : a textbox name txtfname a table named Customer (located in Database.mdb) the customer table has only 1 field fname. How do i create a connection such that whenever i click on add button, whatever is in the txtfname textbox … |
| | Hi, Plz help me... My project is Sales system using DAO I need the code for: Password code System (to generate the Item code) Item Entry code, Item Inquiry by description, Item Inquiry by quantity on hand Item Inquiry by unit of measure Item Inquiry by unit price Custumer Entry …  |
| | Hi everybody, I have following code: [ICODE]Public Class Form1 Private Sub btn1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn1.Click Dim dayChange As Date = dtp2.Value Dim answer As Date answer = dayChange.AddDays(1) dtp2.Value = answer End Sub End Class[/ICODE] Working : each time I click btn1 datetimepicker changes … |
| | HI all, I have on the form an ADO data control and an OLE object. ADO is connected to a MSAccess Database (With a table having an OLE field). The class of OLE field is "Word.Document.8". Now when I try to connect the datasource property of OLE object, it says … |
| | Hi all Does anyone know about any software which will help me in making a question bank for my students? Also I want the software to help me in making a question paper for the students from the question bank that I create. Thanks in advance any help will be … |
| | Can anyone provide me with code on how to Delete a row from a list box?? lstReorder.RemoveItem (index) I believe is the right code. However this does not actually do anything by itself. How do i tell the program what the index refers to? ie what the index is? for … |
| | I would like to learn the basic tutorial of Visual Basic  |
| | please help that how to add data of one field of database to the combo box. i attached one rar file with this. check that |
| | I'm having problems filtering the date for my reports with access and older versions of mysql i can do this my using this query format: Select * from transactions where xdate =#"& txtdate.text &"# or Select * from transactions where xdate =#"& format(txtdate.text,"mm/dd/yyyy") &"# but now that i'm using wamp … |
| | hello... i' m doing registration license system... i need source code that can search due date by their month... and i want to list their date with companies name.. how to combine two table in database?? because i want use the combine to search and display the data.. |
| | is it possible to pass the value of a text box and the caption of a label from one form to another |
| | I am trying to write a code that asks for a date in a user form text box and then takes that date and looks for it in a range. Once it finds that date I want to enter the data from the second text box in a cell on … |
| | I'm currently designing a report using VB6 and crystal reports using mysql as backend but everytime i open the report in VB i always have the error "Access Denied". I never had such error in the old version of MYSQL. I using WAMP server with MYSQL 5. Anyone who has … |
| | I'm new in MYSQL is there anybody who is expert in MSQL as backend and VB6 as front end please i'll be willing to study espcially on the connection. How and what are the procedures? Thanks a lot in advance...hope to share also my little ideas soon... |
 | Hi again, In my previous thread regarding Combo box at runtime I had not forseen the problems I would experience introducing a variable to the code. [CODE]Private Sub Form_Load() Set myconn = New ADODB.Connection myconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\Gareth Powell\Desktop\db2.mdb" myconn.Open Set mycomm = New ADODB.Command Set … |
| | Hi all, What I need to do is populate a combo box at runtime according to specific inputs from other forms.The code listed below is a seperate trial and works OK. I would like to know if I am overdoing the code thing for what I am achieving. [CODE]Private Sub … |
| | Hi There In an Excel Macro. I am trying to install a manual Page break in an IF Statement, if it results in a 'Yes'. What I am missing? Please help. Best regards, Broxy. Sub PM3() ' ' PM3 Macro ' ActiveCell.FormulaR1C1 = "=IF(RC[1]=""yes"", ActiveCell.ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell)" End Sub |
| | I have a form with several list boxex. The form feeds an Excel spread sheet. I need to move thed data from the list box to the spread sheet. Some times it works, and some times it doesn't. I have varified that the list indexes are correct, and have even … |
| | I am trying to create an alert in Vb.6 code that tells the user to make purchase since he has riched limit of the product |
| | steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server(last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my …  |
| | Hi all. I'm having difficulty making a log-in screen. i am using an adoc contorl called adoClerk, which contains only two fields and ClerkId and Password. The ClerkId is a autonum and password is text. I Have two text boxes that need to be read from this screen txtClerId and … |
| | need help on adding a photo to a form and connect it to a database.thanx |
| | Hello all, I have a VB Script that creates a phone list for my company, and I have been asked to alphabetize the names listed under the department headings....I am so new to VB that this is the first time I have used it.....ever I've done a great deal of … |
| | hi thanks for ur suggessions now i got mysql connection with vb but i need to use the mysql Queries in this application hope i wil get solution thank u very much |
| | hi there thanks guys now im able to connect to the mysql database and know how to use select statement to access the the data in the database but what to do to view the data retrieved by the select statement |
| | Hi... I am developing a software where I need to enter both [B]text as well as some Mathematic equation or some BMP picture [/B]inline with the text. Is it possible to enter this as input to any one variable. If so what type of the variable should be used? Please …  |
| | Hi, I have made a DataProject in VB6 with Access as back-end. Using Jet OLEDB 4 as provider. Programme is running well on my Computer. When I Installed the project on another Computer where VB6 is no installed on Hard disc, Error comes. When I try to show Report in … |
The End.