Search results

I have a simple validation rule on a data field as value entered should be <=date() and have input mask 99/99/0000;0; This rule is working fine on my PC but for some other users on their PC when user tabs to that field to enter data it is giving validation rule error as "The expression date you...

I have a numeric field with 2 decimal places on a form that was functioning fine for data entry for me but one of the other users who also have Access 2000 they are getting an error message when they try to ente data. The error message is as follows: 'Function is not available in expressions in...

I have a database with no user level security. Users enter data into db through front-end db data entry form. They do not see the backend tables. However now they want to run some reports based on data in 1 table. How can I give access to tables for them to run queries/reports without...

I have a database where users can write to it through frontend form only. They do not see the backend database. However, now they want to query the database to run reports. I have no user level security on the database. HOw can I give them access to table where they can just run queires...

In option box selection I have Yes, No, N/A. If I want to type a Y for yes, it doesn't take to Yes. I have to pick my mouse to select Yes choice. Is it possible to code so that when I type first letter takes me to 'Yes' part of the pick list for selection

I have form designed on a query. When I open the form the form prompts for a student ID #. After entering the ID # it should take me to that student record but for a brief moment it displays the 1st record in the query results and then the requested record?

My form has 1 display only text field. The record source for the field is a code field(value ex: 1,2,3). I know what these codes stand for but the users do not know what 1,2,3 mean. I want to display the descriptions for them on screen. The code/descriptions (code 1= purchase) are stored in...

I want to disable all 10 data entry fields on form when user enters date value in dt_completed field. When user goes to the record later all fields on form including dt_completed should be disabled. How can accomplish this? This is a simple data entry form I created for 4 users and I do not...