Recent content by Parariddle

Hi All I am looking to create a stored procedure to run multiple stored procedures. I want the procedure to truncate all tables and upload files and loop where the date is between 2 dates then stop when the last file has been uploaded. The other procedures are the upload and format...

Hi All I have a query which calls information from 2 tables. The tables are linked by ReportID, A Prim Key on one table and not on the other. Now for some reason in my query they join will work once but when I try to base a report on it the join slips and the query goes caput. Any ideas...

Hi Guys Hope you can help. Am looking to start doing websites using wordpress as a cms. Any suggestions on a good host that will provide me with a good amount of SQL dbs and also is fairly cheap. Thanks

Its based on a table that produces all reports for a year so staff can go in against them and tick them off once they are complete

SELECT DISTINCT tblReportInstances.InstanceID, tblReports.ReportID, tblReports.ReportName, tblReportInstances.DueDate FROM tblReports LEFT JOIN tblReportInstances ON tblReports.ReportID = tblReportInstances.ReportID GROUP BY tblReportInstances.InstanceID, tblReports.ReportID...

Thanks for the reply cheap but still not getting the desired result and am still getting multiple entrys for the report name unless I have the dates unshown but I want those to be returned in the following combo box.

Thanks Missingling I put that into the query and have refreshed everything but it doesnt not work. I forgot to mention report name is drawn from another table via a link and not sure if that would make a difference ?

Hi Guys I have a combo box based on a query which has these fields Instance ID Report ID Report Name Due Date What I want is the first combo box too bring back a list of report names and the second to return the Due Date for that particular report based on the selection. My problem is I...

Thank you so much cameron for your help I have tried to overload your reputation ha ha This is all working smoothly now so thank you !!!

Hi Cameron Thanks for all your help I really appreciate it. You have helped a lot in lifting some of the fog. My question lies in the VBA code you provided previousley and where to use it. Are you referring to adding it too a button or on report open ? Ideally I would like the manager to...

Wow Doc thank you so very much for this and for your time ! I will try this Monday at work and let you know how it goes !

Hi Guys Thanks both for you help. What you are saying sounds spot on but please could you elaborate a little as I am fairly new and what do you define as interval type ? Also how does that VBA tie in with people recording what they do. The 2 main functions are to allow staff too record...

Thanks Rainman Being a noob could you perhaps give me an example of that would work. So afterupdate text box =dmax value of a query ? I can not find how to call the value from the query in VBA ? Thanks

Hi All I am trying to populate a text box with a field from a query. After updating a combo box I want the text box below to show the latest value (in this instance a date) in a query for a set field. So Afterupdate, Textbox = Max Date in Field Next Due. Any help would be much...

Ok so a walk home certainly clears the mind ! Thanks for the thoughts namliam and your right but the query was correct. The problem lied in that frequency was a lookup so it was a number not the text so I have rectified that and it now works. Thanks to everyone who helped I appreciate all...