Recent content by powerblade

thnx moke for assistance and advice. Ok i will play around with the code and post my final solution :). thnx this form is the best!

Thnx moke. The end result is exactly what i talking about.:D Offcourse i understand that sample 1 was for quick test. Your workaround works fine, i can implement in mine code...So in fact my question has answered. I wonder if we could combine several buttons in 1 vba code like i mentioned...

thnx for the sample database. Its allmost what i want, but youre sample works only if the categorie ID is same so : 10-0001 10-0002 <=missing 0003 ie 10-0003 so above works fine. i added manually to your sample table 2 or more categories 10-0001 20-0001 10-0002 20-0002 10-0004...

The created productID is datatype is number longinteger. The products table containes Productid, productname,productcategorieID etc. 10 001 A 10 10 002 B 10 and so on. And the first missing ID after certain prefix(categorieID at the beginning of the productid) is what im looking for. So you...

No the categorie ID is from logical purpose choosen by the user so its number type and long integer. So tehere are 15 categories starting from 10, 20 30 etc..

Hi, I have product form/table which has productId, productCategorie, productname, etc. When i want add new product, i select first ProductCategorie ie "10" Then i made a button to get productID ie: 10001 (10 is categorieID+001) next add productID if categorie is 10, 10002 en so on. If...

Thanks for reply. The problem is only the WHERE statment. strSQL = "SELECT tbl_ink_id.[imei-1] AS imei, tbl_ink_id.inkoop_id_no, tbl_ink_id.model AS Naamproduct, tbl_ink_id.kleur, status_id.staat, tbl_ink_id.prijsink, tbl_ink_id.prijsverk, qry_totaalinkoop_bulk.SomVanaantalbulk AS Totinkoop...

Hi, I've searched for days, but not found a solution.:banghead: Here is what i want: i have a combo: idd i type something and it begins searching ( search as you type ). Everything works when 1 table. example.. when i begin typing is see: name - price I want put an extra field : stock so...

Ok, finally i figure it out. now i have another problem: Private Sub lala_Change() On Error GoTo CleanFail Dim strText As String, strFind As String, i, strSQL As String strText = Me.lala.Text If Len(Trim(strText)) > 0 Then strFind = "NaamProduct Like '" For i = 1 To...

here is an sample database, maybe you understand better if you see live.:) ( by the way, i use access 2003 ) The combo which i have problems is the "Prod name". thanks in advance..

attached you can see photo of the combo while typing and after clicking there is only 1 product and if you click with mouse, it stays second photo. only when enter TAB or ENTER then it selects the product, you cannot select with mouseclick.

no its not. you must select product names, and there are allmost a couple of 1000 products and sometimes the names are too long, and they want to write some words and search must start showing all products containing the typed value...

Yes then the error disappears, but then after selecting or clicking with mouse, i cannoot select, after selecting, the cursor doesnt jump to the next field....

hi thanks for replying at all :) The code works perfect whitout the after update event. especially when we drop the setfocus part. if i begin to write letters, the code begins to work and search begins and if i see the desired product name and i enter " TAB " the after update event works...

No one who has an idea????:confused::(