Recent content by muchjubble

oops! yep forgot to mention that, sorry :o Thanks Paul, that did the trick :) Well I moved to San Francisco for a while, but then ended up settling down in Sherborne! I still get down to Bmth regularly though, such a lovely place. Thanks for your help and nice to meet you, cheers! :)

Aaah Bournemouth, my home town :) Thanks pr2-eugin. It's not always an hour wrong unfortunately. So I guess the entries that are correct already can be filtered out by adding criteria, but how can I access the time portion in order to do so? Show all entries that don't equal 09:00:00 and...

Hi guys I have some incorrect time entries in a column that I need to fix with an update query. So, 04/11/2013 08:00:00 needs to be changed to 04/11/2013 09:00:00 Can you help me out? Many thanks

Still trying to work out how to change the backcolor of the next textbox though. Would be great if you can give me a hint :) For Each ctl In Me.Controls If (ctl.ControlType = acTextBox) Then If (Left(ctl.Value, 3) = "Mat" Or Left(ctl.Value, 7) = "Machine") Then...

oops! ok I understand now, my apologies, and thank you

Thanks, but the code I posted above already checks for controltype textbox.

Hi Galaxiom :) Many thanks posting I have 7 similar tables. tblMonday, tblTuesday, etc. The table fields are like: tblMonday m0800, m0830, m0900, ..... tblTuesday t0800, t0830, t0900, .... I tried: Dim ctl As Control For Each ctl In Me.Controls If (ctl.ControlType = acTextBox) And...

Hey guys, I'm new here so a big HELLO :) to all who are reading this. I'm really glad to be here as there is so much I want to learn. I wonder if anyone can help me with this? I have 7 subforms, each containing 30 textboxes. Each field represents a half hour slot, in a 15 hour day. The fields...

Hey guys, muchjubble here. I'm very pleased to now be a part of this wonderful resource. I am going to learn a lot and hopefully when I'm proficient enough I can help others and help continue to grow this forum. I have worked with most versions of Access since 97 but have never spent enough...