Search results

think i got i placed me.requery in a event procedure (After Update) of the combo box on the main form that selects the "lesson" (fld_lesson_id) thanks for yall help

Wayne - the db is fairly big, and it would be next to impossible to strip it down....although if i cant get a solution, i may see what i can do about posting it OSB - yes the tables have a join based on the field fld_lesson_id... what is happening now is when i open the form, the subform...

i have a form bound to a table, user fills in various fields, one of the fields has choices of math lessons, user selects a math lesson and at this point i need a subfrm to populate with references that go with this specific lesson....the references have already been aligned to the math lessons...

i am having one problem the field i am stringing is a list of page numbers when i sort ascending i get a string such as: 108, 168, 35, 36, 62 i want it to read 35, 36, 62, 108, 168 i think i need to add a zero in front of the 2 digit numbers is there a good way to do this?

Thank you, I just had stumbled on a post of yours from a while back to this very link...i thought i had searched the forum fairly well before i made my post but i guess i was in too big of a hurry.....thanks and sorry for troubling you with ONE more question of this nature incidentally, the...

i need to create a query that concatenates multiple rows based on another fields matching records example: record # fld_Book_Title record 1: The Three Bears record 2: The Three Bears record 3: The Three Bears record 4: Green Eggs and...

thanks i will give it a try

Is there a way to NOT ADD a record, if that record has already been added the field is a rich text memo field I have like 2000 lessons to add in a rich text memo field some are duplicate lessons...i want to be able to add the lesson in the field and have the db check the lesson (string) and...

o' happy day! works like a charm!! thanks so much

ok i must be missing something here i am still getting the same error "wrong number of arguments" maybe i am putting this code in the wrong place its in a field row of the query

Rich i tried using the above syntax but i get an error stating the function has the wrong number of arguments...

is there a way to concatenate 4 text fields, and leave off the text between the & " " & if the next field is null?? EXAMPLE Resource: [fldreference] & " " & [fld_free_text] & " " & [fld_txt_book_lesson] & " pp. " & [fldpages] gives me: "The Math Book of Addiion", "Adding 2 and 2". pp. as...

i had a problem with wizards and access 2000, click on the link to see how i corrected my problem..not sure what version you are using but this may help http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=53895&highlight=wizards

hi jack how ya been? you probably dont remember me, but you helped me with my first db a couple of years ago..through this forum...and i learned so much from you...just wanted to say thanks...and thanks for responding to this post... about the post...i think i didnt do a very good job of...

i have a form with a bound subform on the main form i have combo_one that when selected displays all records relevant to that record on the subform the main form and subform are linked via the id that is selected in the combo_one the form is bound to tblalpha the subform is bound to tblalpha...

Thanks Wayne

i have popfrm_B which passes criteria via Combo1 to frm_A 's query populating many fields on frm_A using [Forms]![popfrm_B]![Combo1] in the Criteria field of the appropriate field popfrm_B opens via CommandOpen which is placed on frm_A all works well except, when i open frm_A, i get Enter...

Wayne Works great! Thank you so much. My final code as follows: Private Sub Combo_brief_GotFocus() If IsNull(Me.Combo_standard) = True Then Me.Combo_brief.RowSource = "select fldtplanid,fldtplan_brief_description,fldtplan_label from tblmimtplan where fldmim_core_id = " & Me.Combo_Component...

i have the following code as the rowsource that provides the selection for the combo in question...i am not sure how to change the existing code to incorporate what you suggested....do i just add another line??? if so, could you please explain..thanks Private Sub Combo_brief_GotFocus() If...

i have a form(frm_Alpha) record source is tbl_one and the fields are fld_one_id (auto number_primary key), fldA, fldB, fldC, fldD, and fld_two_id (foreign key from tbl_two) i select a record from comb_fld_two_id (bound to tbl_one.fld_two_id), populate fldA, fldB, fldC, fldD then click a...