Search results for query: *

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

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?

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

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

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

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

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

I have a column of numeric values which I want to sum on the group footer, which works, and on the report footer, which does not work. When the object, =sum([WTS_Volume]), is included in the Report Footer the report goes through the report's "On No Data" event and gives me the message I placed...

I have a MS SQL stored procedure that updates a couple of tables. It does not return a result set. When executed in Access VBA via an ADODB Execute command it does not process correctly. It is as if some of the update queries within the stored procedure do not execute. When executed in Query...

Is it possible to determine programmatically the connection information as specified in the "Data Link Properties" wizard from within the ADP application? I need to programmatically alter the "Initial Catalog" specified in the following when the the database is changed. NGMSConnect.Open...

I have a form containing two subforms. The form is TrsumGroup_Modify_Frm and the subforms are TrsumGroup_ModifySet_SubFrm and TrsumGroup_LCList_SubFrm. When I start (open) the main form (TrsumGroup_Modify_Frm) the following events occur in the order listed below. TrsumGroup_ModifySet_SubFrm...

I have FormA with a combo box. When I select a value from the combo box it is saved in a global variable. I click the OK button on FormA and it opens FormB and closes itself. When I close FormB the closing process opens FormA again using the following commands: DoCmd.Close acForm, "FormB"...

I have an Access 2002 ADP which connects to a SQL Server 2000 database. The connections is established by going to FILE, CONNECTION, and entering the appropriate information in the Data Link Properties window. I wanted to create a new ADP and establish the connection to the SQL Server database...

I have a form which contains a subform. The OnCurrent event in the subform checks a date field on the subform and depending on the value issues a MsgBox message. The problem is that the subform's OnCurrent event processes before the form and subform are visible, therefore the messages pop up...