Recent content by AndyPandy

This code does not work it shows run time error can anyone fix this x

I have two work books the 1st work book as a hyer link that is liked to a specfic sheet in another work book but after 24 hours when i come back to use the sheet, its says hyper link not valid. yet it works when i re- do the hyper link, I do not wish to do this everytime. is there away of...

Hi would you be so kind and take a look at this and help me please. http://www.access-programmers.co.uk/forums/showthread.php?t=263504

Can Anyone help with the following. I have a form with 3 subforms onit i have managed to get them to reqeury after they have been updated however the form does not refresh automaticaly to show the changes i have to save close down and then re-open. I only need each subform to refresh after...

Thanks. I am trying to do without altering the main form the only way that would work realy wouldbe to have a duplicate form set up running that command, I idealy want to try and do it on one form but have the command button on the call list form tell the form what to do when pressed etc. as...

Hi there I have created the following database and want to know if the following is possible I have no programing experience so would like to know if anyone can resolve this bit for me. I have a main form called non contracted call out form and then a form called call list. from the call list...

Hi can someone please explain to me how i create an attachment field within a table that will store say documents etc, ive seen in templated that in table design you have the option to select attachment but in office 2010 /07 it appears to be no longer there only the OLE object. When i try and...

Write I shall try again I have created a main form that contains customer name and address then a subfrm that holds the call type and the operater details, the next subform i am trying to create is one that holds the job details who dispatched it and notes. 1. it should store the job details...

Write I shall try again I have created a main form that contains customer name and address then a subfrm that holds the call type and the operater details, the next subform i am trying to create is one that holds the job details who dispatched it and notes. 1. it should store the job details...

Please use this attachement instead

I have created a main form that contains customer name and address then a subfrm that holds the call type and the operater details, the next subform i am trying to create is on that holds the job details who dispatched it and notes. i have created this for as jobdetails form however i cant...

Also can you advise how do i get spaced to appear between each section of this as it stands at the moment it combines it all into one word. Expr1: [eforname] & [eSurname] & [eEngineerID] & [ePhoneNumber]

when i enter the note i need the date and time in the datime field to be added automaticaly etc so would it be better to have two seperate coloums one for date and one for time. or will =date() & time() work

I know you can do now() date() time() is it possible to combine both date() & time() as one default value

Re: Hitory Hi I will proberbly go for this however what fields would I need int the tblhistory i know how to do the junction table.