Kamis, 28 Mei 2015

RE: [MS_AccessPros] Re: #Name? on report

 

Adam,
 
I don't believe I suggested "create a report in a module". I only wanted you to make sure any code in your application compiles with no errors.
 
When referencing report header and footer sections there is a significant difference between Page and Report/Group sections. Please be specific when you post question relating to these.
 
Duane
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 May 2015 09:25:59 -0700
Subject: [MS_AccessPros] Re: #Name? on report



John,


I think that was the problem. Before I read it, I got it to work by putting [CompDate] in the header. That seemed to work as long as it was in the header or detail, but not the footer. "Totals for " & [Product] started working again on its own. I'll try your fix next time.


Duane,


It also happened with [Product] which was just part of a concatenation, not a function. I don't know how to create a report in a module. Is that possible? More efficient?


Thanks,


Adam



---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Adam,
 
I would open a module and try to compile your code. If the issue is always with DateSerial(), I would search your code for another function with the same name.
 
Duane Hookom, MVP
MS Access
 
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 May 2015 06:52:20 -0700
Subject: [MS_AccessPros] #Name? on report



I'm getting this on calculated fields in headers and footers, but not all calculated fields.


Header: I have a series of 12 monthly columns. The source for the first column is CompDate, a field on the report's source query. That field shows up correctly. The second column's source is =DateSerial(Year([CompDate]),Month([CompDate])-1,1); the third is =DateSerial(Year([CompDate]),Month([CompDate])-2,1); etc. #Name? shows up on the other 11 columns.


Footer: #Name? shows up in a field with the source ="Totals for " & [Product] where [Product] is a field in the report's source query, and in the detail (grouped by Product. Other Sum and Count calculated fields in the footer are fine.


This is happening on other reports with similar fields. These reports worked yesterday. Forms with the same sources and fields are working. I'm baffled. Any ideas?


Adam




__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Posting Komentar