Search results

Hi, I have a database witha database password set on it. Just a database password. and i restricted access to design view to forms and reports for admin and users. But i have a textfield on the startup screen . where if i enter the password on it , it should enable the design permissions to...

the code i have behind the scenes does disable f11 and by pass p.s how could you be so sure in saying that "obviously the code doesn't work" i gotcha i confused you with my question. i will re arrange my question.

Hi , I have database with a password on it. I disabled the f11 and shift through code. I need one button on the start up form which should prompt for a password on click of a button or an empty textfield when i enter a password it should enable F11, shift ...... The password will be known...

Hi , I secured the database . I splitted the database as Back end and Front End . I have Back end and its assosciated Workgroup File on the server. I have front end on the local desktop . What i would like to request is that I need a shortcut for the Front end which should point to the Back...

Oh Ok . But if you check it is moving the files . Don't you think so. Genuinely, Thanks a lot for having so much patience and clearing all my queries. Thank You.

i did not get that. do you want me to delete the attachment

actually nothing what l would like to know is that after " *.*" it copies all files in to the sample folder only files but not the sub folder if it has any.

actually let me post some code that i have it is working . but one issue actually Set fs = CreateObject("Scripting.FileSystemObject") fs.CopyFile "C:\Security Database\*.*", "C:\Sample"

hi, its not working. I tried a few ways some times it says bad file number some times file not found. some times path not found.

Copying it

I will be a bit clear i need to move file which resides in program files folde ron C drive to COmmon Files folder on Cdrive. How do i do that. Thank You.

Hi SOS, It is a quickie , DO you know how to move a file from one folder to another folder through vba . I know FileCopy("Current Path", "New Path") . But it isn't working . DO you know that by any chance. Thank You.

how do you do that i mean debug.print .... what should i specify after print

and when i removed the quotes the shortcut is getting created when i looked in to target property it is just storing access executable path and error is getting displayed like unrecognized format

Hi SOS, One more thing is that it is picking up the 2000version access executable . I have 2003 too so what should i do in order to make the code to grab 2003 version .

hi SOS, I am pasting my code could you please check because when i run the shortcut which it has created on the desktop it is opening the mdw file but not the actual database and . I running the code on the button onclick event . Please take a look at it. I hope i am very close to getting it...

Hi SOS, THank you for replying in such short time . I need a littble bit more help the link you have forwarded after copying and pasting in a module how should i invoke the module . I mean where should i address it . I am a newbie so please help me out..........

Hi SOS, I will create the shortcut and i will hide the main database and the assosciated mdw file. AS you know the target property = " C:\Program Files \Microsft Office\Office 11\ MS ACCESS.EXE" ........... I would like access executable to be changed by looking up the users drive...

Yes the If the two users have access executable in different folders. Then i do not want to change the shortcut target property manually, I need some sort of code or a batch file to recognize the path of the access excutable and use it in the shortcut target property. Thank You. Please Help me .

Hi lagbolt, I think i need to use that statement in vba. But how does it reflect the change in shortcut. Please walk me through this. thank you.