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

I am using MicroSoft Access 2003. It does not allow multiple values when using the lookup wizard. Therefore, when making a recordset, is there a way to insert multiple copies of the same row of information in one step - for example using a do---loop statement or some other conditional...

Thank you for your answers. I thought that was the way that I would have to make the table, but I was so hoping that access would have made it simpler over the years.

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

Thank you for your answers. However, I think that we may have to re-evaluate our program. The form currently is obtaining the data from a membership table which gives the member his current fee. We would like to add a column showing the dollar amounts of all the various levels that are...

Yes, we are trying to print the form. However, the correct table does not print even though the correct table is showing on screen.

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

Thank you for the response. However, I had tried the duplicate command and it does not save the record. It will give me an error message.

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.