Search results

  1. S

    Question Form control error on query

    Hi, I am having an issue with a database application I created. I needed to add another query that could be controlled from combo box on a nested form. The combo box is for dates for entries in a table. Which then filters the query based on the combo box selection. Easy enough stuff. The...
  2. S

    Question Listbox

    I have a table of trainees. One of the fields of that table is 'authorized trainer' (YES/NO) tick box. What this allows me to do is query the trainees table based on who is an authorized trainer, and who is not. I have a table of called training, that records information about training a...
  3. S

    Embedding Icons instead of paths

    I have searched the forum for threads on icons and haven't found one that relates to what I'm about to ask. I have an access icon (*.ico) file associated with my DB. But when I try to access the database from a place other than my desktop where the icon is located the icon doesn't show up. Is...
  4. S

    Duplicate Customers in Query

    I have a table of customers, and a table of products. I also have a table of orders. Each time a customer orders a product the details of the customer and the order are added to the orders table. Pretty standard. I have a query that shows customers who bought product 1 and 2, but none of the...
  5. S

    Feeding a 'live' query...

    Ok, So this might be a little bit complicated, but I'm sure it must be possible.. I have a form that displays a customer and a subform that displays their purchase orders. If I wanted to be able to print a customers details and purchase orders on the fly, how would I do that? I'm thinking...
  6. S

    Modal forms

    I have three modal forms set up. The are options for when a user wants to add something to my database.. I have three tables, cities, states, countries. The reason being that I have multiple tables which all use these tables. What I have set up is if a user trys to enter an address for a city...
  7. S

    Comparative Report/Query

    Hi, Can anyone tell me if this is possible in Access 2010... I have a table of employees, who are required to complete a certain level of training for their role, depending on the department that they work in. So for example, if an employee works in Finance, they must complete Outlook and...
Back
Top Bottom