Search results

I am converting an old database that was from Access 2002 to Access 2007. Everything has gone well and I'm at the final point. The problem I have run into is with a function in VBA that is no longer valid in Access 2007. It is something like this: Select Case ReportName Case "Report1"...

I have a database that has different types of insurance plans listed in a datasheet, and each plan can have a combination of different plan category, plan type, coverage type. But I want each plan to be unique, so there aren't two plans with all three fields having an identical value. Here is...

I have a form that shows all user accounts available in the program. The users are listed in a listbox control named "lstUsers", which has it's record source value set to gather records from tblUsers There is a button on this form named "cmdDeleteUser" and when it is clicked, it should delete...

I'm converting an old database to an Access program and there are a bunch of SQL queries that need to be imported into Access. I'm no SQL expert but I can create simple queries. The old program used an SQL server and here is an example SQL query it used: set ANSI_NULLS ON set QUOTED_IDENTIFIER...

I'm converting an old access database to a new one and I have imported some tables. The old database had just one table for insurance plans, named "tblPlan". It had compound primary keys in which the set of the three fields (PlanType, PlanCategory, CoverageType) had to be unique. I want to do...

I have a data entry form called "frmAddDependant" and it is opened with a button with the VB code line: DoCmd.OpenForm "frmAddDependant", , , , acFormAdd, , Me.ID Well, "frmAddDependant" then opens and I can add the new entry and it shows up as a new record in the appropriate table. The...

I have a form in my application named "frmWorkHistoryDetails", and it is opened when viewing an employee's information in "frmEmployeeInfo" and clicking on a "Details" button in subform "sfrmWorkHistoryList". The form "frmWorkHistoryDetails" needs to know what record to find in a query based...

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

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

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