Query Definitions

Question

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 1

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

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