Recent content by Cosmicnoodle

Does anybody know if it is possible to populate a date field based on the calendar function in outlook? I have a call handling database and am wondering if there is anyway to use the calendar function within outlook to populate our date of attendance field within our database. Any idea?

cheers - thats perfect... ta

Is there any way to format the result when using Now() in VBA Private Sub cmd_Today_Click() tbo_DateTo = Now() End Sub I am using the above code to put todays date into a textbox on a form, but it gives me the format dd/mm/yyyy hh:mm:ss. I simply want dd/mm/yyyy.

Right, as perfect as this is... I need to display the average travel time in hours/mins rather than as a decimal result. How do I convert the code below to display a result in hh:mm format? Private Sub Cmd_GetAverage_Click() Dim rstAvg As DAO.Recordset Dim strSQL As String strSQL = "SELECT...

YAY!!! It worked!!!! Thanks to all those that have helped - i realise its been a pain in the arse, but its all worth it!

that brings up a syntax error, simply highlighting the command15 click function

doesnt seem to make a difference? Still get the same errors...

Guess what... didnt work! New error = " 'Run time error 3061' Too few parameters, expected 2" highlighting : Set rstAvg = CurrentDb().OpenRecordset(strSQL) in my code Im going to keep trying to tweak it but i am not exactly a pro so may fail.... help needed!

I think I must be really dumb... that code looks correct to me, with all syntax in place and proper but it still does not work. I get the error: "Syntax error in query expression: (tbl_Travel_Time.Date_Of_Visit " & _ "BETWEEN [Forms]![frm_Average_Travel_Time]![tbo_datefrom] " & _...

The SQL Statement works perfectly, but the caption change code gives me the following errord when placed in the cmd_click() private sub (is this the correct place for the code?) I get the following error "cannot find the database table or query '#'" And visual basic highlights the following...

using the following SQL statement I have got the average for all values in the table SELECT Avg([Travel_Time]) AS AvgTravel_Time FROM tbl_Travel_Time; Now how do I apply this to my query below? SELECT tbl_Travel_Time.AutoID, tbl_Travel_Time.Travel_Time, tbl_Travel_Time.Date_Of_Visit FROM...

this is the 1st time i have tried to use an aggregate query and its proving a nightmare! I have my query set up and running smoothly but thats as far as i can get. Any change of a BASIC demo? just one or two records with 1 column or something - just to give me the just aas i am lost! Cheers

I do not have the numbers, I need some code that will run a query (that I have working fine) and average all the values in a column returned in that query. Basically, I have a table from a call handling database that has all of my engineers visits logged. I have a query that simply selects a...

Hmmm, thats strange, the code seems to be working now - but it isnt returning any values or presenting any errors? That link works fine to display users logged on to current db in VB but I need this info on a form, and also refering to another database... Im sooo fussy! :D Any ideas people?

ok, feeling like a true amateur now! How do I do that - and more importantly, what does that do exactly?