Bibliography Help

[poodlestrudels]

Please help!

I have a major problem. I’m trying to build an automated bibliography in Excel, via a report, however, it just wont work. Right now I’m using this command:

=[Book Title Search]![Author/Editor] & ". " & [Book Title Search]![Year Published] & ". " & [Book Title Search]![Title] & ", " & [Book Title Search]![Publisher] & ". " & [Book Title Search]![Publishing Location] & "."

, but it just returns a #Error? message instead of the data. My guess is that it’s because it’s only made for just one row of data from a table, but it’s only a guess. Could somebody solve my mystery?

 

[boblarson]

well, one BAD thing that you have to start with is that there is a slash mark within a field name. That will honk things up royally to begin with.

Let's emphasize here: Do NOT use special characters within field names!

Also, try not to include spaces. If you must have the names spaced out use underscores. Unlike the / character, spaces can be used within field names, but they too can cause you headaches later. So for safety's sake - don't use them.

So, rename your field without the / character and see if that doesn't help.

Oh, and one other thing:

Make sure your text boxes within your report Are NOT named the same as your field names!

In other words, if you field name in your table is: BookName
Then make sure you name your text box something like txtBookName and not BookName.

 

[poodlestrudels]

Thanks for the help, but the problem persists...

Well, I changed the code to:

=[Books]![Author_or_Editor]&[Books]![Year_Published]&[Books]![Title]&[Books]![Publisher]&[Books]![Publishing_Location]

I use the table now, as opposed to the query, but I get #Name? as an error message. I have a strong feeling that itknow where to go, but not how to show it. Is there a way to either spawn multiple fields to show the data, or maybe even split it into sections within the text field? Maybe i'm wrong, is there something that I missed?

 

[boblarson]

Again I re-emphasise:

B]Make sure your text boxes within your report Are NOT named the same as your table's field names![/B]

And then check to see if your References are okay and none listed as MISSING.

If you need more detail on the references, do a search within this bulletin board for "MISSING REFERENCES" as there is a TON of posts on them and how to deal with them.

But the first thing I would say is this:

If your table's field name is Book Title Search, then make sure the text box is not named Book Title Search and that it is something like txtBookTitleSearch.

 

[poodlestrudels]

Well, thanks for the help.....

Thank you for replying, but I found the real poblem. It turns out that I needed to set the "Record Source", so the report did not know what data toview from which location. Once I did that, everything worked just fine.