Search results for query: *

Has anyone else encountered this problem before? If so, is it documented anywhere? I wrote a report that used a stored procedure ("sproc") in the core dataset. The sproc used parameters, which I defined in the report. The dataset worked properly on the Data tab of the report. But whenever I...

Hi, I have a report that renders correctly in SQL Services 2005 Reporting Services. It contains two tables, and one of the tables has textboxes that refer to values in textboxes in both tables, via the ReportItems() function. When I export this report to an Excel workbook, the system sees the...

I have a table on a SQL Server back end, and my Access 2003 client connects to the table via ODBC. The table has an identity field (similar to AutoNumber) which serves as the table's primary key. My problem is this: I have a form which is bound to this table. If I enter a new record and type in...

You can drag and drop bitmap files from Windows Explorer into a Bound Object Frame to store that image in a database table. However, I would like to have a way of doing this sort of population programatically, using VBA. I'm working with small image files here, nothing over 4k in size, and only...

I have an Access database that opens an invisible Monitor Window, which is used to store global settings. The monitor window is opened via a procedure called by the AutoExec macro. There is also another form that is opened at startup, and this other form is visible to users. It is named in the...

We are having recurring problems whenever we take data sources and reports that were developed for SQL Server 2005 Reporting Services, and redeploy them on a new installation of SSRS. I have a project consisting of one Shared Data Source and several Reports all based on this Data Source and all...

I'm using SQL Server 2005 Reporting Services, and I am having troubles getting a ratio to blank out when the divisor in the calculation is zero or null. I have a static group in a matrix with three columns. The first textbox is Margin, and the second is Objective. I want to display...

If I have an Extended MultiSelect ListBox, how can I update other form fields when the selected values in the listbox are changed? It's not a simple as it looks, because I'm looking for a technique that will work with both a mouse AND the keyboard. Here's a simple setup to illustrate the...

I had an application, an MDB with all tables linked to SQL Server, where I would call DoCmd.ApplyFilter on an Order form and use a WhereCondition like the following: EXISTS (SELECT 1 FROM OrderDetails AS x WHERE Orders.OrderID = x.OrderID AND x.Received = 1)) Now I am try to develop an ADP...

I am developing an ADP in Access 2003. I have a CustomersForm form, which is bound to an Customer table. The form is exhibiting bizarre behavior that I've never encountered before in any other Access-based app. CustomersForm has an OnDirty event that updates a "Time Modified" field. But when...

Can somebody explain something to me about how Access 2003 works with triggers and foreign keys? Let me explain what I'm trying to do. I'm running Access 2003, with a back-end database on SQL Server 2000. In this database, I have a Products table with a one-to-many relationship to a Categories...

I don't know if what I'm attempting to do is actually possible, but I'm getting inconsistent behavior. What I'm trying to do is this: I have a ListBox that I want to make easy-to-use for both mouse users and keyboard users. I've set MultiSelect to Extended, because such a need exists and works...

How do I retrieve the settings for the various SET options? Please forgive me if this is too simple a question, but I cannot find a solution anywhere.

Hi, I don't know if anyone else is encountering this, but I could use your help. I have a form in an Access 2002 database (an MDB) which changes the foreground colors of some of the textboxes when the OnCurrent event is triggered. The purpose of this is to warn users of (non-fatal)...