Field validation issues
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Field validation issues
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?
I looked through all the fields for a validation rule and find none in any field. So where else to look redefine any rule?
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field valibration issues
NM, I did finally find where the validation is located.
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field valibration issues
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.
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.
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field validation issues
Perhaps the OrderStatus field is required (i.e. it cannot be changed to blank)?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
There are records in which OrderStatus is null so that can't be the issue
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
There is Validation text on all fields
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field validation issues
Could you attach a zipped copy of the database with the Trades table?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
Too big.
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field validation issues
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.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
OMG, I decided to delete x records so that I could zip it and forgot to save. Is thee a critical undo?
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field validation issues
'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?
- 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?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
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.
Oh man the zip file is 864K and the website says too large.
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field validation issues
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.
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.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
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.
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.
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field validation issues
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.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
OK, I'm in the process of updating, two sources Db BU and Excel Feb to May
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
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.
-
- Administrator
- Posts: 78594
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field validation issues
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.
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.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Field validation issues
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
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