Display a Single Record in a Microsoft Access Report - Open a Report to a Specific Record
ฝัง
- เผยแพร่เมื่อ 26 ต.ค. 2009
- NEW!!! See a newer version of this video here: 599cd.com/OpenReportSpecific
Want to open a report and find specific data to display? You can't do it with the Command Button Wizard like you can with forms. I'll show you a trick for opening reports and showing specific data.
Thanks millions Richard for your valuable lessons. I always find the solution from your classes. You're the BEST teacher online!
Wow, thanks!
Excellent!
I was trying to display specific data from a second form through a command button. The command button wizard when followed step-by-step doesn't display matching fields on the left-hand side. The right-hand data is displayed correctly. What could be the cause(s)? Any help would be appreciated.
LIFE ... SAVER!!! Definitely subscribing to this channel. Easy, to the point, no BS instruction.
Thank you very much for the compliments.
I used your suggestion and it worked great. However if your using the form your linking you quary to in a "Main Form" or "Navigational Form" then your suggested process won't work. Any suggestions on how to fix this?
Very grateful for this tutorial as I have just needed to add a command button to a form which run a macro which emailed out a RTF version of the report that was based on this query as I needed to only have details of a single entry per email. It worked for me :)
You're welcome. :)
could u please help me? im desperate!! i need to create report with specific data that the user will check. so the user will open a form that has listed all the collums from table and to check ones that he wants in his report. how do i do that???
thank u so much! i will try to find some vba programming tips on google first. i have other problem now. i was watching ur video on how to set up a search. i have a lot of colums and when i make a form and query(everything like u explainded it in video) it does not show any records. i have no idea why,its been bugging me since yesterday.when i set up search for several columns it works,but for all no,not even for the ones that worked before i added new. do u know maybe why is that happening?
Does your report show a single record or multiple records in a row/column format? If it's only a single record, you could set the VISIBLE property for the fields based on the selected values. EITHER WAY, this is going to involve some VBA programming and is way beyond what I can explain here. Contact me privately for further help.
Brilliant guide thank you so much! Been ripping my hair out for ages with this, 2:02 in and you nailed it! Thumbs up!
Thanks
Thank you so much, this was really helpful.
My pleasure.
your tutorials are very helpful! thanks! =)
Welcome
this worked for me, but when i do it, in my report, i have 10 copies of the same record :s. any ideas where i went wrong?
how do you make these video's
Thank you very much sir.i learned a lot from yr amazing video
My pleasure
Thanks for this informative video
You're welcome.
thanks - wonderful tutorial
Welcome
Thank you for that. Just wondering how would you print single record with single contact only report? Any suggestions. thannk you
599cd.com/46S3J
It does not work. When I pick third record and clicked on contact button. Contact form shows first record not third record. Please care to explain why?
thank you sir. you helped me to solve many mysteries!
My pleasure
thanks! and please guide how we can get the result from multiple reports of different types .. if report "A" have data in rows and report B have data in Tables format then how we can control with a single button?
Good question. Feel free to submit it: 599cd.com/TH
Thank you very much,
I have a question: I have customer list over 50 person, how do I select some of them to print them in a report?
Add a Yes/No field called "ToBePrinted." Go down the list and check the ones you want to show up on your report. Now make a query that only displays those records. Base the report off of that query.
Do you know how print something when i use navigate Form? MS Access 2013
Click the PRINT button.
Thanks....it really helped
You're very welcome.
I want to thank you very much it worked. I always used the VBA command, but it didn't work for this form. thank very much
welcome
Thank you very much!
Welcome very much. :)
Couldn't get it to work. At 4:45 when I try to run the query I get "Type mismatch in expression"
Fixed it :)
Thanks sir u solved my problem
My pleasure.
HI pls ihv an it exam and wanted to know how to like make on only a specific( male or female) gender in a report
Sure you can.
When I run my query referencing the field in the form that contains the ID I'm looking for, strangely, it is asking for that value as a parameter? As it the field was empty or something.... can you please help me out Richard? I'm lost :(
599cd.com/EPV
@@599CD Amazing! it is working now. Richard, you're an absolute genious. Thank you so much!
I would like to add my voice to the chorus of thank yous. I used this query argument back in 2000 and completely forgot on how to do it. Thanks.
My pleasure
I cannot get this query to work. Are your customer number autonumbers or assigned numbers? Does it matter if they are autonumbers? I desperately am trying to get this to work. Anyone can help?!?!
I always use AutoNumbers as Primary Keys. But this shouldn't matter what kind of field you use, as long as it's unique.
how can I use this in a Access navigation form.
I don't particularly care for Navigation forms. I prefer using a Main Menu form. I show how to make one here: 599cd.com/blank. Once you have that, it's easy to add a button to it to open your reports.
Your tutorials are great however can I make a suggestion. I think it would be very beneficial if you ran the application as it was intended and then show the logic of building it. I get confused on the need of the session or functionality or end goal when watching the method of building the tables, queries and reports. Thanks.
I don't get it
Is it possible to display more than one record
Sure. Just make a query with whatever criteria you want. If you want so PICK specific records, then make an "IsSelected" field and check the ones you want.
Reports start at 2:47.
K
How to hide duplicates and get sum in access report
Feel free to submit your question at 599cd.com/TH
It's impossible for me to tell what's wrong without looking at your database. Sorry.
Where is the 300 level series..??
599cd.com/Developer
Supper ... Mashallah... thanks alot
Now that you mention it, I am kinda hungry. :)
Thanks
Welcome
omg what a babe! Thank you xD
Haha thanks.
Sir I am a student in the south pacific region and I am currently working to support my family due to the current job that I have as on casual and I want to be promoted to an administrative office, so please help me build a application for teachers development so I can present to them may be this might help in my career
Sounds like a noble cause. Start here: 599cd.com/acb1
Thanks. you just saved my ass.
I'm not a proctologist, but I'm glad to help.
Star Trek Fan?
Ya think? :) LLAP
hi good
thx
hard to learn. :3
Keep at it