Microsoft Access
--
Questions
--
Followers
Top Experts
Need help with fixing this old Find as you Type Allen Browne sample database - error: run time error 2465
Please note the following website has a sample database...
http://allenbrowne.com/AppFindAsUType.html
and I would love to be able to take a look at this via 64 bit - Microsoft Access but so far when it opens... I get an error: run time error 2465' application defined or object-defined error. per images here
I've looked in References everything looks fine.
Perhaps there is a change in the past before with the way Form Controls - are laid out in progression.
I know the following article can help me fix the proper syntax but still failing all attempts:
https://docs.microsoft.com/en-us/office/vba/api/access.page.pageindex
What do I have to do change the syntax to make this work? Thanks in advance!
http://allenbrowne.com/AppFindAsUType.html
and I would love to be able to take a look at this via 64 bit - Microsoft Access but so far when it opens... I get an error: run time error 2465' application defined or object-defined error. per images here
I've looked in References everything looks fine.
Perhaps there is a change in the past before with the way Form Controls - are laid out in progression.I know the following article can help me fix the proper syntax but still failing all attempts:
https://docs.microsoft.com/en-us/office/vba/api/access.page.pageindex
What do I have to do change the syntax to make this work? Thanks in advance!
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
It runs nicely here. No errors.
I converted it to an accdb (attached). You could check that out.
FindAsUType.accdb
I converted it to an accdb (attached). You could check that out.
FindAsUType.accdb
FWIW, I was also able to download that MDB file and open it in Access 2019 64bit version here with no errors...
»bp
»bp
Wow. I downloaded your sample, Gustav and still get that same error above in the screenpics.
Here is an image of the type of MS Access I have and update:
Here is an image of the type of MS Access I have and update:
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Basically I need an adjustment on function: FindAsUTypeLoad()
Instead of having it call that ParentNumber function - can't I just pass it the name of the only form: CustomersFinder existing in there to get the page index?
If so, I'm not sure how to change the syntax.
If so, I'm not sure how to change the syntax.
The error is elsewhere. Check the References, or do a repair of the Office 365 installation.
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.