Hi everyone,
I have a problem in deleting a data that is connected on the database.. I tried this code but it shows me an error: Run-time error '-2147217900(8004 0e14)': Syntax error in string in query expression 'ID=". Here is the code that i did:
Dim cn As New ADODB.Connectio n
Dim rs As New ADODB.Recordset
Dim ab As String
cn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=C:\Docum ents...
Kyosuke18
Last Activity: Dec 14 '09, 06:17 AM
Joined: May 19 '09
Location:
-
problem in deleting data
-
hi smartchap,
I read your message thanks for the help.. regarding about vbskfr2.ocx is a vb skinner.. I change the design of the form instead of using a classic form. I just follow ur instructions on the green or asterisk.. I have problems again regarding flexgrid.. since you've entered the
RowClicked = Me.MSFlexGrid1. TextMatrix(Me.M SFlexGrid1.RowS el, 4)
in the MSFlexGrid1_Cli ck event. When I clicked... -
Music Search
Hi Smartchap..
Thanks for the reply.. I test it and it works, thanks for that. Attached herewith is my program that I did so far.. I'm thinking of something to the table in database that I created, do I have to create another table for artist table, album table something like that instead of storing those records into one table? In the 3rd form that I created, I just tested on how to open a music and play...Leave a comment:
-
Hi smartchap..
Thanks for the rply.. Now I have another problem with my program again which is searching music and since it is ok i guess in searching a correct data... now I have 2 problems.. problem no. 1 in searching a data again, what if i have the same title when I search but different artist and same artist but different titles? for example, I type in titlebox Because of you by Ne-yo and Because of you by 98 Degrees.. Also regarding...Leave a comment:
-
Hello smartchap,
Thanks for the reply and I really appreciated it.. it works and i pass it to flexgrid.. and I try also using a procedure and I seperate the Title, Artist, year and album then calling the procedure.. thanks for the help.. Actually it works in terms of searching a record. my problem is that when I search it, the data will found but when I type another record, it adds to what I've search on the previous one.. I like...Leave a comment:
-
Hi everyone,
I have a program about search engine about music.. I like to add music player also but for now i just focus on searching a correct data on a database.. Since I use to study visual basic, I use practice as well. Below is the code wherein I have to search all the data on a database (THIS IS TO TYPE ALL THE TEXTBOXES AND WHEN ONE TEXTBOX IS NOT FILL, THE MESSAGEBOX WILL SHOW "Search not found". These are Title, Artist,...Leave a comment:
-
Hi to all,
Is there anyone know how to store images on a database, what are the procedures and also how to call? (citing an example would be appreciated) I know how to store data on a database like names, address, telephone number and other informations.. I used vb 6.0 and my backend is ms access.. anyone?! I need to know some of the concepts because I don't have any idea on it. very thanks if someone replies
=)Leave a comment:
-
Using vbCr and vbCrlf
Hi everyone,
I'm just confused in vbCr and vbCrlf.. Is there anyone who explain to me what is the function of those 2 codes? I didn't really understand. And I really want to know the concepts and planning also to make some sort of a program relating this code. And additional examples of using these 2 codes that I have mentioned earlier. I really appreciate it if someone replies.
Very...Leave a comment:
-
Hi Everyone,
I'm making a stopwatch application. The Form are consisting of 4 buttons which are Start Timing, End Timing, Exit And Clear. Also it has 6 Labels. Namely
...Code:Label 1 Caption=Start Time Label 2=End Time Label 3=Elapsed Time Label4=BorderStyle 1-Fixed Single Caption [Blank] Name lblStart Label5=BorderStyle 1-Fixed Single Caption [Blank] Name lblEnd Label6=BorderStyle
Last edited by Frinavale; Jul 21 '09, 08:19 PM. Reason: Please post code in [code] [/code] tags. Added code tags.Leave a comment:
-
Looping structures (do while loop)
hi daniel aristidou, sorry for the late reply but thanks for the post.. I really appreciated it. Well I will follow what you've mentioned so the next time I code, I will make a comment and trace it. I'm confused on the 2nd technique you've mentioned: "Another techique to use when checking ur code in loops is to use a variable table. Where you make a table and change the variables in order downwards...Leave a comment:
-
Hi everyone.. I made a program of Summation.. I have 2 labels, 1 textbox and 1 button. Once I typed the number in textbox for example "3" and click the button, the result is in Label where it says " The Summation of 3 is 6. I coded it using for next statement and it works, in do until loop it works also but when I used the DO WHILE LOOP sometimes it has infinite loop or the error that I encountered in "The Summation of 3 is 4"....Leave a comment:
No activity results to display
Leave a comment: