Recent content by agehoops

Hey. Sorry about the REALLY late reply, didn't even know visitor messages existed, so I apologize. Do you still need help or have you solved it now? Ta Aidy

oh wow that sounds fantastic!! If you could get the links here that would be amazing, sounds like just what I've needed! :D

alright, how do I go about doing that? I mean, I can create an SQL string to get a record, but how to I get it to check if one time is between 2 times or equal to them in the table?

Hey. I want to create a loop which runs through all records in a table, to compare the data it finds with the data entered. What I've got is a time field, and when a value is entered, I want it to run through every record in the table, and check if the time entered is between the time of two...

perfect! Thanks so much, just what I needed. This forum is the best :D

That works, but how do I then determine which of the buttons has just been selected? Seeing as there are 12 tabs?

The code is literally something like txtMonth = 1 That's it. It does work, but only when i click the area just under the tab button which is really stupid

seems it is, but only the area under the actual tab button which just makes it useless!!! How can I got about making it the button itself?

I'm using a tab box on a form, and want to use the OnClick event of the tab buttons along the top. I have the option of the OnClick event, but no matter what the code is behind, it won't run!!! Why not? It's really annoying me Thanks

Ah fantastic, works a treat cheers. haha thought you might. Basically I'm creating a custom event calendar which obviously will contain 365 days and 1 leap year so the 366 days, as I've done it as a tabbed calendar rather than selection the month by a drop down

Is there a way to requery all the controls or types of controls? I've tried doing a form.requery and others, but the only one that works is the specify the control each time, which sucks,cos i'd have to do it for 366 controls which I don't really want to do. Thanks

WOOHOO!!!! Thank you so much!! The first one worked (without the .[text]) works a treat, thank you! Was really annoying me! I'm making the system for uni and that's in about 2 weeks and it was just slowing me down so yea. Really appreciate it :D

I don't think it's due to the focus. Basically, the user selects a year at the top of the form, and then the text boxes use the value selected from that combo box, and change their value accordingly, however the user may suddenly change the year, so I can't set it as a default value?

Whenever I click into a list box and select an item, it changes all of the text box controls to " #Error " The text box controls have a control source of the following: =Format("3/1/"+[cboYear].[Text],"dddd")+" 3rd" But slightly different for each one. Why when I click in the list box to...

Heya, thanks for that. Will have a look through and see What I can use from it. Does most of the stuff that i'm after, although it doesn't check the times and such but the design is great. Also it logs february as having 31 days as with every month. haha Thanks for the response though, great...