Search results

How would I be able to test this on my end? The database doesn’t do anything, not even a warning Private Sub Form_Open(Cancel As Integer) ' Set Count Down variable to false ' on the initial opening of the form. boolCountDown = False Dim strFileName As String strFileName =...

I'm trying to test it but having it close on my end, but its not

Hi CBrighton and thank you for getting back to me. You must be either some type of teacher of have kids. I appreciate your patience with me. Let me know if you prefer me to put the attachments in some other format. The 3 postings are of my different folder options, more so wondering which one...

one more. let me know

Here is the other address

here is the screen shot

Hi again CBrighton, I think I have everything setup correctly but my database still is not closing. Let me walk through the steps and let me know if I’m missing something of doing something wrong 1: Created a file on the network drive so that anyone that needs access to the database is able...

I’m sorry to keep asking the same question, but how do I create the file. Would you be able to explain how to make that file or attached it?

sorry, this one

Is this one right

here are all the pieces

Can you please check and let me know if there is correct

ok, so I just put a 1 after the empty folder on the network drive Enabled.db + 1 = Enabled1.db

CBrighton, What file do I need to edit when you said the following sentence" There is no need to interact with the database to kick people out, all you do it rename the file (personally I put a 1 on the end of the file name, but you can edit / delete the file however you want)." Thanks you...

CBrighton - Thank you very much for working with me on this, and please bare with me while I work though this and get it to work on my end with my users. Could you please check the VBA below and let me know if I need to change anything else. I also attached a db to show you what I'm doing...

Oh, so this is the part I need to change Private Sub Form_Timer() On Error GoTo Err_Form_Timer Dim strFileName As String strFileName = Dir("c:\Enabled.db") <- to this ("c:\Enabled.db") ("I:\SHAREDatabase1.2.mdb") If boolCountDown = False Then ' Do nothing unless the check...

I'm sorry that might be the step I missed, I didnt do any VBA or file path. what do I need to do?

CBrighton - This is aswsome. but I thing I'm soing something wrong, it only closes the database on my end and not other people that have it open. did I miss a step? Thanks for your help

I dont quit follow, would I just place this code in a vba

I know there is away to in a macro show the start and stop times of the actions/queries that run in a macro. Could someone please remind me how this is down again? Thanks for your help TCB