Search results

found this and seems to work Private Sub lbl122_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) info.Visible = True Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) info.Visible = False End Sub

not sure if this is the right forum, can you help please , I have a form [main form] and a subform[subform], on the subform I have a label in the header [lbl22] , what I am trying to achieve is that when the user moves over the label it will open a label [info] on the main form code using so far...

hi all sorry for delay, the reason for doing this is that I have found that a user has taken a copy onto his desktop and updated some records in the table , I need to copy this table into the original database to get it back on track

hi all can you help please, I have two databases both with a table called [new load],can I move one table to the other database and overwrite the other table? if yes how? and what pitfalls have I got to watch out for ? :confused:

hi The_Doc_Man , yes this is what I am trying to achieve but I get a compile syntax error?

can you help me this code please? on a subform I am trying to look at the [en update ] textbox (contains a date), and if it is within 28 days of the date then it will change the value of textbox [EN update info] to 0 the code I have been trying is as follows but I keep getting an "loop without...

how would I do this in vba ?

hi , don't know if this is the right section for this , I have a date textbox [test] and want to change the value of another textbox [update] if the value of [test] is between todays date and last month ,i want to do this using conditional format , can you help please?:confused:

how would I set the before update to cancel any update ?

the field is called test date , sorry

here we go

can you help please , I have a subform with a field [test] this is a date field using the date picker , on the after update control I have the code , me.test.enabled = false . (I am trying to stop it being updated twice ) , but when I run this it disables all [test] fields , how can I stop this...

ok I will try this and let you know thanks mate

what do you mean?

have attached an image , front sub is sub2 , if you look I have put a date in the gtaw update column 08/01/2019, I have updated this field I want to update all test date fields in the sub1 that the [ make] fields contain gtaw

I think I can handle the update to sub1 but how do I only update the rows that contain only "gtaw" in the [make] field?

hi, they are not bound , sub2 is for holding a history by date and it is only opened by selected users , sub1 is always show to all users so I need to get sub1 to update with the dates placed In it

hi all can you help please I have two subforms [SUB1] and [SUB2]on SUb1 I have two fields the first [make] can contain the following texts gtaw gtaw/smaw smaw gmaw/fcaw the second [test date] contains dates on sub2 I have a four fields [gtaw][gtaw/smaw][smaw]and [gmaw], all are date fields ...

hello arnelgp, how nice to hear from you again , this still does not work mate

how do I do that please?