You are giving a awesome service out for a really good price. Iv been self employed all my life and my family ran a few different business just before the 2008 crash. The Information you basically give out at as cheap as a price as if you were paying the monthly fees of Microsoft access. I spend more on one class at a local College and only pick up half as much as what I have learned off your you tube. Keep it up please.
Thanks for the recognition. I'm just trying to build a nice family of UA-cam members. Hopefully if this keeps growing, I'll be able to spend all my time JUST making these TechHelp videos, which is what I enjoy doing the most.
You`re the best, I`ve ever found in this ! Please keep it up!!! You make my day! In contrast to German forums, where most of them are just arrogant and annoying, you explain everything with an ease that is second to none. Very delightful! Please please please, keep up your excellent service!
Hi Richard, firstly, thank you for the pool of knowledge that you put forward, and where ever you are in the world, I hope you are safe and well. It takes me quite a bit of pass throughs to understand, but I get them by the end of the videos and it all makes sense and I learn new methodologies to implement in my own database. Your way of getting technical things across is clear and you use the correct terminology for the app which I also am OCD about and enjoy. I wanted to contribute to the last bit of this video, where you mentioned that it can't open a Report directly from the button click, the following seems to work in my use case. I used the 'Macro Design' tool with the 'Open Report' action, Report Name = (The report you want to open), View = (Print Preview), Filter Name = (leave empty), Where Condition = (="[Job_ID]=" & [Job_ID]), Windows Mode = (Normal)...Making sure to remove the () open and close round brackets/parentheses. This seems to open the report to the Job_ID to match the report, as the Job_T is my junction table (essentially) connecting the Employee_T, Customer_T, and Billing_T...Hope this helps someone who doesn't want to use the code builder and wants a simpler way to do this (I know you personally avoid this)...I believe the syntax for the 'Where Condition' reads the name of the current form from the first 'Job_ID', then takes the report name from the and reads the 2nd 'Job_ID' from the report to match them (I might be wrong here as you are the MVP)...Hope this helps someone. Be safe, thank you, and continue your great work, wishing you and your loved ones a merry x-mas.
Well ah... Richard, it's my first viewing of one of your videos, got to say that it's really great! I'll be back for more. You have the know how and you're blessed with a radiophonic voice. Overall, Great job.!
I want to thank you so much. I have been learning Access strictly from watching your videos and i have learned a lot. I have been struggling on what video I should watch and I am hoping you can help. I would like to learn how to adjust a price on a product without altering previous records. Any information would be helpful!! Thank you again for your guidance your videos are fantastic!
real informative content. only discovered how powerful access is today and I'm already making databases for my own apps that I wrote in C#. Thats how much I learnt from just watching your videos today. Thank you man
I have been watching some of your videos on and off for the past two years and learned a lot. I used one great teacher Bruce Myron from Udemy and also learned a lot. I took some college level classes as part of my degree but it does not compare to the level of great examples to different processes from you guys. Thanks for the great work... Well let me get to the Ext Cut for this video... : )
I to follow both of these guys. It's really productive when you find the top guys online who are not only highly knowledgeable and have most pertinent examples but also great presenters. It helps when the presenter can sustain the interest with an economy of words and at a good pace.
I wanted to download the free templates for the Invoice Order program I spent the day watching and creating. I lost my incentive at the end... where you started adding buttons to get the right invoice to print. Anyway, do love your tutorials but trying to download your information just keeps taking me around in a circle and right back where I started. I'll have to watch the end of this video again. Thanks for all your detailed contributions! :)
NO FREAKING WAY!!! DOUBLE-CLICK the "FORMAT PAINTER" - this is going to be SO handy in my day job! Also, thank you for these videos [Silver member on Day 1] - super helpful going from zero Access skills for my Master's Degree database project.
Your channel is so amazing, I keep learning new short cuts and tricks with all your video and couldn't have done anything without them. Thank you again 👍
Your videos are amazing. I've been binge watching and learning so much alongside my uni study. So much information, ideas and inspiration. I've setup a demo database prospecting for work off my old boss. Trying to convince him of the benefits of a database system instead of dozens of linked spreadsheets. My tables are on a Linux server VM running Lamp stack, and use the ODBC 8.0 unicode driver to connect my Access front end. Did consider standalone access, but plan to develop some website connection for customer enquires, and wanted to learn Linux and Mysql too. I'm looking to subscribe at Christmas when I get some time to really get stuck into the higher vba stuff. I've never really understood and got Access until I went to uni, learnt about relationships and normalisation, and watched your videos to put a front end on it all. My old job I used excel vba to create entry forms and enter into sheets, and also doing my PDF invoice/del note/orders constructed painstakingly on the sheet. I'll never use Excel as a database again 🤣 Access is amazing. Thanks. Atb👍
Your videos are so helpful! Thank you for sharing your extensive knowledge of Access. I am using the Northwind Traders template to build an order entry database for selling cabinetry. Every product on the Product table is available in six different colors. I created a new table called 'tblColors' and assigned each color to a ColorID. I added the 'ColorID' field to the 'Orders' table and the 'OrderDetails' table as well as created a combo box on the frmOrderDetails form to select a color. I created one-to-many relationships with the ColorID field in my Colors table and the newly added ColorID fields on the Orders and OrderDetails tables. When I create an order and select a Color from the combo box, the record is updated in the Orders table but not the OrderDetails table. I have tried many different things but I cannot get the ColorID to update on the OrderDetails table. What am I doing wrong?
That was a nice video showing how invoice forms are created in Microsoft Access. I enjoyed the way that Richard Rost used all the database objects to create an effective invoice.
Hello Charles, let me take this opportunity to thank you for the great work. Am Eric Muwanga from Uganda. You videos have helped me so much to build up a school management System software. Am looking forward to join silver
Hi Richard, Thank you your videos have been so very useful. However I am struggling with the joining of the first and last names, have set up the combo box but none of the customers show and it asks me to enter parameter value and doesn’t display the names, the same when I open the query linked, what have I done wrong?
Hello Richard, been watching for awhile and I’m enthralled with learning this program. As for your issue with continuous forms having alternating colors, have you tried right clicking and setting alternate back color to none? If you do this in your template then it should solve your problem. I’ve watched both your beginner series that are currently free on UA-cam and would love to see more!
Hey hi!I'm Denis from kenya I'm trying to develop a point of sale system in access,but Im having one common PROBLEM,a linked table or subquery that should display the price of a product as well as the items name,but the user should store them on different fields e.g you select pencil from a lookup field,and u get the default price on sell price field,having set the product and price on items table,I'm really determined to make this successful, I'll appreciate your help 🙏, thanks in advance
Question. I am at the point where I have dragged my OrderDetailF into the OrderF and for some reason no data is showing up in the Order Detail fields. If I open OrderDetailF by itself, all the data populates. I'm sure I am missing something simple, but I don't know what it is. My Link Master and Child fields are both looking at OrderID. Any tips on where to look for the issue?
Thanks very much sir for the knowledge I have built a sample of this tutorial but I reach the print a specific record and I go back to the query design I input but my form names doesn't show What can I do
Sorry, but based on the information you've given me, I really don't have enough data to help you. Feel free to submit your question with more details (including screen shots) in the Access Forum on my web site. 599cd.com/AF
This video helped me a lot. It is just what I need for my organization. I also want to take i9t a bit further. So I must ask. Do you also have a stock system where when an order are placed, then the products will automatacally go of the styock level? Because now I have to sit and physically go in and add and substract when products going in and out. I love your videos, they are so much more than just showing. Thank you
It is important to know how an invoice gets created. It means on what basis it got created. For example because of some orders, an equipment assignment or something else. This way of doing invoices is so simple.
Your videos are so helpful thanks for posting. We have lots of calibrated equipment and I am wondering if I am put them all into a database can I get access to print out a reminder automatically 1 month before for when the calibration is due? Could you do a video if possible many thanks
hi! i been watching your videos since 2018 and have created 2 dBases! :) now I am working on my 3rd and need some help. So I need help with receiving of individual product from multiple sources and then creating pick list/orders from existing data... this is very high volume, 1000+ units a month.
Thank you for all that you share. Extremely helpful. What is the cheapest thing you offer, for me to learn how to make my products and prices automatically populate on the order form etc? I am using your template for balloon decorating / twisting. Not sold any yet just for family and friends. Take care
If by "automatically populate" you mean choose a product from a list and the details (price, etc.) go into the order form, then I show that in the Extended Cut of this video. $5.99 to become a Silver Member gets you ALL of my Extended Cuts.
Thank you, it was very instructive. What about if I do want to lock the invoice (or marked it as printed) after it has been printed in order to avoid showing (printing) the same invoice again and again?
Mr. Richard Rost i like your videos the way you tell easy to understand. I have learned lot of things from your videos. I have a table of different fields in which Amount and Check box. I want to sum the amount values on for check box yes. Need your help
Just SUM up the check boxes. A y/n field has a value of -1. Multiply the end result by -1 for your answer. This is actually already on my list for a future TechHelp video, so stay tuned.
Thank you very much. I Watch and love all of your lessons from Afghanistan. I have told about your lessons to a lot of my friends and they are also following your lessons. I wish we could buy your UA-cam membership, but it's not available in our country.
Hi Richard. I have followed your video making the order system with an invoice. I have a question. I also want to have tables and forms where I can register products in and out, Inventory for my products. It is important for me to be able to produce that kind of system inside this system I just made by following your instructions. Thank you for videos that it easy to follow and easy to understand. Richard
I don't start every video from a blank database because then I would be repeating A LOT of material for EVERY video. I always give links to the pre-requisite videos, so if you don't understand something, go back to those. In this case, here: 599cd.com/Blank. You can't go to med school until you finish pre-med. :)
Hi Richard, I am running a macro that will export a query to an excel format and send it to my customer via email using Outlook. On the SendEmailObject, how can I make the "From" and "To" to read the email address from a table? Also, if I have multiple recipients, how can I add them all in the "To" field. Thank you.
Hey Richard, I wanna ask you something. I set the criteria in the query as same as the orderID to print out 1 invoice. But how about printing multiple invoices? What should I put in the criteria in my query.
I've watched several videos and find them an excellent source of education to build my DB. I started a charity and have simple needs. A donor table, a donation table, and forms to enter data. I need to build report letters to send to donors. One is required when the donor makes a donation of $250 or more. The other one I want is to send a yearly summary of all donations for each donor. What videos should I review to accomplish this task?
Such an informative video series. Thank you for creating them. Only issue I am having is when I go to look at my Order Invoice Report, it has a pop up window saying Enter Parameter Value. what did I do wrong? I can never put the same number in twice.
@@599CD I understand actually I need to present that system and I just wandered if you have one. I hope you can build one as majority of students has a final requirements on school library system. It will help us students if you made one. I always enjoy watching your video and I learned a lot. Though I couldnt afford to be a member though :) more videos to come Mister :)
Hi Richard. Richard here as well. I struggling to get my database with products, orders and suppliers products to work properly. So I use one and the same table for the products, and that is being very messy. I want to know if there is a way that with a Combobox I can choose my or my suppliers' product and still use the same table. And show only the right fields for the right choice. and how to do that with VBA codes. Thank you
Hi, I'm using this tutorial of yours to create my invoicing database and hit a simple snag and can't figure it out. I started to create the invoice (order) query and the relationships between the OrderDetailQ and everything else does not exist, can you assist
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
Hey Man! Thanks for your videos! It does help me a lot. Now. Do you have any video where could help my case? My case: I have customers form different countries, so, my product details changes according to the buyer. For example, I have one number product with 3 different details. Thanks again!
Hey I have been following and I am getting a OrderT.notes could refer to more than one table listed in the FROM clause of your sequel statement when trying to create the order invoice report.. please help
In my full classes, yes. I'm going to continue building this into a more full-featured template and I will add the ability to create quotations and purchase orders.
Is there any way to make the forms available outside of Access? Perhaps hosted on a website or something? I want to have multiple people to be able to enter order info and print invoices at the same time.
Rich, your videos are very informative. My name Steve , I'm from Canada, a have a question, am working with 365 office 2019. when i write in my query ExtPrice: [Quantity] * [UnitPrice] my answer does not shown a $ sign. What am i doing wrong?
How do I add count number on the left side of the list for how many product has been ordered? eg: I received order for 38 product but before sending, I checked the list only have 34 product. rather than having to count from the list to know if anything missing, I prefer having number there. How do I do this? or how do i put a row count in a query?
For a blind individual you make it about as simple as possible however there’s a few things that would make it a little easier is if you could do a slight better job of describing what you’re clicking and where you’re clicking and if you’re also starting from a beginners level or which level and are you starting with a completely new aspect and building from scratch or are you starting in the middle of something I love what you got reach out to me I’d like to know if you got something I can help with those of us who are visually impaired
Hi James. Speaking as someone who is also partially blind (100% blind in one eye, and not that good in the other) I sympathize with what you're saying. As far as the "beginner" aspect of it, I make mention right in the beginning that this is NOT a beginner video. It has pre-requisites that explain a lot of the concepts that I skip over in this video. I can't cover EVERY topic EVERY time I record a new video.
@@599CD I am sorry I guess I missed the part where you said that there was a prerequisite video to this however when you start your video if you could just clearly say well I’m at this point for that point with starting a lesson then for people such as myself who are deeply impaired it would make it easier for us to know where you’re at such as I’m picking up from where we left off on the last video I have open XXX and I think a lot would be resolved an answer than that way once again thank you for what you do and I appreciate any and all help. Like you I am 100% blind in my left eye and I have 2200 version at best in my right eye.
A new unitprice could cause real trouble with invoices currently awaiting payments from customers, also viewing past invoices will be altered. Hope business owners will tread carefully "somehow" .. good lessons though.. 😊
Many thanks for your valuable information and topics! Please I'd like to ask you about the Error No Run time 3044 My data base is splitted into BE&FE and if the network connection failed while using the MS access forms this error occure... How can I check connection with BE and at any time when the FE not connected with BE I need to close the program or wait until re connect with BE or close DB .. Please advise to handle this Error
Thanks for your reply and valuable reference, may i ask you with clarification can i check the connection validity between FE linked tables that bounded on a form ( already used as a recordset in a form) and the BE access file ? And if no network connection between FE and BE can I Handle error 3044? Sorry for asking again but only to clarify more Many thanks in advance
Then something in your code is causing the error. Again, I'm not familiar with this one, and without BEING THERE it's near impossible for me to troubleshoot. If you want further technical support see 599cd.com/Consulting
In my company I make many orders per customer with tables (Customer - Order - OrderDetails - Products) during the month, But at the end of the month I make one invoice with all orders made by specific customer. How to accomplish this in Access to be able to add existing orders in one invoice?
It sounds to me like you really want to have it so that you can put multiple orders on a single printed invoice or have a jobs table where you put job details in that, and then at the end of the month you invoice all jobs that have not been invoiced yet. That's a little bit more in-depth than I go into in my TechHelp videos, but I definitely cover something similar to this in my full course. Or optionally, you can just print out multiple invoices for them like I show here: 599cd.com/PrintMultipleInvoices.
Hi, can I build a database for customers that will book their appointment, and automatically send emails or texts for appointment confirmation, appointment cancelation, reminders etc?
Hey Richard! I've been watching a lot of your videos cause I'm building a medical recordbase for a Vet clinic. I'm having trouble deciding how my database is gonna store medial records. All our medical services fall under 3 basic cathegories; vaccinations, surgeries and consultations. Each type of visit requires different info to be stored, but also share a lot of fields (For example: On a surgery or consultation you might need a "Medication" field but you will not need it on a vaccination) Should I; -Have a dedicated table for each type of service and include all the details necessary for each visit on their designated table (Tho this makes them complicated to show all the medical entries together on a "medical record" form) -Store it all in one table and leave empty values on each entry if they're not needed (depending on what service it is) and have a value define which form has to be opened if trying to view or edit that specific entry on the medical records form (That's how I have it currently) -Have an "Entries" table that has that has the fields used in all visits (index to the patient, owner, medic responsible, date and service) and make "Vaccination" "Surgery" and "Consultation" tables, linking them together (For example: the "VaccinationID" to the "EntryID") so I can view the full info for the visit on a form using a query. I have my patients in a table linked to their owners in another table. Which approach you think might be better on hardware space and performance?
Very good question. I don't know your field, so I'd have to say it's really up to you. I would definitely have an OwnerT table (for the human) and then a related PetT table (one-to-many from OwnerT). Probably a VisitT to log each visit (time, notes, etc.) in which you could put the data that's common to every visit and then maybe a separate table each for vaccinations, surgeries, and consultations and those link to the visit. You'd still be able to pull up a list of all vaccinations from the PetT because they're linked through VisitT. But again, this is something you'll have to decide as you know your business better than I do. As far as hardware space and performance goes, I don't think you'll have a problem with whatever you do here, as long as your database is properly normalized. Good luck!
If you want to email me over a list of all of the tables, fields, and such that you're thinking about including in your database, maybe I'll use this for a future TechHelp video. I've never done any kind of a veterinary database before. Did some medical billing back in the 90s but that was boring and I was just learning Access at the time. :)
@@599CD I'll follow your advice and go that way, if you want me to I can send you a copy of the file to check it out after the update. It already has some cool features, it can generate printable medical recipees with a button on the consultation form. A thing that I would like to add (since a lot of costumers ASK for a feature like this): When you vaccinate a patient it needs to be revaccinated in one year (depends on the situation and vaccine but it's usually one year) and people ask if we could remind them with an Email or text since they forget. How could I make my access database send emails to costumers to alert them like 2 days before? This same principal could be applied to send Happy birthday cards too (without the "two days before" calculation)
Hello. I've watched several of your videos and i have to say, everything is great. I just wanna ask a question about orders and product forms in general. In case i have customer's information on the main form, and adding in the order all the products, in the sub form. Is there a way for xyz reason to cancel the order? I know that it might sounds simple, but when i add something in the sub form it is added automatically in the table data is bound doesn't it? How can we cancel this process and clear the table from the "temporary data"? Perhaps using temporary tables and if the order is placed then we insert it to the main table? P.S. If this topic is covered in one of your videos , please let me know. Thanks again for the well made and well organised material you provide
If the customer cancels the order, you can either delete it or somehow mark it canceled (y/n field). In the Extended Cut for members, I show how you can mark an order either as an Invoice or a Quotation. If it's a quotation it's not something the customer is expected to pay for (i.e. don't list it on your accounts receivable).
Is there a way to auto convert the final total of the invoice into words. i.e. if the final total is $3300.00 then the amount is also mentioned in words Three thousand three hundred.
Hii Rick it’s was nice video I use in my company invoice I got some problem with while typing invoice it’s was blocked and can’t open it’s says some primary key or something So I started typing bills in tabelle directly ther also the + symbol to opne and type bill but it’s vanish how to get it back help me out
I followed the same steps. But when I want to print the invoice of a specific customer, it contains all customers' items. How can I print the invoice of a selected customer? Thanks
Sir I’m just hoping you might see this message, i’ve follow this wonderful template for our invoice processing in our office, but i end up with errors in sharing for multiple users after splitted the files with the backend file resides in the server, hope you can give me an advise what the best solution to eliminate this error cannot open the file “FILE ALREADY IN USE”. It allows only one user to use the file, please help me and also the rest of my database has the same problem now. Error mssg. Couldn’t use file already in use.
You are giving a awesome service out for a really good price.
Iv been self employed all my life and my family ran a few different business just before the 2008 crash.
The Information you basically give out at as cheap as a price as if you were paying the monthly fees of Microsoft access. I spend more on one class at a local College and only pick up half as much as what I have learned off your you tube.
Keep it up please.
Thanks for the recognition. I'm just trying to build a nice family of UA-cam members. Hopefully if this keeps growing, I'll be able to spend all my time JUST making these TechHelp videos, which is what I enjoy doing the most.
You`re the best, I`ve ever found in this ! Please keep it up!!! You make my day!
In contrast to German forums, where most of them are just arrogant and annoying, you explain everything with an ease that is second to none. Very delightful!
Please please please, keep up your excellent service!
Hi Richard, firstly, thank you for the pool of knowledge that you put forward, and where ever you are in the world, I hope you are safe and well. It takes me quite a bit of pass throughs to understand, but I get them by the end of the videos and it all makes sense and I learn new methodologies to implement in my own database. Your way of getting technical things across is clear and you use the correct terminology for the app which I also am OCD about and enjoy. I wanted to contribute to the last bit of this video, where you mentioned that it can't open a Report directly from the button click, the following seems to work in my use case. I used the 'Macro Design' tool with the 'Open Report' action, Report Name = (The report you want to open), View = (Print Preview), Filter Name = (leave empty), Where Condition = (="[Job_ID]=" & [Job_ID]), Windows Mode = (Normal)...Making sure to remove the () open and close round brackets/parentheses. This seems to open the report to the Job_ID to match the report, as the Job_T is my junction table (essentially) connecting the Employee_T, Customer_T, and Billing_T...Hope this helps someone who doesn't want to use the code builder and wants a simpler way to do this (I know you personally avoid this)...I believe the syntax for the 'Where Condition' reads the name of the current form from the first 'Job_ID', then takes the report name from the and reads the 2nd 'Job_ID' from the report to match them (I might be wrong here as you are the MVP)...Hope this helps someone. Be safe, thank you, and continue your great work, wishing you and your loved ones a merry x-mas.
599cd.com/Ask
Well ah... Richard, it's my first viewing of one of your videos, got to say that it's really great! I'll be back for more. You have the know how and you're blessed with a radiophonic voice. Overall, Great job.!
Thank you!
I want to thank you so much. I have been learning Access strictly from watching your videos and i have learned a lot. I have been struggling on what video I should watch and I am hoping you can help. I would like to learn how to adjust a price on a product without altering previous records. Any information would be helpful!! Thank you again for your guidance your videos are fantastic!
real informative content. only discovered how powerful access is today and I'm already making databases for my own apps that I wrote in C#. Thats how much I learnt from just watching your videos today. Thank you man
Great to hear!
I have been watching some of your videos on and off for the past two years and learned a lot. I used one great teacher Bruce Myron from Udemy and also learned a lot. I took some college level classes as part of my degree but it does not compare to the level of great examples to different processes from you guys. Thanks for the great work...
Well let me get to the Ext Cut for this video... : )
Awesome. Thanks for the compliments. Glad you enjoy!
I to follow both of these guys. It's really productive when you find the top guys online who are not only highly knowledgeable and have most pertinent examples but also great presenters. It helps when the presenter can sustain the interest with an economy of words and at a good pace.
I wanted to download the free templates for the Invoice Order program I spent the day watching and creating. I lost my incentive at the end... where you started adding buttons to get the right invoice to print. Anyway, do love your tutorials but trying to download your information just keeps taking me around in a circle and right back where I started. I'll have to watch the end of this video again. Thanks for all your detailed contributions! :)
I'm sorry, but I don't understand your confusion. The downloads are pretty straightforward.
@@599CD I must have just been tired! I did download the database and I really don't know what I was thinking! Thank you for your response!
NO FREAKING WAY!!! DOUBLE-CLICK the "FORMAT PAINTER" - this is going to be SO handy in my day job! Also, thank you for these videos [Silver member on Day 1] - super helpful going from zero Access skills for my Master's Degree database project.
Great to hear!
Your channel is so amazing, I keep learning new short cuts and tricks with all your video and couldn't have done anything without them. Thank you again 👍
Great to hear!
Thank you very much for all your inspriring videos (a new Ms Access french developer)
Welcome
Your videos are amazing. I've been binge watching and learning so much alongside my uni study. So much information, ideas and inspiration.
I've setup a demo database prospecting for work off my old boss. Trying to convince him of the benefits of a database system instead of dozens of linked spreadsheets. My tables are on a Linux server VM running Lamp stack, and use the ODBC 8.0 unicode driver to connect my Access front end. Did consider standalone access, but plan to develop some website connection for customer enquires, and wanted to learn Linux and Mysql too.
I'm looking to subscribe at Christmas when I get some time to really get stuck into the higher vba stuff.
I've never really understood and got Access until I went to uni, learnt about relationships and normalisation, and watched your videos to put a front end on it all. My old job I used excel vba to create entry forms and enter into sheets, and also doing my PDF invoice/del note/orders constructed painstakingly on the sheet.
I'll never use Excel as a database again 🤣
Access is amazing. Thanks. Atb👍
Thanks for the kind words. Glad you enjoy. Keep learning! :)
Am now developing an accounts management System for schools I was going through your invoicing system and it's helping
Glad to help
Your videos are so helpful! Thank you for sharing your extensive knowledge of Access. I am using the Northwind Traders template to build an order entry database for selling cabinetry. Every product on the Product table is available in six different colors. I created a new table called 'tblColors' and assigned each color to a ColorID. I added the 'ColorID' field to the 'Orders' table and the 'OrderDetails' table as well as created a combo box on the frmOrderDetails form to select a color. I created one-to-many relationships with the ColorID field in my Colors table and the newly added ColorID fields on the Orders and OrderDetails tables. When I create an order and select a Color from the combo box, the record is updated in the Orders table but not the OrderDetails table. I have tried many different things but I cannot get the ColorID to update on the OrderDetails table. What am I doing wrong?
Thank you very much You helped me a lot to resolve my problem (print invoice for each customer). So thank you again .
That was a nice video showing how invoice forms are created in Microsoft Access. I enjoyed the way that Richard Rost used all the database objects to create an effective invoice.
Thanks, Captain. :)
@@599CD You are welcome.
😊😊3🎉😂😊😂❤🎉😊😊❤🎉3😂😊😊
Thank you very much Sir!
Taught with great detail, quality and hard work
Very helpful exercise
So nice of you
I would like be joining you pretty soon after i do all the basics before going advance.. thanks sir
Sweet
New subscriber, From Canada, great presentation, this should help me understand Access better. Thank you
Welcome aboard!
I'm from Africa i always use your video for evening study! Thank U!
You're very welcome, from Florida.
Thanks a span. Really helpful. Explanation on spot.
You're welcome
really thank you im in cambodia and your training make me easy to work more batter
Happy to hear that!
Thank you so much sir. i follow your videos most help full for me. thanks
YW
Another great video again steve
Welcome
thank you for this video, it's a big help in creating my project... thank you so much...
My pleasure
wao! It's great dear. Lot's of learning from this channel.
Thank you! Cheers!
Great video. You are awesome.
You are God of MS Access
See, that's what I've been telling people this whole time! Ha ha. Seriously... Thanks! I appreciate the kind words.
Thank you for doing this, this was very helpful.
Welcome
Hello Charles, let me take this opportunity to thank you for the great work. Am Eric Muwanga from Uganda. You videos have helped me so much to build up a school management System software. Am looking forward to join silver
Sorry Richard I put "Charles" I meant Richard
You're welcome. Signed, Charles... er... I mean Richard. :)
Grate video, I really appreciate it.
My pleasure!
At the 31:30 mark of the video, I am not able to get the last table to link to the other two. What am I missing?
Make the relationship manually. 599cd.com/Relationships
I laugh every time you get mad at the stupid box outline. Fantastic lesson, very engaging
Damn outline!!! :)
Question: how do you colour the background of the report. I used the bucket tool but it still doesn't fully colour the page.
Hi Richard, Thank you your videos have been so very useful. However I am struggling with the joining of the first and last names, have set up the combo box but none of the customers show and it asks me to enter parameter value and doesn’t display the names, the same when I open the query linked, what have I done wrong?
599cd.com/Concat
Thank you very much for such a great work!
welcome
Hello Richard, been watching for awhile and I’m enthralled with learning this program. As for your issue with continuous forms having alternating colors, have you tried right clicking and setting alternate back color to none? If you do this in your template then it should solve your problem. I’ve watched both your beginner series that are currently free on UA-cam and would love to see more!
Yep. I did it in a subsequent video. Thanks. It's something I almost never use.
Hey hi!I'm Denis from kenya I'm trying to develop a point of sale system in access,but Im having one common PROBLEM,a linked table or subquery that should display the price of a product as well as the items name,but the user should store them on different fields e.g you select pencil from a lookup field,and u get the default price on sell price field,having set the product and price on items table,I'm really determined to make this successful, I'll appreciate your help 🙏, thanks in advance
Question. I am at the point where I have dragged my OrderDetailF into the OrderF and for some reason no data is showing up in the Order Detail fields. If I open OrderDetailF by itself, all the data populates. I'm sure I am missing something simple, but I don't know what it is. My Link Master and Child fields are both looking at OrderID. Any tips on where to look for the issue?
Thanks so much Richard Rost. It's of much help
You are very welcome
Thanks very much sir for the knowledge
I have built a sample of this tutorial but I reach the print a specific record and I go back to the query design
I input but my form names doesn't show
What can I do
Sorry, but based on the information you've given me, I really don't have enough data to help you. 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. very easy follow. Thanks
You're welcome!
This video helped me a lot. It is just what I need for my organization. I also want to take i9t a bit further. So I must ask. Do you also have a stock system where when an order are placed, then the products will automatacally go of the styock level? Because now I have to sit and physically go in and add and substract when products going in and out. I love your videos, they are so much more than just showing.
Thank you
599cd.com/Inventory
It is important to know how an invoice gets created. It means on what basis it got created.
For example because of some orders, an equipment assignment or something else.
This way of doing invoices is so simple.
Add whatever additional features you need.
Your videos are so helpful thanks for posting. We have lots of calibrated equipment and I am wondering if I am put them all into a database can I get access to print out a reminder automatically 1 month before for when the calibration is due? Could you do a video if possible many thanks
It's certainly possible. Feel free to submit your request here: 599cd.com/TH
hi! i been watching your videos since 2018 and have created 2 dBases! :) now I am working on my 3rd and need some help. So I need help with receiving of individual product from multiple sources and then creating pick list/orders from existing data... this is very high volume, 1000+ units a month.
599cd.com/ask
Thank you for all that you share. Extremely helpful. What is the cheapest thing you offer, for me to learn how to make my products and prices automatically populate on the order form etc? I am using your template for balloon decorating / twisting. Not sold any yet just for family and friends. Take care
If by "automatically populate" you mean choose a product from a list and the details (price, etc.) go into the order form, then I show that in the Extended Cut of this video. $5.99 to become a Silver Member gets you ALL of my Extended Cuts.
With the prices if they change will it change the older orders that are stored?
599cd.com/qq
Perfect. So good. Thanks very much
Glad you like it!
Thank you very much for the training. I have Years only using excel
You are welcome!
Thank you, it was very instructive. What about if I do want to lock the invoice (or marked it as printed) after it has been printed in order to avoid showing (printing) the same invoice again and again?
599cd.com/AllowDeletions
Mr. Richard Rost i like your videos the way you tell easy to understand. I have learned lot of things from your videos. I have a table of different fields in which Amount and Check box. I want to sum the amount values on for check box yes. Need your help
Just SUM up the check boxes. A y/n field has a value of -1. Multiply the end result by -1 for your answer. This is actually already on my list for a future TechHelp video, so stay tuned.
Im usig this for my cousework thanks!
Great!
Thank you very much. I Watch and love all of your lessons from Afghanistan. I have told about your lessons to a lot of my friends and they are also following your lessons. I wish we could buy your UA-cam membership, but it's not available in our country.
I now offer memberships to the Extended Cut videos on my web site as well: 599cd.com/TechHelp
Thx so much. Clear and practical
Glad it was helpful!
Hi Richard. I have followed your video making the order system with an invoice. I have a question.
I also want to have tables and forms where I can register products in and out, Inventory for my products.
It is important for me to be able to produce that kind of system inside this system I just made by following your instructions.
Thank you for videos that it easy to follow and easy to understand.
Richard
599cd.com/Inventory
Hello great Teacher. You suppose to start the blank tables in the pages because some have no knowledge. Please I want download the access file.
I don't start every video from a blank database because then I would be repeating A LOT of material for EVERY video. I always give links to the pre-requisite videos, so if you don't understand something, go back to those. In this case, here: 599cd.com/Blank. You can't go to med school until you finish pre-med. :)
Hi Richard,
I am running a macro that will export a query to an excel format and send it to my customer via email using Outlook. On the SendEmailObject, how can I make the "From" and "To" to read the email address from a table? Also, if I have multiple recipients, how can I add them all in the "To" field. Thank you.
Pretty sure I cover that here: 599cd.com/SendOutlookEmail
Thank you.
Hey Richard, I wanna ask you something. I set the criteria in the query as same as the orderID to print out 1 invoice. But how about printing multiple invoices? What should I put in the criteria in my query.
Coming up in a future TechHelp video
@@599CD thanks for replying Richard. I’ll be waiting
I've watched several videos and find them an excellent source of education to build my DB. I started a charity and have simple needs. A donor table, a donation table, and forms to enter data. I need to build report letters to send to donors. One is required when the donor makes a donation of $250 or more. The other one I want is to send a yearly summary of all donations for each donor. What videos should I review to accomplish this task?
Letter Writer: 599cd.com/LetterWriter
Such an informative video series. Thank you for creating them. Only issue I am having is when I go to look at my Order Invoice Report, it has a pop up window saying Enter Parameter Value. what did I do wrong? I can never put the same number in twice.
Likely something is spelled wrong. 599cd.com/EPV
Hey friend,
I'm watching you from Israel, you helped me a lot!
Is it possible to select products from another "Products" table? (Combo box)
Yep. That's covered in the Extended Cut for members. 599cd.com/Invoicing
Very nice
Hi Richard.
How can I lock n invoice after printed so I can't print it agin?
599cd.com/QQ
Great 👍,
Could you please tell me, how to select multiple orders into one invoice?
That will involve some VBA. 599cd.com/Developer
If I want the customer to see the OrderId, would it be better to make it a random # so that it would appear there are a lot of orders? Thx
Sure. Or do this: 599cd.com/Counter
Sir Do you have School Library management System?
Nope... but I get a lot of requests for that. Thinking of building one.
@@599CD I understand actually I need to present that system and I just wandered if you have one. I hope you can build one as majority of students has a final requirements on school library system. It will help us students if you made one. I always enjoy watching your video and I learned a lot. Though I couldnt afford to be a member though :) more videos to come Mister :)
Hi Richard. Richard here as well.
I struggling to get my database with products, orders and suppliers products to work properly. So I use one and the same table for the products, and that is being very messy. I want to know if there is a way that with a Combobox I can choose my or my suppliers' product and still use the same table. And show only the right fields for the right choice. and how to do that with VBA codes.
Thank you
In your product table you'd have a VendorID to indicate which supplier you purchase that product from. I cover this in my full lessons. 599cd.com/ACX7
Thank you.
Welcome
Hi, I'm using this tutorial of yours to create my invoicing database and hit a simple snag and can't figure it out. I started to create the invoice (order) query and the relationships between the OrderDetailQ and everything else does not exist, can you assist
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
Is there any reason to not put the extended price calculated field in the order details table? Why make a separate query just for that?
Use calculated query fields instead. Tables shouldn't contain calculations. 599cd.com/Evil
Nice video 😊,
Thanks 😊
Hey Man! Thanks for your videos! It does help me a lot.
Now. Do you have any video where could help my case?
My case: I have customers form different countries, so, my product details changes according to the buyer. For example, I have one number product with 3 different details. Thanks again!
Sure... but I would need to know specifics to tell you how best to handle it. Feel free to submit your question to 599cd.com/TH
Good work but how we can get party wise Running balance from journal entry
Check Register: 599cd.com/CheckRegTH
Hey I have been following and I am getting a OrderT.notes could refer to more than one table listed in the FROM clause of your sequel statement when trying to create the order invoice report.. please help
Sounds like you added OrderT.Notes twice.
Great video. Do you have tutorial for converting order into invoice or purchase order into invoice
In my full classes, yes. I'm going to continue building this into a more full-featured template and I will add the ability to create quotations and purchase orders.
Is there any way to make the forms available outside of Access? Perhaps hosted on a website or something? I want to have multiple people to be able to enter order info and print invoices at the same time.
Not with just Access. Please see: 599cd.com/AConWeb
Rich, your videos are very informative. My name Steve , I'm from Canada, a have a question, am working with 365 office 2019. when i write in my query ExtPrice: [Quantity] * [UnitPrice] my answer does not shown a $ sign. What am i doing wrong?
Format the query column as Currency. If that doesn't work, use the CCur function.
Is it possible to create form without a table.....
Sure. It's called an unbound form. It won't save any data though.
love YOU Man Thank you very much
Love you too, bro. You're welcome. :)
How do I add count number on the left side of the list for how many product has been ordered? eg: I received order for 38 product but before sending, I checked the list only have 34 product. rather than having to count from the list to know if anything missing, I prefer having number there. How do I do this? or how do i put a row count in a query?
599cd.com/RowNumber
For a blind individual you make it about as simple as possible however there’s a few things that would make it a little easier is if you could do a slight better job of describing what you’re clicking and where you’re clicking and if you’re also starting from a beginners level or which level and are you starting with a completely new aspect and building from scratch or are you starting in the middle of something I love what you got reach out to me I’d like to know if you got something I can help with those of us who are visually impaired
Hi James. Speaking as someone who is also partially blind (100% blind in one eye, and not that good in the other) I sympathize with what you're saying. As far as the "beginner" aspect of it, I make mention right in the beginning that this is NOT a beginner video. It has pre-requisites that explain a lot of the concepts that I skip over in this video. I can't cover EVERY topic EVERY time I record a new video.
@@599CD I am sorry I guess I missed the part where you said that there was a prerequisite video to this however when you start your video if you could just clearly say well I’m at this point for that point with starting a lesson then for people such as myself who are deeply impaired it would make it easier for us to know where you’re at such as I’m picking up from where we left off on the last video I have open XXX and I think a lot would be resolved an answer than that way once again thank you for what you do and I appreciate any and all help. Like you I am 100% blind in my left eye and I have 2200 version at best in my right eye.
A new unitprice could cause real trouble with invoices currently awaiting payments from customers, also viewing past invoices will be altered. Hope business owners will tread carefully "somehow" .. good lessons though.. 😊
That is, indeed, a valid concern... and I show how to deal with that properly in the Extended Cut and my Access Expert lessons. :)
Many thanks for your valuable information and topics!
Please I'd like to ask you about the Error No Run time 3044
My data base is splitted into BE&FE and if the network connection failed while using the MS access forms this error occure...
How can I check connection with BE and at any time when the FE not connected with BE I need to close the program or wait until re connect with BE or close DB ..
Please advise to handle this Error
Not familiar with that one. Try running down my Troubleshooter: 599cd.com/Trouble
Thanks for your reply and valuable reference, may i ask you with clarification can i check the connection validity between FE linked tables that bounded on a form ( already used as a recordset in a form) and the BE access file ? And if no network connection between FE and BE can I Handle error 3044?
Sorry for asking again but only to clarify more
Many thanks in advance
@@599CD an observation after extra search, this error not occure of I did not use "shift" bypass key while opening the db..
Then something in your code is causing the error. Again, I'm not familiar with this one, and without BEING THERE it's near impossible for me to troubleshoot. If you want further technical support see 599cd.com/Consulting
Very helpful
Glad you think so!
In my company I make many orders per customer with tables (Customer - Order - OrderDetails - Products) during the month, But at the end of the month I make one invoice with all orders made by specific customer. How to accomplish this in Access to be able to add existing orders in one invoice?
It sounds to me like you really want to have it so that you can put multiple orders on a single printed invoice or have a jobs table where you put job details in that, and then at the end of the month you invoice all jobs that have not been invoiced yet. That's a little bit more in-depth than I go into in my TechHelp videos, but I definitely cover something similar to this in my full course. Or optionally, you can just print out multiple invoices for them like I show here: 599cd.com/PrintMultipleInvoices.
If I select CURRENCY, then is it possible to select another sign in stead of a '$'. i.e. £ or € or ¥ or ₹
Currency Symbols: 599cd.com/CurrencySymbols
My OrderDetailF will not fill will all OrderDetails, only one record at a time, but the OrderDetailQ does list all records… Help?
Hi, can I build a database for customers that will book their appointment, and automatically send emails or texts for appointment confirmation, appointment cancelation, reminders etc?
Of course you can! :)
@@599CD Thank you. Can you show me how? What is your email?
I don't provide one-on-one training, but I have videos that cover all of this. Emails for example are in 599cd.com/EmailSeminar
@@599CD Thank you. I'll check it out. Update: I am not able to access the web page. Is there another web address or link?
can u add all invoice list button
that show all save invoice and edit then print
Sure... pretty much anything is possible.
Hey Richard!
I've been watching a lot of your videos cause I'm building a medical recordbase for a Vet clinic.
I'm having trouble deciding how my database is gonna store medial records. All our medical services fall under 3 basic cathegories; vaccinations, surgeries and consultations. Each type of visit requires different info to be stored, but also share a lot of fields (For example: On a surgery or consultation you might need a "Medication" field but you will not need it on a vaccination)
Should I;
-Have a dedicated table for each type of service and include all the details necessary for each visit on their designated table (Tho this makes them complicated to show all the medical entries together on a "medical record" form)
-Store it all in one table and leave empty values on each entry if they're not needed (depending on what service it is) and have a value define which form has to be opened if trying to view or edit that specific entry on the medical records form (That's how I have it currently)
-Have an "Entries" table that has that has the fields used in all visits (index to the patient, owner, medic responsible, date and service) and make "Vaccination" "Surgery" and "Consultation" tables, linking them together (For example: the "VaccinationID" to the "EntryID") so I can view the full info for the visit on a form using a query.
I have my patients in a table linked to their owners in another table. Which approach you think might be better on hardware space and performance?
Very good question. I don't know your field, so I'd have to say it's really up to you. I would definitely have an OwnerT table (for the human) and then a related PetT table (one-to-many from OwnerT). Probably a VisitT to log each visit (time, notes, etc.) in which you could put the data that's common to every visit and then maybe a separate table each for vaccinations, surgeries, and consultations and those link to the visit. You'd still be able to pull up a list of all vaccinations from the PetT because they're linked through VisitT. But again, this is something you'll have to decide as you know your business better than I do. As far as hardware space and performance goes, I don't think you'll have a problem with whatever you do here, as long as your database is properly normalized. Good luck!
If you want to email me over a list of all of the tables, fields, and such that you're thinking about including in your database, maybe I'll use this for a future TechHelp video. I've never done any kind of a veterinary database before. Did some medical billing back in the 90s but that was boring and I was just learning Access at the time. :)
amicron@gmail.com
@@599CD I'll follow your advice and go that way, if you want me to I can send you a copy of the file to check it out after the update. It already has some cool features, it can generate printable medical recipees with a button on the consultation form. A thing that I would like to add (since a lot of costumers ASK for a feature like this):
When you vaccinate a patient it needs to be revaccinated in one year (depends on the situation and vaccine but it's usually one year) and people ask if we could remind them with an Email or text since they forget. How could I make my access database send emails to costumers to alert them like 2 days before? This same principal could be applied to send Happy birthday cards too (without the "two days before" calculation)
How can I
get an accounting entry after saving invoice
I don't understand what you mean
Hello. I've watched several of your videos and i have to say, everything is great. I just wanna ask a question about orders and product forms in general. In case i have customer's information on the main form, and adding in the order all the products, in the sub form. Is there a way for xyz reason to cancel the order? I know that it might sounds simple, but when i add something in the sub form it is added automatically in the table data is bound doesn't it? How can we cancel this process and clear the table from the "temporary data"? Perhaps using temporary tables and if the order is placed then we insert it to the main table?
P.S. If this topic is covered in one of your videos , please let me know. Thanks again for the well made and well organised material you provide
If the customer cancels the order, you can either delete it or somehow mark it canceled (y/n field). In the Extended Cut for members, I show how you can mark an order either as an Invoice or a Quotation. If it's a quotation it's not something the customer is expected to pay for (i.e. don't list it on your accounts receivable).
is it possible to add a watermark and footers in the invoice?
Sure. Put an image in the Report Footer.
Is there anywhere we can download this fantastic app
Yep. Says so right in the video: 599cd.com/Invoicing
Why doesn't an image in the PageHeader print on reports? It shows up on print preview but when I print, the image does not show up.
It should. Try a different image. Try a different report.
Is there a way to auto convert the final total of the invoice into words. i.e. if the final total is $3300.00 then the amount is also mentioned in words Three thousand three hundred.
Yep. I cover that in a bunch of my classes, and there's a function to do it in my Code Vault. 599cd.com/search/?Q=english
Please any solution when i chang any product rate its changed in all previus invoices
Sounds like you need an update query. 599cd.com/UpdateQuery
Hii Rick it’s was nice video
I use in my company invoice I got some problem with while typing invoice it’s was blocked and can’t open it’s says some primary key or something
So I started typing bills in tabelle directly ther also the + symbol to opne and type bill but it’s vanish how to get it back help me out
I'd suggest starting with a fresh copy of my template.
I followed the same steps. But when I want to print the invoice of a specific customer, it contains all customers' items. How can I print the invoice of a selected customer? Thanks
Follow the instructions again, carefully.
@@599CD Thanks for the guidance, I found the part I had missed.
Sir I’m just hoping you might see this message, i’ve follow this wonderful template for our invoice processing in our office, but i end up with errors in sharing for multiple users after splitted the files with the backend file resides in the server, hope you can give me an advise what the best solution to eliminate this error cannot open the file “FILE ALREADY IN USE”.
It allows only one user to use the file, please help me and also the rest of my database has the same problem now. Error mssg. Couldn’t use file already in use.
599cd.com/TFIX
Thanks Sir.
Welcome!