Search results

Thought I would start a new thread for this one even though I'm building off the last issue. I have a single table db that now has a search form to find any combination of Institution, Pass/fail status, and begin and end dates. I am needing to now add in searches for some of the testing...

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

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

Still not getting a workable search form so making sure we can at least utilize filter by form so we have functionality. Here's my question, is there someway to make it so that filter by form accepts wildcards? I want a search where we enter White to return results of not only White, but also...

Not sure this is where this discussion goes but here it is. I'm using access 2003 on windows xp. Table structure is as follows: StudentInfo: StudentID pk LastName FirstName MI etc Classes: ClassPrefix pk CourseName CreditHours CourseCost etc Grades: ID pk StudentID Semester Year...

Using Access 2003. I'm fairly new to coding in Access/VBA, my background is web design not development but I've been thrown headfirst into this project. I have a database of student information. Main form/table is StudentInfo. Also have forms/tables for Enrollment, Classes, Grades etc. I'm...

I am using Access 2003. I have a form containing student information that shows information from more than one table. I know I can create subforms to show some of this information, but the main trouble I have with subforms is that they are not searchable from the main form; I'm having trouble...

I have a form set up that has several fields to search from. I created a separate form and included the most searched fields that we use. In the search query for that form, under criteria, I have the following code: Forms!QBF_Form!StudentID Or Forms!QBF_Form!StudentID Is Null also for...

I'm not sure what category this even falls under so putting it in general. Some background: I maintain a database of student records. Currently this is a Lotus Approach database but we are converting to Access 2003. (I work for the state, this is as far as we've gotten so far, sucks I...