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
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.
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
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/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
Your explanations are detailed, that helps me understand well.
this was explained so well, this is very helpful. thanks
Thanks Guruji ( An Indian respective word for a great teacher!) :)
“I’d be nothing, nothing , nothing with out you”
Never seen a better explanation.woow..thank u
I'm glad it helped :)
Very understandable and informative
sir you are saving my life. Thank you so much
Glad you find the videos helpful!
the goat 🐐 thanks a lot man
Wow i can do it now I've been struggling in class thank you sir 🥳
Awesome. Always happy to help!
ALL WORKING THANK YOU SOOOOOO MUCH BRO LOVE YOU PROFESSIONAL UNLIMITED ALL WORKING WELLL
a life saver mate
Thanks it's a good lesson
Thank you Mr Long
drake is that U?
Very informative, Thanks
You're the best❤
Thank you sir🙏
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
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
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
hayee Allah g
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 :)