You are a great teacher with sense of humor, Greeting from EGYPT , best instructor to learn MS Access, despite I am not professional , because I have another profession (surgeon) But I enjoyed your way of building up every part of MS access file , and thinking to subscribe of professional levels ...Thank you
Sorry, but based on the information you've given me, I really don't have enough data. Feel free to submit your question with more details (including screen shots) in the Access Forum on my web site. 599cd.com/AF
Hi professor. Successfully followed your tutorial but when I Emptied all my record since there is no reference in the code for the target report to open, error message comes out when you click the print button. How to handle error on blank record pls. ..this is highlighted in yellow color...DoCmd.OpenReport "ProjectListR3", acViewPreview, , "ProjectID =" & ProjectID, acDialog, your kind reply is highly appreciated.
Dear Sir, I test my database with both methods a query and VBA. But every time it prints the whole database. Not a single report as presented in video. I’m using text field Compay_Name as a filter not CompanyID.
How to retrieve the customer name from more than 2 tables or queries in one report, i mean to check the customer history from customer master, customer RFQ, quote to customer, P.O from customer, Invoice to Customer in single REPORT
how to open the form to minimize like that and different window with the main from? cause when i try the same thing i just change my windom to another form with full screen view of that form
Suppose I want to enter let's say a farmer brings in the morning 50kgs of coffee cherry and in the noon the same guy brings 30kgs and lastly in the evening he brings 70kgs. Now how do I save these records to database using forms. Note that this records is saved under specific I'd number. I am waiting for your feedbacks.
hey guys please help i am stuck in aquery i have sales table and cash receipt table which records the amount received from customers and in sales table the colums are name, product , price ,total , amount received and the amount received may be zero or a partial payment so i wanted to make a customers balance query where i can see the balance of each customer i have make a sql query but its some time gives true values and some time it not
It is totally impossible for me to figure out anything based on what you've told me. I would need to see screenshots, details, and a lot more information.
Going a step further, now that you have the single record report, is there a way using the Property Sheet to save the report as a PDF or Email with the fields Last_Name and First_Name? Trying to build the steps without VBA/macros...challenging myself! Currently the Report uses the Caption entry.
I get a ton of questions every day, and I don't have time to answer them all here on TH-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
Anybody else have trouble with all the records in the underlying table trying to print when you 1st open the database even though only one record is opened in the report? I've tried restricting the recordset multiple different ways, in the query, in the docmd.openrepert method. After closing then reopening form from which report was opened and printed, it works fine
Hi there, new member here. So far its so worth the money. I keep getting Compile error: Syntax error but I cant figure out why: Private Sub Command24_Click() DoCmd.OpenReport "Notice_Pending_Lien", acViewPreview, , "Lien ID = " & Lien ID End Sub Any thoughts?
I've done everything you said and it works fine with all my Forms but still can't get it to work with a report...Access keeps asking me ID value ! Here is my button code, i checked everything and it's ok but the 'Enter a Value' box still appears : Private Sub Commande37_Click() DoCmd.OpenReport "Soumission", acViewPreview, "ID=" & Me.ID End Sub
I get a parameter prompt. I've double checked the spelling of my field everywhere it's in use. Here is the code: Private Sub Command138_Click() DoCmd.OpenReport "rpt_StudentReportFromQuery", acViewPreview, , "StudentID=" & StudentID End Sub Also, my form is for Students, and has a sub-form listing the classes they are in. Does that matter? Thank you.
I figured it out. My report is based on a query, not a table. In the query, the full field name is tbl_Student_StudentID. So I modified the field name in quotes to "tbl_Student_StudentID=".
thumbs up to the greatest Access teacher Richard from the beginning of class so that I wont forget. Thanks Richard for another excellent tutorial.
Welcome
You are a great teacher with sense of humor, Greeting from EGYPT , best instructor to learn MS Access, despite I am not professional , because I have another profession (surgeon) But I enjoyed your way of building up every part of MS access file , and thinking to subscribe of professional levels ...Thank you
Thank you for the compliments
I just want to shout out a huge thanks ! In one day I was able to create an inventory database outputting Kanban cards. You made that possible.
You're welcome
This is well-delivered and clear
Thank you very much that tutourial saved my day
Glad it helped
THANK YOU
Welcome
Super helpful! Thank you.
You're welcome!
Pretty cool. How would you the same thing but instead of a report how you export to excel??
Just format the report so you can export it.
Thank you so much. for but i got a problem on opening a specific Date...!!! please direct me the right way
Sorry, but based on the information you've given me, I really don't have enough data. Feel free to submit your question with more details (including screen shots) in the Access Forum on my web site. 599cd.com/AF
Great video.
Using VBA code, how would you print a report of only the records a user selected as they browse through the database? Thanks 🙏🏿
599cd.com/SelectRecords
@@599CD - Thanks a bunch. Life saver!!!
Hi professor. Successfully followed your tutorial but when I Emptied all my record since there is no reference in the code for the target report to open, error message comes out when you click the print button. How to handle error on blank record pls. ..this is highlighted in yellow color...DoCmd.OpenReport "ProjectListR3", acViewPreview, , "ProjectID =" & ProjectID, acDialog, your kind reply is highly appreciated.
599cd.com/NoData
Dear Sir, I test my database with both methods a query and VBA. But every time it prints the whole database. Not a single report as presented in video. I’m using text field Compay_Name as a filter not CompanyID.
Try, try again.
Sir, I had a question in my project, i have made a project and I want to show you .
You can post some screen shots. I don't accept file attachments.
How to retrieve the customer name from more than 2 tables or queries in one report, i mean to check the customer history from customer master, customer RFQ, quote to customer, P.O from customer, Invoice to Customer in single REPORT
599cd.com/Relationships
I have never seen you using Form Wizard and Report Wizard?
Why don't you use this option? Sir..!
599cd.com/QQ
how to open the form to minimize like that and different window with the main from? cause when i try the same thing i just change my windom to another form with full screen view of that form
You need to switch to Overlapping Windows. 599cd.com/OverlappingWindows
How did you record this in your screen
599cd.com/a?23801
I tried the VBA example but I got a missing operator message.
Try again
How can you do that sir with two or more tables?
Sure
Suppose I want to enter let's say a farmer brings in the morning 50kgs of coffee cherry and in the noon the same guy brings 30kgs and lastly in the evening he brings 70kgs. Now how do I save these records to database using forms. Note that this records is saved under specific I'd number. I am waiting for your feedbacks.
Use a 2nd related table to store that, just like a customer with multiple orders or contacts. 599cd.com/contacts
How do I base a report on a field in a tbl being blank
I don't understand
hey guys please help i am stuck in aquery i have sales table and cash receipt table which records the amount received from customers and in sales table the colums are name, product , price ,total , amount received and the amount received may be zero or a partial payment so i wanted to make a customers balance query where i can see the balance of each customer i have make a sql query but its some time gives true values and some time it not
It is totally impossible for me to figure out anything based on what you've told me. I would need to see screenshots, details, and a lot more information.
Thaaaaaaaaaaaaaaaaaaaaank you siiiir
weeeeeeeeeeeeeeeeeeeeeeeelcome ;)
Going a step further, now that you have the single record report, is there a way using the Property Sheet to save the report as a PDF or Email with the fields Last_Name and First_Name? Trying to build the steps without VBA/macros...challenging myself! Currently the Report uses the Caption entry.
I get a ton of questions every day, and I don't have time to answer them all here on TH-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
❤
Anybody else have trouble with all the records in the underlying table trying to print when you 1st open the database even though only one record is opened in the report? I've tried restricting the recordset multiple different ways, in the query, in the docmd.openrepert method. After closing then reopening form from which report was opened and printed, it works fine
Never had any kind of a problem like that.
Hi there, new member here. So far its so worth the money.
I keep getting Compile error: Syntax error but I cant figure out why:
Private Sub Command24_Click()
DoCmd.OpenReport "Notice_Pending_Lien", acViewPreview, , "Lien ID = " & Lien ID
End Sub
Any thoughts?
You broke one of my top rules... No spaces in field names!
@@599CD you are absolutely right. Removed the space in the table and it worked! Thank you
I've done everything you said and it works fine with all my Forms but still can't get it to work with a report...Access keeps asking me ID value ! Here is my button code, i checked everything and it's ok but the 'Enter a Value' box still appears :
Private Sub Commande37_Click()
DoCmd.OpenReport "Soumission", acViewPreview, "ID=" & Me.ID
End Sub
You didn't do what I said, because nowhere did I use Me. And you're missing a comma. Details matter.
I get a parameter prompt. I've double checked the spelling of my field everywhere it's in use. Here is the code: Private Sub Command138_Click()
DoCmd.OpenReport "rpt_StudentReportFromQuery", acViewPreview, , "StudentID=" & StudentID
End Sub
Also, my form is for Students, and has a sub-form listing the classes they are in. Does that matter?
Thank you.
I figured it out. My report is based on a query, not a table. In the query, the full field name is tbl_Student_StudentID. So I modified the field name in quotes to "tbl_Student_StudentID=".
Glad I could help. :)
I have the same issiue too, how do I get the field name in the query