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've isolated the problem. There are triggers on the table on SQL Server. When a new recorded is inserted using Access, the fluke occurs. When I remove the triggers, new records are displayed correctly. There may be a way around this problem. For instance, what if I didn't use the identity...

scking: I am not requerying the form at all. I just don't want to have to resort to requerying. I should have mentioned that all of the forms that are bound to this table are continuous forms. If I click on another record on the screen after I insert a new record (Missinglinq: that's what I...

Put this code behind your form, and call it when you want to turn off editing on the main form and all subforms. Private Sub DisallowAllEdits() Dim c As Control Me.AllowEdits = False For Each c In Me.Controls If c.ControlType = acSubform Then...

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

Thank you, randy700! In that thread, TheAceMan1 linked to a method that worked for me: How to Load OLE Objects from a Folder into a Table http://support.microsoft.com/?kbid=198466

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

That's absolutely perfect, payback. Thank you!

payback, that would be immensely useful! Please do post some examples.

I agree, randy700. It's like carving a marble column, then writing your grocery list on it. But it's a Microsoft-recommended practice. I at least expected it to work properly. Actually, most settings in the system are stored in the database. That's not a problem. But I have settings that cannot...

I did try storing global settings in a public module. But occasionally, all of the settings would be lost. Nothing in my code was clearing them. The system would just reset them, without errors or warnings. I started using a hidden form to keep these settings, because this is advice that...

It's a native Access form. I call it with DoCmd.OpenForm (with the option that keeps it invisible, which I've temporarily forgotten).

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

Sheco: The Code.SafeDivide() solution worked perfectly. Thank you!

These can be tricky, but it's possible to work with them. As far as I can see, you have two options. You could include special conditions in your dataset to handle "Show All" functionality, or you could use a dynamic query. The first option involves using a special value in your parameter...

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

Thanks, Frink, for the reply. I've wished that there was a comprehensive list explaining when events fire on Access forms. The help files are occasionally useful, but whatever information I can find is always piecemeal. I ended up doing somthing like this within the List0_KeyUp event procedure...

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