I have an In-Line Function in an Access 2003 database attached to a SQL Server. I am trying to set up a Form to enter a parameter for the function. Everything works fine mechanically with the form (it opens the function) but it does not retrieve any records.
I believe the problem might be...
How do I get "(blank)" from appearing in the pivot table when there is no data in a field? For example, my column looks like:
(blank)
X
X
(blank)
(blank)
(blank)
I have tried "For Empty Cells Show" in the Table Options and what I indicate in the box does not show up.
Thks.
Mary
I'm new to XML. Can anyone point me in the direction of a solution to saving an Excel file in XML format using a schema provided by a third party (hasn't been helpful)? I'm trying to import data into the third party's web site.
Thks.
Mary
Hi.
We use Datatel's Colleague (unidata) for our student information system. We have been pulling data into a warehouse and then using Cognos to write reports. Does anyone know if Cognos can directly interface with Colleague?
Thks for your help.
M
I want to use a formatted blank Excel worksheet as an embedded photo for an Access report. My problem is how to save the Excel worksheet as a bitmap so I can put the bitmap's name in my report properties.
If I copy the worksheet, I can Paste Special as a bitmap but then the photo is in the...
Hi.
My company uses a one-page Excel spreadsheet for calculation of annual salaries by department. A paper copy (!) of the spreadsheet is then submitted (that's a different problem).
My data (for multiple departments)is in an Access database. In a nutshell, how do I get my data to look...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.