report results (1 Viewer)

[pwicr]

Hi,

I have a report that works great!

I added a new model to my table "tblModels" today. It is set up EXACTLY like all the other models.

When I run the report with the new model I get #Type in the Model and no results anywhere else...if I use the SAME vehicle but change it to a previous model, it works fine.

Suggestions?:banghead:

 

[Trevor G]

Can you upload a sample of the database and state which table, which form and which report.

How is the report generated?

 

[pwicr]

I've taken out all the information, reports, forms & queries that I possibly can and it's too big to attach. I tried Zip and that won't accept for upload either.

 

[Trevor G]

Try using Drop Box or something similair and then post the link to it.

 

[pwicr]

does this work?
https://www.dropbox.com/sh/agkeanovmfadrw2/0dCF58NTrn

 

[pwicr]

the forms and queries are the only ones there.

to produce the report rptPWMSO go to the dealer tab in the form and click PWMSO button.

PURST is the problem

 

[Trevor G]

Sorry to say that I can't do anything all the tables are linked to another system so not able to open anything.

 

[pwicr]

the back end is in there too.

 

[pwicr]

https://www.dropbox.com/sh/agkeanovmfadrw2/h54Ursd9si/Dealers2011_be%20-%20Copy%20%282%29.accdb

 

[pwicr]

this is the front end, the above is the back end.

https://www.dropbox.com/sh/agkeanovmfadrw2/IdWycLypl8/Dealers2011_FE%20-%20Copy%20%282%29.accdb

 

[pwicr]

Remember, once you download them, you will have to relink to the new location from the front end.

 

[vbaInet]

Sorry I haven't got time right now to look at your db and do the re-linking etc. But what is the difference between the old model table and the new one? Are there any structural differences? If there aren't, make a copy of the table (without data) and copy and paste it across to the copy and rename your copied table.

 

[Sandrra]

Try using Drop Box or something similair and then post the link to it.

Thanks for this, was able to use it...