Search results

Let me explain clearly, 4 tables connected in query. If you look at the data below ID( 2) is a duplicate one because it has got same records . And ID (3) has got two records but with different Dates So i want the report to only show the data assosciated with ID(3). Please Help me thank you...

Let me explain clearly, 4 tables connected in query. If you look at the data below ID( 2) is a duplicate one because it has got same records . And ID (3) has got two records but with different Dates So i want the report to only show the data assosciated with ID(3). Please Help me thank you...

Trying to achieve, capturing the deleted record information and storing it in a array in the ONDelete event and using that same array in the AfterDeleteConfirm event , writing the values to the table. iam calling the function in the AFTERDELEVEnt := modprocess([Form]) In my form's module at...

Hi , Problem Is When the user tries to multiple records at a time on the form . I do not want to let him do that. I should allow the user to delete one record at a time. So whenever the count of records ,that the user is trying to delete is more than 1 , cancel the operation . Whenever , the...

HI , the code in AFterDELCONFIRM of the form and the same goes to each and every form i have . SO instead of pasting code in the AFTERDELCONFIRM event of every form . Can i create a module which has the code and i can just call the module from every form. I do not know how to do that. Please...

Hi, Please this is not a duplicate question. I need to save a delete record. the Purpose is same but the way i should do is different now. So thats why i need your help guys. Whenever a user deletes a record on the form I need to store that record in a separate table. I was told that i should...

Hi , I have the code which stores the deleted records in a separate table . When the user tries to delete a record , upon select yes on the message box the record gets deleted and it is stored in a separate table . But there is a glitch , I will explain it by taking 2 tables ( tbl_customer...

H, I have two tables tbl_ new and tbl_copy both have same structure and field names but the data will vary among the tables So Tbl_ new (id, first name, last name ) has 3 records and tbl_copy ( id , first nbame, last name) has 2 records .So when you compare the data in both tables...

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...

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...

Hi , I post a few threads earlier but i decided to take the shortcut route. THe only question i have is that if users have access executable in different folders . I do not want to change the target path in shortcut for each user. I need some code or a batch file to recognize the access...

Hi , THe user will be running the database off the flash drive. it is secured and the workgroup file is also on the flash drive but i will be hiding it. It is mandatory that they have to run the database off the stick. they cannot copy DB on the local desktop and run them . So my...

Hi , I have a secured database. and I want the database to be linked to a specific workgroup file. I do not want to use shortcuts where i can link the shortcut to a specific workgroup file. I want the database to be linked . I know i can do that through VBA . COuld anyone help me out here...

Hi I have a secured database , i will be deploying the database to 14 users in Flash drives. So i will be having a shortcut in the flash drive and i will hide the main database in the flash drive. IN the short cut target path , the access executable path could be different in user computers...

Hi I created the shortcut for the secured database and done with filling up the target fields with correct path leading to the database. But as you know The path has to be like this C:\My Computer\Local Disk C\ Program Fiels\ MS OFfice\ Office 11\ MS Access .Exe wrkgrp........ THe...

Hi I created the shortcut for the secured database and done with filling up the target fields with correct path leading to the database. But as you know The path has to be like this C:\My Computer\Local Disk C\ Program Fiels\ MS OFfice\ Office 11\ MS Access .Exe /wrkgrp......... THe...

Please Help me . I looked at ghudson's solution and a lot other threads too. But I need to disable F11 and shift key depending up on the user group . I mean if the admin log in to the system the shift and f11 should work , he should not have to enter any password or click on the hidden...

Hi, I applied security to my database. It is secured now and the shortcuts are also working fine. I need to write the code like to disable menu bar, toolbar depending up on the user group rather than on the current user. I need to enable all the toolbars, if the user belongs to the...

I am applying security to the 2003 version of Ms access. If any one who has 2007 access open the database does it gonna change any security settings. Please need some information regarding that.