Recent content by m40wen

Thank you so much! I fudged it and it was as easy as this:- Private Sub Resolution_AfterUpdate() Me.Date_Resolved = Now() Me.Time_resolved = Now() End Sub And then changed the fields to medium time and date as appropriate.

Ok, I was trying to put the following in my "Resolution" field to update the "Date resolved" field in Afterupdate Select issuefrm.date resolved = Now() But this doesnt work. Am I missing something?

Hi mate, Thanks for the response but I still dont really understand. Is there not a simple way of on the afterupdate property of the "Resolution" field to go to the "Resolution Date" field and put in "=Now()"? Is the code necessary - not being funny just trying to see how Access works. Any...

Sorry guys, I thought this would be simpler than it was! Basically I just want to update my "Resolution date" field with the date or time now (which I know how to do) but AFTER I input data in my "Resolution" field ie I want a field to automatically record what time I am entering the text in my...

Thanks Pat. Just like to say this site is awesome! Many thanks!

Morning all Ok, I am going to try and break this into pieces. How do I check the data of one field (lets call it Download Buy/Sell) matches what I type in (say Manual Buy/Sell)? For example a fax order comes in, I look up the reference and start typing the details in my form against what I have...

Hi Guys Just like to say that I am almost ashamed at how little I know about access, so I guess over the months I will be taking out alot more than I will be putting in! Anyway, I have the following project to do. Basically it will be necessary to download from an ODBC database on a daily...

Thats great, thanks for taking the time

Hi all, I am very new to Microsoft Access, and hope somebody can help me. Apologies for what I am sure is an easy subject - but I dont know what keywords to search on! Basically, I need to have a drop list of say 5 different products. Now depending on the product will lead to different field...