Search results

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.

THANKS i AM ALSO TRYING TO GET HISTORY FIELD TO WORK. ma trying to create a history field where by I enter the notes and then the notes appear in history with a time and date stamp, i belive it has something to do with =coloum history expression. the form is called job details and it will link...

Re: Hitory Ok I am creatting one form via multiple subforms, to enter call details, customer calls in and i log the details etc and then when it comes to the fault description i will be able to enter a description of the fault and if anyone calls in chasing i will then be able to add notes that...

Re: Hitory Sorry i think the easist way to explan it is i enter the notes regarding the job i press enter the txt box i guesse if you wanna call it then transfers ito to history box where it is time and date stamped and displayes what i have just entered like so customer called at press...

I have two fields one call notes and one called history What I want to happen is the following is i enter the note in the notes box i then press enter and in the history field i get date time and the note details. whilst the note box autmaticaly clears i have the two fields as i still want...

Hi it is in table call details because thats the design of the tables that you had created but i will delete it. never used dlookup in access know bit about lookups as in lookupwizard that about it.