Recent content by hwong

Thanks Cbrighton! I think record count is a bit "informal" cause it may create duplicate number if a previous record is deleted. Oh~~this is still an annoying question to me.:banghead:

Thanks 1st. I will try. Whay I am trying writing autonumber function myself is the function provided by Access is quite poor that an autonumber will be skipped if a record is not saved. Hence audit trail (deleted record? no record?) will be lost .

Greeting all! I have written the below codes for creating auto-number (i.e. pre_number) for data entry of a form. It runs perfectly when I used it at 1st time. However, when I exit and re-open the form, the new record's pre_number field becomes 1!!! I spent much time to surf internet but...

Would someone help? Thanks in advance!

Greeting All, Thank you to this forum and all the generous teachers here, I have learned much knowledge in Access and now become an Access VBA starter. Of course, a starter always encounter problems XD My 1st question is how I can use VBA to set a combo box's width auto-fit to the longest...

Thanks for your reply~ But if I use checkboxes (tick or empty?) I cannot provide a choice that selecting 2 starter of same type.

Greeting all! I am making an a form for set meal ordering~ say set meal #1 provides a choice of 3 out of 10 starters. I created 10 input boxes for user to enter 1, 2, ~ but how can I disable any further input if 3 starters are chosen already??? Of course, the chosen items must be...

After trial and error of John and Trevor's code, it is successful at the end. Thanks. My default choices are "MALE" or "FEMALE", and I have tried and failed thousand times by using "Male" in setting the code......XD

Thanks all good people above!

Greating all! I have been requested to create a form for entering 1) Sex 2) Number of Pregnancy 3) ... How can I prohabit the user to enter value into 2) Number of Pregnancy if answer of 1) is Male :banghead: I have tried hundred times and still no idea X( Anyone would like to help this...