Search results

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)...

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.

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.

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?

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

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...

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...

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...

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

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...

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...

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...

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...

And the winner is Me.Undo Thanks g

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

Thanks g That works great, but I still get the alarm "undo is not available now" Any suggestions Rich

I have a form with a combo box that notifies the user when they are changing a pre-existing record. I would like when the user click on the negitive/no button on the message box that the change is reversed. However I get a runtime error telling me that Undo is not available now. Thanks This...

Thanks g This strategy doesn't seem to distinguish between the user creating a new record and editing an old record. I didn't make that clear enough I guess. I would like to notify the user only if they are changing a old record. I also get an error. Undo command unavailable now. Here is the...

I'm using Access xp and working on a .mdb database. I have a form that is bound to a junction table between student and books. It records the copy number, student number and data in/out. I need to advise the user when they have changed an old records copy number or student number with a Yes/No...

Thank SJ The Cascade update didn't clear it up in win 98, but I tryed it on my broken xp laptop and the error did not appear. Platform matters. I'm off to bed Thanks again.