Search results

When you say 'Patient Details' do you mean their address, phone number etc, or do you mean treatment they've had (history)? If it's history/treatment, I guess he should have a one-to-many relationship as the patient can have more than one lot of treatment. He should have a PatientID number, and...

Depends on what you want to do. You can have a tab control on a main form. You can have a tab control on a subform. You can also have a tab control on a main form, with subforms on each of the tab pages (and the subforms can have tab controls on them too). So, they are quite versatile. If...

Faceman I'm sorry my post wasn't of any use to you and that I was having a go. It's just that these Forums are extremely helpful, and a lot of people spend a lot of time helping others out. So when you post something as you did, saying "thanks for nothing", it irritates me somewhat, and such...

If I were you I'd apologise to Pat. I can't think of many people that spend as much time as she does trying to help others. Don't be so ungrateful. Perhaps you should try to not act like one.:mad: Ps. I'm not trying to offend you - I'm just not particularly keen on your attitude.

If you just want data entered into textbox B if listbox A = yes, then try (1). If you don't want text box B to appear at all if listbox A = no then try (2). and if you want both of these to occur, just merge the code. (1) Private Sub textboxA_AfterUpdate() If me.listboxA = "yes" then MsgBox...

Are you looking at the properties on the form itself? If so, that could be why. If you look on the subform control on your main form, 'on enter' should be there. If it's not that, I don't know. But then it's Friday, and I never seem to know much on a Friday..... :rolleyes:

Seeing that I don't have the Developers version, is there anything similar I can do?

Where can you obtain the Windows Help Compiler? I had thought it would have been on my PC, but I don't seem to be able to locate it, and IS don't appear to know what it is, let alone where it is. Or is it something that you have to buy? TIA (and sorry to hijack your post, Steve):)

How do you currently book items? do you have a combo or something where you can choose either 'available' or 'unavailable'? If so, you could have some code to say Private Sub Form_Current() If Me.cmboAvailability = "unavailable" Then msgbox "This item is currently booked" End If End Sub...

Try what Mile suggested to reduce it's size. I have PM'd you

Can you zip the db and then post it?

Sounds as though it's what you're asking the query to do, and it's not too happy. Attach the db and say which one is the problematic query.

It's probably worth you searching on the Forums for 'cascading combo boxes' as this will give you plenty to refer to. I would have a table for Building Type (tblBuildingType) and have a numerical index field (BuildingTypeID) so that 'building1' = 1 and 'building2' = 2. Then have another table...

So when you chose a contact type from your combo, the subform was completely blank? I presume you have an 'index' field such as ContactID which is both in your main form and in your subforms. This should be the field that you use to link the main form and subform. Maybe you could explain a...

Firstly, build all of the 5 forms you want to use as your specific subforms (eg, frmOne, frmTwo etc). Then place a subform control in your main form, calling it for example, frmContactsSubform, and link it to your main form. ContactType is the combo on your main form you want to choose from...

You may need to refer to the tab page number (page index). This isn't exactly what you want (I don't know what you're trying to do), but should give you the general idea. If Me.cmboSchemeType = "KCC/Babtie" Then Me.tbCtlsfrmDetails1.Pages(0).SetFocus End If Where tbCtlsfrmDetails is the name...

Merci beaucoup.

Thanks for your help - it's appreciated. Going well - now just trying to find a way to link to get the form to open at a specific record.:) ;) :)

Mile-O-Phile Thanks for your response to my problem. However, my coding skills are basic to say the least, so if you could give me a little more to go on, that would be brilliant. Chewy I'll email you with an example of the search form (with cascading combos) at lunchtime.

What exactly are you after - an example of cascading combos, or were you referring to the Search form stuff?