Search results

Hello again, Thanks Wayne for your reply. I've tried it out and the code does update the query but it's not shown in my subform. I have to close the form first and then reopen it to see the new result. Anyone who can help me further with this one? Thanks

Hello, I have a form (called MyParentForm) with a subform (called MySubForm). On MyParentForm I have a text field called "txtState" and a command button called "cmdFind". The subform is based on a query I call here "MyQuery". When I fill in a state in the text field and click on the command...

Thanks Norbert, this really works well. This is it. Thanks again for the quick reply and the right solution.

Hi, I want to make a query with 2 fields. The first field needs to count all the records in my table. The second field, which is a YES/NO field, needs to count only those records with criteria YES. My question is, if this is possible in one query? Or how can this be done? Thanks already.

That's indeed the entire population of rooms in my service. What do you mean with getting someone on the 2nd floor? There are a static number of rooms.

Thanks Bert for the quick reply. First of all. The only criteria on what the columns must be located is only the patients that are still in hospital. Let's say with a YES/NO field called StillInHospital. On each button or textbox I like to see the names of the patients still in hospital...

I work in a hospital and I want to make a form witch shows me all the patients in my post. Please open the attachment I've included (it's a word 2000 document) in which you can see how I would like it to be. I saw it on an application at my work but I don't know how this can be done...

OK. That's it Carol. It works fine now. Thanks again.

Thanks for the quick reply Carol but I'm afraid I still get the openreport error.

When I open a report with no data my own message box (put in the Report-NoData event) is shown followed by the following error: Runtime-error 2501 - The Openreport action was canceled. The report is opened by pushing on a button on a form with the following code: DoCmd.OpenReport "MyReport"...

OK Rob, I've tried it and it works. Thanks again.

Oops, I just missed Rob's reply while writing my reply to Pat. I think this could be it. I'm going to try this code first. Thanks Rob.

Thanks for your reply Pat. But when I make use of a query I filter the records and I won't see the other records anymore in my form. I still want to be able to scroll the other records to in my form.

I have a form, based on a table with unique dates, with a subform. When I open the form I like to see the record for today in the form if there is already one. If not I like to see a new record. How can I make this happen. I use Access 2000. Thanks in advance.

Already thanks for the quick replies, but I really think this can't be done with a simple query because what I want is that all the items of the standings must be calculated for each team. When I enter a new match result the standing must be recalculated and of course be sorted. Let's say...

I like to make a database of football results and tables (standings), but I'm not quite sure how to start on it. First of all I need of course a table in which to store the results of the matches. But do I need to make a table for the standings (tables) or don't I, because this is something...

OK, this is what I found so far. And it works. If anyone has an even better solution, please let me know. Just one little problem left: every time I click on a date that's not in my table yet a new record is added. Option Compare Database Private Sub Form_Current() ctlCalendar =...

Thank you Likhoutx for your reply. But is it possible to give me some more information because I still don't know how to solve this problem. I've tried several things already but still haven't found what I'm looking for. Thanks again.

Is it possible to navigate through records with the Calendar Control? What I want is the following. I have a form with a calendar control. The form is based on a table with several fields including a date field. This date field is unique. Now, I want to navigate through the records with the...

Finally, it works. But I still had to made some changes. When I made a record that already exists and I close the form I get my message and my form remains opened. Thanks again, Pat. Thanks to you I could finally solve my problem. So, here is the code: Option Compare Database Dim...