Replies

Firstly download the database from Access2010 then go into it like normal, open the navigation pane on the left and see all the objects there.

Before I even have a look at you database, change the following:
SELECT * FROM My Train Collection WHERE Group is NOT null
to
SELECT * FROM [My Train Collection] WHERE [Group] is NOT null

Note the square brackets, it is not advisable to put spaces in object names.
Note. Group is also included in square brackets because some words confuse the query engine, like Group, because there is a clause Group By.

your query above shows ” around the field name, take them out. As I said earlier use this SQL as the record source of the report.

What is the SQL you are using?

If you still have problems, why don’t you compact and zip the database.

Unless SetWarnings has been turned off the DoCmd will throw a warning.

Why do you use the save option on closing the form?

I don’t understand what you wish to do, you have 2 tables, one called JOB_MASTER which holds job info from your accounting system, and a table called Maps. What exactly do you wish to do, please be specific.

I downloaded your database and cannot see the design view of the form, or see what objects you have.

I wrote a database back in Access97 days that recorded the ins and outs of vehicles at a a steel mill, from memory it did it all from one form. Sadly I have lost that database.

Why don’t you put that code behind a button on a form.
You can use a text box on the form to specify the name required.

Why would you want to do that?

Put this SQL in the record source of the report.
SELECT * FROM Tablename WHERE Road_Name_Description is NOT Null
Substitute tablename for your tablename.

You could develop a query based upon the table in question and use that as the source for the report.
A general form of this query would be:
SELECT * FROM Tablename WHERE RailroadName is NOT Null

You still don’t have the right idea on that table and the combo boxes.
Do as Wendell suggested and separate the Cat and Type data into separate tables and put an autonumber type field as the primary key.
Then when defining the combo box the column widths should be zero for the primary key (bound column) and you should see just the description in the combo box as long as the 2 fields that are defined are 1. the primary key and 2. the description.
This way there is no need to put redundant data into your main table, ala Cat_Description and Type_Description, same goes for Road_Name_Description.

The reason your Cat_Code and Type combo boxes show an error is that the tables those controls use are missing from that database, those tables are [My Train Catalog Table – Category] and [My Train Catalog Table – Type]

Since you use a query for the report you can change the query parameters each time you run it.

You could put the parameters in a temp table that the query uses then just change the parameters (eg. class of 1958) for each run.

Thanks, i read that but noticed it was set to my demo account, when i changed it to real away she went.
I must remember that.

I have just noticed today that my MT4 program is in a state of No Connection, this is a trading platform i use for Forex, i have left a mesage with Go Markets my broker, so i’ll see what they say.

I was most impressed with that essay you wrote above for a solution to my problem, that must have taken quite a time to compose.