Field validation issues

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Field validation issues

Post by bknight »

I'm attempting to update a filed and got about 75% error in a validation rule error.
I looked through all the fields for a validation rule and find none in any field. So where else to look redefine any rule?

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field valibration issues

Post by bknight »

NM, I did finally find where the validation is located.

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field valibration issues

Post by bknight »

Well I thought I had cleared the issues, BUT...
I deleted all of the validations, however when running the update query I still get the issues and fields not updated.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

Perhaps the OrderStatus field is required (i.e. it cannot be changed to blank)?
Regards,
Hans

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

There are records in which OrderStatus is null so that can't be the issue

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

There is Validation text on all fields

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

Could you attach a zipped copy of the database with the Trades table?
Regards,
Hans

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

Too big.

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

You can email it to me, or upload it to OneDrive, Google Drive, Dropbox or similar and post a link to the uploaded file here.
Regards,
Hans

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

OMG, I decided to delete x records so that I could zip it and forgot to save. Is thee a critical undo?

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

'Fraid not. Perhaps you can retrieve a previous version of the database:
- Right-click the database file in File Explorer/Windows Explorer.
- Select Properties from the context menu.
- Activate the Previous Versions tab (if present) and wait for it to populate.
- Is there a version from before you deleted the records?
Regards,
Hans

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

No previous version, but at the minimum I did backup th Db in February, so it would only be less than 4 months work, meanwhile I can zip what is left, to solve first issue.

Oh man the zip file is 864K and the website says too large.

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

Wow, that's a lot of work!

The maximum size for an attachment here is 250 KB, but as I wrote 4 posts up: You can email it to me, or upload it to OneDrive, Google Drive, Dropbox or similar and post a link to the uploaded file here.
Regards,
Hans

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

PS in the future, I'd make backups more frequently!
Regards,
Hans

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

Sorry I didn't remember the size being that small, but no matter.
Yes I should have backed it up more frequently. That is like tell the farmer to lock the barn door after the livestock has left.

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

I received the database. I created the query from the screenshot that you posted higher up. I could run it without error - it updated 2 records.
Regards,
Hans

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

OK, I'm in the process of updating, two sources Db BU and Excel Feb to May

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

Got a question when you awake. How would I append records from Excel to Db. A couple of problems there are a couple of fields in Excel that are not "correct" in the Db. Only 312 records and I can figure the values that are correct. The order of the fields is different. Also the Excel has multiple sheets, #3 is the one to append from.

User avatar
HansV
Administrator
Posts: 68784
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Field validation issues

Post by HansV »

I would import or link the table from Excel into your database (using the External Data tab of the Ribbon).
Then create an append query that appends records from the imported/linked table to the Access table.
After running the query, you can discard the imported/linked table.
Regards,
Hans

bknight
4StarLounger
Posts: 598
Joined: 08 Jul 2016, 18:53

Re: Field validation issues

Post by bknight »

After one and a half full days, Db is reconstructed and backed up. I still need to review all the additions to fix any entry errors.
I haven't tried any of the updates that started the thread, but if you were able to change them I'm sure I will be able.
Thanks