Recent content by AMC31

It still does not let me change the VerbalDue & Narrative Due manually. There may be some instances when they have 10 days to return the VerbalDue. HELP!!!

OK...your code words if FileStart_D is always the current date. But it is NOT. I don't think you understand the question. A box is checked...todays date goes into the FileStart_D field. VerbalDue and NarraDue are 7 & 14 days following. I use the DateAdd function, but I need to have the...

I love the way you are so sure of yourself...:p I must be a dummy...I have attached the database Open frmBroker When you check File Started three things will happen 1. File started date will complete todays date. 2. Verbal due will complete 7 days from file started 3. Narrative due will...

Thanks. But I still can not make changes. Let me explain in a little more detail...When a new project is started, the File Started check box is checked and the Date field is automatically entered with todays date. That date can be manully changed if necessary. After the date is automatically...

I have a field [VerbalDue]. I have used the DateAdd function to caluculate the date; however I also want the user to be able to manually change the date. Control Source for Verbal Due..... =DateAdd("y",+7,[FileStart_D]) Is this possible? Thanks!!!!

I have a command button on the main screen. I want it to open a form and automaticaly go to a new record. Presently it opens 1 of 15 and you have one more step of clicking "new record" Any help available would be greatly appreciated. Thanks.

Does anyone have any advice for this issue? Please...Thanks

Thanks for the response...however I don' think that will give me the result I need. Maybe this will help Example: Project 1 is Waiting for Info Project 2 has Finished the Report Project 3 is Waiting to review Info. I need a querry that looks to see what the status of each project is...

I have attached the file I am speaking of to hopefully explain what I am trying to accomplish. I have a form [frmBroker] on this form there are 11 steps that are checked off as they occur. Begining with [FileStarted] and the last being [PrintBindSend]. We want to run a report that will show...

OK Call me crazy...but it is not working. I have attached the form. When "File Started" is checked the current date is automatically put into "Date File Started"...[VerbaDue] is 7 days after "Date File Started"...[NarrativeDue] is 14 days after file is started. It is not saving it in the...

I tried that, but I am still not getting the result. When I look at the table that is linked to that form the [verbaldue] field is bland. It is completing the calculation, but not storing it on the table. Any other advice?

I have a form that has two fields...Start Date and Verbal Due. Verbal date uses the DateAdd feature to make it seven days following the start date. I need to run a report on "Verbal Due" dates and set a date parameter. However, when the date is calculated in the form and put in the verbal...

Thanks jfgambit! The copy you sent me duplicates the contact information. How do I show the information, but only record the client number? I know how to pull it out of both tables with a querry, just don't know how to make it "all" display, but not record. This site is great for obtaining...

I do want the First Name, Last Name, Address, etc. saved in the Broker Table How to I make it populate and save as a field in the table?

I have attached the database to help explain what I am trying to do. From frmBroker I want to use the drop down next to Office Name and I want the other contact information fields to automatically complete. Also...when the "File Started" box is checked can the current date automatically appear...