Query Definitions

Question

Query Definitions

Bernhard Zweifel 41

Hi,

I have a table with the field Year. Whenever I pull this field into a query, save the query and reopen it or refer to it the query has changed Year to Expression1: tablename.Jahr.
Therefore all Forms and Records based on the query give no result.
Perhaps changing Year something else would fix the problem but I hesitate to do that because it would mean to search for and change all the queries, forms and Report that use this table.
Any suggestions?
Thanks boz

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Karl Donaubauer 2,856 MVP

Hi,

I suggest changing the name anyway, because Year is the name of a built-in function in Access (which returns the year of a date).

If the name is used in really a lot of places, I would use a find and replace tool. The current standard for this is https://accessdevtools.com/product/find-and-replace/.

Servus
Karl

http://AccessDevCon.com
https://www.donkarl.com

Bernhard Zweifel 41 Reputation points

2021-08-30T08:45:46.483+00:00
Ji Karl

Thanks for your advice. But I have two problems with it.

I understand that the link you sent is for downloading an Add-In. After downloading the Trial version I cannot find any trace of it. Neither in the Programme directery of my hard drive nor in the Add In manager of access.

So I tried your suggestion mannually. I changed the field "Year" in myTable" to txtOYear (the field ist text because it may contain "1950 - 1961"). I changed the query that converted the reference myTable.Year to Expression1: tablename.Jahr to myTable.txtOYear. The same change I implemented in the Form based on the query to reflect the changes. When I want to open the Form I get a message that Access cannot find tablename.Jahr.

I repaired and compacted the application, I rebooted my machine: still the same error.
Any suggestion on how to proceed

Regards, boz

Answer 2

Hi,

For the add-in have a look if the first FAQ on their support page helps.

When I want to open the Form I get a message that Access cannot find tablename.Jahr.

Is it an (error) message with an error number or is it a parameter window that asks for your input?

The old field name could still be in many places like a sorting or filtering expression/property of the form etc.

Did you check that the query opens without problem?

Servus
Karl

http://AccessDevCon.com
https://www.donkarl.com

Share via

Query Definitions

1 additional answer

Your answer