Search results

  1. S

    Tables and Relationship suggestions

    Hello all, I've created a small, simple DB to store/track my daily task(s). Each project can have one or more complaints. I will have to run some general tests for most of the cases before I run some specific tests according to each complaint(s) to confirm if the customer was right about their...
  2. S

    Temp or Permanent Table?

    I am trying to understand your changes and make sense of them in my mind before I try the query. I am sure I will need to run that query or a similar one ultimately. Thanks again
  3. S

    Temp or Permanent Table?

    You're right but I used the same concept as when you have two tables, for instance, "Car Makes" and "Car Models". In table "Car Models" you will have to have the make of that model in front of each model. This also helps to have nested combo boxes in data entry form. Anyhow, this was the best...
  4. S

    Temp or Permanent Table?

    Thanks for your time. I am going to check it tonight and ask you questions tomorrow if there was any. I am taking OFF from my work now.
  5. S

    Temp or Permanent Table?

    Sorry. I was confused. No. I don't need to tie the tests back to the specific complaint but they need to be tied to the project.
  6. S

    Temp or Permanent Table?

    Yes. I do. That's why I have a table for tests per project and a table for complaints per project. This way I can check each project, complaint on each project and the tests that are done when I run a report in the future.
  7. S

    Temp or Permanent Table?

    Exactly. Once I received your projects then I have to work on each according to the complaints. I use this DB to summarize received projects, their complaints, and the test I need to run or have ran. I will run the tests according to each complaint. Some tests are common in different complaints...
  8. S

    Temp or Permanent Table?

    Lets say you send me project (file) A with complaints 4, 7, 10 and 12 (for example). The day after you will send me project B with complaints 2, 3 and 4. That means each project have multiple complaints and even some of the complaints are common in other projects (which is most of the time).
  9. S

    Temp or Permanent Table?

    It holds complaint(s) per project. Each project can have one or multiple complaints.
  10. S

    Temp or Permanent Table?

    Hi all. After spending a lot of times on your suggestions I was not able to solve the issue. Here I have my DB attached. Maybe it helps you to understand me better. I have a table that fills up by user form, frm_projects. As mentioned before each project has at least one complaint or multiple...
  11. S

    Temp or Permanent Table?

    That's correct. We are in the same page.
  12. S

    Temp or Permanent Table?

    That's correct. We are in the same page.
  13. S

    Temp or Permanent Table?

    I am not quiet sure about your chart because I am not familiar with this type of chart but it looks OK mostly. In addition I want to say we have a device that hospital says "there was no output and we had to explant it" when returning the device. The complaint here is "No Output", the...
  14. S

    Temp or Permanent Table?

    I can't share too much info because of the company policy. Medical Device is implanted for some period of time and then when they explant it, send it to the lab for analysis (with the complaint(s)). Complaints are such as early battery depletion or no output or no communication with outside...
  15. S

    Temp or Permanent Table?

    Hi all. Thanks for al your responds. I try my best to clarify. Each device will be assigned one time only. After all tests are done they will archive the device for ever. Yes, a device can have multiple complaints. A USER is the person who tests the devices and prepares a report for each...
  16. S

    Temp or Permanent Table?

    Hi all. Table 1 has list of devices with serial/model number and the date of assignment. Table 2 has a list of complaints. User can have a device assigned with at least one complaint or more brought to the shop for repairs/analysis. Table 3 lists the tests they need to run per complaint...
  17. S

    Navigation Buttons

    I like your code as it is very simple and easy to understand (almost!) for me. I have some issues here. Unfortunately it doesn't work. I need your help to fix it please. Is "Recordset" in your code known/predefined? Do I need to have a connection to table and retrieve the data from that table...
  18. S

    Navigation Buttons

    Yes. That's exactly what I am trying to do. Could you please show me how to build this nav. bar?
  19. S

    Navigation Buttons

    I am aware of this functionality in Access but some of the users aren't. For that reason I am trying to create a set of navigation buttons larger and in the middle of the form. Thank you for your time anyways.
  20. S

    Navigation Buttons

    OK then with all have said about Macro and VBA here comes my question. In a bounded form that includes a sub-form and buttons that are created (using Macro actions) to go to next/previous records, running a VBA module does have any conflict? If there are some tricks or rules needed to be...
Top Bottom