Help for my problem

[Starmo]

Help!
Please someone to help me. I'm not an expert in Access (more amateur), Excel is OK.
Namely, at work I was given the task of tracking the rent for apartments that the municipality used for social non-profit housing.
We have 20 users. Now, I would like that once the rent has been paid, that payment amount is tied to the user. I would also need a billing status report for all users.
Is it necessary for each user to create a separate table, then somehow bind it to a bulk report or all over a common table, so that the program draws the data for each user individually.


Thanks in advance!

[isladogs]

Do not create a separate table for each user.
Each table should be used to store a particular type of data: clients / payments etc
Use queries to link the tables together & to filter the data as needed e.g. all payments by a particular person

[Starmo]

Greeting ridders52!
Here's what I did. Is it possible for the program to borrow users themselves? I would enter the payment information.
I repeat, I'm weak in access so do not blame me


https://www.dropbox.com/s/2dvdzvkldn...ample.rar?dl=0

[davegri]

Is it possible for the program to borrow users themselves?

Pretty sure the program is not able to borrow the users.
And, terminology is important.
In the computer world a USER is the person who uses the software to accomplish the desired task.
In the housing world, a person who rents housing units is not generally called a user, more typically called a tenant.
Unexpected mixing of descriptions leads to confusion (See post #7).
If, in fact, you have 20 persons using the software, my apologies for MY confusion.

[Starmo]

I apologize for my terminology and my knowledge of English. Actually, I have 20 tenants, not a user.

[isladogs]

Rewording my first answer:

Do not create a separate table for each tenant
Each table should be used to store a particular type of data: tenants / payments etc
Use queries to link the tables together & to filter the data as needed e.g. all payments by a particular tenant

No you can't borrow a tenant - but I think that's a language issue rather than an Access issue

[davedinger]

how about if you create a table of users, then create a log on form with a drop down of the user names as your opening page.
With the user name on any screen you can then add a field to any form or table that will auto populate (Default Value) from the log on screen.

[Starmo]

Hello guys!
Do not laugh about knowing English, because it's not my first language. I'm a beginner to Access, so have some patience with me. I post a link, I do not know if you looked at it?
Anyway, I made 3 tables:


1. Tenant table (tenant ID, rent amount, when you use an apartment and some other columns that I could do afterwards


2. Amount of debt table (tenant ID, debit date, debit amount)


3.Payment account table (tenantID, payment date, payment amount)


Now, are these 3 tables enough and how to link them through queries. It is necessary for me to know at any time whether and how much each tenant owes or not.
Now I have 20 families who use these apartments, but in a couple of months they will be over 150. I imagined, if possible, that I only enter the user's payments and the program ends the other.
I repeat to be a beginner in this, but slowly learning (youtube, some online tutorials ...).
Thank you for your patience!

[isladogs]

Your English is fine.
I think you can combine tables 2 & 3. Just use +/- for the different values.
That would simplify your forms and coding

[Starmo]

Yes, but...
It seems to you that simple, but I'm still not at that level of knowledge to be able to realize your instructions. Once again, thank you very much for help, but I'm still no closer to fixing the problem.
I put a link to Dropbox, so if you can look at it and do what you suggest to me.
Thank you!

[isladogs]

Not sure which of us you were responding to.
You are more likely to-get a response if you zip and post your database here.
Many of us will not open externally stored files
Good luck

[Starmo]

OK thanks. I did not know that. I'll set that up.

[Starmo]

Not sure which of us you were responding to.
You are more likely to-get a response if you zip and post your database here.
Many of us will not open externally stored files
Good luck

Hello ridders 52!
Here's the file I set up, just like you talked about.
If you have any suggestions welcome.
Thank you!

[isladogs]

Hi starmo
Sorry but I don't understand what each table means as I don't know your language.
In fact I'm not even sure which language this is.
Suggest you translate the field names into English if possible

[Starmo]

Hi starmo
Sorry but I don't understand what each table means as I don't know your language.
In fact I'm not even sure which language this is.
Suggest you translate the field names into English if possible

Hi ridders52!
Sorry, my mistake. I hope it's more understandable now.