Search results

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...

Could anyone point me in the right direction with this please? I'm looking at creating an event calendar form, where as I can type in the date of the event, the time, whether it is all day, or specify the start and finish time of the event, and whatever I enter, it checks current events and...

Alright cool thanks, i'll see if I can get it doing what I want it to do. Thanks for the help :)

No problem :)

Can't see that it'd be quite as simple as that unfortunately. You could create a query that would do a total of that field from the table itself rather than the list box, then make the source of the text box you've created that query???

Then you'll need either the INSERT or UPDATE command to generate an SQL string, depending on if you want to create a new record, or edit an existing one