Search results

How would I do that? Here's a picture of the table relationships if it helps...

I have a form that has to show an employee's work history details. There are many details it must display so it has a couple tabs on the form. The name of this form is "frmEmployeeWHInfo". To get to this form, the user double-clicks on an employee's name on ListBox control on a form called...

Thank you wazz, your solution worked perfectly!

I tried that but then it replaces all zeros in the SSN, even the ones that shouldn't be deleted (those that are part of the actual SSN).

I'm working on a new Access program and I have recieved a bunch of tables from the programmer that worked on the previous version of the program. Some of the tables contain the Social Security numbers in a column and the SSN is formatted in a different way than the way it is in my program. His...

I have a form that shows employee details (frmEmpDetails) and it has a subform that shows a list of dependants (sfrmDependants), there is a button on frmEmpDetails, (cmdAddDependant) that when clicked, opens a new form (frmAddDependant), but frmEmpDetails stays open in the background. Once...

That was so easy <hits head> Thanks guys!

I have a listbox that is unbound. I have set the rowsource property to a query which is: SELECT tblCompanyPlans.PlanCategory FROM tblCompanyPlans ORDER BY tblCompanyPlans.PlanCategory; The tblCompanyPlans table has three fields: PlanCategory PlanType CoverageType There are multiple rows in...

I was actually thinking about that while working on this and you are right. But I guess the point of the listbox is to let the user see all of the entries (in this case the shops) displayed in order by their shop number system.

I have been learning Access 2007 for about two weeks now and I'm trying to copy a program for my business. We had an old Access 97 database and we lost it when there was a hard drive failure. All we have are recollections from memory and some screenshot prints of what the program looked like. I...