Disconnecting users should not be a prob. since I can add a value in my "configuration table" with either a false or true. My forms can be set to check for the value and display a msg and quit forcefully if need be. Even if there was ONLY one user, My admin menu does have a lock on one...
Thanks for the input.... I just have one prob. i shall not be able to maintain the database after I am gone which is within a month ... then who will compact the back end without making a mess of stuff....
Thanks ...
Taha
thamiral@uwo.ca
Hello again Junior 1544 , the setting i wated to change was the one outlined in
thread705-323980 already answered it there ..... thanks..... now i am just wondering if there is a way to run that code First thing .... or a way to write the autoexec using VB
Thanks Taha
thamiral@uwo.ca
Hello...
Two questions please....I would be very grateful for ze answers :)
1. I would like to ensure that everytime someone loads my database that the option "Windows in taskbar" from Tools-->options-->View Tab is unchecked... For access xp or 2k you can modify the following...
Hello...
I had the exact same need and all i did was make the form lock (all records) onto a DUMMY table that was never required. When you click on the button that loads the form, if another form has locked the table, the form wont load and an err will be outputted by access which can be...
Hello...
Yes I fully tested it and found no adverse affects on other users.... I dont know why there would be adverse affects on anyother users since i am locking onto a Dummy table which has nothing in it...
thanks Taha
thamiral@uwo.ca
Thanks for the solution... But I tried and I got a bit of a better result... I set my admin menu to lock (allrecords) onto a dummy table on the back end! Therefore no other front end can use the admin menu since it will try to lock onto a table that is already locked... I think of my self as...
Hello...
I have s question which I would be extremly grateful to whosoever helps out in anyway.
FIRST THE SCENARIO
I have a database that has both front ends and a back end. In the front end, the user has the ability to use and Administrative Menu that is password protected in order that the...
Hello...
With respect to the last message ... Does that mean I have to count the Hyperlinks before hand???!!!... As you can see in my code ... I am adding as I come across a hyperlink...
That is why i wanted to have a small window pop up to play animation while the func. does its work ...
Hello...
With respect to the last message ... Does that mean I have to count the Hyperlinks before hand???!!!... As you can see in my code ... I am adding as I come across a hyperlink...
That is why i wanted to have a small window pop up to play animation while the func. does its work ...
Me thinks me should rephrase the above msg...
I know that it is set to go only for a certain amount of time ... but I wanted something that is dependant on the number of hyperlinks that I wish to add... for instance if i need to add 1e100 hyperlinks :) the progress bar would take more time...
Thanks for the tip ... However I am curious can someone explain this ... It seems to take the same amount of time even if its doing a MUCH larger folder ...
Thanks ... How about the Hyperlink prob. guys...:) ;)
Taha
thamiral@uwo.ca
Hello again everyone
I was wondering if someone can tell me how I shall be able to monitor the progress of the above code that Ben put up...I would like to put some animation on the screen as it the function does its work...
Additionally I have about 10,000 Hyperlinks in an access table in the...
Thank BEN .. I already Emailed you what I did but for completeness I will post it here ... This code requires no scripting .. Tis Basically Ben's code but with SQL inserts instead of DAO ... (something I dont want to understand :))
"WE ARE NOW FREE FROM THE "ROOT" "
here...
Hello...
Thanks for the help... I would really appreciate a sample that would ...lets say .. enumerate all the files in c:\My Documents ... Additionally ... I need to make hyperlinks out of these file paths... therefore I will need the File name and then I can use the FILENAME#FILEPATH to make...
Hello....
Can anyone tell me how I can get a list of file names path and date in a directory with subdirectories...
I would like to store this info into a matrix that is nxn where n stands for any number then dump them into a table using sql insert statements... I am using access 97 and 2k...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.