Search results

I wondeer if the form is partially corrupt. it shows in the project window but does not display on the task bar almost as if it is invisible or not fully recognised any suggestions how to check for curruption in a form. Most of the code works but just this section fails. Anything to do with...

hi gemma, i wish it was the case. what i have shown is the last version i have tried to solve it. I have tried defining AmPm as integer but nothing. also code as shown works on other forms. AmPm string ends up with a value. I have a feeling that the mismatch is somewhere due to a...

Code is as follows; Firstly module; Public Function twhen(timein As Date) As Integer If Val(Format(timein, "h")) >= 13 Then twhen = 1 ' "afternoon" Else twhen = 2 '"morning" End If End Function Secondly SubRoutine behind Form ( part of larger sequence)...

Exactly. The identical code works on other forms in the same project. So type mismatch is not the correct answer although access is struggling with something on the reference n this particular form. I ahev also tried changing the item to integer/string/date but this does not change anything...

Thanks Gemma, I have checked the form and the function is only defined once elswhere. (other forms refereto it in this place so at least this appears to work) Following the code through fubtcion returns "type mismatch". The form is not reading something properly or is mis-referencing...

I have spent most of afternoon trying this but it does not seem to have the effects that the article suggests any further ideas?

i hope soemone can help i have a form where VB doesnt respond in places. Generally the code of theform works but when it come to a reference to a public function it does not call it and returns error message "" The same public functions works on all other forms in the same project. Also...