Recent content by Candi

If there is missing access or broken reference then I should be getting the same message as others when I log into the same database on my PC? I can access the system without any error messages. Thanks

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

Oopse.. sorry.. I replied to some thread instead of posting a new .. sorry!

Error Message on Form field 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...

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

No, it says no. I changed it to Yes, now it works. Thanks

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?

Display description The form is based on main data table. The code table has 2 fields (code,description). main table data: ID-11111 name - Thomas code -1 code table: code -1 desc - purchase Form displays all 3 fields from main table, I just want the code text field to display description...

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