Search results

Nah, I don't really need to know the last edit date. The "last contact date" field is there just to track when we last made contact with one of our company contacts, just to keep up to date really. And thank you.

At first I did want to save what's in txtPreviousDate so that closing the form doesn't delete data in there, but now, come to think of it, it's not really necessary; it's proves no benefits.

As per request of vbaInet, I couldn't upload the database as it's for work and got confidential info, but I made a sample one with the relevant table and form with the same settings and that one happened to work. I realised, the difference between the two databases was that txtPreviousDate was...

This is what it looks like after I add the 2 lines in, but it doesn't work. Private Sub cmdContactedToday_Click() If MsgBox("Did you contact this referrer today?", vbYesNo) = vbYes Then Me.txtPreviousDate = Me.txtDateContacted Me.txtDateContacted = Date Me.cmdUndoDate.Visible = True...

This is all the code in the form Private Sub cmdContactedToday_Click() If MsgBox("Did you contact this referrer today?", vbYesNo) = vbYes Then Me.txtDateContacted = Date Me.cmdUndoDate.Visible = True Me.cmdUndoDate.SetFocus End If End Sub Private Sub cmdUndoDate_Click()...

LastContactDate That's it. That's the name of the field in the table btw

Thank you, exactly what I wanted. You just helped me in my previous thread too lol. Please try help me in this one: http://www.access-programmers.co.uk/forums/showthread.php?p=1360564&posted=1 Thanks so much.

I'd like a confirm dialog to appear on button click, so when the user clicks 'yes', the on click event should continue and when the user click 'no', the event should stop. Thanks.

Okay thank you

Thanks it works. I didn't use the repaint thing though. What does it do?

What vba code would I use in the on click event of a command button to make another button appear? Thanks.

I don't know which textbox you're talking about but neither of them have a formula as their control source by the looks of it. There's just the names of the fields in the control source property.

Sorry, forgive me for my ignorance. How do you know if a textbox has a formula as its control source? How do you change that? And which textbox are you referring to? txtDateContacted is bound to a table and it needs to be that way. txtPreviousDate is unbound.

It didn't work. I put the code you detailed into the "On Click" events of each command button, cmdContactedToday and cmdUndoDate respectively (using the Code Builder). Btw, before I entered your code, I deleted the code I had on cmdContactedToday, because I recognized a repeat of a similar...

What do you mean 'revert'. And no, I don't know how to code VBA, although I do understand it a little.

In my form, when a button (cmdContactedToday) is clicked, a text field to the left (txtDateContacted) is updated with today's date. However, before this happens, I want the the current date in txtDateContacted to get stored in another (hidden) text field (txtPreviousDate) Then when another...

I've solved the problem! Thank you everyone who answered. FOR FUTURE VIEWERS: The reason I couldn't enter data into my form is because the 3 tables were related using the one-to-many relationship. It's fine like this with 2 tables because Access can just show multiple records for 1 primary...

If you'd like to execute a macro on startup, name it "autoexec".

Nevermind. There's too much labour involved in doing this. It's not that important; just would've made for a better layout. Thanks anyway.

You're right. There's little point in doing this. Thanks anyway.