User Profile

Hemant Pathak · Jun 7 '07, 08:23 AM

Button Name=:Command1
Lable Name = lbl1

Private Sub Command1_Click( )
lbl1.caption=va l( lbl1.caption)+1
end sub...

Hemant Pathak · Feb 10 '07, 07:33 AM

if app.Instance then
exit sub
end if

Hemant Pathak · Jan 10 '07, 04:52 AM

Hi RKalai]Hi,

its a common error with visual basic deployment u can use advanced package builder Like [InstallShield] and [Setup Factory].

Hemant Pathak · Dec 8 '06, 01:28 PM

Hi Archana there is a two option of Discard Save data in Crystal Report and its depend on using on Crystal Report

1. if u r using .dsr file format then write the when u calling crystal report
object.DiscardS avedData

2. if u r use .rpt File then Open the crystal report and Go File Menu and UnCheck this Menu :: Save Data With Report.....

Hemant Pathak · Oct 26 '06, 03:56 PM

Hi............. ..

There are quite a few differences in VB6 and VB.NET. We will highlight some of these here in points:

The greatest change in VB6 and VB.NET is of runtime environment. VB6 used the VB-Runtime while VB.NET uses the .Net Common Language Runtime (.Net CLR). The CLR is much better designed and implemented than VB-Runtime. The CLR uses better code translation through Just in Time compiler...

Hemant Pathak · Oct 15 '06, 06:33 AM

'FOR SAVING THE KEY IN REGISTRY
SaveSetting App.Title, "SubKeyName ", "KeyName", "Key"
'FOR FATCHING THE KEY IN REGISTRY
retVal = GetSetting(App. Title, "SubKeyName ", "KeyName")...

Hemant Pathak · Oct 10 '06, 03:41 PM

Hi............. ............... .

Private Sub Command1_Click( )
Dim a As Double
a = 1230.51
Debug.Print Round(a, 0)
Ans=1230
a = 1230.5
Debug.Print Round(a, 0)
Ans=1231
End Sub

Hemant Pathak · Oct 8 '06, 08:03 AM

To add a new record, the program lets the user select a graphic file. The program opens the file and reads it in blocks of binary data. For each block, the program uses AppendChunk to add the block to the database

Code:

 
Private Sub mnuRecordAdd_Click()
Dim rs As ADODB.Recordset
Dim person_name As String
Dim file_num As String
Dim file_length As String
Dim bytes() As Byte
Dim num_blocks

...

Hemant Pathak · Oct 6 '06, 06:38 PM

HI............. ............... ..

JUST USE VB PACKAGE & DEVELOPMENT WIZARD

JUST GO START MENU --> PROGRAMMS -->MICROSOFT VISUALSTUDIO 6.0 -->MICROSOFT VISUAL STUDIO 6.0 TOOLS--->Package & Deployment Wizard

AND FOLLOW THE INTRACTIONS.... .........

Hemant Pathak · Oct 6 '06, 06:34 PM

Hi............. ..

STDDEV is unreconiz function
it is STDEV and syntex is use MS-ACCESS HELP

STDEV
Estimates standard deviation based on a sample (ignores logical values and text in the sample).

Syntax

STDEV(number1,n umber2,...)

Number1 Number1, Number2, ... are 1 to 30 numbers that correspond to a sample of a population and can be numbers or references that...

Hemant Pathak · Oct 5 '06, 06:31 PM

Control use
1. Dir1 and Visible Property=false
2. Combo Box

Private Sub GetChildFolder( )
Dir1.Path = App.Path '& "\rootFolderNam e"
For i = 0 To Dir1.ListCount - 1
Combo1.AddItem TrimMark(Dir1.L ist(i))
Next
End Sub

Private Function TrimMark(str As String) As String
Dim i As Integer
i = 1
Do Until...

Hemant Pathak · Oct 5 '06, 06:18 PM

Public Function BackupDatabase( Optional ByVal FileName As String="Default ") As Boolean
On Error GoTo Back_Database
Dim fso, fs, Src, Dst
Src = App.Path & "\Database. mdb"
If FileName = "Default" Then
Dst = App.Path & "\Backup\Databa se.mdb"
Else
Dst = App.Path & "\Backup\" & Trim$(FileName) & ".mdb"
End If...

Hemant Pathak · Oct 4 '06, 08:53 PM

Hi............. ...............

u can use this Query

UPDATE TABLENAME SET COLUMNNAME=VALU E WHERE DATE=#GIVEN DATE#

User Profile

Profile Sidebar

All database backup in a single query

File deleted on network

Export Table Or Query Through VB

Leave a comment:

How to Call SQL Store Produ.

Data Flow Diagram

Leave a comment:

Crystal Report Database Problem

Leave a comment:

Leave a comment:

VB Temp File Problem

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment: