Recent content by tanalee

Aloha... I don't have Access available at the moment to experiment. May I ask what is special about On Click? How about On Enter? What is the code you are trying to use? Tana

Aloha... I'm not a programmer, but I wonder if you Dim'd newCombo somewhere. If not, I wonder if it would make a difference Tana

Aloha... What kind of code are you using to get the filter to work? Maybe you need to put something similar in Form_Current? Tana

Aloha... I'm not a programmer, but there seems to be a lot of information under Access Help 'Menus, creating' and 'Toolbars, customizing'. Have youi checked it out? Tana

Aloha... I'm not a programmer, but I wonder if you could add a column to the combo box which would contain numeric values, ie 1, 2, 3, ..., with the matching column being the Activity Type listed in order of priority. Then it seems that you could tell the query to sort on the numeric column...

Aloha... This is from ghudson at another forum: ------------ I use this to create my own record X of Y info... Private Sub Form_Current() If Me.NewRecord Then Me.lRecordXofY.Caption = "New Record (" & DCount("*", "TableA") & " existing records)" Else Me!lRecordXofY.Caption = "Record " &...

Aloha... I'm not a programmer, but I think this is the right direction. On your subform, create an invisible textbox. Make the textbox equal to FirstPriceField + SecondPriceField + ThirdPriceField. (Hopefully they don't all have the same name, as it appears). I believe it's...

Aloha... Yes, it is possible. What are your field/control names? Tana

Aloha, again... I don't know if it's legal to type the code from the book into a forum. Anybody know? The essence of it is to code the BackColor property of the report section to equal one of two colors by using an IIf statement. If the color is white, for example, set the color to blue, and...

Aloha... I just read something this morning about doing that in reports. I don't have the book with me, but the info was in Access 97 Developer's Handbook, 3rd ed. (Litwin, Getz, and Gilbert) in the chapter about Reports. Do you have access to the book? Tana