Recent content by eksortso

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