Activity Stream

English was good enough - we got the job done!

There is *no* penalty for declaring 255. Access will only use what you put in there. It does not reserve the space.

thank you this works. sorry im not good in english i cannot explain well

I think OP is saying that button should be disabled if either field is null. If Len(Me!Company_Name & vbnullstring) = 0 OR Len(Me!Country &...

Private Sub Company_Name_Change() If Len(Company_Name.Value & Country.Value) = 0 Then btnAdd.Enabled = False Else btnAdd.Enabled = True End If ...

Another try: Based on both must have values If Len(Me!Company_Name = 0 OR _ Len( Me!Country) = 0 Then btnAdd.Enabled = False Else ...

its still enabling thebtnAdd,i only put text in the company name

TRY this: (guessing) If Len(Me!Company_Name & Me!Country) = 0 Then btnAdd.Enabled = False Else btnAdd.Enabled = True End If ...

If Len(Company_Name.Value & Country.Value) = 0 Then btnAdd.Enabled = False Else btnAdd.Enabled = True End If

Thanks, splitting into two queries solved the problem.

Please show us/post the code you are using.

It's not working, the button is enabled. i only put text in the company name

I doubt that. I'm sure the client may have asked for or shown a picture of what the "displayed value" should look like. But I don't think they said...

So is my code working for you? Are you good to go?

yes i use your code

Did you try what I suggested?

I add text in company_name and country is null, its enabling the btnAdd

Try: If Len(Company_Name.Value & Country.Value) = 0 Then btnAdd.Enabled = False Else btnAdd.Enabled = True End If

Company_Name and Country

Which value is a string now?

the answer depends on how many levels you need to go and whether any 'sub' product will always be at the same level. In your example you have two...

Thanks and it is solved

This is one of the problems you get when you split transactions into different tables since it is not strictly normalised. Suggest you combine the...

Since you want to GROUP on customer, do two queries that aggregate each table on the customer then join those two queries.

Do you want the alias values displayed as a comma separated string in textbox? Review http://allenbrowne.com/func-concat.html. Build a query that...