--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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 > There wasn't a data of Record Source when I oppened a report in Design view, only a Control Source. If you would like I could send you the entire database. It is called Books, and 2 reports with my problem are called "Autorski katalog" and "Predmetni katalog". Let me know.
------------------------ 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/
