Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Trazzel

    Identifying new records that are added daily to an access table

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

    2 column drop down box

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

    Inputting multiple numbers in one field

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

    Inputting multiple numbers in one field

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

    Inputting multiple numbers in one field

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

    Checking field for duplicates

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

    Form - Making visible one lookup table at a time

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

    Form - Making visible one lookup table at a time

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

    Form - Making visible one lookup table at a time

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

    Saving an Edited record as a new record

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

    Saving an Edited record as a new record

    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.

Part and Inventory Search

Back
Top