Hi,

I think that the Data1 object is not set to database.

If not please set the below property for Data1 Object
Databasename
RecordSource

Thanks
Mahesh

Hi,

Please use the variable as formname.variablename instead of using the variable name directly..

For Example
Form Code
Public Var1 as integer
Call Func1()
Module Code
Sub Func1()

Hi,
Below code can helps you..

convert(numeric, ISNULL(quantity, '0'))

Hi,
Please find the code below to create VB Controls/Array of Controls Dynamically

Dim ControlArrayCOunt As Integer
Dim txtControlArray() As TextBox
Private Sub Create_Control()
On Error GoTo...

Hi Sameer,

If you are using VB6 then u need to use Command object.

Please see the below example
Dim mobjConn As ADODB.Connection
Dim mobjCmd As ADODB.Command
Dim mobjRst As ADODB.Recordset...

Once you completed using the control in the code try to kill the object using nothing.
I mean to say that in the form unload event try to kill objects (Use set <object,OCX control> = nothing) I...

Hi,

Please send the details of your actual requirement.

Hi,
when barcode reader was installed in the system and when you tried to read the value the value will be automatically filled in the control when the cursor is placed in text box control....

Hi,
These are the functions to open the Excel file

Private Function OpenExcelFile(strFilePath)
'***** If File is already opened
If IsFileOpen(strFilePath) Then
Set objTempXlApp =...

Hi,
You want to open a excel file right?

Please help me to Print Layer content from Java Script without opening any popup window.

Actually i created a Layer.
When user click on View One Layer will be seen looks like widget displaying...

Hi Shreya,
Front End Will Be VB And BackEnd Will be DBMS

What Type Of Help Do u Want....
Do You Want The Database Design or GUI Designs Or Requirement Design

Regards
MaheshSayani

Hi
Try With this Code

Dim ReqStr as string
Open <File Path/Name> for input as #1
while not EOF(1)
Line Input #1,Str1
If UCase(Mid(Str1,1,3)) = "ID=" Then
ReqStr =...

Open <File Path/Name> for input as #1
while not EOF(1)
Line Input #1,Str1

take the rest of the string and do what you need with it
End loop

Hi
Try With This Code

If Val(Text1.text) > 0 or Text1.text = "0" then
Print "Is Integer
Else
Print "Not Integer"
End if

If Val(Text1.text) > 0 or Text1.text = "0" then

Ok Thanks

Hello
Please set the SSTab And Commabnd1 properties like visible,Top,Left after creaton

Hi
To Create TabUse Control Array

Load SSTab1(NextIndexValueofTab)' Used to create tab

load Command1(NextIndexValueOfCommand) ' used to create button

Command1(Index).container =...

Comatose
Iam unable to understand your sentence
"Yup, or you can get real crazy, and use directx "

please tell me wheather my suggestion is right or wrong
for thread Re: rectangle in vb

Hi

1 2
Itemname count on ist count on 2nd

Like Wise

Take one combo box consists of month values

after selection of month display datagrid in the formtaof

days in month in horizontal form
item and count of items in vertical form

2 3...

HI

are you executing the exe file or code in XP System

I think it is possible if you write one function to draw polygon using line controls and by using parameter arguments in the function you can change the angle of shape

If you want to send the month name as parameter to crystal report to display then create one formulaefield in cruystalreport

and from vbcode

crpt.formulaes(0) = "<FORMULAENAME in CRYSTAl...

if crpt is the control name used in the form then

Code is:
CRPT.selectionformulae = "payperiod like '" & SSTab1.Caption & "%'"

Try it once

Put Access specifier also

Private Type Structurename

End Type

Hi
Your code for rs3.Fields(3).Value = List1.Text has to be change

Try changing code like
rs3.Fields(3).Value = List1.list(itemnumber)

'itemnumber is the element you want to assign from...

Hi
I Think your access database is not in compact mode if not goto options menu and check on
compact on close option
This may solve your problem

hi all
i want to learn more about DLL and ActiveX control
I Want the link of any site which offers learning about dll and active x in vb with Examples and demo to how to create then in step by step...

Thanks For Your Help Mr Comatose

Hi All
I Want To Create Semi Transparent Forms
I Had done work on Transparent forms but i need semi transparent form which we can see background text/image through this form in vb
please send me...

Thanks For your help Mr.Comatose.

Hi To All,

How can the Network LAN Connection to be Enabled/Disabled
through Vb Code

Hi Embeza ,

Freefile should be used before opening of file
it is used to assign next existed filenumber


Syntax of Reading Files is

x = freefile()
Open (filename with Path) for...

Hi Embeza ,
In the following code you had sent,there is no value assigned to Inputfilevariable
And you have to use function Freefile before opening file
mean
Syntax of Reading Files is

x =...

Thanks Comatose

I Think You want to place Program Icon in Tray right?

Here Is the sample code

The Mistake is for Rs.open there should be only 4 arguments

Dim cnn As New ADODB.Connection, rs As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data...

Hi
this is the code for creating Array of Controls in Run Time
Index Number Is the free number which doesn exist for the Control Label1

Load(Label1(indexnumber))
Label1(indexnumber).visible =...