Hello, please can you help me out on how to correct the error of "Subscript out of range " ? This occurred at the final stage of importing customer record in the tblCustomers..
I am in the midst of your course and just wanted to say how much it has helped me to understand Access. It has been a wonderful experience. You are an excellent instructor.
For the SUBSCRIPT OUT OF RANGE error when creating "tblCustomers" at 1:13:15, simply keep moving in the course. Right after this problem occurs, the course teaches how to work around this problem at 1:14:25 - 1:17:40 while teaching how to import source data into a new table. For now, go ahead and delete your current "tblCustomers" table (Right Click, Delete) - you're going to make a new one. Use the steps taught at 1:14:25 - 1:17:40 to create a new "tblCustomers" table. Next, go back to 49:18 - 56:19 to recapture how we formatted the Field Properties in Design View. Modify your new "tblCustomers" Field Properties to match the old one that was deleted.
I am up to the end of this wonderful lesson (thank you very much!) and... @5:20:51 ~ I don't know if anyone else ran up on this, however; I found that I needed to add an Else Statement to the IF Macro in order for the Employee cbo to be Visible if the Active control were checked. If [Active]=False Then SetValue Item=[Employee].[Visible] = No Else SetValue Item=[Employee].[Visible] = Yes End If
Thanks a lot for the effort you put into this. I've been working in excel but was asked to build a simple db for a brother's elementary school so I had to take this refresher course. I've made one observation that is perhaps because I'm working in Access 2016. When the password code is attached to the load event, after entering no/wrong password, the form loads anyway after showing the dialogue boxes. To fix this, I attached the code to the Form Open event instead and when the right password isn't entered, right before "exit sub", I added "Cancel = true" and that worked. I hope it helps someone else.
Thank you so much, your expert knowledge in Access makes it essay for me to understand the tasks, your explanations are wonderful. Thanks again God bless.
Subscript out of range error is shown because the data type in the Excel file and the access database is not the same. Import the data into a new table and edit accordingly.
Dear Trish. I can't thank you enough for this genius course. it really helped me alot . but i'm having this issue in Module 5 Lesson 5 when I enter the incorrect password, and ok , it takes me into the emplyoyee form and does not take me out of the form, so if you please could you give me a hand on that.
Good afternoon. For example, I have 100 entries in the "table". A question: 1) How to create an automatic numbering in the table, starting from number 001 (this field with the number will be a key) 2) If, for example, I delete line 63, then the numbering should be updated (auto -missing).
3:56 I remember you made a change in the query and it reflected in the table, like you changed last name to Foresst and it also changed in table......now you're saying that those were just select queries and didn't change table
5:48 Didn't understand the concept of FE and BE database...the access to the tables that we need to give to end users is in FE or BE? If in FE then, then how will the further development or changes will be done by DBA in the FE since it's uneditable (you said further development to be done on FE DB)
Module 4 issue with qryCustomerByName not pulling the Jazzy Jazz Cafe may have something to do with the Active & Employee fields being blank- does the same with Milton’s Restaurant and Eastern Eardrums, regardless of whether you enter a partial or full name - doesn’t make sense, but that is the common denominator 🤔
@@Saad-Sadiq Thank you for the response. Per my response, I was able to figure this out. However, the trainer (Trish Connor-Cato) indicated in the video that she did not know why it did not pull the Jazzy Jazz Cafe when the partial company name was queried… which is concerning when someone, like myself, is attempting to learn a program and the instructor cannot explain or correct when unexpected results &/or errors are encountered.
1:55 we could change the data type from shot text to number, even if the table had data, why it didn't give the error this like we got an error in previous sections where we added new field, assigned required data type and deleted the original field?
Hi Trish, I am now on 1:57. I did type the CustomerID numbers. I was just wondering if I have to do this without help, I am sure you are using the CustomerID numbers from the Customers Table. As a point of clarity, I have noticed that although there are 16 Customers not all CustomerID numbers were used. What could be the reason for that?
During my practice, I got to importing the customers record into the table, on my final click(Finish), I got an error which states that 'Subscript out of range' How do I correct this?
I created a data base and I tried to enter a new record and I couldn’t. I got the this error “Cannot add record(s); join key of table ‘MemberInfoTbl’ not in recordset.” I went to my table and I noticed the primary and foreign key I originally established were deleted. I closed the table and re-open them and the keys showed up. Can you assist?
I have recently found this tutorial and found it very well documented, but I do have an issue in Module 5 Lesson 5 the vba code to the employee form, I have done this several time and when I enter the incorrect password, and ok , it takes me into the emplyoyee form any and does not take me out of the form, I have download all the exercise files 5 times, and have run with no debug box, just wrong password and back to employee form ???? thoughts, ideas??
would you please tell me how relationship is done between employee and customer table , however employeeid is number and employee in customer table is text ?!!
Hi! When I try to import data into the "tblCustomers" table, I get a "Subscript out of range" message dialog box? I only get the option to click "OK" and I'm back at the Import Spreadsheet Wizard final screen again...😞 Help!!..Thanks!
@@thomastommy9864I have done Dan's 4 video series and trust me, it's the best access tutorial u can find in the entire world. Am also here to get a tip or two of which am really grateful for coz they're free. God bless learnit institution
I have restarted this course about 6 times to make sure that I have not done something wrong. I keep on getting the same error as soon as I do the lookup. I decided to go back, re-create tblOrders and tblCustomers and not do the step where I put the numbers on the data sheet manually, but change the CustomerID on tblOrders to NUMBER and not SHORT TEXT. I did not do the lookup, but the Customer names still did not show on tblOrders Data sheet. I noticed a down arrow on each record and if noticed if I open it, I can select the Customer names one -by -one. This worked perfectly, I have all the Customer Names in tblOrders. The only problem I see so far is that there is 16 records with Customer Names in, but from record 17 to record 30 is blank records. I do not want to delete these blank records, because it might delete them forever and start the next record with 31.
Exercise Files: learnitanytime.com/p/exercise-files-access-2021-full-course-tutorial
Hello, please can you help me out on how to correct the error of "Subscript out of range " ?
This occurred at the final stage of importing customer record in the tblCustomers..
@@AckahErzane Read my comment.
Thank you Trish for putting efforts to make things easy to understand!! It is helpful :-)
😮😊 8:44
9:27 9:29
I do not know how to thank you for this wonderful, easy and tidy academic work...... Thank you from the bottom of my heart.
Thank you for your continued support Ezz!
I am in the midst of your course and just wanted to say how much it has helped me to understand Access. It has been a wonderful experience. You are an excellent instructor.
Wow, thank you!
What a clear & smooth speaking, you are the best teacher. Course structure and teaching style is very good.
Thanks!
For the SUBSCRIPT OUT OF RANGE error when creating "tblCustomers" at 1:13:15, simply keep moving in the course. Right after this problem occurs, the course teaches how to work around this problem at 1:14:25 - 1:17:40 while teaching how to import source data into a new table. For now, go ahead and delete your current "tblCustomers" table (Right Click, Delete) - you're going to make a new one. Use the steps taught at 1:14:25 - 1:17:40 to create a new "tblCustomers" table. Next, go back to 49:18 - 56:19 to recapture how we formatted the Field Properties in Design View. Modify your new "tblCustomers" Field Properties to match the old one that was deleted.
Awesome tip!
Except that you can't change CustomerID to AutoNumber
I know I could find answer to this problem on the comment section. Many thanks!
@@raquelamarins2249 1:25:26 explains how to fix AutoNumber
I experienced same issue just now. I'm just starting in the course. Thanks.
Best course on access i have seen on RUclips
So many thanks for this MS Access tutorial. Very helpful, clear and detailed in its presentation. I learned a lot from it.
You are welcome!
I am up to the end of this wonderful lesson (thank you very much!) and...
@5:20:51 ~ I don't know if anyone else ran up on this, however; I found that I needed to add an Else Statement to the IF Macro in order for the Employee cbo to be Visible if the Active control were checked.
If [Active]=False Then
SetValue Item=[Employee].[Visible] = No
Else
SetValue Item=[Employee].[Visible] = Yes
End If
Thanks for the great tip!
Thanks a lot for the effort you put into this. I've been working in excel but was asked to build a simple db for a brother's elementary school so I had to take this refresher course.
I've made one observation that is perhaps because I'm working in Access 2016. When the password code is attached to the load event, after entering no/wrong password, the form loads anyway after showing the dialogue boxes.
To fix this, I attached the code to the Form Open event instead and when the right password isn't entered, right before "exit sub", I added "Cancel = true" and that worked. I hope it helps someone else.
Thank you for the notes and we are glad you learned so much!
Wow where was this video two months ago for my exam. Very detailed 👌
Hope it helps!
This is a wonderful course. Thank you!
You are welcome!
Thank you so much, your expert knowledge in Access makes it essay for me to understand the tasks, your explanations are wonderful. Thanks again God bless.
You are very welcome!
Subscript out of range error is shown because the data type in the Excel file and the access database is not the same. Import the data into a new table and edit accordingly.
👍👍👍
Dear Trish. I can't thank you enough for this genius course. it really helped me alot . but i'm having this issue in Module 5 Lesson 5 when I enter the incorrect password, and ok , it takes me into the emplyoyee form and does not take me out of the form, so if you please could you give me a hand on that.
Good afternoon. For example, I have 100 entries in the "table". A question:
1) How to create an automatic numbering in the table, starting from number 001 (this field with the number will be a key)
2) If, for example, I delete line 63, then the numbering should be updated (auto -missing).
Hello Yevgeniy! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@@LearnitTraining Any free community to join?
3:56 I remember you made a change in the query and it reflected in the table, like you changed last name to Foresst and it also changed in table......now you're saying that those were just select queries and didn't change table
This is a wonderful course. Thank you!
You are very welcome!
5:48 Didn't understand the concept of FE and BE database...the access to the tables that we need to give to end users is in FE or BE?
If in FE then, then how will the further development or changes will be done by DBA in the FE since it's uneditable (you said further development to be done on FE DB)
Tx for clear instructions.
You are welcome!
many thanks to you, it is a great course
You are welcome!
5:40 Can we create 2 different VBA codes or event on the same form?
Here, I think multiple conditions VBA got replaced by single condition VBA, right?
thanks very much for this great help through this video.................
Glad it helped
Just started this course, my templates show 2 Northwind templates (Starter & Developer) which one should I select to follow this course?
At 2:09 Why we converted the data into category id as numbers first and then names of category, when originally it was showing names good?
Excellent course, well presented by knowledgeable tutor
Glad you liked it!
4:06:49 We don't save the changes in case of update?
Then did the change reflect in the query?
5:27 what did you press to save the record and have the new blank form displayed again?
You're an amazing teacher! I can't believe this is free.
Thank you! 😃
Module 4 issue with qryCustomerByName not pulling the Jazzy Jazz Cafe may have something to do with the Active & Employee fields being blank- does the same with Milton’s Restaurant and Eastern Eardrums, regardless of whether you enter a partial or full name - doesn’t make sense, but that is the common denominator 🤔
Correct the query shows only the companies where employee field is populated. You can confirm this by removing full name column.
@@Saad-Sadiq Thank you for the response. Per my response, I was able to figure this out. However, the trainer (Trish Connor-Cato) indicated in the video that she did not know why it did not pull the Jazzy Jazz Cafe when the partial company name was queried… which is concerning when someone, like myself, is attempting to learn a program and the instructor cannot explain or correct when unexpected results &/or errors are encountered.
In actual use how do we write the VBA code or even retain it in mind?
Really well explained. Thank you
Glad it was helpful!
Thanks alot for useful video
You are welcome
Thanks a lot :) Your videos are so helpful to me
You are welcome!
Good Day, Could you kindly tell me how you get your mouse cursor to make the arrows. It is very useful.
That is Zoomit! A free program
@@LearnitTraining Thank you very much. Currently I am enjoying your tutorial. Have you got something similar for MySql or Sql perhaps?
1:55 we could change the data type from shot text to number, even if the table had data, why it didn't give the error this like we got an error in previous sections where we added new field, assigned required data type and deleted the original field?
Thanks for the lesson
Our pleasure!
Hi! at 1:13:15 when I want to import the Customers I get an error message saying Subscript out of range. What could be the issue?
Hi Trish, I am now on 1:57. I did type the CustomerID numbers. I was just wondering if I have to do this without help, I am sure you are using the CustomerID numbers from the Customers Table. As a point of clarity, I have noticed that although there are 16 Customers not all CustomerID numbers were used. What could be the reason for that?
Very informative video about MS Access, I need to learn it. Thanks 👍
You are welcome!
During my practice, I got to importing the customers record into the table, on my final click(Finish), I got an error which states that 'Subscript out of range'
How do I correct this?
Hello Krist! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Same with me...did you found the solution?
I created a data base and I tried to enter a new record and I couldn’t. I got the this error “Cannot add record(s); join key of table ‘MemberInfoTbl’ not in recordset.” I went to my table and I noticed the primary and foreign key I originally established were deleted. I closed the table and re-open them and the keys showed up. Can you assist?
Hello Oscar! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I have recently found this tutorial and found it very well documented, but I do have an issue in Module 5 Lesson 5 the vba code to the employee form, I have done this several time and when I enter the incorrect password, and ok , it takes me into the emplyoyee form any and does not take me out of the form, I have download all the exercise files 5 times, and have run with no debug box, just wrong password and back to employee form ???? thoughts, ideas??
Hello Alan! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Hello @alan9171 ! I'm having the same problem here ! Have you found a solution ? Thanks a lot
Same problem. did anyone found a solution ?
timestamp 1:29:31
👍👍
Keep it up 👍
We will!
would you please tell me how relationship is done between employee and customer table , however employeeid is number and employee in customer table is text ?!!
Hello weasam alaa! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Hello deyer happy New year 🎉
Happy New Year!
how can i import emails from outlook with the attachment?
Hello Zsuzsko! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Hi! When I try to import data into the "tblCustomers" table, I get a "Subscript out of range" message dialog box? I only get the option to click "OK" and I'm back at the Import Spreadsheet Wizard final screen again...😞 Help!!..Thanks!
Same error as I'm currently facing..
I'm currently doing manual data entry of that section, but I wish LearnIt will help us out
I am Readying watching in 6 hours 3 hours Just now 3 hours Tomorrow
We hope you learn a lot!
thank you very much.
You are very welcome!
The only reason this is easy to follow along is because it was made recently.
Thanks
Check out Dan McAllister's 2016 Access tutorials from LearnIt Training. I had no problems going through every module step by step.
@@thomastommy9864I have done Dan's 4 video series and trust me, it's the best access tutorial u can find in the entire world. Am also here to get a tip or two of which am really grateful for coz they're free. God bless learnit institution
Excellent mam
Thanks!
Well done
Thanks!
You do not really give some assistance. You only reply when you get a compliment, not when I for one has a problem/error in your course
Hello Kobus! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@@LearnitTraining Thank You
@@LearnitTraining No help from there either
I have restarted this course about 6 times to make sure that I have not done something wrong. I keep on getting the same error as soon as I do the lookup. I decided to go back, re-create tblOrders and tblCustomers and not do the step where I put the numbers on the data sheet manually, but change the CustomerID on tblOrders to NUMBER and not SHORT TEXT. I did not do the lookup, but the Customer names still did not show on tblOrders Data sheet. I noticed a down arrow on each record and if noticed if I open it, I can select the Customer names one -by -one. This worked perfectly, I have all the Customer Names in tblOrders.
The only problem I see so far is that there is 16 records with Customer Names in, but from record 17 to record 30 is blank records. I do not want to delete these blank records, because it might delete them forever and start the next record with 31.
Brilliant
Thank you!
❤
❤
in this class they think that one can do anything on our own. thats not true.
03:03 Report in design view is okay, but how to put current date and time on the report header?