Recent content by accessliz

Hi I obtained an access database template which manages calls logged like a service desk type thing. it works really well - but I have no idea how this has been put together to try to alter it, but I am after an alert email to be set up once a call has been assigned to someone? - is that...

sorry if i made no sense ( i do that a lot) I have re-looked at it this morning and I had inputted the fields incorrectly; I had left year(snapshotmonth) in rather than changing that part to year(DownloadDate) - once I viewed it in design view it made sense. (I really need some training in SQL)...

I am quite happy to look at a years worth anyway! just to get a monthly trend. and im not interested in the year column; although it is a nice bit of code :) So thank you for all your help! - i can get what i need from this perfectly :)

wow thanks, very fast my table is called RTTsnapshots and my field is called DownloadDate but i have just overwritten your fields in brackets with mine :) this has worked brilliantly! but the years dont make sense and it hasnt gone and further back than 12 months? thanking you kindly...

Hi i have a dataset containing snotshots run every friday; But its getting too big to churn in excel in my dashboard so i want to add some criteria to my query which picks out the latest friday/date of each month? :confused:i am at a complete pickle on how to do this, as it would have been...

Hi - can i bump this - i am in the same situation - how did you get on? i too have looked at the templates and they are a little too much for my husband to use, he is not technical i need simple like you have asked for? and table of stock, stock amounts, and orders and a simple form that if...

I could kiss you! it works perfect :) - thank you very much ps sorry for being a bit slow - you learn something everyday

does the reference bit get pasted in too? Oh sorry - i dont understand thanks and i doubt i would have figured that out me thinks! - meant im glad i asked the question becuase i would have never figured all what was needed to insert a hyperlink

thanks very quick and i doubt i would have figured that out me thinks! its not working though, when i click in the box it pops up with private sub in yellow, and filedump as filedialog in blue ? thanks

Hi i have a table of calls, with a field called "link to file". i have a form where staff fill in their calls and when they have completed the call there is an option to insert a hyperlink to where the file is stored. i previosuly had an attachemnt there but the database would just grow and...

Hi not sure how to explain this, im not the best of access users and i dont understand SQL. i have a table of patients having operations. I have columns consisting of: OP DATE, PT NUMBER, THEATRE ROOM, SentforTime,TimeinAR,TimeinTH,TimeinRecovery,TimeoutRecovery i need to work out the time...