Forums Neueste Beiträge
 

RecordSource eines Kombifeldes ändern

12/03/2009 - 20:20 von Hans Weiss | Report spam
Hallo,
was mache ich hier Falsch?

Me!cmbKw.RowSource = "SELECT ta_Importdaten.Woche "
FROM ta_Import
GROUP BY ta_Import.Woche
ORDER BY ta_Import.Woche DESC;

gruss Hans
 

Lesen sie die antworten

#1 Gunter Avenius
12/03/2009 - 20:35 | Warnen spam
Hallo Hans,

Hans Weiss schrieb folgendes:
was mache ich hier Falsch?

Me!cmbKw.RowSource = "SELECT ta_Importdaten.Woche "
FROM ta_Import
GROUP BY ta_Import.Woche



Dim strSQL AS String
strSQL = "SELECT ta_Importdaten.Woche "
strSQL = strSQL & "FROM ta_Import "
strSQL = strSQL & "GROUP BY ta_Import.Woche "
strSQL = strSQL & "ORDER BY ta_Import.Woche DESC; "

Me!cmbKw.RowSource = strSQL

Gruß
Gunter
__________________________________________________________
Access FAQ: http://www.donkarl.com
home: http://www.avenius.com - http://www.AccessRibbon.de
http://www.ribboncreator.de

Ähnliche fragen