Recent content by sisva18

Thanks man it worked now I can work something out

I tried the line you said I just dont get the FieldDefs in my IDE neither do it autocorrect it. How can it be it throws an error "method or data member not found" and marks .FieldDefs I have tried this and it prints the fields I want in the immediate window in the for loop. So if i can get the...

I tried doing something like this yet not working Function ChangeQueryCaption() Dim db As Dao.Database Dim qryDef As Dao.QueryDef Set db = CurrentDb Set qryDef = db.QueryDefs("qryCustomerFromNumberOrName").FieldsDefs("AccountNum").Format("Account number.", "LuL")...

Okay I will try to explain it is just hard to show since it was only an idea and it is work related. Meaning that i cant publish the application. So the query created in access looks like this: I want to be able to change the name of each of these tables right now i do it statically like this...

Hi I have this query I created called qryCustomer I have different text formats for each table. I am showing the tables in a form. Is there anyway I can reference this query and change the text formatting of the titles in VBA? I want to achieve this so that I can change the language of the...