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...

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...

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

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

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! 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! Could someone tell me how I could validate data between two controls on a form? I have two Fields, "Counted?" and "1-Summary". The "Counted?" field has only (2) possible entries, a "Y" for Yes or a 'N' for No. Both are Combo Boxes. The...

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

Hi! I have a Memo Field on a form in Access 97. It will accept a large amount of data, but will not save more than 255 characters when I move from record to record. When I go back to the original record, all data after 255 characters is missing. Does anyone have any ideas? Any help would be...

Hi! I have approximately 75 Forms within a database with 30 date difference fields in each Form which deal with employee vacancies over a year's period of time. The purpose is to determine the total days vacant within the reporting period, which is one year. Each Form will represent a...

Hi! I am developing a data base that will need each record numbered, but will require each record number to change when tables are merged. I am working with a total of approximately 7000 case records per year. Each month I will receive aproximately 5 or 6 databases to merge into one database...

Can anyone tell me how to carry over the same data in a field to the next (all) records in my database? For Example, the Judical Circuit for each of the records in my database will be "Southwestern". Is there any way to carry this information over rather than manually typing in...