Search results

  1. A

    Lhr?

    Ooh I love maps, thanks for the links Chris!
  2. A

    Lhr?

    That's about what it is here during the day too, should be fine then. Thanks!
  3. A

    Lhr?

    Is it very cold there now? We are from Colorado, so we are used to cold weather, but will it be too cold to walk around? Or will we be ok as long as we bundle up?
  4. A

    move row from one table to another

    Are you saying that the query that the form is based on is using the criteria?
  5. A

    move row from one table to another

    Ok, you should put Forms!ViewCableCardForm!Combo29 in as the criteria, and then save the query. It will stay in there. Then, what is the code behind your command button?
  6. A

    move row from one table to another

    What preview button? Is that a command button you put on the form or something else?
  7. A

    move row from one table to another

    Ok, with something selected in the combo box, open the query separately, and then type in Forms!ViewCableCardForm!Combo29 as the criteria, then run the query, does that work?
  8. A

    move row from one table to another

    OK, open the form, pick something from the combo box. Does that much work?
  9. A

    move row from one table to another

    No question mark . . .
  10. A

    move row from one table to another

    OK, so you need tp put [Forms]![ViewCableCardForm]![Combo29] as the criteria in your query, since that is what returns the right value. Make sure the form is open when you run the query . . . does it work?
  11. A

    move row from one table to another

    Ok, open the form, pick something from the combo box. Then go to your immediate window and type ? [Forms]![EmployeeForm]![Combo22].[Column(0)]) and then enter Does it give you the right value?
  12. A

    move row from one table to another

    Open the query, then right click and go to parameters. Is anything in there? The reason I ask is because the parameter it is asking for is different than the way you said you were giving it the key id from the combo box. If there is anything under parameters, just delete it.
  13. A

    move row from one table to another

    Is the form open and the combo box filled when you are running the query?
  14. A

    move row from one table to another

    How are you giving the ID from the combo box to the query? If it is asking you for the ID, that means it thinks you are using a parameter query, i.e., it doesn't understand the input.
  15. A

    Lhr?

    Well I am glad to have all that straightened out!
  16. A

    move row from one table to another

    ok, What I was trying to get at is that you don't want to be filtering on the value of the name - what if two employees have the same name? You should be filtering on the key value. So in a normal combo box, the first column would hold the employee's primary key, and the second column would...
  17. A

    move row from one table to another

    So if you go all the way back into the original EmployeeQuery, what is the SQL there? (What you have posted above is the SQL of a select query that is using the EmployeeQuery).
  18. A

    move row from one table to another

    What is the SQL of the EmployeeQuery?
  19. A

    move row from one table to another

    What is the record source of your combo box?
  20. A

    move row from one table to another

    Assuming your combo has 2 columns, Forms!EmployeeForm!Combo22 likely refers to the key field, not the name field, so you would need to place the criteria on the column that contains the key rather than the name.
Back
Top Bottom