Reports
in [Access]
|
Analyze with Excel In Access 2007 Sp2, Office 2007 I'm beginning to look at how my application, developed in Access 2003, will function in Access 2007. So far it's going pretty well. However, the "Analyze it with Microsoft Office Excel" menu item, which was a standard item in A2003 results in an error with A2007, SP2. Before I installed SP2, my existing "Analyze it... 28 Mar 2010 13:26
How to format a portion of a text box in bold letters Hi friends, I want to format a particualr portion of a text box in bold letters in access report For ex: in a text box controlsource "I, & MyName & ", solemnly delcare that....." here only MyName is to be formatted bold. Is it possible in access 2007 -- from chanakya Baruva ... 28 Mar 2010 10:08
Making the report footer not visible My objective is to use VB to hide the footer in a report. I am using the following: Reports("" & ReportName & "").Section(ReportFooter).Visible = False where Reportname is just that. However it hides the details section. How does one hide the footer? ... 28 Mar 2010 13:26
visible label based on text value I am using a database on a LAN and I have the following in the on format event Me.ContactList.Visible = Not IsNull(Me.ContactList) However when one user opens the data base the label is hidden if the condition is true but if another user on the LAN subsequently accesses the data base all the labels are displaye... 27 Mar 2010 18:51
When Pring From Microsoft Outlook 2000 It Prints two Pages Until lately I can honestly say my Miicrosoft Outlook 2000 worked well. In the past few days, when you print, iit is gracious and gives you two copies of you work. Does anyone else experience this problem or have you experienced the problem and found out how to fix it? ! ... 27 Mar 2010 17:42
Using the data from different record Hi all:) I have a report of accounts' balances. Balances are in USD and account currencies. My reports picks up the currency rate associated with period and calculates USD equivalent. It Looks like GL account 1 Period A Transaction ! Account currency amount ! Rate ! USD Equivalent Transfer ... 26 Mar 2010 15:37
Print Group headings on top of page Hi, I'm running Access via Xp Office Pro on Windows 7. I have a report that is broken out by group using a block format and was generated by the print wizzard. I noticed that the group values (in my case a status description) is only printed the one time. If the group crosses over a page, I want to pr... 26 Mar 2010 13:12
Run report without running access? Hi - Dumb question: To keep it simple, can I create a link or shortcut for a report so that with a click of the mouse the report will show? ... 25 Mar 2010 19:46
Prompt user to input what data to be displayed on Report I've created a report. I would like for user to decide what dates they want to see on report. (I think I need a parameter???? query)? What type of query do I create where user is prompted to enter a 'Begin Date' and and 'End Date'.. and have that data appear on report. What are the steps to do this????? No... 26 Mar 2010 10:24
Report Totals I created a report with totals. See below sample. Date Type1 Type2 Servs1 Servs2 Type Total Serv Total 71/2009 10 20 30 35 30 65 7/2/2009 11 22 33 44 33 77 I used the =NZ ... 26 Mar 2010 10:24 |