Autofill Date by 14 days

[nyakki]

Hello,

Very new to Access. I searched this forum but didn't even know where to start.

I come from a programming background so I'm not afraid of logic :)

What I want to do:

When someone enters a Date in, say, FieldDate, I want FieldDateDue to be 14 days later.


I have tried many things I thought would work but I'm stumped (even went so far as to read the Help ;) )

Can anyone help or point me in the right direction?

Thanks

[MMcCarthy]

Hello,

Very new to Access. I searched this forum but didn't even know where to start.

I come from a programming background so I'm not afraid of logic :)

What I want to do:

When someone enters a Date in, say, FieldDate, I want FieldDateDue to be 14 days later.


I have tried many things I thought would work but I'm stumped (even went so far as to read the Help ;) )

Can anyone help or point me in the right direction?

Thanks

You have to use a Data Entry Form. In the After Update event of FieldDate put the following VBA code:

Private Sub FieldDate_AfterUpdate()
 
   Me.FieldDateDue = Me.FieldDate + 14
 
End Sub
 

Mary

[nyakki]

You have to use a Data Entry Form. In the After Update event of FieldDate put the following VBA code:

Private Sub FieldDate_AfterUpdate()
 
   Me.FieldDateDue = Me.FieldDate + 14
 
End Sub
 

Mary

Thank you for the quick reply.

How do I find the Data Entry Form to enter the code into the appropriate Field?

Thanks

[cocacrispy]

in design view right-click on the field date text field, select properties, select the events tab, click AfterUpdate, click the ellipsis to the right, choose code builder

[nyakki]

in design view right-click on the field date text field, select properties, select the events tab, click AfterUpdate, click the ellipsis to the right, choose code builder

Thank you for the reply. I really appreciate the help.

I did everything you said there. I don't get an events tab. I only have a "General" tab.

I've been in/out/up/down/sideways with the different fields, different points of entry, different types of test databases and still can't find the Events tab.

I've done every item in every menu option... nothing.

Here is my Properties window.

I am running Access 2003, if that makes any difference.

What am I doing wrong?

Thanks

[NeoPa]

Good reply Nyaki.
From that I can see that you were not in the form, and more specifically, not in the TextBox control before you selected properties.

1. Open the form in Design View.
2. Click on the FieldDate TextBox.
3. Select Properties (Alt-Enter).
4. Scroll down to the After Update property and select [Event Procedure] from the list.
5. Click on the ellipsis.
6. You should now find yourself in the VBA window with the Event procedure started for you.

:)

[nyakki]

Good reply Nyaki.
From that I can see that you were not in the form, and more specifically, not in the TextBox control before you selected properties.

1. Open the form in Design View.
2. Click on the FieldDate TextBox.
3. Select Properties (Alt-Enter).
4. Scroll down to the After Update property and select [Event Procedure] from the list.
5. Click on the ellipsis.
6. You should now find yourself in the VBA window with the Event procedure started for you.

:)

I SEE THE LIGHT... :)

OK... This is what I was doing wrong (or otherwise put... this is where I got really confused...)...

1) I was still in the TABLE design. I hadn't worked my way to the FORM design because, well, I wasn't ready to enter info into the table yet (I was working on solving this problem).

2) I was going to what I thought was the TEXT BOX in Table Design mode (i.e. where you type in the name) and not the FORM Text Box where you actually put in the data.

3) Looking back on this thread AFTER I got this puppy working, I see where my misunderstanding of the lingo came up.

So, for those as new to Access as I am, here is my Totally Green Not Knowing Access At All Step-By-Step:

1) After creating the table OR as you are creating the table, save it.
2) Go to Forms in the Objects list. Open up your Database.
3) NOW Follow all of the steps given above :)

Thanks everyone for helping me out. I'm sure I'll have a few more questions in the future :)

nyakki

[NeoPa]

When you posted the properties window you got, I could see what had happened.
This is a good illustration of where intelligent communication can get you where you need to go without the need for various posts backwards and forwards - one side trying to understand the other.

[ArchMichael]

how would be done for business days only, no weekends or holidays

[NeoPa]

how would be done for business days only, no weekends or holidays

You need to ask this question in a separate thread. We don't allow members to ask different (even if slightly related) questions in other threads.

I'm sure if you post this you will find someone willing to help you progress with it.

Welcome to Bytes!