Search results

no i removed the control stuff and made my own on my form but i need to display the current record im on, because it doesnt display it cuz i removed the status bar thing.

this might help me with my filter.. thanks.

thanks ................

hi, i have a vba script that filters my form to certain specifications, but for some reason if i select a filter and it filters something with no values it changes my whole screen blank, .. what is causing htis? how do i fix it? thanks.

these are the 2 functions im calling to filter my form.. its a form with a subform inside of it and they both get filtered when the combo box is selected. now the problem im having is frmWHSEgroup() is filtering fine, but with the invitem filter, if i have an item that is filtered, and i select...

hi as of right now im filtering my subform with WAREHOUSE_listview.Form.RecordSource = "SELECT * from master_inventory WHERE ([tblinvpn] = frminvitem & [tblinvgr_flag] = frmwhsegroup)" can soemone tell me whats wrong with my part that says : [tblinvpn] = frminvitem & [tblinvgr_flag] =...

is this possible? i want to make sure my form is centered correctly in access, is it possible to center a subform in a form to do this?, and also how would i maximize access automatically when it starts? or do you jsut have to set the windowsize yourself?

oh wait duh, nm

hmm having trouble to get dcount working, .. any other suggestions? im doing =dcount("table","field") in the controlsource..

how do i get thetotal number of records off a table? right now im using count(table!field) but when i filter my form it filters the total number, thanks for the help-

thanks so much

how would i find the oldest and newest date in a form?

hi i have this textbox im using to display the total number of items (filtered) in my form, as of right now im using =count(tbl.tblitem) in the control source to display the value, but i can't figure out how to make it display the filtered value ... if anyone could help a function, method...

can someoen give me an example of a vba that would change the value of a field in a table to whatever that is set in a combo box when you clicka button? thanks.

hi, im trying to apply a fitler to a form and a subform with 1 combo box, here is my code, the subform seems to filter fine but my main form always has problems ive tried combinations of different ways to do it but hopefully someone here can help me out thanks a bunch. Private Sub...

sorry im new to this all, i figured how to apply a fitler to a subform, but now im having trouble apply a filter to the main form itself that contains the subform, can someone tell mewhat to point my me.filter = "" stuff to? thanks.

hi, i was wondering what would be the best way to get the total records of a filtered form, sorry im new to this, i know its soemthing to do with the count() function in vba, but i dont know how to get it to point to a filtered recordsource, i also was curious why when i do a me.filter =...

hi i have this subform that's shown as a table inside my main form, i was wondering how i would have a combo box on the main form that applied a filter according to the user's selection and applied it to the subform. thanks as of right now im using private sub frmwhsegroup_afterupdate()...