Search results

hi i have a db that sequences lesson plans users have to add a lesson for each day (5 per week) and 9 weeks per quarter i have a form that they use to sequence the lessons what i would like to do is add (to this form) a visual of sorts or a chart ...something that shows them how much of the...

i got it working using the code below =DCount("[fldOne]","tblRED","[fldOne]=1" & "and [fldTwo]=45")

I have place the code below (example A) in the control source for a text box on a form and it works fine but i need to add a second criteria to it...i cant seem to get the code (example B) to work (i get no results)....any ideas? thanks EXAMPLE A =DCount("fldOneID","tblRED","fldOneID=2")...

hi gizzmo the modal is set to no

i am trying to make my report open up on top of the popup form that opens it i used some code from a previous post as you can view below... and i get the following error "expected variable or procedure, not module" i havent used modules very much anyone know what i am doing wrong? thanks...

ok i was hoping that was the case thanks so much

hi kevin the example you posted only uses one listbox my form has 3 listboxes that users have the option of making selections from can the example you posted be modified to accomadate 3 listboxes? thank you

thanks for responding could you please explain a bit further ..

i am using a form with 2 list boxes to pass selected values to a query/report this code works if i select only 1 item from each list box, when i select different combinations of values (for example 2 items from LBox_Grades and 1 from LBox_Standards or varous other combinations) the report opens...

pat thanks for hanging in here with me sorry i am a bit thick headed ok i found some posts as you suggested and have made the following changes 1. have the list box (LBox_Grades) on the form (popfrm_rpt_ISEQ) set to simple, no codes 2. have report1 with the rowsource set to query1 3...

hi pat thank you for responding i have searched and found several samples .....but none that pass multiple values to a single field for the purpose of opening a report...i found one that was close ...it passes mutliple values to a single field but then runs/opens the query..i need it to do this...

i have a form that uses unbound combo boxes to pass values to a query for a report....what i need to add to this is a way to pass multiple values to ONE field in the query presently i use: combo_grade ....which is populated with a list of grade levels ie first grade, second grade, etc....this...

thanks for your help ken. got it working here is my solution 1. placed the following code in a field row of an empty query grid (one exp as below for each value (via combo box) i pass from the popform) Combo_1: IIf(IsNull([Forms]![popfrm_Red]![Combo_1]),[fld1id]=[fld1id] Or...

now the error is the expression is too complex....i placed in the query grid (criteria row) is this the problem?

thanks a ton i will try it in a few

hi ken i tried the code and got this error message the expression has a function containing the wrong number of arguments thanks for your help

i have a form that passes values to a query via 3 combo boxes code as follows (for each combo box) [Forms]![popfrm_Red]![Combo_1] what do i add to this code so that if any of the 3 combo boxes IS NOT needed (no value passed to query) the query will just ignore any of the combo boxes that are...

hi wayne i can bring up a specific record to edit, however, i am not sure how i bring up the record (from another table) to replace a record in a "specific field" in the record i think an example might be more clear: tbl_Sequence fld_sequence_id fld_grade_id fld_state_id fld_gradingperiod_id...

i have a bound form (to a query) that i want to use to edit records in a table currently i have no problems finding specific records, i am just unsure how to handle the edits ...my vba skills are a quiet limited the form has 10 combo boxes, 4 text boxes and 6 rich text boxes i need to be able...

by george i think i got it.... using the following in an event procedure of the combo box that selects the "lesson" on the main form Private Sub Combo_Lesson AfterUpdate() Me.Requery End Sub thanks for yalls help