RE: [MS_AccessPros] Customize report

Regarding #1, please post back with your report's record source SQL view.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: cc0623@yahoo.com
Date: Wed, 2 Nov 2011 15:42:05 -0700
Subject: Re: [MS_AccessPros] Customize report

Thanks Bill,

The "Is not Null" was close but, it excluded all records if it had a nothing in the field. I need it to show the records IF they have an extension or phone number. Some people have phone numbers but no extensions and vice versa.

I played with the margins and it is obvious that appears to be the problem, when I look at print preview all the columns show up. The problem is it skips pages, I need to tell it to only add 8 columns to the page and then go to the next page.

Tiffany Atchley

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, November 2, 2011 4:21 PM
Subject: Re: [MS_AccessPros] Customize report

Tiffany

I'm nearing going-home time, but I can maybe help with a couple things.

1. Your report should be based on a query. If it has a table as its Recordsource change it to a query. Add criteria in the query design view. Put: Is Not Null in both of those fields. That way, any records where they are null will not be on the report.

2. Anytime a report hs blank pages it means the report is wider than the margin settings so the extra width gets carried over to the next page. Columns are sometimes difficult to work with. try adjusting margins under page settings. Also see if the number of columns is too wide for the page.

If you can't get it to work upload a zipped sample to our Assistance needed folder. One of us is sure to help.

3. As far as I know, the only view that will show you all columns is preview, but I'm not sure about that. I'd have to see the report.

Bill

--- In MS_Access_Professionals@yahoogroups.com, cc0623 <cc0623@...> wrote:
>
> Bill -
> Â
> Can you help me with these last three problems? Then my report will be finished.
> Â
> 1. I would like to exclude any names from the report that does not contain an extension or phone number.
>
> 2. My report is not showing all the names. It says there are three pages but on page one the last name on the page starts with a C and then page two jumps to the R's and page three is completely blank.
>
> 3. I can only see the first four columns in all views other than print preview. In print preview it shows all eight columns. I would like to see all the columns in the other views as well if possible.
> Â
> Thanks,
>
>
> Tiffany Atchley
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, November 2, 2011 11:26 AM
> Subject: Re: [MS_AccessPros] Customize report
>
>
> Â
> Tiff -
> Do you know how to use Conditional Formatting?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, cc0623 <cc0623@> wrote:
> >
> > Acces 2010
> >
> > ÂÂ
> >
> > Tiffany Atchley
> > PO Box 1003
> > Fort Duchesne, UT 84026
> > 435-722-7833
> > WWW.ODYSSEYMINISHETLANDS.NET
> >
> >
> > ________________________________
> > From: Bill Mosca <wrmosca@>
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Wednesday, November 2, 2011 11:23 AM
> > Subject: Re: [MS_AccessPros] Customize report
> >
> >
> > ÂÂ
> > Tiffany
> >
> > What version of Access are you using? 2003 and older has report conditional formatting just like forms.
> >
> > If that won't do it for you, use the section's format event like this:
> >
> > Select Case MyDept
> > Case 'Admin'
> > txtDept.BackColor = 255
> > Case 'Facil'
> > txtDept.BackColor = 12224
> > Case Else
> > txtDept.BackColor = vbwhite
> > End Select
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.com, cc0623 <cc0623@> wrote:
> > >
> > > Okay here is the problem. I created a report off of a table. Tables and queries do not accept color formatting right? I do have a datasheet form colored the way I want it but it appears that I cannot create a report off a datasheet form. Is this correct? So how do I color code the depts on my form?
> > >
> > >
> > > Tiffany Atchley
> > >
> > > ________________________________
> > > From: Bill Mosca <wrmosca@>
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Sent: Wednesday, November 2, 2011 10:12 AM
> > > Subject: Re: [MS_AccessPros] Customize report
> > >
> > >
> > > ÂÂÂ
> > > Tiffany
> > >
> > > Are the colors coming from Conditional Formatting or are they ones you set in the form's design?
> > >
> > > Regards,
> > > Bill Mosca, Founder - MS_Access_Professionals
> > > http://www.thatlldoit.com
> > > Microsoft Office Access MVP
> > > https://mvp.support.microsoft.com/profile/Bill.Mosca
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, cc0623 <cc0623@> wrote:
> > > >
> > > > Duane,
> > > > How do I get it to carry over the color from the form? I have some of the records color coded. Also it was continuing into the next row like I wanted but then I moved the column titles up to the header and it stopped. I moved them back but it still does not carry over. I have hit refresh several times.
> > > >
> > > > Tiffany Atchley
> > > >
> > > >
> > > > ________________________________
> > > > From: Duane Hookom <duanehookom@>
> > > > To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
> > > > Sent: Tuesday, November 1, 2011 5:20 PM
> > > > Subject: RE: [MS_AccessPros] Customize report
> > > >
> > > >
> > > > Tiffany,
> > > > Use the page setup menu options to create a multi-column report. I think you can even use the label report wizard.
> > > >
> > > > Duane Hookom
> > > > MS Access MVP
> > > >
> > > >
> > > >
> > > >
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > From: cc0623@
> > > > Date: Tue, 1 Nov 2011 22:57:10 +0000
> > > > Subject: [MS_AccessPros] Customize report
> > > >
> > > >
> > > > ÂÂÂ
> > > >
> > > >
> > > >
> > > > 1. The data is repeating itself in the second set of columns. I would like it to just continue with the data and not repeat the same data over again.
> > > >
> > > > The report is a contact list. There are 4 columns with data, I copied these four columns, so there are now 8 columns. I did this to maximize the space on the page. I would like the data to flow down the page and then back up to the next set of columns and back down again and continue on the next page until complete.
> > > >
> > > > Can someone help me with this?
> > > >
> > > > Thanks,
> > > > Tiffany
> > > >
> > > >
> > > >
> > > >
> > > >                 ÂÂÂ
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/