How can I make a text field label NOT visible if the text box field is empty? The text box is number/standard formated.
--Steve
Dear Experts:
I encountered an MS Access 2003 file with reports inside.
After opening the design view of a report, I am able to see the list of field names by clicking the "Field L...
I have a MS Access file that runs reports from a .CSV file. I keep getting an error when I put the Date Range from 1/1/08 to anthing past 9/30/08. When the date is 10/1/08 or beyond, I get t...
Is there a way to export an access report into excel and specify the formatting of some of the cells. In this case I would like a particular cell to be formatted as "wrap text" when the repor...
I'm trying to allow the user the option of printing 0 lines, 5 lines, 10 lines, or all Notes (memo field)
The solution in here http://www.experts-exchange.com/Microsoft/Development/MS_Acces...
Is it possible to combine the group header name with number of records without having to use two separate controls?
What I need group header of 'Cleveland' and then to show the number recor...
I have a report that is grouped by the field [CODE].
In the CODE header, I have [txtCODETotal], with an IIF statement that results in a total amount for that CODE. That works fine.
What...
I have a report in Access 2007 that I've created a send button on that sends the report in HTML format to someone via outlook 2007. My problem is that when the report is more than 1 page long...
I am currently working on CA unicenter Service Desk 11.2 , reporting . I am using MS access report of Service desk . I have total 18 categories . Category is a field name under table prob_ctg
...
i have a 2003 ms access file which i am now opening in access 2007 which has a report that prints a filed as a number which i need to be aligned distributedly. all is fine in the report view, ...
I have a query that receives date value as parameter. This query is being used in a report. The mentioned report is being opened from a Form.
I am unable to find a way to pass the parameter ...
I've create a report within Access 2007 which is a picking list. The detail section of the report has two types of line types, stock items and free text description lines. Each of the differen...
Could someone tell me how to convert Time() to 24 hour time?
How do I control the line spacing within the detail section of an access report? I'm working with very small fonts (4 pt or 6pt), and I want to be able to almost print one line right under th...
I have a select box on a form where the user can pick multiple project numbers for the report. I want the numbers selected to show in my report header, however, I can only get it to show the ...
I have a report that is pulling a query. The report has a group header and a group footer. I figure there HAS to be a way to do this in Access 2007:
If a column of a record is null, I wan...
I'm tring to get a Report to sort (OrderBy) AND Filter (Filter) the same way that the user may have specified in the datasheet view in fSubFilingCalendar. (Clicking on the little down arrow in...
How do I multiply a numeric field by 100 on an Access report?
How can I ensure the dates on a report I export from Access to Excel are in date format? I have a query which returns calculated date fields as the recordsource for my report. The date format ...
I have a report created in access 2007 which displays items in a quotation. The report acts like a continuous form, with each record displaying as a single row- these are my quotation items. ...
I have a basic Helpdesk CRM tool in Access. There is a form called HelpDesk which uses three combo boxes and writes to a table titled Contacts_CustServTbl
Within the Contacts_CustSe...
I have a button on a modal form to print a report. The button triggers the following code.
DoCmd.OpenReport stDocName, acNormal
The report is setup to print to the default printer and th...
I am using the following code within a Button on a report
'DoCmd.OutputTo acOutputReport, , "PDF Format (*.pdf)", Me.Report.Name & " " & Format(Now(), "ddmmyyyy-hhnnss")
OR
DoCmd.Ou...
I am having problems with ODBC driver and I am not able to do the following in queries.
I have used this function. With this function I get LITERACY_0708 Or NUMERACY_0708 but I would like to ...
We have a domain network and we just realized that a critical and confidential folder with many sensative files was open to all users. As soon as we realized it, I locked it down and made it ...
