Recent content by SimonSezz

The code I posted is sort of pseudo-code, it's not meant to be taken that literally. The issue is outputting the report into Excel form.

Well there weren't any problems with the previous version but they converted all of the computers in the office to Office 2007 so I don't really have a choice.

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

Thank you for the help. Your code performs perfectly. I have just been referring to the Access help so I try to gather as much information from there as I can. I didn't know you can get the listbox's current value without using the value property. I have a lot more to learn.

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

OK, Thanks for the help. I use a lot of VBA but I have never written queries in VBA yet. I'll read up on it a bit and I'll start working on it.

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

It appears to work now that I moved the line to the Before Update event. Thanks!

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

Alright I used the Where function and everything works. Thank you.

Basically how do I open the form "frmWorkHistoryDetails" and have it look up a record based on two parameters from the form "frmEmployeeInfo"

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

Alright I think I'm starting to understand the whole relationships principle. I can't believe I find this so difficult when Java/C programming seems relatively simple to me and I have been doing it for years. Here's an update (and thanks for all of the help guys):