Search results

any code you may have that could help?

hello all, okay so i have a query which checks which tasks are between 1 and 3 days by using the date due and the current date to calculate the number of days and therefore sending out the email. this works perfectly. however, how can i add to this where if a user completes a task the email...

thanks man. however, i now have the error of run-time '3464' data type mismatch in criteria expression

i have this piece of code but i keep getting the run time error. What am i doing wrong? MyEmpName = DLookup("[AssignedTo]", "Tasks", " [AssignedTo] = " & rs!NameNew)

okay ignore that now do you understand what i am trying to do. if you have a look at my screenshot you would see that it is indeed pulling the correct information but it just gives this error

hi okay a user has the choice of running a report by a date selection which is a start date and end date. now i am trying to bring in the earliest and latest date should they not want to select a date range. here is the code that i am using to get the date range strSQL = strSQL & " " &...

Hi everyone i have made some progress since my last post with regards to the default max and min dates. just have this error... i have attached a screenshot of the error... here is my code though strSQL = strSQL & " " & "WHERE [Clusters].Cluster_Desc =" & Chr(34) & [Combo1] & Chr(34) & "...

Hi everyone i would like to know if it is possible to pull the max and min start date and end date. basically i have an option where by the user selects the desired date range that they would like. now i would like to know how to get the earliest and latest date range should they not select...

Hi everyone i have tried so many different options but this is still not working out :banghead:. i have changed my code many times but i still get this error, Nonetheless here is my code , maybe someone will know where i am going wrong Private Sub Command43_Click() 'namepo = [Combo1].Value...

type , mismatch "13"

:banghead: this thing has stumped me big time , here is my code: Private Sub Command43_Click() Dim strSQL As String 'namepo = [Combo1].Value strSQL = "SELECT Department.Dept_Desc, Count(Source.Headline) AS NumberOfArticles, [Source].Analysis " & _ "FROM (Clusters INNER JOIN...

Hi everyone I would just like to know if it is possible to group Months together: this is what i have did so far : SELECT Count(Source.ID) AS CountOfID, Clusters.Cluster_Desc, Department.Dept_Desc, DatePart('m',Source.Day_Month_Year) AS [Month], Source.Original_Source, Source.Headline...

Hi sorry about that Private Sub Command2_Click() Dim strSQL As String strSQL = "SELECT Cluster_Dept.ID, Cluster_Dept.Cluster_ID, Cluster_Dept.Dept_ID, Clusters.Cluster_Desc, Department.Dept_Desc, " & _ "Source.Day_Month_Year, Source.Original_Source, Source.Headline...

strSQL = strSQL & "WHERE (((Source.Headline) Like " * " & Chr(34) & [Text0].value & Chr(34) & " * " );"

hi all i would just like to know if it is possible whereby if a user makes a selection in combobox 1 it must automatically generate the given vaules in combobox2 from the selection in combobox 1. this is something i am just trying to figure out , and with experts here i am sure it can be...

thanks trevor g but due to restrictions at work for internet access i am unable to view those videos.

hi everyone i have managed to retrieve information to my graph but i am unable to see the bars. i have attached my database

thanks for the speedy response , it is pulling data now but it aint showing any bars on the graph :(

Hi everyone I Have this graph that needs to be run from a combo box selection. it doesnt seem to want to display any information at all :banghead: , please help. i have attached my database.

Hi I posted this one another section within this forum. All i would like to know is if it possible to create a form with a start date and end date and a combobox. If the user enters a start and end date then it must pull data for that date range only. if the user selects just the combobox...