Recent content by Wegets7

  1. W

    Form with a query to display result in another form?

    This is not exactly what you asked for, but if you add a button and use the wizzard you can use a built in search function.(I'm trying to solve the problem you discribed) The unfortunate problem is there is a built in replace function attached to the search function that scares me (and my boss)...
  2. W

    DCount fails in subform?

    Thanks for all your help. It was a case of oprerator stupidity. I was referencing the text box value both in the DCount and in the query.
  3. W

    DCount fails in subform?

    Its in the subform and I'm not sure how to make the main form respond when a subform button is pressed. Thanks for your time.
  4. W

    DCount fails in subform?

    What I suspect is happening is because the code works when the form is running by itself when the form is a subform the main form is canceling the query in some way. How do I correct this?
  5. W

    DCount fails in subform?

    thanks giz That section of code is skiped completly. It hits the Dcount statement and goes to the error handler.
  6. W

    DCount fails in subform?

    This is the Click event code for a delete button on a form. I'm trying to check if the record that is being deleted is active in another table. There should be only one active instance of the record so dcount isn't required, but I don't know any better. When I run this code in a stand alone...
  7. W

    DCount(domain,query,criteria) fails in subform

    This is the Click event code for a delete button on a form. I'm trying to check if the record that is being deleted is active in another table. There should be only one active instance of the record so dcount isn't required, but I don't know any better. When I run this code in a stand alone...
  8. W

    Programatically re-write sql statement to row source

    Thanks... Thanks Jon It really came down to getting quotation marks around the """ & variable & """ and getting spaces in the right place. Lesson Learned: Access will only give syntax error if the SQL statement is in the row source when the form opens. If you write it in later, as I was...
  9. W

    Programatically re-write sql statement to row source

    Since my query doesn't really change... ...is it possible to just pass the value selected by the user to a query at the prompt(newbee)? Rich
  10. W

    Programatically re-write sql statement to row source

    write sql statement to row source I'm trying to use an on click event in one list box to change the contents of another list box. The code I'm using re-writes the sql code to the row source property if I enclose the table names in square brackets, but doesn't generate known results. Similar SQL...
  11. W

    Using selection from textbox to limit query.

    SELECT COPY.CopyKey, COPY.CopyId, TITLE.Title, TITLE.Edition FROM COPY INNER JOIN TITLE ON COPY,FK_ISBN=TITLE.PK_ISBN WHERE(((COPY.CopyKey)Not In (SELECT FK_CopyKey From ISSUES_to_STUDENT WHERE DateIn Is NULL))) AND TITLE.Title=[forms]![3__ISSUES_to_Student]![TitleList] Ok, here is a typo...
  12. W

    Using selection from textbox to limit query.

    I am trying to use the title selected in one text box to limit the query that populates another text box. This is my simplistic attempt at it: SELECT COPY.CopyKey, COPY.CopyId, TITLE.Title, TITLE.Edition FROM COPY INNER JOIN TITLE ON COPY,FK_ISBN=TITLE.PK_ISBN WHERE(((COIP.CopyKey)Not In...
  13. W

    Delete - No Record Selected

    As it turns out I found that the alarm only appeared on my win 98 machine and did not appear on my win xp laptop, your results may vary. Below is a copy of a solution to the problem that I haven't tried yet. I was from someone name Mark from a different forum. Based on Allen's post it's a...
  14. W

    Help with undo, please.

    And the winner is Me.Undo Thanks g
  15. W

    Detect if user is changing new or old record??

    Now I have and it works great. Thanks much. I knew it had to be something simple.
See more
Top Bottom