Search results

Well a big thank you to everyone that has contributed to this thread, especially to: boblarson, Mr. B, Kryst51 and wiklendt. I have now got the Form that automatically enters M (=Male) for Mr and F (=Female) for Mrs, Miss or Ms and the message box "please enter gender" for Dr (or any other...

This throws up a compile error: Expected Function or variable

Thanks for this it works great up to a point. When title = Dr, gender is automatically entered as "unk" = unknown, but I need to be able to manually enter M or F? I don't seem to be able to overwrite this "unk"?

Run-time error '13': Type mismatch Debugger highlights in yellow: If Me.cboTitle = "Mrs" Or "Miss" Or "Ms" Then

Here is a 2003 version.

The code I have been given does not run. If you look at my post 11-23-2009 02:41 PM I have attached a copy of my file (before adding the missing "End If") if you care to take a look? Thanks.

I added the extra "End If" but it still isn't working?

I originally used the code suggested by Mr. B. That code worked but when I modified it to match your suggestion it no longer matched gender to title. I have attached a copy for you to see. Thanks

I can't get this to run?

Ideally I would like Mr to force gender to M (male) Mrs, Miss and Ms to force gender to F (female) but non-specific gender titles such as Dr, Prof to force manual gender entry. Is this feasible?

Can anyone tell me how to modify this code to accommodate titles that are of non-specific gender e.g. Dr? Thanks!

Could this code be modified to allow non-specific gender titles such as Dr?

Kryst51 - did you attach your modified version of music_al's db?

I am not happy with the design now because its not possible to properly normalise with the limit on the number of tables. Also the data entry form for Emloyee is not ideal requiring a title ID to be entered (1,2,3,4) instead of Mr, Mrs, Miss or Ms. I can create a Form based on a query to show...

I had to consolidate two other tables to accommodate this. I still haven't heard back from the creator of the problem.

Thanks for this Kryst51. I have decided this is the way to go as it will meet the criteria. However I intend to combine Title & Gender in one table (as I have a 5 table limit!) and link this to the Employee table. The Title table will consist of: TitleID, Title, Gender 1, Mr, M 2, Mrs, F 3...

Thanks for that solution it works just fine. However my students have not used any VB code before so I am still looking for a simpler solution. Maybe a look up would be easier to implement? Sorry if I offended some people on this forum, I was only asking for a simple solution to a problem with...

Thank you for your suggestions. Unfortunately as this is a 'live' assignment I am unable to post full details. I think that there is a problem with the assignment as the simplest suggestion of an additional table doesn't fit within the criteria; the other two solutions are beyond the level of...

This is indeed an assignment set for my students by someone else, hence the restriction on number of tables. However I need a solution myself in order to guide my students towards a solution.

Perhaps someone can be more helpful and provide me with an answer? Thank you.