Understand advanced principals around Powershell Core with a focus on the Linux Administrator. This course covers how to administer numerous environments across multiple platforms including Linux, Azure, AWS, and Google Cloud from a single shell instance.
Course Of The Month
10 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access 2016 VB code
Posted on 2016-08-28
My OS is win 10 pro 64 bit and I have Office 365 and Access 2016 installed on my desktop. I created a small password creator, which works very well. But I am trying to implement a search function, and this does not seem to work. I copied the code from a 2007 sample app.
Basically, I would open the Form: frmSearch. Where there is a field "Select field to Search:", and in the field I would select the field of the table to search criteria, eg: URL or site. The field is a combo field with a drop down arrow, to allow me to select the field from the Table : tblMainPasswordTable. I normally select the field URL or site.
In the "Search for" field, which is unbound field, I would type the search criteria, eg; Office.
And then select the option box " Any part of field" , and then hit the View Results button.
This would open the Form, frmPwd to display the selected criteria and display the results from the table : tblMainPasswordTable.
But the code is not working, it does not display the correct record for the search criteria. and at times it bombs at the line : Open Args
Attached is the visual basic source code of the app, and hope the Experts could please let me know where I goofed, as my experience in VB is only at the 2007 level. Thank u and Regards.
Search-code.txt
Basically, I would open the Form: frmSearch. Where there is a field "Select field to Search:", and in the field I would select the field of the table to search criteria, eg: URL or site. The field is a combo field with a drop down arrow, to allow me to select the field from the Table : tblMainPasswordTable. I normally select the field URL or site.
In the "Search for" field, which is unbound field, I would type the search criteria, eg; Office.
And then select the option box " Any part of field" , and then hit the View Results button.
This would open the Form, frmPwd to display the selected criteria and display the results from the table : tblMainPasswordTable.
But the code is not working, it does not display the correct record for the search criteria. and at times it bombs at the line : Open Args
Attached is the visual basic source code of the app, and hope the Experts could please let me know where I goofed, as my experience in VB is only at the 2007 level. Thank u and Regards.
Search-code.txt
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
- +1
9 Comments
Hi.
Please, can you attach the database file?, reading the code is useful, but see how you call the code procedures and the forms is much better, beacause we can understand what the code does really.
Thanks.
Best regards.
Antonio.
Please, can you attach the database file?, reading the code is useful, but see how you call the code procedures and the forms is much better, beacause we can understand what the code does really.
Thanks.
Best regards.
Antonio.
Active 1 day ago
I cannot seem to attach a Access file either in 2016 or 2002-2003 versions. How do I upload the file which is in 2016.
thank u
thank u
Active 1 day ago
Thank u hnasr for the solution how to load the file. Here it is as a txt file, but u would have to change the extension to an accdb once u have unzipped it. Thank u.
TestforEE.txt
TestforEE.txt
Active today
Not sure if I correctly understand the problem.
Check if you are opening the right form.
Ignore the frmPwd.
Open the frmSearch.
Enter Search for values and check.
Modified open form to use Where condition.
TestforEE-2.accdb
Check if you are opening the right form.
Ignore the frmPwd.
Open the frmSearch.
Enter Search for values and check.
Modified open form to use Where condition.
TestforEE-2.accdb
Active 1 day ago
in response to hnasr, Bravo for correcting the code, the application now works fine as it was planned for. Thank u again.
Featured Post
The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 23 hours left to enroll
Earn Certification
CompTIA IT Fundamentals
$49.00$44.10
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.