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,572 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,761 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 74
Search took 0.01 seconds. Posts Made By: manoshailu
Save these search results for 24 hours
Page 1 of 2 1 2 >
Forum: Visual Basic 4 / 5 / 6 1 Day Ago
Replies: 3
Views: 437
Posted By manoshailu
Re: [Excel Macros] Creating Macros to search and copy columns

hi

Try this select no. of columns from one sheet to another.


Sub copycolumns()

'
' copycolumns Macro
' Variable Declaration
Forum: Visual Basic 4 / 5 / 6 2 Days Ago
Replies: 1
Views: 64
Posted By manoshailu
Re: How can i retrieve records from data base in data grid through unbound coding

HI,

you can try the coding, this could helpful to u.



sql="select * from student"

if rs.state=1 then rs.close
Forum: Visual Basic 4 / 5 / 6 3 Days Ago
Replies: 2
Views: 141
Posted By manoshailu
Re: How to leave NULL value in access database table in VB6

Hi,

1) You can set the null value for the field by applying the value as "" or Not applying the value.

2) Check the Property for the Field

a) Required = No
b) Allow Zero...
Forum: Visual Basic 4 / 5 / 6 3 Days Ago
Replies: 7
Views: 223
Posted By manoshailu
Re: Using array like pattern matching?

Hi,

Try this one. I think this may be useful to u.


Private Sub Command1_Click()
Dim A(2) As String
Dim B(4) As String
Dim C as String
A(0) = 3
Forum: Visual Basic 4 / 5 / 6 7 Days Ago
Replies: 3
Views: 91
Posted By manoshailu
Re: How to add row and col into MsFlexGrid1

hi,

Simply you like to add rows and columns means you can use below code otherwise explain clearly what is ur need.


Private Sub Command1_Click()
MSFlexGrid1.Rows = 4
MSFlexGrid1.Cols...
Forum: Visual Basic 4 / 5 / 6 7 Days Ago
Replies: 3
Views: 437
Posted By manoshailu
Re: [Excel Macros] Creating Macros to search and copy columns

hi,

Try the below code.




Sub copycolumns()

'
Forum: Visual Basic 4 / 5 / 6 7 Days Ago
Replies: 1
Views: 110
Posted By manoshailu
Re: Help! to create a table in Oracle with dynamically assigned name from VB 6.0.

hi,


Store the whole query in string variable and execute.


SQL = ("create table " & vtblNametxt & " (id varchar2(3), pname varchar2(20), qtyp number(4))")
cn.Execute(SQL)
Forum: Visual Basic 4 / 5 / 6 7 Days Ago
Replies: 7
Views: 223
Posted By manoshailu
Re: Using array like pattern matching?

hi,

Array can be used only by loops and that could be very if u understand wel.
Try the below coding and if you have any doubts in below codings you can ask me i will explain u in detail.

In...
Forum: Visual Basic 4 / 5 / 6 7 Days Ago
Replies: 2
Views: 173
Posted By manoshailu
Re: Help with Excel Macro ...Please

hi,

Try below coding:


Sub fill2()
'
' fill2 Macro
'
Forum: Visual Basic 4 / 5 / 6 7 Days Ago
Replies: 7
Views: 223
Posted By manoshailu
Re: Using array like pattern matching?

hi,

You can do like below when using the variable instead of values.


IF a(0) like "*" & b & "*" THEN
-----------
-----------
...
Forum: Visual Basic 4 / 5 / 6 9 Days Ago
Replies: 5
Views: 307
Posted By manoshailu
Re: Connection.Execute command to Delete Records from MS Access Database Table

HI,

To Refresh the Recordset you can use the ReQuery which the query executes again to get the proper results.


Shailaja:)
Forum: Visual Basic 4 / 5 / 6 9 Days Ago
Replies: 7
Views: 223
Posted By manoshailu
Re: Using array like pattern matching?

Hi,

You can use Like Operator or StrComp Function for Pattern Matching in Array Variable or any other Variable. You can compare the Values like below Given:

1) Bring the Array Values in loop...
Forum: MS SQL May 6th, 2008
Replies: 1
Views: 278
Posted By manoshailu
Re: Simple query

hi,

Try the Below Query:

select c.cat_name,sum(pi.item_price * pi.item_qty) as total, c.c_vat_rate * total
from category c , purchase p,puchase_item pi,country co,seller s
where p.p_id=pi.p_id and...
Forum: MS SQL Apr 10th, 2008
Replies: 1
Views: 355
Posted By manoshailu
Re: Urgent Help Needed

hi,

Try the below Query:


UPDATE EMPLOYEE_DISTRIBUTIONS SET ED.DISTRIBUTION_GROUP = PH.DISTRIBUTION_GROUP FROM
PAYS_HISTORY PH ,ACCOUNT_HISTORY AH,
EMPLOYEE_DISTRIBUTIONS ED
WHERE...
Forum: MS SQL Apr 10th, 2008
Replies: 1
Views: 997
Posted By manoshailu
Re: Create an extra table (copy the columns and new table) for every existing table

hi,

Your code is right but u had used the @TABLE_NAME AND @AUDIT_TABLE. Both the variables are not the Table type so it wont allow to create the table to your requirement. Store the query in a...
Forum: Visual Basic 4 / 5 / 6 Apr 9th, 2008
Replies: 3
Views: 267
Posted By manoshailu
Re: query to select a range of transactions from mutiple tables respect to date??

hi,

Try to avoid Posting the same.

Try Below query:

Select CI.name,I.ServiceID,P.packagename,P.duration,sum(p.price),P.price,I.date,I.timeIn,I.timeOut
From CustInfo CI, InDate I, PakInfo P...
Forum: Visual Basic 4 / 5 / 6 Apr 9th, 2008
Replies: 1
Views: 150
Posted By manoshailu
Re: Brianstorm if it can help :)

Hi,

Try the below coding:

Sub attendance()
Dim i, j As Integer
Dim inp As Integer
For i = 1 To 65536
If Sheet2.Cells(i, 1) = "" Then
i = i - 1
Forum: Visual Basic 4 / 5 / 6 Apr 9th, 2008
Replies: 2
Views: 1,817
Posted By manoshailu
Re: Excel 2007 Macro/VB6 Run-time error 91:Object variable or with block variable not set

hi,

Try the below codings:

Sub Macro4()
'
' Macro4 Macro
'

'
Forum: MS SQL Apr 8th, 2008
Replies: 2
Views: 1,293
Posted By manoshailu
Re: Scalar Function

hi,
First Example is wrkg well. Then why you geting the errors Check well. And then for functions owner name is not an optional one, You must define the function name with owner name to execute...
Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2008
Replies: 4
Views: 252
Posted By manoshailu
Re: calculate total

hi,

CStr is used to Convert from other format to String Format then how can u add the values of the two variables. K. Anyway U can use Format function like below

MsgBox Format("32234324",...
Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2008
Replies: 4
Views: 635
Posted By manoshailu
Re: VB monthview control

hi,

If the textbox control taking this format means "MM/DD/YYYY" check that textbox DataFormat property. Because if u set the DataFormat Property as "MM/DD/YYYY" then textbox takes format...
Forum: Visual Basic 4 / 5 / 6 Mar 21st, 2008
Replies: 2
Views: 699
Posted By manoshailu
Help Re: Type Mismatch error with Time formatting - Using Visual Basic for Excel Macro

hi,

Coding is right but the value assigned for the variable 'bottom' is 1. 1 means it takes first row in the excel sheet that row could be a header row that is the column name so that error...
Forum: Visual Basic 4 / 5 / 6 Mar 21st, 2008
Replies: 1
Views: 170
Posted By manoshailu
Help Re: VB4 layers

hi,

Actually Frame and picture control is said to "Container Control". Because we can place any controls within that controls. So u place the Image control in Picture Control.



Shailaja:)
Forum: Visual Basic 4 / 5 / 6 Mar 21st, 2008
Replies: 4
Views: 635
Posted By manoshailu
Help Re: VB monthview control

hi,

Defaultly Monthview Control date format is "dd/mm/yyyy" then how u getting that format. If the format is like that mean no problem because vb convert the date to "dd/mm/yyy" and then...
Forum: Visual Basic 4 / 5 / 6 Mar 14th, 2008
Replies: 3
Views: 521
Posted By manoshailu
Solution Re: Problem in VB 6.0 I cannot update my database?

hi,

I think you used the adLockReadOnly Lock type. So it displays error. If you use the adLockReadOnly Lock type then the records are said to be readonly record so it wont allow u to...
Forum: VB.NET Jan 28th, 2008
Replies: 0
Views: 488
Posted By manoshailu
Help list contraints of access table using vb.net 2005

Hi,

I need to bind the primary column name and table name in one combo box and foreign key column name and table name in another combo box using vb.net codings with access tables.

...
Forum: VB.NET Nov 15th, 2007
Replies: 3
Views: 1,707
Posted By manoshailu
Help Re: how do i save data in vb to access 07

hi,

Error 1 Name 'import' is not declared.

U have to write the namespace in the outside of the procedures that is it should be top of the coding in the form.

Error 2 'System.IO' is a namespace...
Forum: VB.NET Nov 15th, 2007
Replies: 8
Views: 1,194
Posted By manoshailu
Help Re: manipulate text files

hi,

Try the below codings:

Dim con As SqlConnection = New SqlConnection("server=shailu;uid=sa;pwd=;database=pubs")
Dim cmd As SqlCommand = New SqlCommand
Dim fs As...
Forum: VB.NET Nov 10th, 2007
Replies: 8
Views: 1,194
Posted By manoshailu
Help Re: manipulate text files

hi,
Use the below codings.
in my text file
01.08.2007
06:00 go to work
12:00 lunch
17:00 go home
19:00 dinner
21:00 go to bed
09:00 go to leisure centre
Forum: VB.NET Nov 10th, 2007
Replies: 1
Views: 500
Posted By manoshailu
Help Re: HOW To Save Two different entries in two different database

hi,

Whats the problem storing the data to the database? U had placed the control in the panel thats all. The panel is the contrainer control which is used to place the multiple controls in...
Forum: VB.NET Nov 10th, 2007
Replies: 1
Views: 527
Posted By manoshailu
Help Re: VB 6 and Oracle to VB Net and Oracle Issues

hi,

I had modified some of the codings and attached the file with this. Check it and send me the feedback.

best regards,
shailu:)
Forum: VB.NET Nov 9th, 2007
Replies: 3
Views: 1,707
Posted By manoshailu
Help Re: how do i save data in vb to access 07

hi

Try the Below codings,
import system.io
'Reference - Microsoft Access 10.0 Object Library
SaveFileDialog1.Filter = "(*.mdb)|*.mdb"
...
Forum: VB.NET Nov 9th, 2007
Replies: 2
Views: 353
Posted By manoshailu
Help Re: Plz Help me hurry!

' while form load bind the data in datagird control
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As SqlConnection = New...
Forum: VB.NET Oct 25th, 2007
Replies: 2
Views: 15,596
Posted By manoshailu
Help Re: get the selected row in datagridview

hi,

Use the below coding:

Private Sub upload_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sqlcn As New...
Forum: VB.NET Oct 25th, 2007
Replies: 3
Views: 1,201
Posted By manoshailu
Help Re: login verification form

hi,

Use the below coding
Sql Server Connection
Dim con As SqlConnection = New SqlConnection("server=shailu;uid=sa;pwd=;database=master")
Try
con.Open()
Dim cmd As...
Forum: VB.NET Oct 25th, 2007
Replies: 3
Views: 3,081
Posted By manoshailu
Help Re: connection string in vb.net 2003

hi,

Use below codings:

using ODBC
'Imports the ODBC Namespace
Imports System.Data.Odbc
'Declare the Connection
'Here i used the DSN
'To create DSN
Forum: VB.NET Oct 25th, 2007
Replies: 3
Views: 3,081
Posted By manoshailu
Help Re: connection string in vb.net 2003

hi,
Use below any of the codings:

using ODBC
'Imports the ODBC Namespace
Imports System.Data.Odbc
'Declare the Connection
'Here i used the DSN
'To create DSN
1. Start->Run-> ODBCAD32
Forum: Visual Basic 4 / 5 / 6 Oct 5th, 2007
Replies: 3
Views: 1,467
Posted By manoshailu
Help Re: HELP pls, making a Login form.

hi,

Follow the below instructions, if u hv any doubts u can ask me.
1) First set reference to use ADO Project Menu-> Reference-> Microsoft Activex Data Objects 2.6 Library
2) Create...
Forum: Visual Basic 4 / 5 / 6 Aug 8th, 2007
Replies: 2
Views: 967
Posted By manoshailu
Help Re: anybody can teach me how to open an image.

hi,


To open or load an image to image or picture box by selecting the pictures try the below code.
'To include common dialog control to form
Project menu->Components->Microsoft Common Dialog...
Forum: Visual Basic 4 / 5 / 6 Aug 8th, 2007
Replies: 1
Views: 2,859
Posted By manoshailu
Help Re: time difference in vb6

hi,

u can find difference between date and time by using datetime function.
:-/
Try the below coding:

'To find Days

DateTime.DateDiff("d",Text1.Text,now)
Showing results 1 to 40 of 74
Page 1 of 2 1 2 >

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