--- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > > The Properties window displays the properties of whatever object you have > selected. It sounds like you clicked in a control before looking at the > Properties. You must select the report, then look for the Record Source > property. Choose Select Report on the View menu or press Ctrl+R. > > 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of ivcebos > Sent: Friday, November 11, 2005 6:07 AM > To: ms_access@yahoogroups.com > Subject: [ms_access] Re: A little problem with reports > > 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. > > --- In ms_access@yahoogroups.com, "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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] > On Behalf > > Of ivcebos > > Sent: Wednesday, November 09, 2005 3:41 AM > > To: ms_access@yahoogroups.com > > 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 ms_access@yahoogroups.com, "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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] > > On Behalf > > > Of ivcebos > > > Sent: Thursday, November 03, 2005 5:25 AM > > > To: ms_access@yahoogroups.com > > > 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 > Thanks, John, that really worked.
I was able to open Report Properties, and on a top was, of course, Record Source. I clicked in the property and Builder Button. I was certainly suppraised when I saw a query in Design view. I was also able to switch it on to the Datasheet view. That query returned approximately same number of rows like I have in main form, about 2500 records. After that I closed a query and tried to open my report in Preview mode, and it worked. So, really, really thanks a lot, John! ------------------------ 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 <*> 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/
