Search results
-
C
emails
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... -
C
Run-time error '3075' syntax error(missing operator)
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) -
C
runtime errror 3075
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) & "... -
C
how to pull the Maximum and Minimum Start date and End date
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... -
C
Run-time error 3075
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... -
C
tyep mismatch
: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... -
C
Group records by month
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... -
C
run time error 13 type mismatch
strSQL = strSQL & "WHERE (((Source.Headline) Like " * " & Chr(34) & [Text0].value & Chr(34) & " * " );" -
C
based on combobox one selection , combobox two must display those values
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... -
C
graph not displaying bars
hi everyone i have managed to retrieve information to my graph but i am unable to see the bars. i have attached my database -
C
Graph not displaying any data
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. -
C
One form with 3 options
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... -
C
Question One form with 3 different options
Hi there I am a newbie to access 2007. I would just like to know if it is possible for me to make one form with 3 different options i.e i have a start date and end date and a combo box. if the user enters only for the start date and end date , and clicks the run button, it must pull the query...