Search results

Hi again, You might have suggested this above: it seems that the simplest solution for me as a beginner is: 1. Creating two queries displaying the active records only 2. Using these two queries to create a form, including a sub-form That is: Just swapping the two intitial tables for two queries

Hello Thank you very much to ALL of you. This has been already important help for me. On my part, I will try to progress. But I will need to take small rather than big steps :):)

... I mean: how to do this practically. Assuming, I had my two queries ready. What do do next? Arnel wrote: But where is the relationship between these two queries implemented? I mean: that each account would have one user related. If someone could just tell me the next practical steps to be...

Hey all, Thanks for all these friendly answers, and particularly for Doc Man’s detailed advises. I am happy to follow all your point. Please let me get back to square one, looking at only 2 simple tables: table Users and table Accounts each account has 1 user (i.e. 1 user can appear in n...

Dear all, I am just a beginner with access. Therefore, please apologize if I am not yet familiar with most of the Access functions. My situation: I am currently using Access 2016. My main purpose is to have a simple Form-Subform structure. This means for example, having a form with a user...

Thanks for letting me join