Edcelle, Wow so pleased I found your channel. Since I retired (2009) and during Lockdown in UK I have been learning Access by watching UA-cam. The one thing I have been trying to do is save the file automatically using a button. So my sincere Thanks for you well presented video. Kindest Regards Stewart 👍👏
this video was exactly what I needed thank you SO much. Any chance you can make another video on how to create a macro that opens this form to “click” this button? I’m not familiar with the coding side of access. So when I create a macro attempting to do this (not using VBA code) I think it’s causing an issue and it needs a macro created using VBA code
Excellent video! I presume that the "A" integer returns the "state" of the copy (i.e. successful or not)? Can you then use this "state" to give the user feedback?
Hi, thanks for this video tutorial. Is it possible to keep only last five days backup, I mean is there any way to auto delete everyday backup after 5th day ?
Thanks bro, But when you quit app there will be one copy of the file how can i change the format of the copied file by time and date so each time i close the app i want it to copy a backup file of that time.
I a week or almost two weeks ago asked a question, but I didnt get the answer. The question was, Filter by option group in navigation control doesnt work. Hope you will give me the answer.
Sir Edcelle Good day po. Bakit po pag nag lagay ako ng page 3 sa TAB FORM hindi nakikita sa Form View ang laman ng page 3. Pero sa Design View naman nakikita sya. Ano po kaya ang mali ko dun. Pa sagot naman po. Maraming salamat
Thank you, I'll use this code to create a Backup button in my database. You're very talented and young!
🇲🇹
Thanks for watching man. It's highly appreciated.
Edcelle, Wow so pleased I found your channel. Since I retired (2009) and during Lockdown in UK I have been learning Access by watching UA-cam. The one thing I have been trying to do is save the file automatically using a button. So my sincere Thanks for you well presented video. Kindest Regards Stewart 👍👏
Thank you so much for watching my videos Stewart. I'm glad that my video helps you.
Once again thank you so much.
@@EdcelleJohnGulfan Followed your coding and so pleased as it works just great 👍
Thanks it helps.
Just what i was looking for - thank you
Thanks also for watching.
this video was exactly what I needed thank you SO much.
Any chance you can make another video on how to create a macro that opens this form to “click” this button?
I’m not familiar with the coding side of access. So when I create a macro attempting to do this (not using VBA code) I think it’s causing an issue and it needs a macro created using VBA code
Excellent video! I presume that the "A" integer returns the "state" of the copy (i.e. successful or not)? Can you then use this "state" to give the user feedback?
This is great....can you do one that does the same thing for a SQL back end?
I'll try that.
Thanks for Reply. Have you made any Video on timing Backup??
Not yet but I'm doing that in my projects.
Great work!!
could please make this same to backup Database only, I mean not with forms
Thanks for you, i subscribed and liked
Thanks for it
Nice help full video.
But How to make Timing auto Backup. For exp I set 3:00 pm automatic back up on 3:00 ??
You can use ON TIMER EVENT.
But make sure the database is ACTIVE.
Thanks for the question
Hi, thanks for this video tutorial. Is it possible to keep only last five days backup, I mean is there any way to auto delete everyday backup after 5th day ?
Yes. Kill function
Thanks for the video... Gaubra ko og employee data base sa among lgu, hope u can help po.. thanks
Pwede.
Excellent 👍🎉
Good.thank.
Thank you too.
Ciao Edcell, si può eseguire il backup anche se ci sono degli utenti collegati?
Yes Sir. No issue.
Great, Thank you
Thanks for watching Ruedi.
Thanks bro,
But when you quit app there will be one copy of the file how can i change the format of the copied file by time and date so each time i close the app i want it to copy a backup file of that time.
Hi. Sorry for late reply.
For the Target. You can change the code into like this...
TARGET: Target & format (Now(), " hh-mm-mmm-yyyy) & ".accdb
I a week or almost two weeks ago asked a question, but I didnt get the answer.
The question was, Filter by option group in navigation control doesnt work. Hope you will give me the answer.
Sorry for that. Honestly, I can't read all the comments. Thanks for telling me now.
Can you just tell me your concern here about option group?
Broo...... is it work on split database ?
Yes, but instead the path of front end, you should type the path of backend so that the back end will be copied.
@@EdcelleJohnGulfan OK.... I'll try that.... thanks for your answer......
Sir Edcelle Good day po. Bakit po pag nag lagay ako ng page 3 sa TAB FORM hindi nakikita sa Form View ang laman ng page 3. Pero sa Design View naman nakikita sya. Ano po kaya ang mali ko dun. Pa sagot naman po. Maraming salamat
Hi sorry for late reply. ngayon ko lang nabasa.
baka po sa format. yung VISIBLE ay naka NO.
Paano po kung ung path eh mag oopen kung saan mo sya ibaback up. Possible po ba un
E.type mo lang sa path ang location na gusto mo doon e.save.
Sample sa Drive C.
Path = "C:\Back Up Database"
Sino po kaya makakasagot sa tanong ko. Pasuyo naman po. PLs
sir paano kung ilipat ung back up file sa ibang location
Change the PATH Sir.
Sample ilipat sa Drive C.
Path = "C:\Database Back Up"
Make sure that folder name is exist in drive C.