Search results

Hello I have a query which calculates 12 leave dates of every employee for 3 year project. There are 12 fields for each leave calculation. Type of leave fields is Date/Time. I want to generate the remainder for upcoming leave. For example remainder will check each employee leave from...

Hi, I am making of inventory system, am facing some problem in query designing. I made one check box on the Form. If user check the box then record will save otherwise not. My problem is How to set the criteria so that the Query will look at only the checkbox items from the table before...

Thank you so much Mr. Boblarson But the problem is still there I need secure way for example I uncheck this button but when others users use that invoice data base and they check this button again they can view all tables, queries, macros. Is there any secure way is available that I can view...

Hi I am making one invoice database and I am using Access 2007 I want to hide my Tables, Queries, Forms, Macros from other users actually I want to disable F11 Command. I want to implement security measures in My invoice DB. I am very thankful if u help me in this matter. Thanks in advance.

Hi, How to compare the text field to table field? Thanks

Hi, How to compare the text field to Table fields? :confused: Thanks

Hello, I want to implement user access control in access 2007. I want that only administrator of DB can open objects like forms, tables, queries, etc. in design view and tables & queries explicitly. I mean other users should only interact with these objects through Forms and users can open...

Thanks SOS, But I don't know how to use the code in that link. Please tel me about it. I have just started working on Access. I 'll be very very thankful to you if you send me an example file of this code usage. Thanks & Regards

Hi all, I have made a form with text field which will keep the file name in it. I want a Browse button to avoid any error in typing the location of file. How should I create that button on Form. Thanks

Sorry for disturbing again & again. I want to know that is there any way to restrict any user from opening up the table directly. For example in Access 2007, if you press F11, window on the left appears through which you can open up any object in either Layout view or design view. For tables it...

You mean we will need to implement Access control system with DB. I believe while giving permission to some user on tables, he can also open up tables and one person can alter the signatures of some other one. Is it possible that user only has access to interact with tables through Form, not...

long question & Long answer. ;) Thanks a lot for your so valuable response. The Idea is to convert paper based system to fully electronic. I mean invoices are signed in sequence and every concerned person put his signatures for authorization. I want the same thing implement into DB. As for...

Hi all, I am novice in MS Access application development. I have developed an application of invoice automation system. Any invoice received is signed by the manager. It then entered into the database and kept in the record (in cabinet). Reports can be generated in database on requirements. I...

Accept Friendship