Hi, I'm from Brazil and I'm subscribed to your channel. I like the content, because I am learning Delphi. I would like to know if it is true that Access has limitations on the amount of data inserted in the database. This is true? Is it possible to solve this? Thank you!
Hi. Access has a limitation of storing 2 GB of data, which is quite a lot of data. Not much to get around it. You can make your field sizes of your text fields smaller, and use smaller number formats to conserve space. Other option is to use different database software if you want more than 2 GB of data space.
Hi, I might sound crazy, but I had to set up another Database recently which I hadn't done for a while. I created the Form that I wanted. To save any change I clicked on the Save Icon at the top left of the Form page. The problem is that it saved a duplicate page everytime!! I now have a lot of duplicates in the Form which I have no idea how to get rid of. Please can you help get rid of the duplicates and let me know what I am doing wrong. Many thanks. Gordon
Is there a way to have calculated field that tells me the number of days that have passed since a reference date? For examples, I want to make sure that no projects are older than 60 days. If I have a field that has the date the project was submitted, is there a formula to have it tell me how many days old the project is?
If you subtract two dates the answer will be the number of days between the two dates. So you can use the Date() function to get the current date. For example: = DATE() - [DateSumitted] Assuming the field DateSUbmitted is the project date then you can make the criteria for the calculated field to be
Check out our exam paper walkthroughs for CAT. Question 5 is normally the Access database question. Data files can be downloaded using the links in the description.
@@MrLongITandCAT I would like to share your Access Queries videos with my class, but there is no link to the data in the description. Could you help me locate the dataset that you are using in these videos, please? Thank you
![[LIVE] : ONE ลุมพินี 82 วันนี้!! คู่เอก | ยอดไอคิว vs อับดัลลาห์](http://i.ytimg.com/vi/hSsyTl_9bqs/mqdefault.jpg)
MR Long coming in clutch for my finals
As a Grade 12 student, this helped me so much. Thank you
True😭i feel ready for finals
@@Nique-Reacts This is honestly saving my grade😭
We Writing today in 8 hrs
“I’d be nothing, nothing , nothing with out you”
this was explained so well, this is very helpful. thanks
Thanks Guruji ( An Indian respective word for a great teacher!) :)
sir you are saving my life. Thank you so much
Glad you find the videos helpful!
Never seen a better explanation.woow..thank u
I'm glad it helped :)
Very understandable and informative
Thanks it's a good lesson
ALL WORKING THANK YOU SOOOOOO MUCH BRO LOVE YOU PROFESSIONAL UNLIMITED ALL WORKING WELLL
the goat 🐐 thanks a lot man
Hi, I'm from Brazil and I'm subscribed to your channel.
I like the content, because I am learning Delphi.
I would like to know if it is true that Access has limitations on the amount of data inserted in the database.
This is true? Is it possible to solve this?
Thank you!
Hi. Access has a limitation of storing 2 GB of data, which is quite a lot of data. Not much to get around it. You can make your field sizes of your text fields smaller, and use smaller number formats to conserve space. Other option is to use different database software if you want more than 2 GB of data space.
@@MrLongITandCAT i think he upload lots of aatachment in db, it's better to save attachments on a folder and use hyperlink
a life saver mate
Very informative, Thanks
Could you help me locate the dataset that you are using, please? I cannot find a link to the dataset in the description. Thank you.
Hi,
I might sound crazy, but I had to set up another Database recently which I hadn't done for a while.
I created the Form that I wanted.
To save any change I clicked on the Save Icon at the top left of the Form page.
The problem is that it saved a duplicate page everytime!!
I now have a lot of duplicates in the Form which I have no idea how to get rid of.
Please can you help get rid of the duplicates and let me know what I am doing wrong.
Many thanks. Gordon
You're the best❤
Is there a way to have calculated field that tells me the number of days that have passed since a reference date? For examples, I want to make sure that no projects are older than 60 days. If I have a field that has the date the project was submitted, is there a formula to have it tell me how many days old the project is?
If you subtract two dates the answer will be the number of days between the two dates. So you can use the Date() function to get the current date. For example: = DATE() - [DateSumitted]
Assuming the field DateSUbmitted is the project date then you can make the criteria for the calculated field to be
I need data to practice.
Check out our exam paper walkthroughs for CAT. Question 5 is normally the Access database question. Data files can be downloaded using the links in the description.
@@MrLongITandCAT I would like to share your Access Queries videos with my class, but there is no link to the data in the description. Could you help me locate the dataset that you are using in these videos, please? Thank you
Are you South African?
Yes :)
hayee Allah g