Search results for query: *

Hello Everyone! I created a form with too many controls, so I split the form into two forms, moving about half of the fields from one form to another. Now my original form will not allow me to add any more controls. I get a message "Microsoft Access can't create any more controls on this form...

Thank you Very Much!! Mellay

Hi Everyone! I have a Church Database. In most cases, I have two separate records that contain information on a two people who are married. When I sort telephone numbers or mailing addresses on a report, I get: John Smith (478)-555-5555 101 Main St, Anywhere,State Mary Smith...

Thanks to Everyone for your invaluable help!! Mellay

Michael PS I am using Access 2002 on Windows XP. Thanks!!!! mellay

Thanks Michael! How would you add the century?? Age = DateDiff("yyyy", [Birthdate], Now()) + _ Int(Format(Now(), "mmdd") < Format([Birthdate], "mmdd")) Thanks!! Mellay

Thanks for Prompt reply! I changed to idea suggested by mph1: Age = DateDiff("yyyy", [Birthdate], Now()) + _ Int(Format(Now(), "mmdd") < Format([Birthdate], "mmdd")) However, Dates earlier than 1929 still show up as a negative number. "-19", etc. All dates from 1930 to present...

Hi! I'm using a text box w/ =((Now()-[Birthdate])/365.25) Works OK EXCEPT when date of birth is 1929 or Earlier. For example dob of 03/23/23 returns an age of "-19" For example dob of 01/01/10 returns an age of "-5" Any ideas? Thank you in advance!! Mellay

Thanks Thornmstr for your response. I used an append query and it works fine. Thanks again!

Hi! Thanks for the prompt response! I am manually going to list view, select all records, copy. Then going to second set of records and paste append. I am using only (1) table for appending. Most of the dates will append. Only a few will not. Thank you! mellay

Hi! Can anyone help w/ an append issue? I am using Access 97. When I append records, some of the data does not appear. It is ALWAYS a DATE field that does not append. Any help would be greatly appreciated. Thanks! mellay

Thank you very much for your prompt response! I am working on this now. Thank you again! Mellay

Hi! I am using a checkbox to change the backcolor of another field. However the change in color is not being saved when the record is closed. Any way to save the change in color when the record is closed and re-opened? I am using: Check Box Event Procedure On Click [Field 2].BackColor =...

Hi Jeff and Nigel! I have figured it out and it is working!! Thanks to both of you! My database is unique in a way, my supervisor insists on doing it this way. We have to count the total 'Y's and total 'N's for comparison. I am trying to &quot;bend&quot; Access to do what my supervisor...

Hi Jeff!! I finally have it working with one exception. If the User puts an 'N' in the NO Box First and then puts a 'Y' in the YES Box second, it works fine. But if the user puts the 'Y' in the YES Box first, and the 'N' in the No box second, it will not work. I wish I could have it both...

Hi! Concerning Validaton between two controls on a form. How would you force a null value in one control if another is populated? For Example, If a YES field is populated with a 'Y', how can I keep the corresponding NO field unpopulated? I am having situations where the user will populate...

Hi! One Final Question? If I wanted to have another field that must be populated if '1-Summary' shows 'NOT COUNTED', how would I write &quot;Must Not Be Null&quot; or perhaps &quot;Like&quot; in the code shown above? This field will be the reason for NOT COUNTED' and may contain many...

IT WORKS!!!! Thank you BOTH So Much!!! mellay

Thanks Scoty for your response and your advice! I appreciate it. I am a newcomer to Access, so forgive me, but would you please tell me how and where the code should go? Thank You!! mellay

Hi! Could someone tell me how I could validate data between two controls on a form? I have two Fields, &quot;Counted?&quot; and &quot;1-Summary&quot;. The &quot;Counted?&quot; field has only (2) possible entries, a &quot;Y&quot; for Yes or a 'N' for No. Both are Combo Boxes. The...