Search results

I need help with a required field that has different character lengths. I have an input mask that covers the first 7 characters, however, the users are still entering the incorrect policy numbers, I need to put a stop to it. I have 3 different policy number lengths involved, 7, 8 and 9. They...

A new scenario has come up I need someone's help please. I've been trying to calculate a formula for this scenario October 1st following the 65th Birthday Example1: Someone turns 65, July 15, 2005, it should show Oct 1, 2005 Example2: Someone turns 65, October 15, 2005, it should show Oct...

I got it to work... I had to use the "Insert Word Field" feature in Word and I added my "If" statement and Wholla, it worked perfectly. Thanks for pointing me in the right direction "Brian1960"

When applicable, I have letters in Word already set up to show the cc: information at the bottom. However, Management needs a statement added to the bottom of the letters that ONLY show the cc: I am having a slight problem trying to figure out how to make this statement show up only on certain...

Update, I have completed everything above except for #5, #6 and #10...

The premium due dates vary, we have to manually add them off AS400/PDA. The age varaible comes from the link below. I have completed everything except #5, #6 and #10. http://www.access-programmers.co.uk/forums/showthread.php?t=89159 In this instance, I am thinking about just creating 2...

What about these scenarios: The premium due date following the 70th birthday. DOB is 6/24/35 They turn 70 on 6/24/05 Premium is due 12/3/05 I need the calculated field to show 12/3/05 and DOB is 11/14/35 They turn 70 on 11/14/05 Premium is due 3/12/06 I need the calculated field to show 3/12/06

Is there a way to create a field (Table or Query) that contains the Month and Date only and not the year?

Not yet, I was thinking of having it calculate based on the Date of Birth field [DOB].

I need a query that calculates a date that is the first of the month following a specific date. Example: The first of the month following the 65th birthday. Is there any way this can be done?

I am designing a new database for our life and disability department and they have several different policies where the base life insurance reduces at certain ages. Please take a look at the scenarios listed below and give me any suggestions and tips on the best way to get this done. If you...

We already have Month and Year fields, it's just that the report for the previous month is due the following month. So, we can't use today's date as a trigger to update the previous months records.

We run the query based on the Date Resolved field.

Further Clarification: Today, a new appeal is received today and the clerk chooses Add record and enters the record but does not need to update the Incomplete and Complete. In two weeks, an analyst goes in and works the appeal, but needs to send it to the medical director or outside vendor for...

I do have Add record, however, a clerk adds all the new records and then the Analyst goes into the record later when it needs to be worked. It's when the Analysts works the form is when this option needs to be changed from null to incomplete. Then the may have to go back into the record again...

We have a report that is generated monthly to management on Excel. We Export the data from an Access query to Excel and at that time the user has to update the Month Reported and Year Reported fields on each record within that query. Can I set up something to where the user can click a button...

I have a form where the users need to update an option group when they enter any information on the form. The problem is that the users don't always update this option group. The option group does not have a default value and has only two options. When the user updates a form they need to...

I have a form set up where user's type in an explanation of how a claim is being appealed and resolved in a memo field. One problem, for some reason management doesn't want these explanations to end with a period. But the users keep ignoring our request and keep using the period. Is there a...

IF I make this an unbound object will the data in this option group update the table? I need it to continue to enter it's value in the table.

Great, thanks for your help I will make the changes at work in the morning and let you know how it goes or if I have any problems, work is only 9 hours away now.