Recent content by Crabbymcdo

Figured a fix to this myself, it was a fault with the table link on the form itself, although I could set the textbox to be linked to the correct field in the table it did not recognise it until I also set in on the actual form itself.

Still really need help with this if anyone can help please guys??

Indeed this database was created in 2007/2010 being run on 2010, time function works perfectly but it is just the date function that does not

Hi Guys need a bit of help I have an access database that has been working perfectly, however it suddently stopped working as it should on Friday last week. let me explain what it should do, on my database I have CLOSE CALL option when you go into there I have a section with Close Date...

ahhhh fixed it, thanks so much

Ok final question, in my original post, I would receive an email when the call has been closed, how can I now reincorp this as it now doesn't work,

Ah right ok got ya but how do I stop the closed ones from showing in the drop down I can see you have done it in the copy of frmcallloggedpage but I cant see how you have done it

Ok, don't get it, I made the changes that you said, but now when I load the frmdetails close page it starts with a clear sheet which is perfect but then when I choose a call log from the combo box it no longer selects it. also cannot get the time function to work

also is it possible so put come coding in so that when I select the record from the combo box it enter the current time into the close time for that record and not the first record in the table

Hi Pr2-Eugin thanks for coming back to me, I see what you have done there, basically that may work but I wouldn't want it to go back to copy of frmcallloggedpage but to go back to frmwelcome but then when I go back to frmdetails close. also once a call has been closed I don't want it to show...

pr2-eugin has been most helpful, but if anyone can answer my last question I would most grateful as I have no idea how to do what pr2-eugin has suggested

Please see most up to date database with full flow available to you can hopefully see what im trying to achieve

right ok, could you possibly show me that in the document you sent me earlier, also would that stop it showing in the combo box after closure

the reason for this is that the first table is basically a table of Open calls, when the calls are complete i still want to keep the data as a record of work done so want the data to be moved to the tblout

Sorry ive not made myself clear, basically what i want to do is select the record using the combo box i then have code on a button (CLOSE) that needs to move the selected record from tblmain to tblout