I seriously don't know... and why does it works when it's not splitted ? is it because there is a limit splitted and none when it's not ?
Advanced Beginner
Windows 7 
Access 2007
I seriously don't know... and why does it works when it's not splitted ? is it because there is a limit splitted and none when it's not ?
Advanced Beginner
Windows 7 Access 2007
i read somewhere it could be about ado3.5 or jet 3.5 but i don't know... I started this as an access 2007 so...
Administrator
Windows 7 Access 2007
It almost *has* to be something like that but I can't find it.
Administrator
Windows 7 Access 2007
Access uses ACE and I don't know that much about it.
Advanced Beginner
Windows 7 Access 2007
seriously i'm starting thinking about paying you if you suceed before me lol i'm going to eat i'll be back in a few
Administrator
Windows 7 Access 2007
No problem. See you in a few.
Advanced Beginner
Windows 7 Access 2007
ok i'm back, I thought about it while eating do you think reducing the number of list would solve somethin ?
Advanced Beginner
Windows 7 Access 2007
if you remove the weekendday (day only not aboute the list just the lsit) and in the code in the for i = 42 or something you make hip skip 6-7-13-14-20-21-27-28-34-36-41-42 it will go a little farther... it will fill my list but not the date above... and I will still get cannot open any more database message
Administrator
Windows 7 Access 2007
As a test I deleted all of the ListBoxes RowSources and got the same results. I've asked the MVP community to look at this. It could take some time.
Advanced Beginner
Windows 7 Access 2007
Hey rural i've been searching the net a lot... and found this
http://www.eggheadcafe.com/software/...ar-report.aspx
http://www.access-programmers.co.uk/...d.php?t=122973
those 2 problems seems to be like mine... They tell that making a tempory table from my really complex query... but how do I do this ? I never did something like that... I programm à lot.. but acces is not my greatest strength... do you think this could be a solution and how can I do this ?
Advanced Beginner
Windows 7 Access 2007
and if you delete the listbox row source on running the form they will be filled again
Last edited by Grooz13; 08-05-2010 at 08:11 PM.
Administrator
Windows 7 Access 2007
I figured that should be happening but where does it take place?Originally Posted by Grooz13
Administrator
Windows 7 Access 2007
OK...I see where MajCalendrier is filling in the RowSource. It is a good thing it was not a snake.
Advanced Beginner
Windows 7 Access 2007
what is a snake ?
Administrator
Windows 7 Access 2007
a serpent.
Posting Permissions
Reply With Quote