Search results

is it possible to have mulitple fields to choose which you want filled out and it would auto populate all of them regardless? also is there a way to make the DB u created above to work on 2007 i tried the =cboFatherID.Column(2) but it keeps putting it in brackets

So I would need to redo the rep and school fields are is there an adjustment I can make to them to fix the fields?

Message it gives me is that this Recordset is not updateable.

Here is the SQL. I had taken your advice and cleared all of the criteria out of the query and placed it on the form. SELECT Students.txtFName, Students.txtLName, Students.School.Value, Students.TxtStudentNum, Students.Show, Students.ApptDate, Students.Program.Value, Students.Active...

It wont let me change the data

Ok being such a noob at this how do I make sure of that?

@Bob a question for you. If I setup a split screen using the code above is it possible to allow edits to the upper part of the screen for the information pulled? Specifically allowing changes to the checkShow & checkPend fields?

Thanks for all your help

Sorry about that I should have woken up a little better before I replied the previous post make perfect sense. I did set it up and it works except for the null dates, but at this point I am just glad it works and not too concerned about that. As long as I put dates in both field we are good.

Just to get a little clarification. 1)i am assuming datasheet form is a split form & 2) Does that coding go into the on click event?

Well thanks for all your help this is just showing me how much more I need to learn.

That is what I am looking to do but when I replaced the lines (cause it listed that line twice) it still didn't work. Also it has this funny clitch that the first time I run a report it will not pull anything even if there is info that fits the parameters if I change the parameters and run...

I did use what you had mentioned before about the triple value checkbox and have gotten that part to work now. But adding a Null to checkRep does not seem to be working any ideas on how to fix that?

It probably would be but i am not at all familiar with SQL. Now looking over what I need I realized that to have either a check or not it will always show all the info so I changed it up to just have it checked will make it show and i have gotten it to work that way. The new problem I am...

Ok on the search form it is not even letting me narrow it to just shows. I put in the forms!search!checkshow in a column but it still is pulling everything. The date range portion is working fine though. Attached is screenshot of my query screen since it will not let me save to an earlier version

In the database I have a yes/no for the show & pending fields and in the initial form (Entry Form) I have a checkbox. The new search form also has a check box for the same fields along with a combo box for Reps. In regards to your other post if i was to put that in the column i did tire it...

I was wondering if anyone can help me I have a search form that users list date range, whether an appointment showed or is pending (Show and pending are seperate checkboxes), and then agent. On top of that if a field is blank I want it to pull all records with whichever criteria has been...

The checkboxes are for Pending and Show for appointments they are listed in the query as well but i would like to be able to 1) search for date range 2) to be able to narrow it down further by checking if the Show or Pending box is checked. If that makes any sense

Thanks that worked perfect. One other problem I have in the same search form i have 2 checkboxes what would i need to have in the criteria to get it to pull the records marked yes? Sorry i am pretty new to Access

Sorry i guess my title wasn't very conherent. I have a form that pulls from a query in the query is the code listed above in the Criteria field. Is it possible to make an adjustment to it to post all records if the date fields are empty?