Search results

i have tblDates that has two number long integer fields named FiscalYear and FiscalMonth. then there is my field PerSeq is number long integer. in my Query1, i have 2 fields that use a question in the field part of the qry like: Desired FiscalYear: [Enter Fiscal Year] EG 2007 Desired...

when i change records, my subform that has a memo field, shows the memo field data is "highlighted". i can make a mistake and hit any keyboard key and the memo field data will get erased. is there a way to prevent such a problem? if not, is there a work around. eg, hide the memo field until...

Lagbolt. I think you did it. i changed the autoExpand to NO as you said. it did look better. so for any other readers of your great piece, here is a summary for them. Private Sub CboFormulaNameFilter_AfterUpdate() '=====6-16-2006Lagbolt method =================== DoCmd.ApplyFilter , _...

This procedure is almost perfect. You get my Thomas Edison award tonight. You definitely followed my need. it does drill down to any formulaname containing the typed in characters. anyware: start, middle or end of a formulaname. the only problem now is: say i typed in Sca. i get 5...

OOOHHH wee! i think it is working now. i am sorry for not understanding the need for ON Change event. i never used it before. also, it sounds to me that you are saying that your code is supplemental to my initial threat vba. correct? in summary, here is what i have in just 1 combo box...

thanks for the note Lagbolt. i see now. you want me to replace the code. this is not working yet. I can pick a formulaname that only starts with my choice eg BLA for black. but the record i picked is not pulled up. plus, if i try to repick, i only get records with black bean and does not...

Lagbolt. i now notice your autoexpand note. i changed it from Yes to No. interesting. when i tried BLUE (and it does not exist in my base), i get a nice error message telling me that blue does not exist. i like that. so maybe you fellows can help fix my last post. penwood

Hi Lagbolt. I got an error with the last code. did i code this correct? my combo box with the arrows is called cboFormulaNameFilter. was i supposed to continue Larry's idea using a 2nd box called cboNameSearch which has no arrows? =================================================== Private...

Larry - i must have done something wrong. i get all the records after typing in Black in the new field first. i made a text box field named cboNameSearch. Then i made the VBa change. I probably wrote something wrong. ================================================== Private Sub...

How can i do the following? In a combo box, how can i type in say PEPPER and see every formulaName that contains Pepper in their description. I would get back Red Pepper, Orange Pepper, Black Pepper, Pepper, to choose from. Notice that Pepper can be anywhere inside the name. I would like the...

It works. Thanks so much. You are amazing. First time i had a need to use that qry, paramater box. Penwood

I have a Qry1 that contains a criteria of: Between [Start Date] And [End Date] I eventually use a crosstab Qry2. The wizard does just fine. but when i run the crosstab, i get an error message: "the microsoft Jet engine does not recognize "start date" as a valid field name or expression." Is...

I fixed it. it was me. the recipient field was set at just 8 characters. i made it bigger. now all is fine. thanks alot.

this basic vba in the ON Click did me well for most ADD things. Private Sub AddEmployee_Click() DoCmd.GoToRecord , , acNewRec End Sub see if it works for you. but be wary for more complicated Add Vba needs.

i have a combo box on a main form. The name is cboFormulaStatus and control source is FormulaStatus. the control source is a Text field with 20 possible characters. The Row Source seems simple with: SELECT [tblFormulaStatus].[FormulaStatus] FROM tblFormulaStatus ORDER BY...

Thanks alot. your calc works nicely. and thanks for the improvements too with explainations. that was so thoughtful. penwood

Need Different quotes after change to TEXT i have this qry field that works fine if my formulaID is a NUMBER field. UomUsageSum: Val(Round(DSum("nz([UomUsage])","[tblFormulaDetail]","[FormulaID] = '" & [FormulaID] & " "),4)) However, i just changed the formulaID to TEXT in my table. So I...

I figured it out. Here is the solution if someone wants it. Or if someone has anything better. but this will do. TotalUsage: Val((Round(Nz([UomUsage])/DSum("Nz([UomUsage])","[tblDetail]","[SubID] = " & [SubID] & " "),4)*100)) P

Dsum need 1 field inside divisor calc I have a Qry field: TotalUsage: Val((Round(Nz([UomUsage])/DSum("Nz([UomUsage])","[tblDetail]",),4)*100)) the problem is that the DSUM needs to sum up all the like records using the same SubID. I need some extra code in the divisor part. EG subID...

The following report method works on an old project but not on this one. I am missing a step somewhere. I have a Report Menu Form. I use Popup=Yes on all my forms and modal=NO. On the Report Menu form, i have 2 unbound combo fields to pick a customer SoldtoID and ShiptoID. I next hit my...