- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
|
i need to connect the data grid to access db using ado code and vb6 (without using adodc control)and diplay the result of a select statemet on it and here is the code that i am using (it give me a run time errorr 3705 : the operation is not …
|
|
Hello to all VB masters, I have a problem with the search command. I have a button name [B][COLOR="red"]"btnSearch"[/COLOR][/B] a text field name [B]"fldSearch"[/B] a table named [B][COLOR="red"]MSFlexGrid[/COLOR][/B] and a database named [B][COLOR="red"]db.mdb[/COLOR][/B]. The function of the search button is to search the data being entered in the fldSearch and … 
|
|
|
Hi there I am trying to design a flexi sheet calculator for work so that the users can use this program to calculate their working hours. They enter their times manually over the week. This is a calculator for them to use at the end of each week to calculate … 
|
|
|
hey all! please help me to check for validaiton such that... i hv few textboxes and combo boxes and if data is not entered in them then the submit button should be locked... and also tell me where should i write the code as in .... in form_load or submit_click... …
|
|
|
Hi, If you are interest in using MySQL as your back end database, here is one way to connect: By using ODBC: 'Declare ADODB variable Public ConnectData As New ADODB.Connection Set ConnectData = New ADODB.Connection ConnectData.Open "DSN=MySQL_ODBC" If you want to use MySQL ODBC 3.51 Driver , You can write … 
|
|
|
Re:
day problem
please help me. urgent i have one date in a txtBox1.what i want is, after i click the button, the other date will appear on txtBox2. [B]The other date[/B] is the date after several days such as 7 days. so, how or what the coding to enable the other date …
|
|
|
I have a .mdb database that contains various records. One of the fields is date, ie '19/10/2008 00:00'. How do I sort the database by date? I an a beginner and currently learning with the 'Visual Basic in easy steps' by Tim Anderson. On page 104 he has an example …
|
|
|
Hi, all programmers of this Forum, I am using MS Axcel 2002 and I am trying to format Excel Sheet from VB so as to make a border within the selected cell. My CB code is as under and when I run this, it select the specified rangge, but no … |
|
|
I am doing one project in which Whenever I export the result, the list of record should be extracted as Excel file and the list of record should be listed within Excel Table with formated Line. So, I want to format Excel from VB so as to make line / …
|
|
|
Re:
Acces DataBase
i want to link my forms with access tables and dont want to use the odbc object. i need to use the ADO is it posible and how. for in my first instance it worked, but when i moved it to another computer it signaled "Canot find database" Help pliz 
|
|
|
Could anybody help me with a problem i have? I have a budget sheet and a list of incomes and expenses, and i need to be able to search a specific column and look for a certain text like general ( which may be displayed as "Commission - General") then …
|
|
|
I want to make line in Excel with a click of my VB Form button, but I do not know the correct code, can any one help me.
|
|
|
I am new to ASP, and I used to write the connection for my Access Database using DNSLESS Connection like this: <HTML> <BODY> <% 'Actionvar=Request.QueryString("actionvar") '** Set Up a DSNLESS CONNECTION<BR> Set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " 'DSNtemp=dsntemp & "DBQ=" & server.mappath("Record.mdb") DSNtemp=dsntemp & "DBQ=" & server.mappath("MyWeb/MyRecord/Record.mdb") …
|
|
|
i have adodc1 i want to assign pressing f1 is the first data and f2 in next and f3 is previous and f4 is last data can anyone help me? please help me i need it!
|
|
|
Hi, I am trying to Write web type application and connect my database (Access) with DNSLess Connection like this Set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " DSNtemp=dsntemp & "DBQ=" & server.mappath("Record.mdb") conn.Open DSNtemp This is very much like to Connection to Database from VB6, but, I do not …
|
|
|
In my VB6 Book, in the last chapter programming ASP for web design is written and, it seem that is to be done through VB6, but I dont under stand and I usually write ASP code using FrontPage? If VB is helpful (Even though understanding of VB coding is helpful) …
|
|
|
Hi Friend, I want to know how to Select some range of Excel Say A1 to C5 and then make a line/Table using VB. Can any one help me by giving the VB Code. Also, can any one suggest some book to read relating to VB6 and Excel so as … |
|
|
I want to connect My Access Data in my Web Page. Is this possible? If yes, can you tell the way to connect. IS THERE ANY WAY TO USE ADO CONTRAOL TO CONNECT MY ACCESS DATABASE IN A WEB APPLICATION. CAN YOU PLEASE GIVE ME THE BASIC GUIDE.
|
|
|
Hello I am using windows XP I need a small programme in Visual basic 6 with Access 2000 I have two tables for example one table named student other table named section In student table rno is primary key. In section table Rollno is primary key Both tables have datas, …
|
|
|
Hi friends, I took a date picker control on form but it is not showing current date. Is there any way except this datepicker1.value=date ?
|
|
|
Whenenver I try to Save the Excel Workbook after editing the content by using this Code "xlwbook.Save", It always ask whether to replace the existing File or not. Is there any way to avoid this message? What shall I do to close the workbook silently (not seeing the Message). I … |
|
|
If you can help by giving guide to write this using VB, I shall be very glad: I want to get the quotient and a remainder when one number is divided by another one number, Can you please give/show me the Coding to this problem?
|
|
|
i want to auto generate an ID like 1, 2, 3. and anytime i close my application and open it again it should start from the Id it stopped. if i enter up to 6 the next one should be 7. Can anybody help me?
|
|
|
Hi all I have created an application which automates the Preparation of Question Papers for Various Exams. This software uses a DSN connection to a ACCESS database. While I was developing software I created this connection manually but while I distribute my application this connection will have to be created …
|
|
|
If any body help me, I shall be very greatful: How shall we write Code using VB so that the value of the product of two variable should be rounded to the nearest Integer number which is divisible by 5. Is there any way to check whether the given number … 
|
|
|
Is there any way to display more than ten thousand list of Record using FlexGrid- all at once. If not, what will be the solution of this problem.
|
|
|
Hi, I want to write VB code so that the any First letter of any Word entered in the textbox will be automatically converted to Capital. Whether there is one or more than one word in the text box, any first letter of the word should be converted to Capital … 
|
|
|
Is there any way to display more than ten thousand list of Record using FlexGrid- all at once. If not, what will be the solution of this problem.
|
|
|
Dear Sir/Madam Please tell me how can i remove "Invalid use of null" problem . Coding given below There is no value in rc1.fields(6) [code]db1.Open "Provider='Microsoft.Jet.OLEDB.4.0';Data Source='" & App.Path & "\tmgmt.mdb';" st1 = "select * from travel where sno = " & frmtorf.tserial.Text & ";" rc1.Open st1, db1, adOpenDynamic, adLockBatchOptimistic …
|
|
|