Reports
in [Access]
|
Case statement Excellent Idea Excellent Idea. I love it. I will change it to that. Thanks Marsh !!! "Marshall Barton" <marshbarton(a)wowway.com> wrote in message news:f3vu641h812jdmkt651d8tb7lv07jan6c3(a)4ax.com... tony Jacobs wrote: I am having trouble with this code can anyone help. I have the follwing case statement that ... 6 Jul 2008 12:59
Dynamically Changing Rowsource on Graph I searched all over to find how to change the rowsource on a graph. What I have found is that it can be done in design mode or by changing the source query. I have multiple users on the application and would like to use the same procedure I use for running reports. When I user runs a report they are able to ... 8 Jul 2008 19:16
change a reports control backcolor I want to change the backcolor of textboxes in a report depending on their value. I messed with this for a few hours but I'm not savvy with the syntax for getting at controls in a report. can anyone suggest a direction? Conditional Formatting does'nt provide flexibility or enough format options For example t... 6 Jul 2008 14:00
Report with vertical columns I have a database for monitoring a small shop. Need help in creating the report for the stock status. I have the following tables 1. Stock - ItemID, Item Name, Price 2. Supply - ItemID, Date, Quantity 3. Sale - ItemID, Date, Quantity I need a report with 1. Item Name on column headers 2. Each item with three s... 7 Jul 2008 14:33
Converting from MS-Access 2003 to 2007 This is in regards to customizing the ribbon. If I create a "USysRibbons" file and set "StartFromScratch" = true, how do I display a custom toolbar for a report on the "Add-Ins" tab? ... 5 Jul 2008 18:39
Vertically Aligning Fields in a Sub-Report I'm putting together a report for a service database where each service ticket can have multiple call reports, and each call report can have multiple engineers associated with the report. While all the data's getting on to the form, the vertical alignment shifts if there's more then one service engineer. What... 7 Jul 2008 22:47
Order Details in horizontal list instead of vertical list Is it possible to have the order details to be listed horizontally which is seperated by a comma after each value instead of the default vertical listed. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200807/1 ... 5 Jul 2008 12:31
Case statement Problem not resolved Still Doug; The Value of the Me.Combo28.Column(1) is Like 'B*' , and any other variations.(Like 'C*', etc.....). You helped me with this earlier on. The lstbox gets poulated with items that start with a B when I select a combo box value of Like 'B*', and so on. No all I want to do is print the items in the lstbox , ... 5 Jul 2008 10:28
Graph won't display Zeroes My report has a bar-graph of items per month for the past year. In months where zero items were produced, I want to show zero but the chart skips the zero months. How can I make every month show? All 12 months even where production was zero. ... 11 Jul 2008 12:00
Decimal Problem Hi My report is based on the following expression in my query in one of the text box: Balance: Format$(nz(([sumofpoamt]-[paidnet]),[sumofpoamt]),"$0.00") This works fine but when I added another text box to sum the total, Access ignore the decimal number. For example: 8.00 9.00 6.25 Access display 2... 5 Jul 2008 18:39 |