Search results for query: *

This almost works. It does limit the number of rows that are checked to 40, however, keep reading. The actual update of certain information on the account is done via another button (call it Save) which appears if the checkbox on one or more rows have been checked. Account does not play into...

[sad]I have a Gridview with a data source containing 100 rows. I use page control to display 40 rows at a time. On each row is a check box that flags the row for processing later should the user click on another button on the screen. Additionally, I have a check box (call it ALL) outside the...

I am getting the following error: The path of the item '\SSRS_TrSummMatrixReports\TRSumByCustomerAndDealType.rdl' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash...

I checked and the app does not compact and repair on close. I believe that the delay I am seeing between the application window closing and Access closing is the cleanup being done by Access and OS. I doubt there is much that can be done to speed this process up, but if there is I would...

Access 2002 On my main form I have a button which runs code in a module that closes the main form and then does an Application.Quit acQuitSaveNone. When using the task manager to monitor the msaccess.exe, I have noticed a delay of up to 5-6 seconds between the time the application closes...

I have an Access 2002 database application that runs just find on Windows XP running Access 2002 and Office 2007. When I run it on a Windows 7 PC running Access 2002 (first PC i have had with this configuration), I have two problems: 1) It fails in the createfolder command at the following...

Is it possible in Access 2007 to change the setting for Use Access Special Keys in VBA code? If so, how is it done?

I tried the Err.Clear and it did not help.

Platform: Access 2002 I am running the DoCmd.OutputTo command to create a spreadsheet. The spreadsheet already exists and is currently active on my PC. This causes an error 2302 which I trap and give the user (me) a message and then exit normally. Unfortunately the the Outputting Object and...

Excellent suggestion. Thanks.

I have an excel spreadsheet created by executing the Access VBA command which follows: DoCmd.OutputTo acOutputStoredProcedure, "Exec IndexPrices_sp '" & Me.StartDate & "', '" & Me.EndDate & "'", acFormatXLS, "TIGERS_Index_Prices.xls", False When I open the resultant spreadsheet in Excel I get...

You are correct, the Me.MoveSize does not not work on reports. The Me.Move will reposition (Left, Top) a report, but the additional parameters (Width, Height) that are available in the syntax does not work. Is this a bug or by design?

I have an Access application that detects if it is running in a single screen or multi-screen environment. If it is in a multi-screen environment it open up the Access container to encompass the width of two screens. When in the multi-screen mode I move certain forms to specific screens thus...

I have a form (FormA) in which the record source returns 1000 rows without any filter applied. I have a dialog form which I open on top of FormA that applied a filter (Forms!FormA.Filter=...), which results in 500 rows being displayed. I have not done a Forms!FormA.Requery command. Did Access...

I have a form (FormA) in which the record source returns 1000 rows without any filter applied. I have a dialog form which I open on top of FormA that applied a filter (Forms!FormA.Filter=...), which results in 500 rows being displayed. I have not done a Forms!FormA.Requery command. Did Access...

If I have a dual monitor environment where I can manually expand the MS Access application across the two monitors, how can I programmatically detect the dual monitor window size and then programmatically resize the application across both monitors? I am sure there must be some API modules that...

Yes, I have tried: Forms!FormA!ComboBoxA.value = <new value created by FormB> and Forms!FormA!ComboBoxA.column(0) = <new value created by FormB>

I have FormA with ComboBoxA and a command button which takes me to FormB. ComboBoxA has TableA as a record source. FormB allows me to make a new entry into TableA. When I return (close) from FormB I want FormB to set ComboBoxA's value to the value I just created on FormB. In the close process...

Thank you for your help. It is working wonderfully.

I want to create a form with two combo boxes. cmboA contains all products. cmboB contains only those products that have been selected from cmboA. Once it has been selected from cmboA and moved to cmboB it needs to be "removed" from cmboA via a change in the WHERE logic which defines the record...