Sizin yardimlarinizla olusturdugum dosyaya uygulayamadim hatta iyice karistirdim. Benim sorguda zaten bir SQL kodu vardi, ayni sorguya ikinci bir SQL kodunu ekleyemedim devanli hata veriyor.
Bir yardimci olursaniz sizlere cok tesekkür ederim.
Benim yapmak istedigim Isim ve Sirket metinkutularindaki veriler ikinci, ücüncü veya dördüncü kez tekrarlanmis ise, tekrarlananlarin sayisini renkli olarak göstersin.
Hersey almanca oldugu icin Form üzerinde renklendirme yaptim,
Isim = NameVorname1,
Sirket = Firma
24-03-2013, 23:09 (En son düzenleme: 24-03-2013, 23:10 jon206.)
mrb.lar;
AbfKfzPersDE sorguyu sql görümünde açın ve aşagıdaki sql kod ile değiştiriniz..
SQL
SELECT AbfKfzPersDE.NameVorname1 AS NameVorname1, AbfKfzPersDE.ID AS ID, AbfKfzPersDE.Datum1 AS Datum1, AbfKfzPersDE.Uhrzeit1 AS Uhrzeit1, AbfKfzPersDE.Datum2 AS Datum2, AbfKfzPersDE.Uhrzeit2 AS Uhrzeit2, AbfKfzPersDE.KFZ AS KFZ, AbfKfzPersDE.Heangerzug AS Heangerzug, AbfKfzPersDE.Auflieger AS Auflieger, AbfKfzPersDE.Firma AS Firma, AbfKfzPersDE.Adresse1 AS Adresse1, AbfKfzPersDE.Branche AS Branche, AbfKfzPersDE.NurZumBeUndEntladen AS NurZumBeUndEntladen, AbfKfzPersDE.Versand AS Versand, AbfKfzPersDE.Service AS Service, AbfKfzPersDE.WA AS WA, AbfKfzPersDE.Nation1 AS Nation1, AbfKfzPersDE.Ausweisnr1 AS Ausweisnr1, AbfKfzPersDE.Ansprechpartner AS Ansprechpartner, AbfKfzPersDE.Unbefristet AS Unbefristet, AbfKfzPersDE.Befristet AS Befristet, AbfKfzPersDE.Unbefristet1 AS Unbefristet1, AbfKfzPersDE.Befristet1 AS Befristet1, AbfKfzPersDE.WacheV1 AS WacheV1, AbfKfzPersDE.WacheKfzV1 AS WacheKfzV1, AbfKfzPersDE.WacheH1 AS WacheH1, AbfKfzPersDE.WacheKfzH1 AS WacheKfzH1, AbfKfzPersDE.WacheCTC AS WacheCTC, AbfKfzPersDE.WacheFZM AS WacheFZM, AbfKfzPersDE.WsMa AS WsMa, AbfKfzPersDE.WsMa1 AS WsMa1, AbfKfzPersDE.WacheVerlassen AS WacheVerlassen, AbfKfzPersDE.ZahlFortlaufend AS ZahlFortlaufend,(SELECTCOUNT(*)FROM tblKfzPersDE IN''[ms access; DATABASE=F:\kfzpersonendb.accdb ;pwd=test]WHERE namevorname1=abfkfzpersde.namevorname1 AND firma=abfkfzpersde.firma)AS Mukerrer
FROM tblKfzPersDE AS AbfKfzPersDE IN''[ms access;pwd=test;DATABASE=F:\KfzPersonenDB.accdb]
Kod süper calisiyor, iyiki varsiniz, zaman ayirip kodu ayaladiginiz icin tesekkür ederim.
Hocam bir problemi beraberinde getirde. Kodu uyguladigim zaman hem Sorgu üzerinde, hemde Form üzerinde verigirislerimi engelledi. Su anda hicbir veri giremiyorum. Acaba neden?
