|
More site info...
Discussions in microsoft.public.access.reports - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.access.reports:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
94
|
286
|
759
|
|
Post:
|
177
|
564
|
1,804
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.access.reports (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.access.reports posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.reports Alexa graph:
|
Top authors on Discussions in microsoft.public.access.reports during last week:
user's latest post:
Look-up Wizard not pulling all...
Published (2009-11-27 20:55:00)
Your junction table should only include the primary key from the QryStaff List and tblEduationOfferings. You can add other information that is not in the other tables. This can be implemented using the solution I suggested previously.
user's latest post:
weird report result in...
Published (2009-11-27 10:35:00)
Pedro wrote: >I've made a simple report but with just the objects on the footer section. >12 lines each one with 13 objects, like an anual report. So far so good. It >shows me all the way i want. But i would like to add 8 lines more with >another 13 objects per line. The weird thing is that, it adds my first page >in blank. Completly in blank. Nothing. the 2nd page with the results and 3rd...
user's latest post:
Help with report formatting in...
Published (2009-11-25 09:03:00)
A crosstab query will do it for you. TRANSFORM Sum([Dollar Amount]) AS SomOfDollar SELECT [Item] FROM YourTable GROUP BY [Item] PIVOT [Month];
user's latest post:
Printing two different dates in...
Published (2009-11-25 06:25:00)
You can use the expression on each page in the Page Header or Create a top-level group based on the expression =1 Add a control to this top-level group Set the control's control source to the = The expression I posted Set the Top-level group's Repeat Section property to Yes (True) so that it will repeat on every page. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore...
user's latest post:
Report_Close event in...
Published (2009-11-23 21:30:00)
When I close my report, some of my code that controls the left margin for odd-even pages runs many times before the report actually exits - it's in some kind of loop but does eventually close. The code in my report is as follows: Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page = 1 Then MoveMargin = 360 ElseIf Me.Page Mod 2 = 0 Then MoveMargin = -360 Else MoveMargin = 360 End If...
user's latest post:
Look-up Wizard not pulling all...
Published (2009-11-27 12:15:00)
Write now here is my structure, part of the problem is that I a novice Access user, and my supervisor wants a lot of variable built in. There are some subTables that you don't really apply to this issue. QryStaff List (Built off of ODBC Linked Tables) ====================== client_id last_name first_name Discipline Position Dept login-id team_name date_of_hire date_of_term active tblEducationOfferings ================== ID#...
user's latest post:
Make appearance of a footer...
Published (2009-11-19 13:12:00)
Can anyone out there tell me if I can make the appearance of a footer conditional upon whether or not there is null data in a particular field? For example, a field in my table is called "Staff_Section." Some records contain a staff_section while others do not. For sections that do not have a staff_section identified, I do not want their numbers to be summed in the Staff_Section footer. For records that have a...
user's latest post:
Database Renewing Process - in...
Published (2009-11-23 07:40:00)
You've described how you want your reports to look ... but not what your underlying data looks like. "How" depends on "what"... More info, please...
user's latest post:
Access / System crashed while...
Published (2009-11-25 04:50:00)
There are some tips on avoiding corruption here http://www.allenbrowne.com//ser-25.html You need good backups. If the work you have just completed took a lot of time and effort and you don't want to lose it, then back it up. There is no need to wait till you close the database. In A2007 you can go Alt + F + M + K to backup. Create a folder called backups. Save the first backup to the folder. After that access will remember...
|
|
|
Top 10 active forums on Discussions in microsoft.public.access.reports during last week:
|
|
Top 10 forums on Discussions in microsoft.public.access.reports:
|
|
|
|
Latest active threads on Discussions in microsoft.public.access.reports:
Started 22 hours, 41 minutes ago (2009-11-28 07:10:00)
by Marshall Barton
Jean-Paul wrote:
>I have this entryfield on my report.
>
>I use a recordfield to display it's data
>
>ABO_Stage
>
>When I change it into
>
>="Bedrijf: " & [ABO_Stage]
>
>I get a # error
>
>What is wrong with the syntax?
Nothing is wrong with the syntax. The problem is that...
Started 22 hours, 56 minutes ago (2009-11-28 06:55:00)
by Jean-Paul
Problem solved.... never mind this question
Jean-Paul wrote:
> I created a report with 2 entryfields:
>
> Afdeling
> BGVer
>
> I wrote following code
>
>
> If Me!Afdeling = "Groodkeukenmedewerker" Then
> Me!BGVer = "ikke"
> End If
>
> I tried to put it in the Details_Format ...
Started 1 day, 21 hours ago (2009-11-27 08:42:00)
by Duane Hookom
Many of us veteran developers hate lookup fields
http://www.mvps.org/access/lookupfields.htm . Consider using forms with combo
boxes.
Started 1 day, 19 hours ago (2009-11-27 10:35:00)
by Marshall Barton
Pedro wrote:
>I've made a simple report but with just the objects on the footer section.
>12 lines each one with 13 objects, like an anual report. So far so good. It
>shows me all the way i want. But i would like to add 8 lines more with
>another 13 objects per line. The weird thing is that, it adds my first page
>in blank. ...
Started 1 day, 21 hours ago (2009-11-27 08:43:00)
by Duane Hookom
You can bind several combo boxes to the same field. If you update one, the
others will update.
Started 1 day, 21 hours ago (2009-11-27 08:39:00)
by Duane Hookom
There is a solution for dynamic monthly crosstab reports at
http://www. tek-tips.com/faqs.cfm?fid=5466 .
Started 2 days, 10 hours ago (2009-11-26 19:15:00)
by Allen Browne
There are several issues associated with this, and MS has not provided
solutions for all of them.
Here's the ones I'm aware of:
http://allenbrowne.com/ser-63.html
The section of that article on Exports contains the links to MS's kbs.
|
|
Hot threads for last week on Discussions in microsoft.public.access.reports:
Started 5 days, 12 hours ago (2009-11-23 17:20:00)
by Jeanette Cunningham
You can use the Nz function to replace the missing value with an empty
string.
In the control source of an unbound textbox put-->
=[field one] & Nz([field two], "")
If you want a space between the 2 values, use
=[field one] & " " & Nz([field two], "")
Jeanette Cunningham MS Access MVP -- Melbourne Victoria ...
Started 5 days, 15 hours ago (2009-11-23 14:15:00)
by Steve
How about a crosstab query using Sample Dates as columns and Samples as rows
grouped on Station.
Steve
santus@penn.com
"Cydney" <Cydney@discussions.microsoft.com> wrote in message
news:2937F6CD-B445-4FE2-8480-9D0CF492882B@micros oft.com...
>I am needing to create a query (or queries) which when completed will...
Started 6 days, 13 hours ago (2009-11-22 16:15:00)
by Ken Snell
Also set the CanGrow and CanShrink properties to Yes for the section in
which these textboxes are located (perhaps the Detail section?).
Started 4 days, 22 hours ago (2009-11-24 07:05:00)
by Allen Browne
1. Create a group header on your date field.
2. Put the date in this section instead of the Page Header.
3. Set the section's Repeat Section property to Yes, so it repeats at the
top of each subsequent page.
Started 1 day, 21 hours ago (2009-11-27 08:42:00)
by Duane Hookom
Many of us veteran developers hate lookup fields
http://www.mvps.org/access/lookupfields.htm . Consider using forms with combo
boxes.
Started 4 days, 10 hours ago (2009-11-24 19:15:00)
by Jeanette Cunningham
It sounds like there is some corruption in that report you were creating
when access shut down.
To do the trick with importing all in to a new database, import everything
except all reports into the new database.
Then import only the reports that you know will work OK, leaving the
corrupted one or ones in the old database....
Started 1 week, 1 day ago (2009-11-20 10:50:00)
by Ken Snell
=iFileCount([IDField])
Put the name of the field in [ ] characters.
Started 1 week, 1 day ago (2009-11-20 13:25:00)
by Duane Hookom
You will probably need a simple public function that returns the variable like:
Public Function GetCurClient() as String
GetCurClient= CurrentClient
End Function
You can then set a control source to the function.
Started 1 week, 1 day ago (2009-11-20 07:18:00)
by Jen
"Jen" wrote:
> Hi Guys,
> I have a form where you can enter employee details. Each employee has to
> be trained on 9 different jobs so there were too many controls to fit on a
> single form, so i created a Tab Control to split it up into manageable
> sections.
> Altogether there's about 150 controls and ...
Started 1 week, 1 day ago (2009-11-20 09:20:00)
by Jeff Boyce
Perhaps one of the other newsgroup readers has puzzled out a way to do this
within Access.
If I needed a watermark on an Access report, I'd probably just export it to
Word and do the watermarking there... (or, if you are fortunate enough to
have access to one of those modern whiz-bang printers, you can have the
printer add ...
|
|
Size: 1,018 bytes
