Find tilhørende tabel til værdi

Can you try and explain what your trying to do? If the field in the report always comes from the same table then you must alreday know.

It's to a company. If somehow a value is missing they want to find out from witch table it comes from. Without having me to go behind the report and look at the data source. Is that posible? Maby if there is just a way to find all data sources in a report, then maybe you are able to extract the table name(s)?

I designvisning markerer du rapporten eller hvad det måtte være og så går du i Vis>Objektafhængigheder!~)

ps. som standard er der sat flueben ved "spor oplysninger om autokorrektur af navn" og det skal der også være for at det virker. Det gør man under funktioner>indstillinger>generelt..

En grund til at slå det fra kan være et hastighedsspørgsmål, hvis tingene loader meget langsomt, kan man slå det fra og dermed få en hastighedsforøgelse fordi den så ikke skal holde tjek på objektafhængigheder!~)

"If somehow a value is missing they want to find out from witch table it comes from"

Wouldnt that require them to have an understanding of the dB design? If a value is missing then there must be a reason for that and looking in a table, in my opinion doesnt help that much. If a value mustnt be missing then the program itself should catch this. Having users play around with tables/data is looking for trouble.

On the other hand, if they want to take over the program maintenance from you then along with your documentation can use the database documenter.

You can find information on how it works in this link
http://office.microsoft.com/en-us/access/HA012139541033.aspx

I know what you are thinking terry, but the problem is, that data is updated every night, and sometimes, even if it should not be posible, som values in a row is missing. Then they want a function to trace what table the missing data/value comes from(there are maby 150 tables). Maybe a function where they can choose a report and then see witch tables that are used i that specefic report?

You should look at the database documeneter, thats about as close as you can get without programming it yourself.

I fund a way, but can one of you tell me how to import/get the SQL string from a query?

You know, if i got a query by the name "test" and that contains "Select City FROM Contry", can i the get the "Select City FROM Contry" into a string in vba and just show it in a msgbox?

Currentdb.QueryDefs("query1").SQL

Thanks
Did you look at the database documenter?