Search results

Ah - can't try it straight away, give me some time and I'll say if I've got it to work yet... Here's hoping!

The criteria in the query? I've added the below code: "MyNewFld: iif[Flight_requested]"=("Yes",1,0) Which doesn't work! Should I have altered the MyNewFld part? I also get an error about the syntax (comma), could this be due to my other criteria?

Still no joy, here's my code: Private Sub Form_Open(Cancel As Integer) If Me.Flight_requested = 1 Then Me.Flight_Booked.Visible = True Me.Flight_Booked_Label.Visible = True Me.Flight_Booked_with.Visible = True Me.Flight_Booked_with_Label.Visible = True Else If Me.Flight_requested = False...

Ah - I'd left something selected, that's why I couldn't find it! Thanks a lot!

How do I get to the forms Open/Load events? Cheers for all the help - tis a great forum

Works like a charm - I can see where I was going wrong now.

Thanks for the answers... But... umm... where do I put the suggested code?

Ahhh... Except - if I'm applying this to a currently existing database, is there anyway I can have the code check for a tick in the box first? So a tick always means that the fields are visible?

That, my newly found hero, is fabulous! Ta Muchly

Hello, I've been busily working on an Access database for the past few days, and would like to see if it was possible to make a (purely cosmetic) change - basically, there's a set of fields - Flight Requested, Flight Booked, Flight Booked with - Flight Requested and Booked are both tick...

Hello all - third post in less than two days, I'm on a roll! I was wondering if there's a way to get a numerical value out of a Yes/No field (say Yes = 1, No = 0) - for the purpose of reports (and more importantly the totals) Cheers

Cheers, I shall have a look through that and see if I can pick up where I'm going wrong.

Nope! Whatever I remembered, it wasn't the right thing - darn it! So, I need to be briefed on the basics of doing things like this - from beginning to end, I'm sure some of it will look familiar - is there any handy links you could point me to?

I don't know - I must've took some serious knocks to the head in the intervening years... But that sounds familiar, cheers!

Hello, I've recently been asked to update a work Access database - which would've been no problem a few years ago, when I was fully versed in such things - however, since those heady days - ring rust has crept in, and some things I thought Access did are actually things from other programs...

The options I have for my fields don't include the Option group, does it go under another name? I have Autnumber - Text - Yes/No, etc... But no sign of Options...I may be being dense though... Ignore that... I've woken up a bit now.... Any further advice is still welcome though!

Good stuff! My memory fails me on the coding side of things, I used to have some knowledge - can only remember the basics now... :( I shall peruse the forums somemore and see if I can find answers that apply to my questions, thanks for the help so far!

Hello all, Be gentle with me - its been a while since I used Access, but have now been asked to update someone elses Access database at work, and to add some new features - I can remember most aspects of what goes where, I just have a few queries about some of Access' other features (if it has...