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.