Search results

I replaced the refresh code with Recalc & it refreshes the text boxes Thank you moke & theDBguy!!

Thank you moke123, I haven't, I am still learning with access & I haven't ever used that before There are ID fields on both the employee table (main form) & on the employee leave dates (subform). The text boxes on the main form count down how many "Paid Holiday" days & "Bank Holiday" days are...

Thanks for the reply theDBguy, how would you make it remember with code?

[SOLVED] Refreshing only certain fields on a form after a subform has been updated Hi all, I've been attempting to modify the database that was originally posted here https://www.access-programmers.co.uk/forums/showthread.php?t=176891 Code is added so the main form refreshes after the reason...

Thank you for your help Gasman

Sorry for bumping an old thread but the vacation tracker part of the testing database in post 10 by Scooterbug should help me with something I have been asked to create. One thing I noticed when testing it is that the subform for vacation days runs showing all of the staff members days off...

I've already spoke to her about that, she is going to make regular backups on her home laptop :)

She is the only one using it so she can deal without it being split & it won't make any difference to her

It's all working so thank you all for your help, there are other things I need to suss out & learn how to do on all my databases but I'll save that for another day

I am still learning vba_php :D I added the below from the old code I was using Exit_Button_Backup: DoCmd.Quit I guess Exit_Button_Backup: isn't needed? Edit I just tested it, not needed :rolleyes:

Thank you @Gasman I will have to try that one too. I'm not sure any of the codes shared will help with the backend issue though & I'm worried she will split the database on her USB drive when it is in her laptop & it won't open when she uses it in her work PC. @vba_php 's code works really...

Thank you for that code, I've just tested it & it can back up an un-split database as well which even though I have learnt that you should split a database but I think she is going to get an error, I could use that code on her database & try to edit it so it shuts the database down after the...

Thank you for your reply @theDBguy I will have to give your code a try, I think there will still be a problem with the database being split, if it doesn't work once I have split it while it is on my USB & named the same with the same drive letter & put it on hers do you think it will make a...

Hi all, I have created a database for my girlfriend to use at work to create quotes, she wants to be able to run it from a USB drive on both her work PC & her home laptop, she also wants to be able to back her database up at the push of a button. On the databases I have created at work I run...

Hi I'm Paul I'm noob'ish at access but doing my best to learn all the time picking up how to do things on sites like this & adding what I learn to improve the databases I create. I created my first 3 databases a couple of years ago at the company I used to work at & even though I have moved on...