Search results for query: *

I can get the optiongroup status to change to nmcm with the code that checks a date box. But if I then try to click on a different status button it defaults to the FMC status. Do i have to run code to reset something. with the old code i could click right down the list and change the status...

I thought this would work on the gotfocus of the options in the group. it will not let me change the status by clicking on the status. here is the code i had on a gotfocus on one of the options: Private Sub togNMCM_GotFocus() On Error GoTo Err_togNMCM_GotFocus Me.chkUpdate = True Me.STATUS =...

that was it dhookom!! once i removed the () it worked!!! Thanks everyone for the help [2thumbsup]

yes the module is named something else. in the form when i use the formatoptiongroup( do i put the actual status i want "nmcm" or does it reference the text box on the form which contains the status. the text box is called status. Then is the optgroup the name of option group? which in this...

the formatOptionGroup i put in a separate module. Would it need to be a function then? when i typed the formatOptionGroup and hit space it pulled up the help which shows what options should be placed in there. It does it like other functions i have made and used.

Private someEventProcedure_Event() formatOptionGroup(Me.status,me.OptionGroupName) end sub i am getting a compile error expecting =. formatOptionGroup(me.status,me.optiongroupname) am i replacing the me.status to the status i want "nmcm" and the me.optiongroupname with the name of...

Hi, I have several forms that have the same option group on them that do the same thing. I want to create a public function so I would not have to have all the code listed below on all the forms. There are 5 options and if you click one the others would go back to there default settings. The...

thanks guys, PHV's info worked, and TheAceMan1 i forgot about that site showing the info. seen it before but didn't remember it. Thanks,

Hi all, Is it possiable to reference a subforms subform field? ie. forms!frmBIGONE!subfrmNextBigOne!subfrmLastBigOne.form!anyfieldname frmbigone is the main form. subfrmnextbigone is in the main form. subfrmlastbigone is in subfrmnextbigone. anyfieldname is the field i need to reference. Thanks

I am trying to run an update query and i get the following error: The parameter values are too large. The total length of all the values entered for the parameters cannot exceed 1,024 characters. The field is a memo field and it is just updating the other related records memo field also. if i...

figured it out. I just put the sort order i wanted on the ORDER BY field on the reports data properties. Haven't had go about it that way before, could always set the report source or vba to select order. thanks

okay moved it and no errors. However now it only shows 1 record. before it showed all 59 records but with no order.

removed the comma, now the error is: syntax error (missing operator) in qry expression 'issuedqty where pid = rb3355" thanks,

Changed the code to: Set rsHR = Cdb.OpenRecordset("Select NSN, ITEM, UI, ISSUEDQTY, PID, Count([HRID])as HR FROM qryrptflighthr GROUP BY NSN, ITEM, UI, ISSUEDQTY, WHERE PID = '" & Me!PID & "'") now i get a syntax error (missing operator) in qry expression 'where pid = rb3355

I am trying to get the code below to order by nsn but when i add the code i get an error: 'excute a query that does not include the specified expression 'NSN' as part of an aggregate function.' Set rsHR = Cdb.OpenRecordset("Select Count([HRID])as HR from qryrptflighthr WHERE PID = '" & Me!PID...

is there a way to assign items to a page footer? say if its page 1 use this footer or subreport else use this footer or subreport. dynamically assign an item to the footer. thanks

is there a way to size them in vba? thats right they don't, sorry i was trying subreports and i had them to grow and shrink.

I need to fill out a report with blank records that will fill up the last page of the report down to the page footer. Also, the first page of the report will have a 5 line page footer. all the other pages will have a 1 line footer. I can get the 5 line page footer to show on page 1 only and the...

okay figured it out. Made the query a make table query then updated the row# from that table. Thanks for the help!

cmmrfrds and phv both of your codes work perfectly. However when I take the row # and try to update the table i get 'operation must use an updateable query' I am trying to take the new row# and put that in a table that will use it to base the printout order on. Here is the sql for the update...