Rabu, 07 April 2021

Re: [MSAccessProfessionals] New Error | Reserved Error (-1524); there is no message for this error.

Thank You Duane. 

the report has been working for years and there has been no changes to the query or the report. 
No missing references in vba
I did not create the table so the names are so crazy that I cringe every time i see them.  examples Draft posting to HO and HO approves posting
The query runs with no issues. 
I deleted all of the objects on the report and that did not work. 
I  deleted the text box in the grouping header and it worked. 
but when i recreated the report it came back with the error. 
i created a new table and i still see the error




From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom <duanehookom@hotmail.com>
Sent: Wednesday, April 7, 2021 2:10 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] New Error | Reserved Error (-1524); there is no message for this error.
 
Hi Jim,
I did some quick searching and several threads point to corrupt records. Otherwise I would check the References and look for field names using reserved words.

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner <josephwagner2@outlook.com>
Sent: Wednesday, April 7, 2021 3:52 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] New Error | Reserved Error (-1524); there is no message for this error.
 
Hello All,

One of my users received this error on a front end database this morning. the help is no help. I am able to recreate the objects of the report and query and table in a blank database and it works. but if I move it into the production front end it does not work. I moved all of the objects to a blank database and that did not work. all of the tables are linked tables in a backend. 
It has taken me years to get my bosses to let me do the front end back end solution and this may force me back to one database for multiple users. 

there was a office update last night so i do not know what to think. 

Is there a fix for this? 

thank You

Jim Wagner

Tidak ada komentar:

Posting Komentar