Search results for query: *

Traingamer- Thank you! That solved my problem! Also, for future reference, if I wanted to change the code to IsNotNull, what would the code look like? frosty2000

GingerR - You are awesome! Thank you! I was able to get the below code to work if I left off the [EmployeeMedicalCoverageEndDate] = Null criteria. However, I need to keep this in there because if a coverage end date has been entered already, I don't want to overwrite it. With the below code...

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

Hey there.... Just wanted to let you know I got it all to work. Silly me...I think part of the reason it wasn't working on my test record was because there was no date input into the LatestHireDate field! I ended up changing the fields so that the name of the boxes AND the control source had...

Hey AceMan, The options in my MedicalPlan combo box list out the actual medical plan names (i.e. Medical Plan Gold, Medical Plan Silver) as well as "Medical Declined". So, if someone is actually enrolled in a plan, I want it to check the "yes" box and also auto populate the...

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

Richard, Thanks for your help. I was able to set up my own customized Input Mask. Here are the details: Description: No Punctuation Input Mask: a Placeholder:" Mask Type: Text/Unbound Select "Without Symbols in Mask" Note: The input mask "a" limits entry to a letter or number only. I...

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

PHV - Thanks for the info. Yes, the tblDependent has a birthday field. Please explain to me the purpose of including birthdays in the code? Also, the data is all coming from a Union query that I used to combine the employee and the dependent data together. Does that matter? And please tell...

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

Thanks to everyone for their help. Here's the code I used, and it seems to be working for me... Private Sub MedicalPlan_AfterUpdate() If [MedicalPlan] <> "Medical Declined" Then [EmployeeMedicalCoverage] = True Else [EmployeeMedicalCoverage] = False End If End Sub

Thanks for pointing me in the right direction, AceMan! I put the following code into the AfterEvent update of the combo box, but I'm getting a "Runtime Error 424 Object Required" error when I open the form and select a medical plan from the combo box. When I debug, it's the first line of code...

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

PHV - Thanks for your help. The UNION query was exactly what I needed! I was able to create the union query, and then create a make-table query off the UNION query. Here's some sample code I used for my UNION query: SELECT [Last Name] AS [LastName], [First Name] AS [FirstName] FROM [1...

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