Search results for query: *

Hello, I have created an Access form to track the benefit selections of our employees. Our employee's benefits coverage ends on the last day of the month in which they terminate. (Therefore, if someone terminates on 2/1/05, benefits would end on 2/28/05. Or, if they term on 2/28/05, they...

Hello, I am tracking employee's benefits in an Access database and have designed a form for input. I would like to automatically calculate the Coverage Start Date based on +30 days from the employee's date of hire once the user selects the plan in which they are enrolled. Below are a...

Hello, I have a field in my form titled "Address" and I want to limit the entry to only letters and numbers (i.e. no punctuation - no periods, commas, etc). I've done some research on both input masks and validation tests, but I can't quite figure out which one is best or exactly how to...

Hello, I am creating a query that will pull demographic information on our employees' spouses and children. The spouse and dependent records are linked to the employee by the employee's social security number, and the column "Record Type" differentiates between an employee "E", spouse "S", and...

Hello, I have created a subform ("Dependent Demographics") linked to a main form ("Employee Demographics") to track employee and dependent details (date of birth, address, etc.) In my subform, I have a field titled "Record Type" where the user can select "S" for spouse or "D" for dependent...

Hello, I am using a form to track employee benefit selections. In my form, I have a combo box where the user can select the name of the medical plan enrolled (i.e. Medical Gold, Medical Silver, or Medical Declined). I then have a checkbox titled "Medical Coverage" that I want to automatically...

I am working on a database to track employee data and their dependents' (spouse and children's) data. I have an "Employee Table" to track employee data, and a "Dependent Table" to track dependent data. The two tables have similar fields (i.e. date of birth, gender, etc) and are linked by the...

Hello! I am new to Access and have little programming knowledge, so any help you can provide would be much appreciated! I am creating an employee database to track employee demographics and their dependents' demographics (i.e. name, Soc Sec #, birthdate, etc). I have a main form ("Employee...

I have created a form to enter employee data, and a subform to enter dependent data. My subform is currently set in Datasheet view (so that it looks like a table). My question is - Is there a way to wrap the text in the column headings on my subform? For example, one column heading on my...