Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-18-2019, 08:33 AM   #16
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,662
Thanks: 38
Thanked 890 Times in 873 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Error: Item Cannot Be Found...

Quote:
Originally Posted by xyba View Post
The code I used for the module includes this explanation.

If I'm reading that right, I've changed RecordNo to reference the field on the form that holds the unique ID but I still get the error message.
Hi. Try adding the ID field to the form but hide it.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 07-18-2019, 08:35 AM   #17
xyba
Newly Registered User
 
Join Date: Jan 2016
Posts: 168
Thanks: 55
Thanked 0 Times in 0 Posts
xyba is on a distinguished road
Re: Error: Item Cannot Be Found...

Quote:
Originally Posted by theDBguy View Post
Hi. Try adding the ID field to the form but hide it.
I was just trying that but still getting the error.
xyba is offline   Reply With Quote
Old 07-18-2019, 08:50 AM   #18
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,662
Thanks: 38
Thanked 890 Times in 873 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Error: Item Cannot Be Found...

Quote:
Originally Posted by xyba View Post
I was just trying that but still getting the error.
Unless I get some new revelation later on, the only thing I could think of right now is to have a copy of your db, so we can look for ourselves why you're getting the error. Otherwise, you might try commenting out the bad code until you can figure out how to fix the error.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
xyba (07-18-2019)
Old 07-18-2019, 08:51 AM   #19
xyba
Newly Registered User
 
Join Date: Jan 2016
Posts: 168
Thanks: 55
Thanked 0 Times in 0 Posts
xyba is on a distinguished road
Re: Error: Item Cannot Be Found...

Quote:
Originally Posted by theDBguy View Post
Hi. Try adding the ID field to the form but hide it.
Sorted!!

There was a mismatch in a table field name in the audit table.

Thanks for all your help as I wouldn't have got that far without it.
xyba is offline   Reply With Quote
Old 07-18-2019, 08:55 AM   #20
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,662
Thanks: 38
Thanked 890 Times in 873 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Error: Item Cannot Be Found...

Quote:
Originally Posted by xyba View Post
Sorted!!

There was a mismatch in a table field name in the audit table.

Thanks for all your help as I wouldn't have got that far without it.
Congratulations! Glad to hear you got it fixed. Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
xyba (07-18-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Item Not Found in this Collection Error Sousuke81 Modules & VBA 3 06-01-2016 07:04 AM
Question Item not found in this collection error? WildmanUK General 3 07-31-2015 05:53 AM
Item not found in collection error ritco Modules & VBA 3 06-11-2012 12:38 PM
Item not found in this collection error SeriesIII Modules & VBA 5 03-04-2009 07:22 AM
Item not Found in this Collection error Kenshiro Modules & VBA 12 05-12-2006 11:09 AM




All times are GMT -8. The time now is 08:38 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World