Recent content by Mihail

Can't open the DB. I use 2007 version.

Thank you JHB, CJ and all of you Finally it work and now I have a beautiful DB with .accdb files and the users has the .accde FEs. Thank you again !

The dialog box don't ask for a FE. It ask for the BE. So... lets try to explain better: How the DB work now: Open a FE (any of them = 3 possibilities) IF this FE do NOT point to a BE THEN the "z_CheckLinkToBackEnd" form is displayed ELSE the first form in logic tree is displayed End IFIn...

@CJ. I get your point, CJ, and I explained WHY in post #19. On short because, at that time, I haven't enough knowledge to deal with accde. Now I like to do this but still I need help. @vbaInet. OK. Next time or... if you are able, split, please, this thread for me. @All Is a need to have all 3...

Not sure if a new thread is required here, because I have a new issue: If I make .accde files I'm not able to relink the FEs (all 3 from a single one as I do with .accdb files). Have you any solution ? Thank you !

Glad to help you even if I don't understand the problem :) DO NOT mark this thread as "solved". Maybe the MS Access guru will make some light here. Good luck !

Maybe if you post the DB someone will help you to save it in a newer format. Note that we don't need the data from DB. Just the DB. Can you save the actual DB (without the new form) in 2010 format ? Or, at least, in 2007 format ?

Seems that your DB is saved in an older format (perhaps older than 2003). Save the DB in 2010 format and see what is happen.

No .

While we don't know the structure of your DB is hard to provide advices. My guess, based on your description, is to design a query that select ALL the information from ALL 3 tables. About how to loop through a recordset, read this...

@Infinite What about this ? In attachment you have a DB. Search the word "Smith"

@CJ Is this query Case Sensitive or not ? Thank you.

Very useful to know. Thank you one more time, JHB.

Thank you JHB Look: After I established first time the link between BE and FEs (by using the error handler provided by you) I closed the FE (Calcul), I renamed the BE and I used other FE (Definire) in order to (re)link the FEs to this "new" BE. Note please that the FE named "Definire" don't...

Thank you all for the help. Even if I don't fully understand what happen here, at least I'll know how to handle this issue in the future. Thank you again !!!!