Subtables information

[VelvetVoice]

Hello! I'm having some trouble recreating forms and reports. I have an Access database that was built 15 years ago, and I was trying to copy and paste tables from the test environment to production. However, one of the key tables has subtables, and the subtables will not copy over. There are several macros built into this database too, and I think the builder connected tables unnecessarily. In particular, I want to generate blank forms calling up several tables, but it is giving me the following errors: problem opening report, type mismatch 13, activity I/O, item not found in this collection 3265, problem opening a recordset. I understand I have overlapping problems here, but if you can help me with the subtable issue, the rest may fall into place.

 

[VelvetVoice]

What is the function of subtables? I tried looking for definitions in the help portion of Access, but it is not there. Is there some kind of manual where I can find the definitions? How are they created?

Incidentally, I added the cost center numbers to one of the other tables for another report, deleted the cost center table in the query, and it seemed to run just fine. The trouble here is, that on the form/report I'm having trouble with, I think it's going to a subtable with dates on it, when the form I need isn't required to have dates. How do I fix the subtable so it is not calling up dates?

 

[VelvetVoice]

I posted a snapshot of the table. The table in question has a list of items, and there are little plus signs where the primary key designation usually is. Like when you look at Windows Explorer, and clicking on those little plus signs opens the folder to show what is in them. It shows the lines that the tables connect to.

I've rewritten these tables and tried to paste them in the test environment, it seems to work for the monthly reports I am doing, but it is not working on the daily blank forms. I can cut-and-paste the VB macros that I am looking at, because I think it is looking at an unrelated table to get dates.

Don't spend too much time trying to fix this, because I've gone to Excel to create these forms and reports, basically I'm going to use Access as the information database, and create the forms and reports in an ODBC link to Excel. It's basically a matter of personal pride that I want to know what the problem is.

 

[VelvetVoice]

Here is a copy of the query design, report design and the macro. As you can see, it is referencing the Activity table when it doesn't need to. These blank forms do not need to be dated. I'm not sure why the designer put that in there.