Search results

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?

that is perfect - however, it needs to be modified and this seems to require talents greater than mine! This works fine in the demo, but when I import that form into my application, it doesnt work? I get the error 'User defined type not defined' refering to: Private Function WhosOn() As String...

I have a form that I want to use in order to work out a global figure for average travel time for my engineers (data coming from another database). I have a form with two text boxes, which allow the user to define a date range. This links into my query which works fine and returns all records...

Ok, let me clear this up - I do not need to see a users u/name & p/word. I need to see which users are logged onto my call handling database via my reporting app (access 2000) at any given moment. The lockfile viewing is fine, but i need this info linked into my reporting app - and it needs to...

Ok, it seems that the logged on info must be hard coded - what I was hoping for was a field in a table somewhere that simply was populated when the user logged in, and null when they werent. This was far too hopefull! The usernam/password is stored into a table. Is there any way to extract this...

the problems isn't that i cannot tell the username or password, but simply if they are logged in at a given time I have access to the username/password table - but it is very basic and doesn't have a 'STATUS' field (i.e logged in or not) I am just looking to run a query that will give me a list...