Search results for query: *

The Event Procedure when a user clicks the OK button is: Private Sub OK_Click() Me.Visible = False DoCmd.OpenFunction "Check PT", View:=acViewNormal, DataMode:=acReadOnly DoCmd.Close acForm, "PT Faculty by Dept and Term" End Sub

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

Thank you for your help. 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

alwayshouston, Did you figure out how to use your own schema in Excel? I'm trying to do the same thing. Thks, brownmary

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

Thank you, Zathras. It worked like a charm!

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...

I've given up on importing external data and am retrying bobjackson's copying the Excel report as a background picture. Am having trouble sizing the picture. The original Excel spreadsheet is landscape and needs to be reduced to 64% to print on 11 x 8-1/2 paper. When I paste special,I am...

Ed and Celeste -- I've decided your approach is best -- to use "Import External Data" to pull my data from Access into Excel. My problem now is that I keep pulling in the results of the entire query when all I want is specific fields in specific cells. For example, I want Cell A1...

In other words, you do everything in Access (sorting the data, listing it, totaling, etc) with the exception that you bring the Excel "picture" in as the background for the Access report. I hope it is that easy. :-) M

Bob -- I'm not sure I follow you -- 1. Your data is in Excel (is some of it in Access?) 2. You group the data in Excel and copy them. 3. Then you paste special the data as a picture into the Excel (???) report. 4. Then bring the Excel report format into the Access report (how do you do...

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...