How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
Course Of The Month
10 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access datasheet and hide rows
Posted on 2012-12-28
I have a form that's in datasheet view
It has a subform also in datasheet view
The subform and parent form both have a column txtMyId
What I want to do is if Me.txtMyId <> Me.Parent.txtMyId then
Hide entire data row if possible
I tried testing with the following code and an extra unbound column to update
But it comes back with everything "Matches" which I KNOW isn't correct
Do I need some kind of "For Each?"
I can do that in .Net easily
If Me.txtMyId = Me.Parent.txtMyId Then
Me.txt2 = "Matches"
Else
Me.txt2 = "No Match"
End If
It has a subform also in datasheet view
The subform and parent form both have a column txtMyId
What I want to do is if Me.txtMyId <> Me.Parent.txtMyId then
Hide entire data row if possible
I tried testing with the following code and an extra unbound column to update
But it comes back with everything "Matches" which I KNOW isn't correct
Do I need some kind of "For Each?"
I can do that in .Net easily
If Me.txtMyId = Me.Parent.txtMyId Then
Me.txt2 = "Matches"
Else
Me.txt2 = "No Match"
End If
[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
6-
2
8 Comments
Active 7 days ago
<What I want to do is if Me.txtMyId <> Me.Parent.txtMyId then
Hide entire data row if possible>
Why not just filter for this?:
Make the recordsource for the form:
SELECT....
FROM Yourtable
WHERE MyId <> Forms!YourForm!MyID
...or something similar
JeffCoachman
Hide entire data row if possible>
Why not just filter for this?:
Make the recordsource for the form:
SELECT....
FROM Yourtable
WHERE MyId <> Forms!YourForm!MyID
...or something similar
JeffCoachman
Active today
boag2000
This subform datasource is a view from SQL Server and set in the properties box.
I want to do this in VBA if at all possible...
The actual <> will look like this...
If Nz(Me.txtMyId,Me.Parent.tx
...
This will allow nulls and whatever = the Parent
How do I set this in VBA when the datasource is a straight properties view?
This subform datasource is a view from SQL Server and set in the properties box.
I want to do this in VBA if at all possible...
The actual <> will look like this...
If Nz(Me.txtMyId,Me.Parent.tx
...
This will allow nulls and whatever = the Parent
How do I set this in VBA when the datasource is a straight properties view?
Active 7 days ago
With the addition of the NZ(), it is still not clear what you need here, ...
If the Recordsource is set, and cannot be changed, ...you can set the Filter Property of the subform:
MyID<>Forms![frmParent]![M
(and probably set the FilterOnLoad Property to: Yes)
I mean, you can filter dynamically with VBA, but I don't a reason to go through all the extra work, if you can just filter.
Can you post a simple sample of this database?, it is confusing that you seem to want to filter on your "Linking" field.
Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Unhide any hidden database objects
10. Compile the code. (From the VBA code window, click: Debug-->Compile)
11. Run the compact/Repair utility.
12. Remove any Passwords and/or security.
13. If a form is involved in the issue, set the Modal and Popup properties to: No
(Again, unless these properties are associated with the issue)
14. Post the explicit steps to replicate the issue.
15. Test the database before posting.
In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
JeffCoachman
If the Recordsource is set, and cannot be changed, ...you can set the Filter Property of the subform:
MyID<>Forms![frmParent]
Active 7 days ago
Here is the sample DB I worked up and it sets the filter Prop of the subform.
(Open the database and examine the raw data first)
It seems to do what you asked:
"if Me.txtMyId <> Me.Parent.txtMyId then Hide entire data row if possible"
Database5.accdb
(Open the database and examine the raw data first)
It seems to do what you asked:
"if Me.txtMyId <> Me.Parent.txtMyId then Hide entire data row if possible"
Database5.accdb
Active 7 days ago
I may have crossed to logic, ...but I am sure you can figure out what needs to be done to fix the syntax...
Active 7 days ago
Yeah, I think the filter you may have wanted is actually:
MyID=Forms![frmParent]![My
MyID=Forms![frmParent]
PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 15 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$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.