Over 1 million tech questions and answers.

Access 2007 report formatting in groups

Q: Access 2007 report formatting in groups

Can anyone tell me how I reduce the line spacing in a group in reports. Any help would be greatly appreciated.

RELEVANCY SCORE 200
Preferred Solution: Access 2007 report formatting in groups

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Access 2007 report formatting in groups

Report Line Spacing is literally controlled by the layout on the Report, so reduce any space between lines and from the "Group Header & Footer".

Read other 1 answers
RELEVANCY SCORE 102.8

I have an access report that I am having trouble formatting. I have a field of 13 characters and I want them grouped by the first 9 characters so that there is a line once the first 9 characters changes.

For example: If the data shows AAA AA AA.AA, then the next line is AAA AA AA.AB, I want there to be a bold line inbetween those rows on the report so it is easier to see when the sections change.

Is there any way to do that?

Thank you!
 

A:Solved: Add formatting to groups in Access report?

Read other 12 answers
RELEVANCY SCORE 90

I am trying to produce a report in an outline format as follows:

Employee Name
Employee Name
Employee Name

Client

Heading 1
Subheading
Subheading
Subheading

Heading 2
Subheading
Subheading

There may be more than 1 employee doing a particular service for a client. They each input their service seperately as a new record. I need to be able to pull out the information for headings and subheadings to display as above. I also need to be able to pull out the information associated with the client. My fields are Department, Employee First Name, Last Name, Client, Heading, Subheading. How do I display this in a report. Have tried many options. Please Help!!
 

A:Solved: Access 2007 Report Formatting

Read other 15 answers
RELEVANCY SCORE 77.2

I have a database for a senior center membership. Members are from a number of area towns. I am trying to write a report showing the demographics by town. ie gender, age etc. I have grouped a count of members by town, and now I want break that down by age groups. It would look something like this:
ANYTOWN 50-60 60-70 70+
members = 20 10 5 5

NEXTOWN
members = 10 3 3 4

ETC.

I found a function on line that will compute ages from DOB and assign them to age groups. I use this function in a query that gives me the demographic info I'm looking for, including a column named "AgeGrps" My problem is "How do I get a count of each age group by town in the format shown above?" Any help will be greatly appreciated
 

A:Counting Age Groups in an Access Report

Ron, it may take 2 queries to do this, one to put them in to the age groups and then a second one to Group and count them by Town. Or you could possibly use a Crosstab to do the Grouping and Counting.

Can you post a zipped Access 2000-2003 copy of the Database for us to look at?
 

Read other 1 answers
RELEVANCY SCORE 70.4

HOW DO I CONVERT AN ACCESS 2003 REPORT INTO AN ACCESS 2007 REPORT?
 

Read other answers
RELEVANCY SCORE 70.4

I am having trouble with a report in Access. I have attached a sample page of the report. In the page footer section, I have a row for "Grand Total", "Delivery and Prep", and "Users". I have 2 problems:

1. The items in the page footer are showing up on every page (which would stand to reason), but I only want them to appear on the last page. What section should these calculated controls be in? And how do I get that section to appear in design view?

2.Why am I getting the #Error in the Grand Total field? The calculation being done is =Sum([Boise]) and of course the city name in brackets changes to the city in the column above. The data in the report is coming from a cross-tab query with fields by the same names and the totals in the report lines are correct in comparison with the query.
 

A:Report Formatting in Access

Read other 8 answers
RELEVANCY SCORE 69.6

I have a report, where I have these tbl fields

FirstName LastName Title

I would like it to display:
John Doe, President (if title is present)
or John Doe (if title is not present)

I can concatenate the fields just fine, what i can't figure out, is how to have a comma based on "If".....

any help appreciated.
 

A:Access 2000 Report Formatting

Read other 9 answers
RELEVANCY SCORE 69.6

Ok all, bear with me. I have created a simple database that holds agent statistics for a daily scorecard. There are 6 different types of employees and each type has a certain criteria to meet.

I.E. - An entry level employee must meet a quota of 8 calls per hour (CPH), If he/she meets it then they "Meet Expectations" if it is below then they "Need Improvement"

I have a report tht lists all employees, their employee type (entry, intermediate, advanced, etc) and their "CPH".

I would like their CPH to be color coded based on meeting criteria or not. It would be easy if they all had to meet the same criteria (I would use conditional formatting)but since there are 6 different types, is there a way to write code for this.

Example in plain words:
IF "employee type=entry level"
Then follow these guidelines to color code values.

I know this may be choppy so let me know what detailed information you would need from me. If you want to really help I wouldn't mind sharing my db by email and having you take a look, it is just a very basic database.

This is the code I have so far, i am very new to VB and am not sure if this is correct. It compiles just fine, and I can open the report after saving this code, but it still does not work. Got any ideas???

Here is what i have so far...let me know what questions youhave or if there is anything you need to help me out. Thanks
Code:
[SIZE="3"]Private Sub Detail_Format(Cancel As Integer,... Read more

A:Solved: Formatting Access Report with VB

Closing duplicate, please reply here:

http://forums.techguy.org/development/504994-vb-programming-formatting-access-reports.html

eddie
 

Read other 1 answers
RELEVANCY SCORE 69.6

In access 2000 the formatting choices for information in a text box are R, L,C
how do you justify both margins. You can do this in Word, is it possible in Access?
 

A:Access 2000 report formatting

Read other 11 answers
RELEVANCY SCORE 66.4

Hey everybody

A report that I have in access messes up when I export it as an Excel spreadsheet. I export it, and then go to open the excel file. When I open the file up, I get the error message "File error. Some formats may have been lost."

When this happens, I look at the excel file, and the some of the dates I have are numbers like "38848". The dates should be dates like 5/25/2006.

The odd thing is, all the dates aren't messed up. Any ideas on what is going on?
 

A:Solved: Access 2003 - Exporting Report to Flash causes Formatting loss

Hey smooth, for an explanation of the dates turning into numbers, check my signature (Access Dates and Access Date Conversions both have info). I don't know why it would happen with only some, but there must be a common trait among the dates that get swapped.

chris.
 

Read other 3 answers
RELEVANCY SCORE 65.6

I am trying to make a report in access 2007 but I need a little help. I want the report to only have entries that have a particular answer. I have a field that asks "Dues paid?" with a combo box that has the answers yes and no. I want the report to only list the people with the answer no. How do I do that? Thank you!
 

A:Access 2007 Report Help

Supply the report's data using a Query, in the query's Criteria row for the "Yes/No" field enter 0, that is a zero.
Queries normally use -1 for yes and 0 for no.
 

Read other 1 answers
RELEVANCY SCORE 65.6

If I have a description (memo) type field on a report. Is there a way to have the field auto expand based on the contents of the description field?
 

A:Access 2007 Report

You need to set both the Details Section to "Can Grow to Yes" and the Memo Field as well.
I would also set the Can Shrink to yes as well.
 

Read other 1 answers
RELEVANCY SCORE 65.6

Hi im having a little problem hopefully someone can help me.

I have a form, it has a subform in it. In the form i have a drop down box where i pick a client and the form and subform filters based on the client picked. In the main form i also have textboxes, that show numbers based on the client picked.

I like to have a button in the main form, that when i click it, i want it to take all this information (main form and subform) and show it in a report like an invoice.

Please help
Thank you
 

A:Access 2007 Report. Help

Read other 6 answers
RELEVANCY SCORE 64.8

I am trying to design a Access Report using Access 2007. I find that the report defaults to 22". I've tried to change this, but Access will not allow me to do this. How do I change the height to around 35"?

Dennis Gehris
 

A:Access 2007 Report Setup

Read other 8 answers
RELEVANCY SCORE 64.8

I am using Access 2007. I created a report and added my fields now I want to change how they appear - move them around on the form. When I click on one and move it it brings the whole line with it. What am I doing wrong? Thanks
 

A:Access 2007 Report Design - Help!

Carla, is it a Report or a Form?
I do not have Access 2007 so I can't really help you directly.
 

Read other 2 answers
RELEVANCY SCORE 64.8

Hi, I have are report which displays results from a search that includes all of my tables.
I am currently testing the report and upto now it is displaying the correct results but is repeating them.

For example, a search i am running should return two results, but is repeating them over and over.

Any help would be great.

cheers
Lewis
 

A:Repeating Report in Access 2007

Read other 12 answers
RELEVANCY SCORE 64.8

Is there a way to send a report automatically from Access 2007 via Outlook 2007 to someone at a certain time - let's say 11:00 pm - without having to open the application or Outlook. If not, what is the best way to automate the process so the report is emailed automatically at a certain time during the day without user intervention? Thanks
 

A:Automate a Report from Access 2007

Read other 10 answers
RELEVANCY SCORE 64.8

Hello,
I am trying to narrow fields by Month, Quarter, and Year for several reports. Month and quarter work, but for some reason, when I try to set my dateEntered criteria for Year I do not receive any results. Here is what I am using so far for the dateEntered field criteria:

Month:
Between [Forms]![Individual Time Card Report Form]![Combo15] & "/01/" & [Forms]![Individual Time Card Report Form]![Text19] And [Forms]![Individual Time Card Report Form]![Combo15] & "/31/" & [Forms]![Individual Time Card Report Form]![Text19]

Quarter:
Between [Forms]![Individual Time Card Report Form]![Text29] & "/01/" & [Forms]![Individual Time Card Report Form]![Text34] And [Forms]![Individual Time Card Report Form]![Text32] & "/31/" & [Forms]![Individual Time Card Report Form]![Text34]

Year:
Between "1/01/" & [Forms]![Individual Time Card Report Form]![Text25] And "12/31/" & [Forms]![Individual Time Card Report Form]![Text25]

The text boxes refer to user input from an already open form (which works fine for Month and Quarter) What am I doing wrong with year? Or is there an easier method for searching for only records from a specific year? Thanks
 

A:Access 2007 Report Query

Read other 15 answers
RELEVANCY SCORE 64.8

Hi All,

I'm having difficult getting a VBA report filter to work.
The code is based data within a form.

I can get the data filter to work properly but I can't get the combo box part to work. I just get "Error 438"
I could really use some help.

Here's the code....
Private Sub Preview_Click()
On Error GoTo Err_Handler

Dim strReport As String
Dim strDateField As String
Dim strFilterLevel As String
Dim strWhere As String
Dim varWhere As Variant
Dim lngView As Long
Const strcJetDate = "\#dd\/mm\/yyyy\#"

strReport = "Members Detailed"
strDateField = "[Member Entered]"
strFilterLevel = "Account Level"
lngView = acViewPreview

If Me.cboFilterLevel > 0 Then
cboFilterLevel = varWhere & "Account Level = " & Me.cboFilterLevel & "AND"
End If

If IsDate(Me.txtStartDate) Then
strWhere = "(" & strDateField & " >= " & Format(Me.txtStartDate, strcJetDate) & ")"
End If
If IsDate(Me.txtEndDate) Then
If strWhere <> vbNullString Then
strWhere = strWhere & " AND "
End If
strWhere = strWhere & "(" & strDateField & " < " & Format(Me.txtEndDate + 1, strcJetDate) & ")"
End If

If CurrentProject.AllReports(strReport).IsLoaded Then
DoCmd.Close acReport, strReport
End If

Debug.Print strWhere
DoCmd.OpenReport strReport, lngView, , strWhere

Exit_Handler:
Exit Sub
Err_Handler:
If ... Read more

A:Access 2007 VBA report filter

Read other 11 answers
RELEVANCY SCORE 64.8

I have created a report in Access 2007. The table that the report is based off of does not have any duplicates. However, my report is showing multiple duplicates. My report is grouped by Provider Name with a title header. Then in the detail section of the report I have the following fields: Measure, Member name, Member ID, Address, City, State, Zip. Since the report is grouped by provider, the member could have different measures listed by their name. In which case, I would expect to see them on the report more than once. However, the report is currently showing multiple members for the same measure; therefore, resulting in duplicate information. How can I get rid of the duplicates in the report?

Thanks,
Tonya
 

Read other answers
RELEVANCY SCORE 64.8

Good morning. I found this forum this morning and I hope someone can help me out. My company is looking for a report that will list purchase orders and invoices paid against them. The PO amounts and invoice amounts are housed in the same table but in separate columns. There are multiple invoices paid against every PO. In order see which invoices were paid on each PO, there is a column for PO number. The PO number gets entered in on every line. I have tried to set up a query that will deduct the invoice amount from the PO. The problem I am running into is when the query runs the PO amount pulls in for every time an invoice is paid against it. For example PO123 is $30,000 and the following invoices are paid against it: INV 3 - $5,000, INV4 - $5,000 and INV5 - $5,000. The query will return $90,000 for the PO amount and a cumulative total for the invoices of $15,000. What do I need to do? Any help would be greatly appreciated. Thank you.
 

A:Solved: Access 2007 AP Report

Read other 16 answers
RELEVANCY SCORE 64.8

I have a Access 2003 application which has many reports.

When I am using 2003 and in the report view right clicking the mouse is giving me options one on that is "export" where I can export the report to Excel, DBF, CSV etc.,

But this feature is not available when I try my application using Access 2007

Any help please?
 

A:MS Access 2007 Report Export not there

Maybe I'm missing something, I created a dummy report>>right clicked and got these options....(see attached)
 

Read other 3 answers
RELEVANCY SCORE 64.8

I have a query that pulls the data I need from some tables. I built a report based on that query. Now I want to create another report using the same query, but filtered by criteria in 1 filed. Can I do this without creating another query? Nothing I put in the data tab of the properties window seems to work.
 

A:Access 2007 - Report Filter

I am not sure why you don't want to just copy the Query & report.
But as you don't you could try adding this to the 1st Criteria Row of the Field you want to filter
Like "*" & [Input Selection] & "*"
When you leave the Input message box blank it will sho all the records.
Even better is to have a form with a Combo box to make the filter selection with, as that prevents typing errors.
 

Read other 3 answers
RELEVANCY SCORE 64

I work at a facility with many computers; some are using Access 2010, and others are still using Access 2007. I am developing an app, originally in Access 2007. The conditional formatting on a sub-form is not displaying right away. The sub-form will load, and then it's like Access will "forget" to re-paint the subform's conditional formatting, leaving them in their "default" format. When I click on the subform, the conditional formatting will kick in then.

It sounds like a nuisance, but this has been deemed a fatal flaw by the users.

I have added Form.Repaint, Form.Requery and DoEvents to the subroutine that re-queries the subform. No effect.

I know that Access 2010 uses a different conditional formatting scheme from Access 2007. But I doubt this is the issue, as the first three conditions (in Conditional Formatting) are showing up in Access 2007 (after the click on the subform, that is).

Suggestions & insights are appreciated.

Bob
 

A:Access 2007 Conditional Formatting Trouble

Read other 16 answers
RELEVANCY SCORE 64

I havn't been able to find a solution for a problem like this, so here it is..

I have alot of data displayed on a form. When i click a button on that form, it's supposed to open a report with the information that is displayed on the form. (basically it's a "review form before submitting" functionality) I need this report to show the information on the form the button is on, and also some information that is inside a subform on that form.

I am having issues having the report display this information when the button is clicked.. It's asking me to enter parameter values that it shouldn't be asking me for. Has anyone made a function like this before that has a solution? Any example code would be great
 

A:MS Access 2007 / Report Filter not working

Read other 15 answers
RELEVANCY SCORE 64

Hello all,
I am using MICROSOFT OFFICE ACCESS 2007
I am having a dilema with this report I created to print cards. It is on preprinted 4 up card stock paper. I have designed the report to fit in the spaces it needs to be. The only thing is this database has almost 30k records. It is currently printing the same record 4 times on the same sheet of paper. It also prints a few extra blank sheets also afer each page.

I can reduce the database down to maybe 10-15 records if someone wants to take a look.

What I need to happen is print 4 different records on the page with no blank pages after.

Any suggestions would be greatly appreciated.

Thanks in Advance.
John.
 

A:Solved: Question about Access 2007 report

Read other 7 answers
RELEVANCY SCORE 64

I have a report I run based on a query that works perfectly. I'm managing event registration for an association of school student councils. The report is a separate page for each school that summarizes the information I have for that school relative to its participation, i.e. school name, address, who is coming, how much they owe, etc.

It works fine when I want a page for all of the schools, but sometimes I just want a single school...not all of them. I copied my original query and set up a parameter in the copy [What school?] and it selects the school I want. However, when I run a copy of my original report I made changing the source to my new query, when I open the report, the parameter box opens, I put in the school name I want, and the box comes up again, and eventually my report opens with no data in it.

Help? I don't do VBA, but I get around Access pretty well.
 

A:Access 2007 - Report from Query with Parameter

Read other 9 answers
RELEVANCY SCORE 64

Hi,

I am looking to highlight the report entity i.e. Date if Null, becomes highlighted as RED.

Private Sub Report_Current()
If IsNull([Report Date]) Then
Me.[Report Date].BackColor = RGB(255, 0, 0)
Else
Exit Sub
End If

End Sub

The above work on the report only when i click on the report field and it turns it into RED.

I want it to automatically turn RED if the Date results on the report are NULL.

I have also tried with Report on Load , on Open etc but results remain the same.

I hope this is clear.

Regards,
aejaz
 

A:MS Access 2007 Report results Highlight as red

Read other 11 answers
RELEVANCY SCORE 64

I have a created a report that requires the following information.
It must pull repair data from an OrderID Table & OrderItems Table and calculate the totals of repairs per unit and per company. This all works fine (one small glich with null value)

OrderID Table has the fields "OrderNumber"(autonumber), "OrderDate"(default date), "CustomerName", "CoverallID#"
OrderItems Table has the fields "OrderNumber", "ServiceItem", "RepairQty", "detailID" (autonumber)

Input into these tables come from an OrderForm with a SubOrderForm.
The orderform inputs to OrderID Table and supplies the OrderNumber for the OrderItems Table.
The suborderform inputs to the OrderItems Table.

All Tables have a default value set for the Item, Rate, Qty...etc.
So when I pull up the report everything totals fine where an item on the subform has been entered

The issue I am having is this....
There are some orders where only info on the main form is needed ...the suborder form is only for repairs.
When repairs are entered the totals on the report are fine.
When repairs are not entered it does not create a record in the OrderItems table....only the Ordertable.
Therefore the repair total on the report thinks there is a null value and comes up with an error.
I have made sure there is a default value set on the OrderItems table for the OrderNumber, ServiceItem, RepairQty and DetailID.
So I am not sure how to correct this.

Any h... Read more

A:Access 2007 report trouble with null value

Read other 16 answers
RELEVANCY SCORE 64

I was trying to create a report from scratch based on a parameter query in Access 2007. But my query did not show up in the "Fields List Box" where I could pick the fields I wanted for my report. I saw all the tables in my database with their associated fields in that box but no query. Is there anything I was doing wrong? Please help

Thanks
 

A:How to base a report on a query in access 2007

The easiest way to accomplish this is to highlight the query and Hit report - you can then strip it all out and start from scratch again but it will link the correct fields

Its strange i know but it jsut doesnt like to work with queries.

The alternative is, if you really do want to start from scratch is create the Text Box (unbound) and link it in properties to the relevant field. Like in the picture
 

Read other 2 answers
RELEVANCY SCORE 64

Hi,

I am working for a small Hotel where we need to generate a report to watch the accounts. There would be around three types of reports viz. Daily, Weekly and Monthly. I know nothing about MS Access except the names like table, query and forms, other than this its like a rocket science to me.

Here is what i can describe best,
1. Daily transactions like bill number (awesome if automated), payment made, details of food or drinks ordered, date, mode of payment etc will be entered in the system OR may be extracted from the excel dump
2. This Hotel already have a software that helps them do the basic billing thing but is not good at reporting level so we are planning to find an alternative and my boss asked me to use Ms. Access (sorry i am loosing focus)
3. We'll be printing out the daily, weekly and monthly reports and filing them for records

I am attaching a sample excel here to help you understand what the data would be like. Can you please help me with a quick program in MS Access (great if its in 2007) that will serve the purpose.

Thanks in advance,

Vishal
 

A:Help to create Ms. Access 2007 report or form

Vishal, I can assist you with this.
Is the Excel "Input" tab the same as the "excel dump"?
 

Read other 1 answers
RELEVANCY SCORE 64

I have a group done in a report, This causes the grouped on field to appear in the line above the details that belong to it. How do I make this appear on the first detail line of the group? This is to save space in a report that could be overly long with all the 'blank' lines between groups. (I know this should be a problem)
 

A:Access 2007 Report layout question

You can drag the Group Header text down on to the Details and close up the group header.
But you will then have the text on every record.
It might be best to make the Header Font smaller and reduce any spare vertical space to a minimum, the same does for the Details.
 

Read other 1 answers
RELEVANCY SCORE 64

I'm having a problem getting an query right for this report. I've been using Access awhile and have gotten comfortable with SQL queries but I haven't any experience with VBA, modules and classes at this point. (I've managed to work around that so far but am trying to learn on my own)

I have a bond table and my monthly report should show Total Liabilty at the beginning of the month - activity during the month, and Total liability at the end of the month. Table fields needed for this report are:

[Date Bond Set Up] [Dollar Amount of Bond] [Date Bond Cleared]

I need to Count how many bonds were set up in the month. Total dollar value, Total number and amount of bonds cleared during the month and ending liability. Sounds simple right? Summing and counting is easy, but I have two date values and the two dates in the record are usually not the same month.

I have tried an input dialog where you enter month and year, and just set criteria for both the "set up" and "cleared" date fields in the query equal to the input dates for the report, which should in theory show at least activity during the month.(It returned "0" every time) But then I still have to figure totally liabilty at the end of the previous month and new total liability after this month's activity. I'm wondering if I should restructure my tables now. I'm up against a deadline and I'm not rational any more. HELP!
 

A:Solved: Access 2007 Report Nightmare

Read other 16 answers
RELEVANCY SCORE 64

Hello,

First time poster so please be nice . With that out of the way here is my question:

First some background info to help understand the problem:
I am have designed a report in Access 2007 that displays a list of programs on what servers they are installed (if any) and where they are missing.

CountyName ProgramName ProgramVersion Size
County1 BlackHole.exe 2.4.0.5945 1072KB
County1 DirtFarm.exe 2.4.0.5945 1072KB
County1 PlayGround.exe 2.4.0.5945 1072KB
County1 Gremlin.exe 2.4.0.5945 1072KB
County1 Water.exe 2.4.0.5945 1072KB
County1 Hydrogen.exe 2.4.0.5945 1072KB
County1 JustInTime.exe 2.4.0.5945 1072KB
County1 RogerRabbit.exe 2.4.0.5945 1072KB
County1 SuperMan.exe 2.4.0.5945 1072KB
County2 Hydrogen.exe 2.4.0.5945 1072KB
County2 JustInTime.exe 2.4.0.5945 1072KB
County2 RogerRabbit.exe 2.4.0.5945 1072KB
County2 SuperMan.exe 2.4.0.5945 1072KB
County2 Ironman.exe 2.4.0.5945 1072KB
County2 Gorgon.exe 2.4.0.5945 1072KB
County3 BlackHole.exe 2.4.0.5663 1064KB
County3 Astroid.exe 2.4.0.5663 1064KB
County3 Galaxy.exe 2.4.0.5945 1064KB
County3 SpaceMan.exe 2.4.0.5663 1064KB
County3 Clouds.exe 2.4.0.5663 1064KB
County3 Green.exe 2.4.0.5945 1064KB
County3 Ground.exe 2.4.0.5663 1064KB
County3 DirtFarm.exe 2.4.0.5663 1064KB
County3 PlayGround.exe 2.4.0.5945 1064KB
County3 Gremlin.exe 2.4.0.5663 1064KB

what I would like is a way to use conditional formatting on the report to highlight any Program version in red where the program name is the same as County1 but the Program Version i... Read more

A:Solved: MS Access 2007 Report Question

Read other 6 answers
RELEVANCY SCORE 64

I have an access 2007 report that prints the totals from three different fields using three different queries. 1. Total number of businesses, 2. Total number of Inspections. 3. Percentage of Businesses that were inspected, 4. The total number of inspectors.

Because there are dates on the inspections, I have a parameter to enter the year that I want totals for. My problem is that I want the year I have selected to print at the top of the report so it will be evident what period the figures represent. Any ideas?
 

A:Print Parameter on Access 2007 Report

Margo, if you use a Form for the Parameter Input like the one that we used on your first database that I helped with you can then create columns with the Form fields as Headings to include on your report using -
Forms![Formname]![Fieldname]
 

Read other 1 answers
RELEVANCY SCORE 63.6

This is in reply to a thread that was closed due to inactivity, but the original question was never solved, and I believe I have the solution. Perhaps the Mods can move this reply to that thread. In any case, for Bob, or anyone else with this problem:
Bob_Scrivens said:


I work at a facility with many computers; some are using Access 2010, and others are still using Access 2007. I am developing an app, originally in Access 2007. The conditional formatting on a sub-form is not displaying right away. The sub-form will load, and then it's like Access will "forget" to re-paint the subform's conditional formatting, leaving them in their "default" format. When I click on the subform, the conditional formatting will kick in then.

It sounds like a nuisance, but this has been deemed a fatal flaw by the users.

I have added Form.Repaint, Form.Requery and DoEvents to the subroutine that re-queries the subform. No effect.

I know that Access 2010 uses a different conditional formatting scheme from Access 2007. But I doubt this is the issue, as the first three conditions (in Conditional Formatting) are showing up in Access 2007 (after the click on the subform, that is).

Suggestions & insights are appreciated.

BobClick to expand...

The same thing happened to me in Access 2007. One moment the conditional formatting in the datasheet view of my split form was working perfectly, then suddenly only the first record showed the conditional formatting... Read more

Read other answers
RELEVANCY SCORE 63.6

Hello
I have a date format on excel which increases the next date cell by 182,5 days and so on for the next 4 cells increasing it by the same amount... Does anyone know how to do this on Access 2007?
 

A:Solved: Conditional formatting dates in Access 2007

Read other 6 answers
RELEVANCY SCORE 63.2

I'm working in Access 2007, making mailing labels.

Some of the addresses have company names, and some do not. For those that don't, it's showing a blank line where the company name would have been. For example:

Mr. Joe Labelhead

23 Blank Line
Extraspace, ON A1A 1A1

Is there a way to get rid of this line for the records that don't have a company name associated with them?

Thanks
 

A:Solved: Access 2007: Getting rid of empty lines on a report

Read other 12 answers
RELEVANCY SCORE 63.2

Gentlemen,

I have a table "company" with a one to many relationship with the table "Product". The table "Product" has
a ratio of one to many tables with the "Steps" and "Notes." I have a report with three subreports,
(1. With the product name and company. 2. Steps and 3. The comments.) In each
one of the master field is the "ProductID" field and also the son "ProductID". After choosing a product shows a button
clicking it opens the report in accordance with the chosen products. (picture1).

I'm trying to choose a company that when open the same report with all products. But that the steps become
and the separate observations, like the image that I built. (picture2)

Thanks for helping.
 

A:Solved: Access 2007 Problems wich report

Read other 16 answers
RELEVANCY SCORE 63.2

Just found someone who helped write the code...no further help needed.

I have a form to filter some data via a query and you can either view the query results or print a report of the data in a slightly different format. I can't get the filtered result to populate in the report to be printed.

Here is my vba code. Am I missing something? I want anything that is checked a priortiy to be the only thing to print. When I check priority I can view the query results but it doesn't translate into the report. Help??

Private Sub cmdPrintReport_Click()
'The following code displays the pre-close report based on user entered criteria.
Dim strSQL As String
'Check that the user has filled out the form correctly.
If Not EntriesValid Then Exit Sub
'Check that the SQL string was built correctly.
If Not BuildSQLString(strSQL) Then
MsgBox "There was a problem building the SQL string"
Exit Sub
End If
'Run the query.
CurrentDb.QueryDefs("P3-2qry").SQL = strSQL
'Display the report.
DoCmd.OpenReport "P3-3arpt", acViewPreview
DoCmd.Close acForm, Me.Name
 

A:Report won't print from filtered query Access 2007

How many nested if statements are in that thing? I wouldn't even know where to begin looking in that mess to find out where the problem lies. What are you declaring a string as boolean? The function Boolean is true or false.

Have you set a breakpoint at the end of the code and walked through it?
 

Read other 3 answers
RELEVANCY SCORE 63.2

I have three years worth of data in three tables in one database-2008, 2009, 2010.100,000 records in each, with identical column designations including country designation, sales, SKU cost, SKU designation, etc. Of interest are 1) country designation (name of country), 2) SKU designation (what the item is), and 3) SKU cost (what the item cost to sell)

So for France, say, I may have 600 records in the 2008 table with a unique SKU and cost for each record. So France sold 600 different items (with 600 different SKU costs). For Italy, I may have 300 records with a unique SKU and cost for each record, and so on. There are forty countries.

I am interested in mathematically summarizing the SKU cost for each country.

I would like a report that rendered the min, max, median, variance, and standard deviation of the SKU cost for each of the individual countries.

Also there are some SKU costs that are zero that I would like to exclude from the calculation (return results for values greater than 0).

I started trying to build a report using the two fields from the database- country designation and SKU cost, but could not get anywhere with it. Everything I tried in expression builder made Access very unhappy.

I also tried pivot tables, but I could only do one pivot table for each country, and the columns were in text format. I could copy/paste/ and reformat, but for this size of project, that's a lot of work. So I was wanting to develop a summary tool for the three tables.

I... Read more

A:Access 2007-Render arithmetic results in report

Read other 16 answers
RELEVANCY SCORE 63.2

Hi everyone,

I created a report in Access and in the datasheet view the spacing is all off. It looks fine in the design view but the datasheet and the print view have too many spaces. Is there a code I can use to remove the spaces and have everything on one line the way a book will read. The fields I am using are first name, last name, title and phone number. I also need to add a doted line to show which phone number corresponds to what name
(i.e: John Smith, Manager.......555-555-5555)
 

A:Solved: Remove spaces in access 2007 report

It is normal to have the spaces in Access Reports and usually you use a Line to separate the detail rows so you can see what data belongs to who. It uses Columns of data.
You can make it read like a book, but it might make it harder to read and find the phone numbers.
To do what you want remove the fields from the report's detail section and add an Unbound text box, in it's Control Source you type
=[Name] & ", " & [Title] & "......." & [Phone number]
you will of course have to use the correct field names for the name, title and phone.
This can also be done at the Query level.
 

Read other 3 answers
RELEVANCY SCORE 63.2

I have spent all day fiddling with this and getting nowhere. I have a report in Access 2007. It's very simple - just orders placed which I want to send to be printed as a PDF. On screen in the report view it all looks perfect, with orders which involve more than one item showing as they should. However, when I send it to the print preview the detail section disappears and is split across 8 or sometimes 9 pages. I had it working fine (briefly) and then had a go at including a field to total the costs of multiple orders and it's all gone to hell in a handcart since then. I've got the detail section and the controls within set to 'keep together' but nothing so far seems to make any difference. I'd be grateful for simple help as I'm a novice when in comes to coding. Thanks in advance.

Info re my computer:
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 2986 Mb
Graphics Card: Intel(R) HD Graphics Family, 1024 Mb
Hard Drives: C: Total - 750003 MB, Free - 519898 MB; D: Total - 197870 MB, Free - 152844 MB; X: Total - 114442 MB, Free - 18524 MB;
Motherboard: ASUSTeK Computer INC., P8H67-M
Antivirus: Norton Internet Security, Updated: Yes, On-Demand Scanner: Enabled
 

A:Solved: Access 2007 problem printing report

Read other 16 answers
RELEVANCY SCORE 63.2

I have a simple query that sorts the item numbers in a report ascending. When I run the query everything is in 1,2, 3 order perfectly, but when I use this query in a report, the items come out descending (3,2,1). Something is overriding my sort order and I can't figure out what it is. Any help would be appreciated. ...
 

A:Solved: Access 2007 Report -not sorting items

The Report has it's own Sorting & Grouping function which completely ignores the Query (unlike a form). With the Report in design view, Main Menu>View> Sorting & Grouping ands set it there. You can also set it in the Report Wizard, but you may not have noticed it.
 

Read other 2 answers
RELEVANCY SCORE 62.8

i have a access 2007 database and one of the tables is a invoice table. the client want me to format the invoice number like eg. year-autonumber >> 2010-001 or autonumber-year

any help will be appreciated

the tables are already created and there are some data in.
 

A:Solved: formatting a auto increment number in access 2007

The best way to do this is to have the autonumber field and alongside it your Invoice field, set to Enabled = "No".
In the first field in which data is going to be entered (which is what triggers the autonumber) you enter the following VBA in that field's After update Event Procedure.
me.InvoiceNumber = Format(date,"yyyy") & format(me.autonumberfield, "000")
where is the actual name of your Invoice field and autonumberfield is the name of your autnumber field
See the attached database for an example of the above format which puts the year first and 3 digits for the autonumber part
 

Read other 2 answers
RELEVANCY SCORE 62.8

I have a cumulative query that I built using Method 2 here: http://support.microsoft.com/kb/290136

The numbers that are being accumulated are formatted as Standard Numbers. However, the running totals themselves are formatted as text, which prevents me from adding them together (instead, they concatinate, so 10+10 = 1010 and 2+3 = 23 as if they were letters).

How can I prevent the running total from being formatted as text? It's preventing me from graphing the results of the query, since text has a value of 0.
 

A:Solved: Access 2007 - Cumulative count formatting as text

Read other 16 answers