Search results

Now you talking :-) Thanks a lot, mate Really preciate your help. Regards Mark

Mate, Please tell me what have you done with my sample? It doesn't work at all, mine was still working. I've noticed that you've change the querry and that's about it. Regards Mark P.S. HELP Somebody

Hi, I've previously posted this problem but without the sample, just description, and I guess it wasn't clear enough. The problem is with displaying the records in a subform, the "index" and "name" fields are display correctly whereas "group" and "vendor" have numbers instead of text. It...

Wayne, Thanks for your reply, I'm not sure if I'm getting this correctly, there is no problem with the combo. The problem is in the subform where I have a text fields related to a querry. ProductId, Product name are display correctly, in the other fields instead of names I'm getting numbers...

G'Day all, This problem really bothers me, so please somobody help, Here is what I have: I have a main form with combo: SELECT TblProducts.ProductID, TblProducts.ProductName FROM TblProducts ORDER BY ProductName; Subform is joined with main one with ProductID field. Subform is a...

I've read it, and try it again, no luck this time either. Don't know what's going on here, I'm getting Run-Time Error: 2450 Help somebody Mark

Sorry for such a late reply, It's a query problem Pat, I reckon it is something related to calculated fields, I've checked with another query based on the same table but without these calculated fields and it works fine. What should I do, I need all these fields. Regards Mark

Hi there, I have a main form with combo: SELECT TblProducts.ProductID, TblProducts.ProductName FROM TblProducts ORDER BY ProductName; Subform is joined with main one with ProductID field. Subform is a continous one linked to a query: SELECT TblBOM.ProductID, TblMaterials.MaterialID...

Damn, it's strange, tbl structure might be a proble, thus I'll show you how they look like. TblMaterials MaterialID text (pk) Name text Vendor text Group number (SELECT TblMaterialGroup.GroupID, TblMaterialGroup.groupname FROM TblMaterialGroup ORDER BY...

G'Day I have the following querry: SELECT TblProducts.ProductID, TblProducts.HarnessNo, INQCuttingTimeTPZ!Expr1/TblProducts!HarnessNo AS ExprA, FROM (((tblProducts INNER JOIN INQCuttingTimeTPZ ON TblProducts.ProductID = INQCuttingTimeTPZ.ProductID) On the form, I have a text field: Number of...

Somebody help thnx anyway, Anybody have an idea?

I know, that's why I wanted to hide Group_ID and get the name, instead I get only ID

Yep, it did the trick, Cheers, mate One more thing, cause I'm kind of newbie to Access, got some idea but sometimes got stucked on simple things. It's from my yesterday thread 2nd Has Groups: SELECT tblGroups.Group_id, tblGroups.Group_name FROM tblGroups ORDER BY Group_name the results I'm...

I'm getting a sort of idea where to go and this moment I'm stuck with this code: If Grupa Is Null Then Nazwa.rowsource = SELECT [tab_materialy1].Indeks_mat, [tab_materialy1].nazwa_plFROM [tab_materialy1] WHERE Producent = Producent.Value Else Nazwa.rowsource = SELECT...

Thnks for your replies, guys. I've just poped in to the office, Wayne I'll prepare a sample in a bit, first I'll chew what StepOne suggested. I'll be in touch. Cheers Regards Mark

I've posted a thread before but no one could help or I wasn't clear enough. I want to create a simple search form using combo. The table looks like this tblMaterials (material_id, name, group, vendor) The querry I use (qryTest): SELECT tblMaterials.material_id, tblMaterials.name...

Problem solved :-)

Hi all, I have main form "frm_Haupt_Material" with text field and I am using it as some kind of a search box. I have a querry based on this field which looks like this: SELECT Lagerbestand.Indeks, Lagerbestand.Nazwa, Lagerbestand.JM, Lagerbestand.MAG, Lagerbestand.Bestand FROM Lagerbestand...

Yep, you were right, one letter was missing :-) Thanks for that Regards Mark

I have simple search form using InString, when I run it on my computer (Access 2000, Win98) it works fine, there is no problem with running the db on A2000 Runtime, the problem occurs when I try to run it on A2003, XP, I get the following: Enter the value of parameter...