Hello Guys. i Need Help!

[Richar_Days]

First of all i need to tell you that I am very new in access ...

So, i use in my work 2 comment´s generator like this:

And now I want to unite the two generators in one and cut some typification of the second generator like this:

But when i copy the second generator to the fist one the second stop working

Is there any kind soul who can help me resolve this issue?

Please

 

[pbaldy]

Given the lack of replies, it may help if you can attach a sample db here that exhibits the problem.

 

[Pat Hartman]

We need to see the table descriptions and relationships. Do you currently have two comments in each row and now you want to have the comments in separate rows?

 

[The_Doc_Man]

While you might not want to hear this, you will do best to take your two forms, print them out, mark or highlight what you want to keep, and then just build a new form that has that in it.

From what you presented, I can only GUESS (with heavy emphasis on GUESS) that you might have two tables involved in a single form. We will need to know more about that kind of thing - data sources, relationships between the sources, etc. Part of the problem is that, I believe, you will use Portuguese in your DB. Nothing wrong with that, but it isn't a language that many of us speak, so our responses will have to be tempered by the need to translate. You would have to be patient with us if a language barrier becomes apparent.

It is clear that you want to simplify what you are doing by changing two complex forms to a simpler form. This is a good and reasonable goal. The harder part, though, is the merging of two data source streams (two tables) if that is what you are trying to do. We will need to know if/how the two sources are related since your goal is to merge the forms.

 

[mike60smart]

First of all i need to tell you that I am very new in access ...

So, i use in my work 2 comment´s generator like this:

View attachment 116837

View attachment 116838

And now I want to unite the two generators in one and cut some typification of the second generator like this:
View attachment 116839

But when i copy the second generator to the fist one the second stop working

Is there any kind soul who can help me resolve this issue?

Please

Can you upload a copy of the database?

 

[Pat Hartman]

Given that you are new here, you will not be able to upload a database so for now, we can make do with pictures. Open the database relationships window and add your tables there . Try to expand them so we can see all the columns. Draw relationship lines between them if you haven't done that already to help us to understand the relationships.

 

[Richar_Days]

Hello, first ... thanks for all the reply´s.

There is the all file from this...

Its attached!

 

[arnelgp]

you try and test

 

[Richar_Days]

Hello arnelgp ... second form still not working.

 

[Richar_Days]

The second form will work with this table "Pendencias e SLA"

The first form its all ok, working fine, its just second give that problem ...

 

[arnelgp]

try again

 

[mike60smart]

The second form will work with this table "Pendencias e SLA"

View attachment 116966


The first form its all ok, working fine, its just second give that problem ...

Hi
Your database is made up of 8 tables with no Relationships set between any of them.
You have a number of tables with no PK
All tables have ID as the first field with some set as PK Autonumber and others just as Number.
You should not have spaces in field names.
All your Forms are unbound when it is recommended that they be bound to queries.

 

[Richar_Days]

How yes ...

Its working, well done!
arnelgp you make my day, Thx a lot

 

[Pat Hartman]

@Richar_Days arnelgp hasn't done you a service by simply fixing your problem. @mike60smart has given you some sound advice for moving forward and becoming self reliant.

I would add to mike's list -
using default names for controls makes your code unintelligible even to you. Are you going to know what Text66 is next month? Especially when it might be a different field on different forms.

 

[Richar_Days]

Hey Guys, The form already works, but it is not giving the table response ...​

Hey Guys, The form already works, but not giving the response from the table ..
When I choose the option in column 2 it doesn't automatically give me the answer that´s in column 3... just like it does in the first form.

Appears like this ...

But, It should appear like this in the following image...

 

[arnelgp]

Test it again.

 

[mike60smart]

Hey Guys, The form already works, but it is not giving the table response ...​

Hey Guys, The form already works, but not giving the response from the table ..
When I choose the option in column 2 it doesn't automatically give me the answer that´s in column 3... just like it does in the first form.

View attachment 117018



Appears like this ...

View attachment 117017


But, It should appear like this in the following image...

View attachment 117016

As Pat has said you need to stop and rethink what you are doing with your table design.

 

[Richar_Days]

As Pat has said you need to stop and rethink what you are doing with your table design.

Hey mike60smart
As I said at the beginning of this post, I'm still new to the world of access, I'm still learning how to work with it... and with these changes made by arnelgp I can understand what I should have done... but I'm grateful with your help too

 

[Richar_Days]

Test it again.

Yes arnelgp, its all working fine ... thx lot

 

[Pat Hartman]

I'm still learning how to work with it... and with these changes made by @arnelgp I can understand what I should have done... but I'm grateful with your help too

You will never get where you need to be if you persist in using poor solutions. Good luck. I will stop bothering you now.