User Profile

Lavs · Jun 25 '07, 12:27 PM

Thank You Sonya and Purple

Soonya and Purple! Thank you for your replies. Can we be friends? I'm hoping to hear a lot from you soon...

Lavs · Mar 29 '07, 04:10 AM

try this one...

Set conn1 = New ADODB.Connectio n
strConn = "DSN=READ;UID=M e;PWD=MeMeMe;SE RVER=read_serv; "
conn1.connectio nstring = strConn
conn1.open

Lavs · Mar 29 '07, 02:28 AM

DO it like this,

ADODC1 is the name of the ADODC control.

Code:

with ADODC1.Recordset
        if .recordcount = 0 then
             msgbox "Empty Recordset"
             exit sub
        end if
        .movefirst
        .find = "idno = '" & txtidno.text & "'"
        if .EOF then
              msgbox "No match found"

...

Lavs · Mar 29 '07, 02:04 AM

Hello...

Are you using a Recordset? In Vb, I guess you have to store the Data from your database to a recordset object. You can then use the Filter method of recordset object to filter data under given condition. If example you have a recordset named RSTPROFILE, then

RSTPROFILE.Filt er = "lastname = '" & txtlastname.tex t & "'"
to remove the filter just use
RSTPROFILE.Filt er...

Lavs · Mar 28 '07, 11:08 AM

Halu there! :-) thanks for sharing your ideas.

I got the shell ( ) also...

try this

shell("cmd.exe /c " & "copy c:\firstfolder\ db1.mdb e:\secondfolder ")...

Lavs · Mar 28 '07, 10:16 AM

Halu! :-) Create a project in vb. Add 1 button on the form, also add a textbox.
The textbox just show you the number of clicked you've done. If the number of clicked is equal to 10, a msgbox will be displayed, and the counter variable A is set back to its initial value which is zero(0).

Dim a As Integer

Private Sub Command1_Click( )
a = a + 1
Text1.Text = a
If a = 10 Then
...

Lavs · Mar 28 '07, 07:50 AM

Thanks a lot for your help. I'll try looking for what you've advised me. By the way, you're right, i mean 3 inches by 5 inches(3" 5", not 3' 5")lol.
You're smart coz you're able to notice it. By the way i hope this is not the last time you'll help me.

Have you tried using the shell( ) in vb 6.0 in this manner?

shell("cmd. exe /c " & "c:\firstfolder >copy db1.mdb e:\second...

Lavs · Mar 28 '07, 07:36 AM

Thank you very much... The code works... I had tried it before but i omitted the filetitle in the secondfolder that's why i got a path/file access error.

Anyway it now works... thank you so much...

By the way, if you have any idea about the other way i want, the one using shell to copy the file, please give me also. Because i want to be able to learn on supplying dos commands to shell function in vb6.0...

Lavs · Mar 26 '07, 06:57 AM

Halu! i have a problem of how to create a backup files. My file is a database file created in MS Access. I want to copy the whole mdb file to another directory. Is there a command in vb6.0 for copying files from one directory to another? I badly need it now...

Lavs · Mar 23 '07, 07:20 AM

Hi there! :-) thanx for entertaining my question. I'm new to all these things that i'm using now. i have not yet encounter the printer properties. I thought the data report size can be set in design time. By the way, can you please send me a sample code if you have, because i have no time to explore, i am still working on some bugs in my code, and also working for the unfinished part. Thank you very much...

Lavs · Mar 6 '07, 10:50 AM

Halu there... this is my suggestion...

'You should have three textboxes, a label, and one command button...
'Use the Replace() function in visual basic

Dim OriginalString, Replacement, tobeReplaced As String
Private Sub Command1_Click( )
OriginalString = Trim$(Text1.Tex t)
Replacement = Trim$(Text2.Tex t)
tobeReplaced = Trim$(Text3.Tex t)
Label1.Caption = Replace(Origina lString,...

Lavs · Mar 6 '07, 10:09 AM

Halu... I'm a new member of this forum. I just read your post about the datagrid that doesn't show data from the database. And definitely, I can't answer that question because I myself is a beginner in Visual Basic Programming. I'm here to ask you something... It's all about creating a backup files to a storage device...
Can you please give me a sample code for creating a backup files to any storage device like CD ROMs, Floppy Disk, Flash...

User Profile

Profile Sidebar

Leave a comment:

Where to get the PHP installer

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

How to use the shell function in vb6.0 to copy file from one directory to another

Leave a comment:

Leave a comment:

How to make a data report as small as an index card 3" X 15" for creating a catalog?

How to insert and read an image from and into an access database using SQL statement

Leave a comment:

Leave a comment: