I will look into the filter and apply it. Thanks bob i will post if it works applying a filter. Brian Love that Example. Thank you for showing me it, i will also try to do something similar.
Here is my database
SearchRecords and SearchCriteria are the two objects i am working on. The form is where the input is placed, whereas SearchRecords is the query which is replacing my code with additional that throws off my search. :banghead:
This is a complex search query. It has four fields in which each criteria could be entered. So the code you put is correct but has to be include some other fields to. Here is the sequel view it includes what access puts into my code.
SELECT EquipmentAssignments.[Perm ID]...
I am currently trying to complete a Search Form for a table of mine and i baffled by what Access does for me. I want to Search for dates between Start Date and End Date when there is input and List all dates when blank. This to me is the correct code
Like "*" & (Between...
Finally! i did it. i was getting errors left and right while binding it, furthermore even more when adding additional features to my form.
This isn't a major problem but before when the form was unbound i had the date automatically insert itself into the Assigned Date text box. But now since it...
haha sorry i forgot there was a second page. So i would be better off using the Forms to directly input the data into the EquipmentAssignments? I've never done that it is the same as having the query do such? Instead of having the parameters be passed to the query i just redirect to the Table? I...
Okay makes sense, I need to be more general and specifics could/should be inside the table. I guess i could get rid of one of the fields since i can make the database count how many equipment are in inventory. Thank you 3x. If you would be willing would you check my database so that it is...
Thanks for the advice I am going to start working on tables right away before working with the queries and such. Equipment Number and Equipment ID are two different fields. Equipment Number is just an auto number primary key. It solved a problem for me trying to assign a student an equipment and...
Oh finally after rereading several times I understand what you are saying. Thank you very much I made a simple thing so difficult for myself. I should of gone through reports and controls better. Thank you again, if i should run into a problem would it be alright if i was to pm you?
This would help the problem of having to keep inputting the same parameter right? I would have to insert it in all the involved queries? Sorry if i ask stupid questions, i am trying to get all the information before i hack away at the database. I've learned to plan before coding away from...
I have posted my database. I do think i could structure my queries to run more efficiently, but i have a problem of trying to deal with everything in one step. Could you tell me a way to improve? I learned all this by myself.