Recent content by zyxwvu44

  1. Z

    Stock Control Form

    i think what you want is a continuous form, which will update as you fill it in if its linked to the table directly.
  2. Z

    Trying to populate data into form.......I'm an access beginner

    for the record source try: SELECT table.[ID], table.[name] FROM table ORDER BY [name];
  3. Z

    Trying to populate data into form.......I'm an access beginner

    try changing the bound column to 1 or 2
  4. Z

    Trying to populate data into form.......I'm an access beginner

    in the properties, set the first column width to 0, the second to 1", or however wide you want it. so, it will look like this: 0";1"
  5. Z

    Distribute MS Access

    can the acess 2007 free version run on windows xp?
  6. Z

    Archive Code - SQL Syntax Query

    why not cascade delete on the relationship?
  7. Z

    multiple queries from a single form

    Try using one query. This might help: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=285 it writes the sql for your query based on your selections, you can then filter the fields afterwards.
  8. Z

    Problems combining two queries

    I figured it out, had to set more indexes and rearrange my relationships, thanks
  9. Z

    Desperate for help- 2 problems

    for the querying, what about something like this? http://allenbrowne.com/AppFindAsUType.html
  10. Z

    Problems combining two queries

    I want to comment on a counterparty given a certain product. so, counterparty A and product X have a comment, counterparty B and product X have a comment, counterparty A and product Y have a comment, etc.
  11. Z

    Problems combining two queries

    Hello again, I am trying to have users be able to see and enter comments on a form along with results from a query. My database looks like this: the "comments" table is what i'm having problems with. Right now i have a query where a user selects a product and any number of funds and it...
  12. Z

    Complex Database/Query Design

    I have this table in the relationships, but i dont know how/what to link it to? I need it to match up with the details section of a form that comes up with Counterparty, given a product
  13. Z

    Complex Database/Query Design

    Okay now i have another problem with my relationships, i need to add a comments column that is linked to a specific Counterparty(as a whole, not the entities) and a specific product. For example something like this: Counterparty A, Product A, "not preffered" Counterparty A, Product B, "Quick...
  14. Z

    Complex Database/Query Design

    thanks keith, i think i got that working now
  15. Z

    Complex Database/Query Design

    oops, the company is the counterparty. Each product can be traded in each fund, but only certain companies(counterparties) will do so, hence why i am making this database so i can easily look that up. Right now the combine table looks like this: Counterparty ID, Product ID, Fund ID, Avaiable...
Back
Top Bottom