Search results for query: *

When adding records daily to a large access table, how can unique items be captured easily? Much of the daily submissions are repeated item numbers. However, occasionally, there is a new item number. How can that item be easily identified? Could this be done in a query? Thank you.

How do you create a 2-column drop down box where the box populates from column 2 based on the data chosen from column 1? For instance, the first column is a list of departments and the second column is a list of the numerical codes assigned to the departments. In the spreadsheet, if the...

How do you data enter multiple numbers in one field for one person? For example, if an employee is responsible for several standards how would you input "Employee A has oversight of standards 1,7,9?" The field needs to be searchable. Thank you.

How does one check to see whether or not a duplicate PIN ID number has been entered into the text box field, send a message "A duplicate number has been found, please choose another", check that number for any duplicates and if all is OK, move on. The program I wrote sends a message...

We have created a form listing members' costs and options based on their category. We would like to have one of two lookup tables become visible at a time. For example, if a member is full-time, the full time cost table would become visible; if the member is part-time then the part-time table...

I have a form that finds a record and allows edits. This form also allows me to add new records. However, for tracking purposes, I would like to save the edited record as a new record. The "find a record" approach allows me to capture the demographic data that has already been submitted.