Search results

Appreciate the advice! Thanks! ;)

My sympathies to you on your loss...some appropriate words...: The Greatest Art Henry David Thoreau, the nineteenth century writer, naturalist and philosopher, said: “It is something to be able to paint a particular picture, or to carve a statue, and so to make a few objects beautiful; but...

Ahh! Stupid me! It works now. Thanks very much for your time!:D

Hi I've done that. Please see code below. In the form, when I click on 'Amajuba', the text dissplays in the District field, but when i click on the rest - from eThekwini to zululand, numbers 2 to 11 dissplays in the district field. Seems like a minor problem with the code?? Private Sub...

Don't know what you mean. I'm very new to code.

Hi Khawar I've been trying Sample 2 and I'm almost there. I still get numbers but I think I'm close. Please check the code below for me and tell me why I still get numbers. I've adapted the Gender example for another one. I want to display the 11 names shown below in my query. Thanks!:)...

Please give me an example of the code I would have to use ie. 'if' statement. If the checkbox is unbound on the form, how will it store the text values in the gender field?

So using an option group with control source being the field 'gender' will give me 'male' and 'female' values in my gender field for the query, instead of numbers cos that's the problem?

I've tried an option group, but have the same problem when querying -male and female are listed as separate fields with numbers as values.

Hi! I have checkboxes for MALE and FEMALE (my form has to mirror my data collection form, hence no drop-downs). What code do I put behind the checkboxes to allow the query to reflect the values in one GENDER field (which I will create in the table with drop-downs) with the actual values - male...

Works Neil. Thanks mate!

Thanks Neil, I've got this one working now. How would I add another after update to this event? I would like to make another subsequent field null but on a different entry in the cadre field...do I just go AND...???

Option groups We have a winner!!:D Bit weird though...in the other d/base, I didn't use brackets of any kind and it worked! Thanks Ken!

option groups Tried that...I then get the Number assistive devices.. highlighted with this error message: Compile error: Syntax error

Option groups You're absolutely right. The forum is very useful but has its limitations. I have played around with some code. Can you tell me what's wrong with the code below...its designed to make a subsequent field disappear after update. The code has worked for me in one d/base but is not...

option groups That's my next step...tell me lastly Ken, will Access 2003 Bible be a good resource for my purposes now?...and thanks for your time!

option groups Ok, I'm lost now. How can I learn quickly about events, procedures and select statements? :o

Hi Ken I have in my option group 11 health districts with checkboxes. 1 district is chosen per captured record. In the tables and queries, the districts are stored as numbers (1 to 11), but I want the actual district names to be reflected. Thanks! Sandro

Hi Please tell me how I can get my option group in the form to display original data in my tables and queries instead of the numbers (codes). Thanks Sandro

Hi Guys Please can anyone tell me what's wrong with the code below (I want to make the Number Assistive Devices dispensed field null after the update of the cadre field): Private Sub Cadre_AfterUpdate() If Cadre.Column(0) = Primary Health Care Nurse Then Number Assistive Devices...