Have you tried taking renamed "Colour Name" to something like "ColourName"? It might not like the space.

To answer you questions about the different source files, if you're using Visual Studio, each time you add a new component to your solution (as explained by ddanbe above), it is placed in its own...

Get rid of the surrounding ' for the values in your insert statement.

INSERT INTO DataStatus(CedantID, CompanyType, CompanyName, TypeOfFile, FileName,Reportingperiod) VALUES ('@CedantID',...

An easy approach would be to separate the values in the array by a comma before putting it into the database as a comma delimited string. Then when you bring it back from the database, just do a...

You would probably have to play with the count and where the message box is displayed to get this to be exactly what you want, but I think something like this should work.


Public Class Form1

...

If I'm reading this correctly, it sounds like you just want to be able to manipulate the ListView on a Form from another class somewhere in your application. Have you tried making a public instance...

I actually just started to pick Python back up a couple of days ago. What has probably helped me most is going through the problems at Project Euler (http://www.projecteuler.net/). It's a great way...

I'm assuming you want to check the values before making the call to the FV function. If that's the case, you could accomplish what you're trying to do with three simple if statements. Something like...

Do some research on normalization.

You might want to consider a simple setup where you have three tables.

Menu
MenuID (Primary Key)
MenuOutlet

Starter
StarterID (Primary Key)

I've always run into issues with using the IDENTITY property in Access. If your using an autonumber, you could always just do something like:

SELECT MAX(autonumber_column_name) AS alias FROM...