Search results

Ok, the solution is: Minute([Time1])>=Minute([Time2]) And Minute([Time1])>=4 This works J

Ok this is what I have currently: [Time1].Value<=[Time2].Value This works, however I need to say [Time1].Value<=[Time2].Value by xAmount for example 4 Minutes. So by 00:04:00 How would I do this? Thank you

ah, I see, that works :) Thank you very much for your help

Yeah I do have another textbox on the report, thats how I got the left and top values.

Heres an example of what the report is doing.

Yeah that was just an example here is the code I have: Me.Controls("TextBox1").Left = 9.199 Me.Controls("TextBox1").Top = 0.399 The left sould be moving from the right of the report closer to the left. But 9.199 the left pos, isnt as left as what the its currenlty jumping to.

yeah, sorry i meant Me.Controls (TextBox1).Left = 12828 Me.Controls (TextBox1).Top= 888

Hi Thank you for the advice, however I have tried this, and its giving me the same error, the box that I am moving TextBox1 jumps to the far left. Thank you

Hi :) I need some tips and advice when it comes to access conditional formatting, The idea is to highlight a textbox (Time1) when one value is bigger than (Time2) by x amount. Currently in an expression I have: [Time1 >Time2] this works well and highlights the box the conditional formatting is...

Hello I wonder if anyone can help me, I need to move a text box with an access report. I have the code on the activate event. Currently I have: Me.Controls (TextBox1).Left = 12828 Me.Controls (TextBox1).Left = 888 But this isn’t working, :( can anyone give my an example of this. Thank you

using a wildcard to equal a Multiple fields for example a field called url with 10 values in it?;) thank you

ok, studding carefully then what is the difference between name and userID and topic id and title because the topics one works fine and add the value found to the database were the userID add to the database at 0 always

yeap, sorry had a blode moment there, i been working on this for to long, lol sorry

ok this is funny but i dont have a ROWSOURCE box?

yeah, thats what i want to happen but i dosent

thankx, ok, but if i dont use the dlookup is there another way of getting the topicID from the title?

yes its in the forms before update event, thats why i dont understand why its not working

no, Addcomments is my form and userID is the text box, also again with the frist form and then textbox

yeap have done but it still saying the same, and my form is called AddComments

what have i done wrong when it errors, the expression may not result in the name of a macro, the name of a user-defined funtion, or event procedure? this is what i have, in the before update event =AddComments.txtName=AddComments.UserID