Impossible to open more database

[RuralGuy]

No promises but I'll keep working on it for today at least.

[RuralGuy]

Does your system compile without errors? Mine does not! It is even worse when I start putting some "Option Explicit" in your modules.

[RuralGuy]

I don't have an answer yet but I noticed you are using some Lookup Fields in your tables. Never a good idea IMHO. http://www.mvps.org/access/lookupfields.htm

[RuralGuy]

Does this calendar *only* work for July 2010?

[RuralGuy]

A better question is: Have you HARD CODED your dates into the ListBox RowSources? If so, it seems that would be rather limiting to the calendar.

[Grooz13]

I don't understand what you mean yeah I put an sql command in a rowsource, and no this calendar is universal, and what do you mean by lookup field ? putting a company name instead of working with it's number ?

[RuralGuy]

Lookup Fields are in TABLES. Did the link make any sense? What time is it where you are? It is only 15:27 here right now.

[Grooz13]

it's currently 5h28 here so no problems, lookupfield you mean putting like No_company_auto and then the company name and after that with a combox box using the number but showing to the user only the name ? if so yes... I use it often that's how I learn to do in school

[RuralGuy]

It puts the ComboBox in the table rather than in the form where it belings and makes it difficult to see what is really in the table when you are debugging. Doing a lookup with a ComboBox on a form is just fine and the preferred way to do it. So it is 05:30 in the morning where you are?

[Grooz13]

no pm ! yeah i used lookup a lot... sorry for this i didn't knew honestly I thought it was the right way to do it

[RuralGuy]

It mostly just confuses the PROGRAMMER! (Like Me )

[Grooz13]

hahaha excuse me for this then i'm trying to search on my side too and mostly it's in majcommande that i find a problems... but i can't find what it is

[RuralGuy]

I'm thinking maybe the DCount() is opening something each time but I commented it out and replace with =0 and no help. Did you notice the error happend *before* the OPEN event. I can't seem to get ahead of it yet.

[Grooz13]

well I can't get past it except if I delete the weekend day.. but it doesn't solve anything... and I know that it scans and add everything fine like the date of the day and the job in the list zone except for the last 7 week day and I don't know how many weekend...

[RuralGuy]

I don't know why it is trying to open another Database or at least throwing that error.