Recent content by Suepoo

Cheers for that. I will give it a go :)

Hi Bob, No, I haven't used subforms. There are a lot of forms in this db. I have one main form (Welcome) which consists of buttons that open the forms (which in turn contain buttons to other forms). The tables are all pretty much linked back through to the main alpaca table. I was trying...

Big sigh.... Okay, Bob, I'm still playing around with DateDiff.... John, the problem I had with my code is that it either displays the error message for all results (or if I played with the structure) it didn't display the message at all. Basically, I have an alpaca table which contains the...

Thanks heaps for that. Over the last couple of days I have accessed so many places for help (including sifting through this site and the Access VBA help (and even a copy of VB for dummies:o ). I think my brain was starting to turn into mush from the information overload. Your info looks like...

I have two dates I would like to compare. Basically if one date is older than the other date - display an error message Otherwise, continue on. I have been doing this for at least two days now (and today is my birthday). I've been researching the DateDiff function as my other method I was...

Sorry, was trying to reply to missinglinq Probably should've of quoted first.... :o

Yeah, I realised a little later I should of used American spelling. Did I mention I am blonde? :D PS - I'm in Australia so no, I'm not part of the British empire, though some may claim otherwise:p

I'm having problem with my background colour for my form display. I have set up my main form with all the buttons etc and the background colour displays fine. However, when I go to change the background colour on my other forms it won't change. You can see it flash for a split second, but...

Using VB... Hi, this is my first time here. I hope I can be of help. I wanted to do exactly the same thing. I have an opening form where I created buttons that opens up the forms straight to a new record. This way it is only the button that does this while the form itself (if opened from...