Search results

Hm. That might be my problem. We want to be able to answer either yes or no, it's a pass/fail checkbox so values are 0,-1. -1 = yes or true (I think the table has true) and 0 = no or false. When I do a query using just that field... [Yes or No] works to filter it properly according to what you...

I showed you two in the first message, what else is needed? I can show you every one I've tried so far, but there are about 12. Here are a few more I've tried that do not work: SELECT DeadRecords.[DOC #], DeadRecords.Lastname, DeadRecords.Firstname, DeadRecords.Institution...

Thanks Brian, I looked at that link, and it's one I've used before when running into query issues. I have tried that and it's still not working in the design grid. As Jon states there, setting it up like that makes Access split the Is Nulls off into their own column and on my bigger database...

I'm aware of that :) it's something I always change, I should have done that here just was focused on the other issue. Those aren't really critical to the question at hand so wasn't concerned with them just now. Thanks for the reminder though.

I'm using Access 2003. There will only ever be two users, myself and my boss, using this so we are not concerned about typing errors and both of us prefer to type as opposed to mouse clicking multiple things. Most of what I do is geared toward only a couple of users, we don't have multiple...

I can certainly make it work with more than one query, boss wants just one, I have no idea why she's set on that but she is. I can do comboboxes for the instutitions and the pass/fail I guess, but the date range seems like it would be easier to do as input. What you're talking about requires...

I'm doing a fairly simple database, one table with 20 or so fields. Want to do a simple parameter query that when run asks you to enter Institution, Start Date, End Date, and a Pass/Fail value. We want to enter all or some of these values and get the results. For example, might need to search...

I've attached the database again, maybe it will help to see it. this is the new one uncorrupted and on the search form in question I marked out what input boxes are to search on which form or subform. Hope this helps.

Thanks for all the help. It's not returning an error, but neither is it returning any results. Here is what I have on the search button onclick event now: Private Sub Searchfrmbtn_Click() Dim strWhere As String Me.Filter = vbNullString Me.FilterOn = False If Len(Me.LastName & vbNullString) >...

Ok, so would I need separate With / End With statements to include the two subform controls in this? Or can they all be included in the With Forms!YourFormNameForFormYouWantToFilter .Filter = strWhere .FilterOn = TrueEnd With code?

Ok that makes sense. I'll make that change. I would need to add to that code if I am wanting it to filter on the subforms on that studentinfo form then?

It was improper use of a . but I got the studentid cbo unbound and that went away. Now when I enter a last name into the last name box and click search... nothing happens. Here is the code on the onclick event of the search button Private Sub Searchfrmbtn_Click() Dim strWhere As String...

That worked perfectly thank you. It no longer gives me that error, but shows me a different one. LOL I know we were moving past this issue but I wanted to make sure it wasn't corrupt like you said.

Bob, Can you tell me how to do this without recreating all my forms, queries, etc? Thanks.

Ok. What I want exactly is that we can do a ctrl-F while on the StudentInfo form, have it bring up a blank form (much like filter by form does) where we can type in any criteria into any of the fields and have it return results on not just the form but the two subforms there as well. Ideally we...

I changed it all back to me. still have just the first three fields so once I get those to work I can do the coding for the rest. I used combo boxes because that's what everyone keeps telling me to use. Every instructional for doing a query by form says it, and it's what I was told to do in...

I made some changes, enforced refrerential integrity on the relationships and changed the code in question to correct where it was pulling from. (changed me. to StudentInfo. since the search form is unbound and the fields pull from the studentinfo table)

Here is the database I've been working with, thanks for taking a look at it! edited to removed db since it had flaws I needed to fix. see next post.

Is it not possible to use the enter key as a hotkey in Access 2003? I have an autokeys macro set up for all my keyboard shortcuts, but it won't let me use {Enter} or {Esc} as hotkeys. Anyone know if there is a way to work around this limitation and make it work? Trying to get enter key to...

You edited after I replied, but looking at your edit I guess my reply would remain the same. The point is to have an input search form that is user friendly, not programmer friendly. the Lotus Approach database we are using currently has this. We do a ctrl+F which brings up a blank form that...