Search results

I would first check if RecordCount and AbsolutePosition are giving you a proper Value Put sth like Debug.print(.AbsolutePosition & "/" & .RecordCount) after the With RS and post the result.

No it was Working and then i had to do it again cause i had to use a backup where this step was not done already. The 3 Combo boxes are my workaround so instead of changing the Rowsource i now use 3 Boxes and hide/Show them as needed. At the moment im working to get the Form done cause i found...

Hi Gina, For me its a little bit strange cause im not storing any Data i just fill a combobox. When access would search for the *Date* cause thats the Datatype of the underlying table why does it work when i select *week of the Date* first? Its like he binds the Combobox to the first data i...

The Data Type for the Field im Catching (Data.Datum) is Date/Time In all 3 Cases im getting the same field but i use Datepart to get the Weeknum and Monthname+Datepart to get a string with the Month. Greets Loki

The Querys are like this Dist_Datum = "SELECT DISTINCT (Data.Datum) FROM Data;" Dist_Woche = "SELECT DISTINCT DatePart('ww',Data.Datum) FROM Data;" Dist_Month = "SELECT DISTINCT MonthName(DatePart('m',Data.Datum),True) AS Monat, DatePart('m',Data.Datum) AS NMonat FROM Data ORDER BY...

Quick Update: When i set the Bound Column to 0 i dont get the error anymore but then i dont get any values from the list just the Id´s.... I really dont understand what is going on there....

Hi there i have a weired problem that i can´t figure out on my own. I have a Form with a combobox and 3 checkboxes now i want to change the Rowsource of the Combobox by clicking on the checkboxes. When i click the Checkbox the Rowsource gets Changed as i want it but i can not use the new...

Hi Together, Im 29 Years old and living in Switzerland. Im more or less new to Access but i have a lot experience in Excel and Excel VBA. Im Working for a Telecommunication Company here in Switzerland and do a little development for our department now and then. Nothing big just some...