Search results for query: *

Hi, Here is a question for the real experts out there. I have searched and read everywhere I can and can not find ant reference to my problem. What I need is to be able to trigger an event ONLY when arrow of combo box is clicked. Not when it gets focus or anything like that but when the actual...

hi CosmoKramer, Thanks for the suggestion but no luck, just get the error message: Undefined function '[Forms]![frmTrackInfoMain]TracksFound].Column' in expression. Any suggestions please ??

Hi I need to use the value or data from column 2 relating to which ever row is selected by the user within a list box on a subform as criteria for a query. I have the following in an Access2000 database. Main form = frmMainDataEntry sub form = frmTrackInfoMain List box = TracksFound I have...

Hi turtlemaster, Thank you for your reply and suggestion but it did not work. Access gives an "undefined function in expression" error - any more suggestions please ??

Hi gang, I have a form in Access2001 we shall call frmOne and on it is a Listbox we shall call listOne. I want to pass the value (or information) from the 2nd column to a query but cant work out the correct syntax or where in the query to put it. Can someone kindly point me in the right...

Hello, I am new here so if posting again upsets anyone then I apoligise but no-one helped me when I first posted and I also noticed that no-one had marked the thread. I just assume that the right people who could help me did not get to see my original post hence my reposting in the hope that...

Hello, I am new here so if posting again upsets anyone then I apoligise but no-one helped me when I first posted and I also noticed that no-one had marked the thread. I just assume that the right people who could help me did not get to see my original post hence my reposting in the hope that...

Hello, I am new here so if posting again upsets anyone then I apoligise but no-one helped me when I first posted and I also noticed that no-one had marked the thread. I just assume that the right people who could help me did not get to see my original post hence my reposting in the hope that...

Hi Astrid, Thank you for your suggestion which I have tried to make work over this weekend but Access2k just gives me the following error message: "The expression is typed incorrectly or is too complex to be evaluated." Here is the SQL that I used: SELECT Sum(Hour(TimeValue([...

As a first time visitor to this forum, I have to say that I am very disapointed at the level of help offered on my question. Reading through the different Access forums and Newsgroups, questions about time seem very popular although I have yet to see a question simular to my own. Please, If...

Hi KF, Thanks for the reply but it didn't work. I placed a unbound Text box on the same form as the textbox containing the time data (its called Length) and used this string as the control source: =Format(Sum([Length]),"h:nn:ss") All I got in the text box that should contain the...

Hello, I am new here so if i go into too much/or not enough detail, then I apoligise. My question is can a sql statement or a set of querys be written that will add up a specific range of time data; EG: 1:00 + 1:20 = 2:20 and then called from a text box on a form so that the result is...

Hello, I am new here so if i go into too much/or not enough detail, then I apoligise. My question is can a module/function be written that will add up a specific range of time data; EG: 1:00 + 1:20 = 2:20 and the function called from a text box on a form so that the result is displayed in the...