Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: ru-vid.com/show-UCeXAUvo5xxDY_b-lSknPC1A
This series has been extremely valuable to me! The way that you start with tables and relationships first and not forms is, I think, very important for getting those fundamentals right - for my first project I was trying to cover bad database knowledge with mediocre programming knowledge and the results were not amazing. This is helping me go back and clean up that mess.
Hi Steve. Amazing work you're doing here, much appreciated. Just a note regarding this, another way of doing this (correct me if I'm wrong) seems to be as follows: 1- Put the field (text) we want to show first column of the query, and have the ID in another column (in data tab) 2- Specify the bound column number to the ID column (in data tab) 3- Set column count=1 (in format tab)
Following this course ahead of the Access2016 one (which I use) but this is a great grounding in relational databases. I love your teaching style and approach, very easy to follow and a great refresher for someone who dabbled in MSAccess many years ago. This lesson on coding drop-down combo boxes was a light bulb moment for me. Thank you so much!
Thank you very much! My teacher doesn't explain anything so i watch your videos to sort it out by myself. And your explanations on everything is so clear, so that i can get it even if english is not my native language
Oh my god, I just noticed, you earn way more views and likes man! Your tutorials are awesome! I'm going to learn vba soon on my school and I'm using your tutorials to start preparing ;) I want to thank you so much for making these video's. New sub ;)
Hey so one thing I have noticed cause I'm using this as a refresher.. You do not need to close forms/tables/queries... just hit the refresh all button in the Home tab.
Hi Steve, thanks these videos, they're great. I've a question. When through the steps and noticed my form and queries is not updateable. Do you've any ideas why this happening?
Hello Steve-- your tutorials are great and thank you I am really battling with this lesson. I cant get my mind around the addresstype section. (I am working on this alone so I dont have access to anyone to debate with) I cant get my mind around the relationship between qrycustomeraddresses and tbl2addresstypes. I think I have been working on this problem to long and have developed a mental block. Do you perhaps have the instructions expressed in a different way? I can see the mechanics of the code by7 the logic eludes me. Please help fred
QUICK QUESTION: I wanted the text in my combo box to be center aligned. While the text in the box was easily centered, the drop down list was left aligned. I went back to the source table, changed the alignment there & wallah, it worked! However, other formatting doesn't work like; color, font type, bold, italics etc... Is it possible to make the [text properties of the drop down list] different from [the text properties of the box itself]? I'm sure it's possible with code, but is their an easier way?
Hello Steve-- My previous comment refers I think I have got a bit closer to my particular problem. What are we actually expecting this combobox to do? I cant figure out the purpose of this combobox?? regards fred
Hi, I have been watching your videos to learn Access 2013. Its been great till here I have watched. Thanks for the videos. I have a query here in this video. At 1:00 in the video when you changed office to ship to all entries fields changed but when 10:13 in the video when you selected bill to from dropdown why all entries fields didnt change like what had happened at 01:00 ?? I know you changed the text box to combo box but ultimately that field is updating, earlier it was through typing in text box and now by selecting the option from combox box but still the table is linked so all entries fields should update why that didnt happen ??
hello Steve, I like your method very much, I'm accountant and I want to learn programming and I started with your play list programming in access, but I discovered that I need to know the base and how to think in programming. I don't know the logic and I want to know what should I learn at the beginning, please tell me.
Programming ، I watched almost of Microsoft access 2013 till the 38th session but I discovered that I need to know more basic about programming to understand how to think , s I started watching your series of C#, is that recommended for me?
Steve, Your tutorials are amazing and really useful. Thank you for sharing these videos. I do have a question. I am trying to add "After Update" event to "Tab Control" between 2 tabs. So for example, I have "Inventory#" textbox on Page1(InvForm) and "Status" combobox on Page2(StatusForm). I was trying to use macro for the "After Update" event. my expression was Forms!InvStatusform!status="requested" and isnull(forms!invStatusform!Inventory#) then msgbox ..... Needles to say it doesnt work. I tried instead changing the expression, instead of InvStatusform to InvForm and StatusForm, and I also tried moving combobox from StatusForm to InvForm but that didnt work as well. Do you have any tips? Thank you
Hi. I'm trying to do the same thing, but I get error that I can't change record due to primary key duplicate. I have similar setup where I have tblVendors, tblNegotiations and tables connected by Vendor_ID. Then I run query to show info from both tables. It has dropdown list reference to tblVendors. So when I create form and use query as reference, somehow I think record is being changed to tblVendors instead of tblNegotiations. Hope it's not too confusing.
Hi Steve, I have a question. I am able to see the data for address types here in my work, however not able to update and then see my updated data table. It is not happening. Kindly point out the issue.
Like JSUPRR, I get the same error when I try and make changes in Form View. I'm using Access 2007 (the best we have at the office) and wonder if that might be the problem? I downloaded the work file and compared all the properties for the Address Type text box and the form and they seemed the same. I'm just going to use your files and proceed from there. Thanks!
I noticed in your work files the record source is tbl1Addresses instead of the query. I am wondering if because I built if off of the query it will not allow me to update.
Maybe you covered this somewhere and I missed it but I'm curious as to how to select more than one value in a combo box or list? So for instance if I have a table for names of events that my church is having throughout the year, how do I select multiple events within a form? The events are in a separate table as I would like to add new events throughout the year. I hope this makes sense.
If I interpreted your problem correctly, I think I ran into the same issue. I downloaded his files and compared them to mine. I sure hope you haven't spent the last 6 months trying to figure this out. However, if someone else is running into this, here's a potential solution. Try going to your qryCustomerAddresses and turning OFF the "Total" option (i.e. remove the "Sort by") by going to the tool bar Design > Show/Hide > Totals. Try that.
I'm using MS Office 2013 I run into the same issue by following the video, it seems if you choose "change to" combo box, the combo box wizard wont show up and by adding data source under "data" tab wouldn't really add the data source.
Hello Ray, Thanks for sharing your experience. Actually that was causing the problem and when i removed the Total... the whole steps worked very fine.... May Thanks.. Regards..
I THINK I NEED A HELP HERE. I ACTUALLY NEED TO CREATE A SOFTWARE THAT WILL COLLECT INFORMATION OF SUBSCRIBERS TO A PRODUCT. I ACTUALL CREATED TABLES WITHOUT ENTRY ANY DATA, AND NOW I HAVE CREATED THE FORMS I NEED BUT, MY PROBLEM IS HOW DO I CONNECT THE FORM TO THE QUERY SUCH THAT IF I ENTER DATA IT AUTOMATICALLY REFLECTS IN THE QUERY OR TABLE
Thanks for this video. I made the form just fine. However, whenever I try to change something in view mode, it beeps and says "This recordset is not updateable." I can't change anything in the form. Anyone know why I get this error?
If I interpreted your problem correctly, I think I ran into the same issue. I downloaded his files and compared them to mine. I sure hope you haven't spent the last 1 year trying to figure this out. However, if someone else is running into this, here's a potential solution. Try going to your qryCustomerAddresses and turning OFF the "Total" option (i.e. remove the "Sort by") by going to the tool bar Design > Show/Hide > Totals. Try that.