Search results for query: *

...

Background: I've designed a query that tracks due dates for quarterly reports based on the anniversary date. I've used PHV's code to ensure the anniversary date is relative to the time the person is entered into the system and it all works perfectly. Problem: I need to modify query so that...

Thanks Craig...as always, I knew I would learn something new.

Perhaps I missed something here but the first solution that came to mind for me was the dateadd function. For my own knowledge is there a reason why the following code wouldn't work? This also seems to work for the Feb 29 issue. [txtDate] = Any date you choose [txtDateExpired] control source...

TheAceMan1...thanks for taking the time to explain your code. I've learned so much from you guys since joining this forum. I will be looking at that common routine function as I'm sure I'm duplicating a lot of code unnecessarily.

Thanks TheAceMan1...code works like a charm even though I am completely lost as to how it actually works...will have to go back and study your code some more.

MainForm = Me SubForm = frmFCPSYCHMEDS Checkbox = FC_PsychMeds This code below works fine for showing/hiding the subform based on whether cbxFC_PsychMeds is checked. The problem is when I check cbxFC_PsychMeds for one record, it makes the SubForm appear for all records rather than the related...

Thanks PHV, I forgot about the principle of not storing a calculated value in a table and I appreciate your simplified formula.

tbxFirstAidStatus located on frmManagers (underlying tblManagers). Ideally, I would like to bound the textbox above to a field so I could use it in reports in queries. Is there a way to do this even though the control source is a calculated value. I can do the above with no problem if I do a...

I think we finally got it guys... :-}. I've been tinkering around with PHV's code and it worked with a few slight modifications. Here's the final code for anyone else who runs into this situation down the line: 'Code to prevent overlapping time intervals for a particular project' Private Sub...

Hello guys...I'm posting back on the results thus far and I'm sure you guys are going to hang me by my toes. I've discovered at least two major factors that may have contributed to code not working after checking all of forms and underlying tables. Problem 1: The bound column was set to the...

TheAce...I'll double check all of my references and substitutions today and get back to you with the results. I'm sure it's going to prove to be something very simple as it's always been.

TheACE...yes, I did.

Hi Blondie...I believe you can accomplish this by setting each of the fields "Required" Property to yes (the default setting is "no"). You can open the underlying table in design view to do this. If someone attempts to save a record with a blank required field, an error message will display...

I'm wondering if it could have something to do with your combobox not being bound? If so, you may want to consider using a bound combobox. If your interested, I have code to enter a new record via a bound combobox when the notinlist event is triggered.

ACE...You hit the nail right on the head as far as the problem I'm trying to resolve is concerned. PHV...I ran your code as is and then I tried a couple of variations. When I went back to my subform (based on underlying input query) and entered overlapping dates, no VB Message was triggered. I...

ACE...frmManagers is indeed the subform. Hoever, the dates I wish to ping against are the START/END Dates of any previous records in the same subform, not the main form. Thanks so much for your patience and help.

Sorry Ace...missed your post. frmProjects is main form and frmManagers is subform. Code is running on BeforeUpdate event of frmManagers. I tried other If statements in lieu of the one we're trying to get to work and they worked fine so I think the form referencing issues are resolved.

I tried out both of your codes for Set sfrm and got error messages both times. The Set sfrm setting listed below is the only one that does not trigger the error message so I think we've made some progress. The only problem now is that the "The start date is included in a previous manager's...

It was a typo on this post. My actual code has frmManagers as in previous posts. It seems like the code ACE suggested is looking for a field rather than a table according to the run time error.