User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
White Papers
All
•
•
•
•
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 374,509 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,850 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
•
•
•
•
Showing results 1 to 40 of 500
Search took 0.05 seconds. Posts Made By: QVeen72
Save these search results for 24 hours
Page 1 of 13 1 2311 > Last »
Forum: Visual Basic 4 / 5 / 6 6 Hours Ago
Replies: 1
Views: 46
Posted By QVeen72
Re: how to use date difference in vb 6.0

Hi,

Try This :


Dim i As Integer
i=DateDiff("d",CDate(txtEntDate), CDate(txtExpDate))


Regards
Forum: Visual Basic 4 / 5 / 6 6 Hours Ago
Replies: 6
Views: 82
Posted By QVeen72
Re: Need to separate 16 bit binary to 4bit and 12 bit binary values

Hi,

Post Some Sample Data here..
For What Input , What is the Output you want...?

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 6 Hours Ago
Replies: 2
Views: 35
Posted By QVeen72
Re: convert date value from dtpicker to string

Hi,

Try This :


Dim a as string
a = Format(dt1.value,"dd-mm-yyyy")


Regards
Forum: Visual Basic 4 / 5 / 6 10 Hours Ago
Replies: 9
Views: 87
Posted By QVeen72
Re: How to seperate the text file data using Mid Function?

Hi,

I guess, You Can use "FIND" method of ADO Recordset...
Try This :

After opening the connection...

Set rsId = New ADODB.Recordset
rsId.Open "ID", cnName, adOpenKeyset, adLockOptimistic
For i =...
Forum: Visual Basic 4 / 5 / 6 12 Hours Ago
Replies: 4
Views: 86
Posted By QVeen72
Re: Issue with Get and Let properties in Class Module

Hi,

Yes, I concur with both of the above...
for Property , you can Get or Let only one Value parameter.
Since, you are wanting to pass 2 parameters, Create SetLength, as a Public Sub Procedure and...
Forum: Visual Basic 4 / 5 / 6 12 Hours Ago
Replies: 9
Views: 87
Posted By QVeen72
Re: How to seperate the text file data using Mid Function?

Hi,

Initially, TArr, is a Variant. When assigned with results of "Split" function , it becomes an Array..

REgards
Veena
Forum: Visual Basic 4 / 5 / 6 1 Day Ago
Replies: 9
Views: 87
Posted By QVeen72
Re: How to seperate the text file data using Mid Function?

Hi,

Just Use Split function..


Dim TArr
Line Input #1, a(i)
TArr = Split(a(i),",")
ProductID(i) = TArr(0)
a(i) = TArr(1)
Forum: Visual Basic 4 / 5 / 6 1 Day Ago
Replies: 2
Views: 70
Posted By QVeen72
Re: Ivalid Use of New Keyword error

Hi,

Recordset also need to be decalred as New..


Dim adoRecordset As New ADODB.Recordset


also give Full Path of the Database in connection string..
Forum: Visual Basic 4 / 5 / 6 1 Day Ago
Replies: 9
Views: 87
Posted By QVeen72
Re: How to seperate the text file data using Mid Function?

Hi,

Have you Transferred all f your contents to array a..?

If not, You need to Open the Text File First:
Open "C:\MyFile.txt" For Input as #1

and Loop Thru File Contents using
Line Input...
Forum: Visual Basic 4 / 5 / 6 2 Days Ago
Replies: 7
Views: 133
Posted By QVeen72
Re: help! "too many lines continuations" error

Hi,

Selva asuumes that your Recordset object name is "adoRS" and it it is opened.. if it is not, then change the variable name to your variable name of the recordset

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 4 Days Ago
Replies: 5
Views: 2,819
Posted By QVeen72
Re: Bind ListBox to ADODB.Recordset

Hi,

Use DBListBox, Set datasource to an ADODB.recordset.. and bind

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 4 Days Ago
Replies: 2
Views: 71
Posted By QVeen72
Re: green screen problem

Hi,

Was that Complete code..? or you forgot one more Outside loop for ScaleWidth...?

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 4 Days Ago
Replies: 2
Views: 68
Posted By QVeen72
Re: sum up a fields

Hi,

Connection Object is not mentioned...:

rsArmaster.Open "select sum(balance) as credit from ArMaster where shippercode= '" & shippercode & "'" ,Conn

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 7 Days Ago
Replies: 7
Views: 133
Posted By QVeen72
Re: help! "too many lines continuations" error

Hi,

Check this :


Dim i As Integer
Dim j As Integer
i = 0
Do While Not rekod.EOF
i= i +1
Forum: Visual Basic 4 / 5 / 6 9 Days Ago
Replies: 2
Views: 156
Posted By QVeen72
Re: Visual Basic 6.0 to Oracle 8i connectivity

Hi,

You have to give "Server" name also..
whatever service name you have given in Net Configuration :

db.open "Provider=MSDAORA.1;User id=ourpro;Password=ourpro1;Persist Security info=False;...
Forum: Visual Basic 4 / 5 / 6 13 Days Ago
Replies: 4
Views: 233
Posted By QVeen72
Re: Adding Time Values

Hi,

Instead of simply using Sum, use this Query:

Select Sum(Val(MyDateTimeFld)) From MyTable

You will get total Time,
Later you need to get the Decimal Part, Integer Divide by 60, add it to...
Forum: Visual Basic 4 / 5 / 6 14 Days Ago
Replies: 4
Views: 233
Posted By QVeen72
Re: Adding Time Values

Hi,

You want to get Total in a Single Query..?
Is the Field in Access Table DateTime field or Single/Decimal field..?
You can do it in a single query...

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 16 Days Ago
Replies: 3
Views: 169
Posted By QVeen72
Re: Using Where clause

Hi,

Once already Where is given in the first statement, after that use only "And"

Change the second line to :


If Trim(strChoice) <> "" Then
strtemp = strtemp & " and type ='" & strChoice &...
Forum: Visual Basic 4 / 5 / 6 18 Days Ago
Replies: 4
Views: 183
Posted By QVeen72
Re: Calling subroutine

Hi,

Yes, You have to Create the procedure as "Public" if you want to call it in other forms through out the project..

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 18 Days Ago
Replies: 6
Views: 229
Posted By QVeen72
Re: transferring vb6 tabular data to MS word

Hi,

I guess, it must have been installed in your system.
In VB Editor check menu:
AddIns >> Report Designer

REgards
Veena
Forum: Visual Basic 4 / 5 / 6 18 Days Ago
Replies: 6
Views: 229
Posted By QVeen72
Re: transferring vb6 tabular data to MS word

Hi,

Yes, I know, its a Standard Export Invoice Format. I have designed it using CR. Well the Top Portion Goes into Page Header. Place Lines/Boxes etc..
And Place the Detail Fields (Qty / rate) in...
Forum: Visual Basic 4 / 5 / 6 19 Days Ago
Replies: 6
Views: 229
Posted By QVeen72
Re: transferring vb6 tabular data to MS word

Hi,

Use Crystal Report. Design the Report using all the Lines and Boxes. Connect to the Database. Insert the Table where all the Details are stored. Place the Fields in Respective Columns.
Now from...
Forum: Visual Basic 4 / 5 / 6 19 Days Ago
Replies: 2
Views: 144
Posted By QVeen72
Re: Enum vlues into Combo

Hi,

It should Retrieve all Distinct Column from the table.. Can you post some Sample data as of what kind of string is left out....?

Regards
Veena
Forum: VB.NET 19 Days Ago
Replies: 5
Views: 288
Posted By QVeen72
Re: Error While Connecting to Database

Hi,

You need to First Create a Public User, in "SQL Server Authentication Mode" .
and give permission to the database.
Also Select Default Database for this User.
And You need to login thru this...
Forum: Visual Basic 4 / 5 / 6 21 Days Ago
Replies: 3
Views: 289
Posted By QVeen72
Re: Displaying multiple similar names in a listbox

Hi,

For Access database(.mdb) , Like operator works with *

Try this :

" Where P.Name Like '*" & sName & "*' "

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 24 Days Ago
Replies: 2
Views: 198
Posted By QVeen72
Re: problem using list.removeitem to delete multiple selections

Hi,

Try this:

Dim i As Long
For i = (lstFrom.ListCount - 1) To 0 Step -1
If lstFrom.Selected(i) = True Then
lstTo.AddItem lstFrom.Column(0, i)
lstFrom.RemoveItem i
If lstFrom.ListCount = 0...
Forum: Visual Basic 4 / 5 / 6 25 Days Ago
Replies: 6
Views: 362
Posted By QVeen72
Re: Combobox

Hi,

If you are using VB6, open the recordset to the table, loop thru and populate the combo box, Check this :


Dim RST As New ADODB.RecordSet
Combo1.Clear
RST.Open "Select Distinct Title From...
Forum: Visual Basic 4 / 5 / 6 25 Days Ago
Replies: 7
Views: 231
Posted By QVeen72
Re: Frames in tabstrips

Hi,

It is not a type library,
Go to menu : Projects >> Components
Select Microsoft Tabbed Dialog Control 6.0 click OK,
and add it on the form..

REgards
Veena
Forum: Visual Basic 4 / 5 / 6 27 Days Ago
Replies: 6
Views: 362
Posted By QVeen72
Re: Combobox

Hi,

You mean, you want both Enum and ComboBox to be filled with data from the database table...?

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 27 Days Ago
Replies: 8
Views: 295
Posted By QVeen72
Re: Problems with saving 1st record

Hi,



In above code, after confirm, you are not altering emp name, may that could be the reason..
may be this sort of like should be included.. :

row.employee_Name =...
Forum: Visual Basic 4 / 5 / 6 30 Days Ago
Replies: 4
Views: 258
Posted By QVeen72
Re: How to code for a login form by taking data from Oracle db?

Hi,

You need an ADO Connection object and a Recordset object .
First open the Connection to the Oracle database.
and open a Recordset with this Query:
"Select * From Login_Info_Table Where UserName...
Forum: Visual Basic 4 / 5 / 6 30 Days Ago
Replies: 7
Views: 544
Posted By QVeen72
Re: Adodc.recordset.update

Hi,

For the ADODC, have you set the Database and Record source property...?
And why "Update" without Addnew or Edit..?

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 31 Days Ago
Replies: 5
Views: 394
Posted By QVeen72
Re: using Horizontal scroll bar in visual basic

Hi,

Make TextBox's property :
MultiLine = True
ScrollBars = 3 ' Both

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 31 Days Ago
Replies: 5
Views: 435
Posted By QVeen72
Re: code to add 15 days to a given date.

Hi,

Use DateAdd function


Dim TDate As Date
TDate = CDate("01-06-2008")
MsgBox DateAdd("d", 15, TDate)
Forum: Visual Basic 4 / 5 / 6 34 Days Ago
Replies: 4
Views: 389
Posted By QVeen72
Re: VB6 Package and deploy with access 2007

Hi,

Along with EXE, Have you copied the Database also..? With P&D Wizard, database is not copied automatically, you need to copy it your self..

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 34 Days Ago
Replies: 4
Views: 389
Posted By QVeen72
Re: VB6 Package and deploy with access 2007

Hi,

I Guess, you also need to add this reference:

Microsoft ActiveX Data Objects 2.5 Library
(or later version)

Regards
Veena
Forum: Visual Basic 4 / 5 / 6 Jun 20th, 2008
Replies: 7
Views: 324
Posted By QVeen72
Re: how to change properties of table

Hi,

Just Loop through all the Available columns and set the property..

For Each ACol In ATbl.Columns
ACol.Properties("Jet OLEDB:Allow Zero Length").Value = False
Next


Regards
Forum: Visual Basic 4 / 5 / 6 Jun 19th, 2008
Replies: 7
Views: 324
Posted By QVeen72
Re: how to change properties of table

Hi,

Comment it .. or
use SET

Set ACat = New ADOX.Catalog


Regards
Veena
Forum: Visual Basic 4 / 5 / 6 Jun 18th, 2008
Replies: 7
Views: 324
Posted By QVeen72
Re: how to change properties of table

Hi,

Try this code:


Dim AConn As New ADOdb.Connection
Dim ACat As New ADOX.Catalog
Dim ATbl As ADOX.Table
Dim ACol As ADOX.Column
'
Forum: Visual Basic 4 / 5 / 6 Jun 17th, 2008
Replies: 2
Views: 530
Posted By QVeen72
Re: Format Number in Sql Query

Hi,

Try this SQL Statement:


SELECT REPLICATE('0', 4 - DATALENGTH(MyCol)) + MyCol AS TempCol FROM MyTable


Note: You will get Null, if the Column Length Exceeds 4 chars..
It is always a Good...
Showing results 1 to 40 of 500
Page 1 of 13 1 2311 > Last »

 
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 2:24 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC