Search results for query: *

Before I go -- I couldn't resist trying to read and follow how the code works... I'm trying to wrap my head around how the: BegDate = DateAdd("m", 3, BegDate) ...isn't self-referential and wouldn't make the database crazy... (how could X = Y+X... unless Y = 0...) And I'm not quite getting...

Thank you so much for your replies! And AceMan: You've helped me before if I rightly recall, waybackwhen, and I do _very_ much appreciate it! Your analysis exactly understood the problem at issue! Meanwhile: I'm constantly getting drawn away and assigned to do all-day projects (such as...

CORRECTION: Where I referred to the way Access appears to calculate quarters, I should have given the 4th quarter as starting on 10/01, not 12/01. C. Reyes

The following applies to Access 2003 on MS XP Pro On a form, I have a field [CurrIspQtr] that needs to give a count in 3-month periods, between the current date and a begin date which could be any date of the year. That is: the required Result is the number of quarters from date X to today...

yes, it's been forever.... I actually found, with some more experience with If-Then code and how ElseIf works and the proper order of things, that I could get it to work exactly the way I needed with just the Else/If statements properly coded. The code goes on the Current event of the...

I'm so sorry I have not responded earlier... was out sick; and on returning have been assigned a completely unrelated report that will take some doing, and can not focus on this right now; it'll probably be a couple days at least. I _so_ appreciate your efforts but am really between a rock and...

Somehow I'm not making myself clear at all... it isn't how to flash the text that I need to know! I can get that to work fine once I have entered: Private Sub Form_Timer() With LblProofGd1 .ForeColor = (IIf(.ForeColor = 14013951, 106, 14013951)) End With End Sub in the On Timer event of...

I just found that my cutting and pasting caused some extra code to show up when I put in the code that includes comment lines. It should end with: End If not: End If If Forms!frmClientInfoEnter.TogBHasGuard = -1 And Me.ckGuardProof = -1 Then End If (plus the assumed End Sub and whatever...

TheAceMan1: Thank you for giving so painstaking a reply! I'm humbled. meanwhile... there are more than several reasons I use two boxes for the two lines. First of all: Access's line break behavior (Shirt-Enter also works) usually puts the lines too far apart for my taste, so I find myself...

I have a subform fsubGuardianhship that has on it textbox ckGuardProof with a two-line label that uses two label controls: a transparent control LblProofGd1 containing the words "Proof of Guardianship", and a second label LblProofGd2 that provides a background and the second line of text, "in...

Thanks – code worked great! C. Reyes

Okay... so your're saying the suggested code actually still uses the BeforeUpdate event and would go after: Private Sub Form_BeforeUpdate(Cancel As Integer) Sorry I'm so thick if this seems obvious.... C. Reyes

I have a problem similar to that in thread702-1453633 where user 'sheuz' was trying to "Provide the user with the option to save/undo changes made to the record in the form." The code I'm having trouble with is similar to sheuz's (myYesNoQPlus is a public function that simplifies creation of a...

hm... looks like I can work with this.... I've got shotgun deadlines thru today but If I can't get to working on it today I should be able to let you know how it went no later than next Monday. For general reference I am also attaching screencaps, showing the top part of the...

I have a an add-new form, frmPersonnelAddChange, that users are to invoke to add a new new professional (such as a Case Manager) associated with a client. Info for different types of professionals is listed in subforms on different tab control pages (e.g. a tab for Case Manager, a tab for...