Open the report in Design view. Open the Properties window. Find the Record Source property and let us know what's in it. You should be able to click in the property and then click the Builder button (...) next to the property to open the Record Source in a query window. Switch to Datasheet view to see if the query returns any rows.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ivcebos Sent: Wednesday, November 09, 2005 3:41 AM To: [email protected] Subject: [ms_access] Re: A little problem with reports Thanks, John, for your concern. My report is blank in Print Preview, although it has only one thing on a top, and that is a title of the report. I could not find any queries in the database, b ut I did find a VBA statements for main form and it's subform. If you are interested I could post it to you by e-mail next time. Once again, thanks a lot! --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Do you mean that the report is blank when you open it in Print Preview? If > so, then the query must be filtered in some way so that it returns no rows. > What happens if you open the query in Datasheet view? Is there any data to > display? > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of ivcebos > Sent: Thursday, November 03, 2005 5:25 AM > To: [email protected] > Subject: [ms_access] A little problem with reports > > Hi, I am a librarian, and I have a database that someone else has > programming in 1997 by using MS Access '97. It has 7 tables. Three of them > are the point of my question. > > Table1 has 8 fields: id, Bookid, Title, Topicid, PublisherName, > DateofPurchasing, Price, CoverType. > > Table2 has 3 fields: Authorid, AuthorFirstName, AuthorLastName. > > Table3 is connection between two previous tables, and has 3 fields: > BookAuthorid, Bookid (which is the same as Bookid in Table1), Authorid > (which is the same as Authorid in Table1). > > My database has main form which is based on Table1, and it's subform, based > on Tables 2 and 3. In subform (about authors) the designer of database put > together AuthorFirstName, AuthorLastName in one row by sql statement. When > he designed a reports to make catalogue of books and authors, he used the > same sql statement to put together AuthorFirstName, AuthorLastName in one > row. It is very much shown in Design mode of both reports, but in Preview > mode all I saw last year when I started to work in that library were a title > of those reports. > Please, any one, help me. > > I am working with MS Access 2003 now. > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair > play? Video games influencing politics. Click and talk back! > http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM > --------------------------------------------------------------------~- > > > > > Yahoo! Groups Links > Thanks, John, for your concern. My report is blank in Print Preview, although it has only one thing on a top, and that is a title of the report. I could not find any queries in the database, b ut I did find a VBA statements for main form and it's subform. If you are interested I could post it to you by e-mail next time. Once again, thanks a lot! ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
