Search results for query: *

Thank you for your resopnse, Remou. I didn't see your thread when I posted the above message... Your suggestion worked as well, when I added the "Else" structure. I will stick with my solution for now, but I think I can use your "icount=icount+1" idea in many ways. Thank you again! Yoko

Thank you, Tom. I put the correct code in OnFomrat, added "Else" condition, then it worked! (without "Else", it didn't). My final code looks like this; Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer) If Me.txtDeptType = A Then Me.GroupFooter1.Visible = True Else...

Hi, I have a report with a department footer with sums for dept 1, 2 & 3. Users want to add a sub total of dept 1 & 2 after dept 2 group footer. I added a DeptKind field in department code table, and set DeptKind of dept 1 & 2 as A, and DeptKind of dept3 as B. Now I set a group footer of...

evalesthy, your solution worked for my form as I wanted. Thank you! mph1, I appreciate your advice as well. Depending on the data, I would consider making another field for Extension. Thank you again, for both of you!

Hi, I'm trying to set up an input mask for phone number with optional extension number. I tried !(999) 000-0000 9999;;_ It works when there is an extension, but when there isn't, it shows like this after I tab out of the field. ( ) 12-3456 7890 I tried left justfied and right justified, but...

I'm posting this for your reference, since I found the solution for my problem on the Microsoft site! http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q300643 I cut and paste the vba module (needed to add one line to define a variable, though), followed the instruction, and it worked. Y

Skip, Thank you for your quick reply, but I cannot send it out...it is kind of a confidential data. Y

Hi, Our user created a complicated XY chart with bunch of data, and he lost his data file by accident. We tried to recover the data, but couldn't. Is there anyway to reconstruct the data from the chart? I changed the chart option to "show value", and I can read some of the numbers, but many of...

It worked! Thank you very much, Roy! This was my first time asking a question on Tek-Tips, and got the right answer in less than an hour...happily surprised! Thank you again! Yoko

I have an append query that uses a variable on a form as a criteria. The criteria of the query is something like this. WHERE ((tblLoanTrans.ControlNo)=[forms]![frmLoanRO]![ControlNo]) I have another form frmLoanDD, with similar but slightly different controls. I want to use the same append...