jhai_salvador

1. Rename your column name 'order' because ORDER is a reserve words/keyword in sql. 2. Check your date format (Edate = #" & txtEdate.Text & "#")

1. (sugestion) Move connection close inside "If delete_confirmation = MsgBoxResult.Yes Then" 2. After delete, just clear out your textboxes txt_pid.Clear txt_pname.Clear ....

do not hardcode your database path. Just make your setup structure like this: App.exe (your compiled app) database\db.mdb (your database) Then on your code where you connect to database, you can do it like this: `App.path & "\database\db.mdb"` thats it. hope it helps.

obviously its an syntax error in your sql. post the code where it breaks so we can help you.

This question has been asked and answered several times already. if you try to use the search bar on this forum, you find the answer to your question. you can also use GOOGLE to find answer to your question. here are some links that could help you. https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/29709/search-code-in-a-database https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/334183/how-to-create-a-search-command-in-vb6 https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/445719/how-to-search-database-and-display-matching-record-in-vb6-

can you tell us what are you planning to do after reading a multiple length barcode?.. If Len(txtMessage.Text) > 4 and Len(txtMessage.Text) < 13 Then txtMessage.SelStart = Len(txtMessage) your code should accept barcode 5 up to 12 digit

Is this purely on SQL or it will be use in VB6?

You can use ADODC control or ADODB reference.

You want to clear a textbox?.. use this.. [CODE=vb]Text1.Text = ""[/CODE]

Hi! I don't know where to post this, but since this is vb6 thread i'll just post it here. I need all of your support by voting Visual Basic Classic to be improved. here is the link: [Bring back Classic Visual Basic, an improved version of VB6](http://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/3440221-bring-back-classic-visual-basic-an-improved-versi) To vote: Click …

1. Try to use search 2. check this thread: [Click Here](http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/119916/save-edit-delete-vb-6-using-ms-access)

what kind of api? windows api? rest api? you should give more info when asking questions.

how about posting the error?..

I use SaveSettings/GetSettings in my program to; Store textbox value - savesettings will save the value of my textbox when user close the form or press save button, so when user open the app getsettings will be performed to retrieve the value of it. getsettings/savesettings store value in your system …

1. If you shared your ms access database, it might look something like this; \\192.168.1.1\SERVERPC\MYDB.accdb and NOT \\192.168.1.1\SERVERPC\C:\MYDB.accdb; Try to open \\192.168.1.1\SERVERPC\ and see if the database exist or not.

How about you use M$ HTML Object library and M$ WinHTTP Services you can find it on VB6 Project > References Use WinHTTP Services to GET documents source (HTML Source) Then use HTML Object Library to parse it by passing it to HTML Document Object Like this Dim doc As …

My fan is also noisy especially when booting it up. any can help us with this?

Hope this helps you: http://www.daniweb.com/software-development/visual-basic-4-5-6/code/455533/saving-and-extracting-image-to-recordset

How about arrays? Private Function ReturnArrays(SomeArgs As String) As String() 'Code goes here End Function You can also use user define types and even classes.

How I wish VB 6.0 was 2006.. ahaha.. anyway, what does the title on the error says? For 64Bit OS make sure that you run and install your vb6 app with admin rights.

Add the snippet in your module. **Requirements:** * Make sure you have reference to M$ ActiveX Data Objects Library (ADODB) * A table field with OLE Object / BLOB as datatype * A recordset that is already oppened and ready to be use **To save Image on your table field, …

so its in csv format. you can easily read/write that using vb6. can you show us what you have done so far?..

try learning the basic of adodb; Learn how to connect a database using ADODB.Connection Learn CRUD (Create, Read, Update, Delete) using ADODB.Recordset What have you done on your project so far?..

Did you define interpo correctly?.. Did you initialize interpo object correctly?.. Are you using late binding or early binding (using reference)?..

on what line youre having an error?.. if its on Adodc1.Recordset make sure that your adodc1 is connected and loaded with records.

so what is your problem?.. What is the error you encounter with your code?..

I will help you for a price.. I will code it if you want to.. :D

Follow what tinstaafl said and also start learning to use array objects and variables. I promise you that you're life will be easier on using array objects ;) OT: I don't know where to post this but i need your support by voting Visual Basic Classic to be improved: [Bring …

Try searching google first, or maybe planetsourcecode which have a lots of sample code.

This is a sample code. 'For loop dim i as integer for i = 0 to 5 debug.print i next 'while loop dim i as integer i = 0 while i <> 5 i = i + 1 debug.print i loop

> How to connect a vb6 executable files to A website? Can you please explain it more?..

Well i don't know how but you can use the clipboard object in vb6 to get and set clipboard content.

Follow what AndreRet said. Error handler will do the trick. Another method would be doing it like this (like what tinstaafl is saying): Dim x As String x = InputBox("Input a number") MsgBox Val(x) variable x is string since the return of InputBox is also a string.

heres what you can do: 1. Open your template form in notepad (form with the extension of .frm) - this is the form you want to copy the menu. 2. After you open it with notepad, find the Begin VB.Menu and COPY it. Something like this; Begin VB.Menu mnuGroups Caption …

how about writing it in basic html?..

why not do it in php or asp since it will be online?..

> OUTLOOK WEB APP > > OUTLOOK WEB APP > > hi AndreRet, > > basically what my req. is when i press button in vb6 then it redirect me to browser(i.e. ff,ie.chrome) and my all values (i.e. Send to, CC, mail subject,etc) also filled in outlook web app respective …

yes, same on me, daniweb crashes on firefox.

use appropriate tags, share it in social networking sites like facebook. Have you tried posting it to some triffic exchange site?..

have you tried it without using late binding?..

just do what ponnu said, you can replace rs.Fields("NAME").Value & ", " & RsFields("AGE").Value with var1 & ", " & var2 etc if your using variables and not database.

google clipboard object for cut copy and paste.

This is my code in adding picture to database: Add this code to your module: Public Function SavePictureToDB(tblName As String, _ WHERECondition As String, _ FldName As String, _ strFileNm As String, _ xcn As ADODB.Connection) As Boolean Dim FF As Integer Dim rs_pic As ADODB.Recordset Dim Fl As Long …

you can also add vb4android which also got BASIC syntax same like visual basic.

> We plan on doing lots more contests in the future ... we're just getting our feet wet and we'll learn what works and what doesn't as we go along! :) Well, I hope next time we can just have a programming contest and submit a fully working application and …

If the database is Access then all you have to do is Share its folder and make it writable so it can be access through lan connection...

Well, as what the error said, make sure your database path is valid. Anyway, can you post your database connection code?

> I want to show a form and on top of that form I want to show another form. I want to be able to access any of the two forms (so I can't use vbmodal) Then you should use SetWindowPos API. Check this out http://www.ex-designz.net/apidetail.asp?api_id=192

This is my code with Microsoft Speech Object Library as my reference [CODE=vb] Dim Voice As SpVoice Set Voice = New SpVoice '* This will display available voice in VB6 Immediate Window from your computer Debug.Print Voice.GetVoices().Count '* This will change the voice Set Voice.Voice = Voice.GetVoices().Item(0) '* Index 0 …