Search results for query: *

I have the following VBA code: Dim dkg As Variant, str As String dkg = Application.FileDialog(msoFileDialogFilePicker).Show str = Application.FileDialog(msoFileDialogFilePicker).SelectedItems(1) DoCmd.TransferText acImportDelim, "OnyxSRImportSpecification"...

I have the following code in a Public Sub: Public Sub DailyCash_Click() Dim cmd1 As New ADODB.Command Dim errtype As String On Error GoTo ErrorHandler errtype = "vb" If (cnnP.State = adStateOpen) Then Else ConSrvr End If Screen.MousePointer...

Another report with a different set of problems. This report has all the calculations in the Account Header (don't ask me why; I didn't write it) and the text box it is referencing is named net_repo and has the following calculation in it...

Let's just say I have never ran into this before and have been doing access reports a long time. Also, this is not my report and there is no documentation. I have a Label9 Header and a Label9 Footer with detail between them. I have inserted the following text box formula in the detail...

I have the following line in vba in access 2007: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Floor_Execution_Import", str, True, "B4:H30" The format of the data in the .xslx is as follows: ELECTRONIC Date ELECTRONIC Ticket # Account # B/S Quantity Month Product...

I have never, ever ran into this before. I am inserting data from one table to another and the insert is only one field to another field. Both fields are varchar(50). The field being transferred from populated just fine using an Access 2007 text import function with no errors. When I try to do...

I have a subreport detail area that has the following detail: Box SumOfYTDConverted 5700 1200.00 5720 1699.00 5740 2000.00 The subreport is named Sec_Combined_Test. In my main report I have a the subreport named...

I have a combobox in an Access 2007 form that has two columns. I am trying to get the second column to bind and update to a table when selected by the user but each time I select that row the first column is put into the cell. The Bound Column property is set to 2. Is there something I am doing...

We have Access databases which we are converting from SQL Server 2005 back ends to SQL Server 2008 back ends for tables with the Access database as a front end. During the test conversion I ran a form which has a button and received the following error: Run-time error'-2147467259 (800004005)'...

We have Access databases which we are converting from SQL Server 2005 back ends to SQL Server 2008 back ends for tables with the Access database as a front end. During the test conversion I ran a form which has a button and received the following error: Run-time error'-2147467259 (800004005)'...

I have a text box (shows result of a query) which factors into a sum later on in a report. This text box sometimes has a null value in it which in turn throws an error in the sum field. I need to set this text box to zero if the result is null. I have tried the following: 1...

I have searched all of the previous postings on this item and tried every one of their suggestions. Here is my problem. I have an Access form where the user enters a row and has a primary key in the table. The error number is 3621. I have tried to set up the following: Private Sub...

I have a table that has the following columns: Reg Dept Electronic Volume Outcry Volume Volume Reg and Dept are primary keys in this table. Sometimes it is necessary to add a reg and dept (this is a Access 2007 front end to an SQL Server 2005 back end table) with the associated volumes. I want...

I am hoping someone can help me on this one. I have googled this to death to no avail. I used to have Object Explorer docked on the left hand side of my management studio and then the query screen would come up beside of it. Now the Object Explorer has disappeared and I cannot get it to dock...

Here is my code: use actg --NEED PARAMETERS FOR CURRENT MONTH AND NUMBER OF MONTHS DECLARE @CurrMth NUMERIC(18,0); SET @CurrMth = 9; DECLARE @CurrMthName VARCHAR(3); IF @CurrMth = 1 BEGIN SET @CurrMthName = 'Jan' END ELSE if @CurrMth = 2 BEGIN SET @CurrMthName = 'Feb' END ELSE IF...

Here is what I am trying to do. I have a table variable : DECLARE @NITable table ( Reg Varchar(1), Dept Varchar(3), CurrentMonth Numeric(18,0), CurrentYTD Numeric(18,0), CurrentAvg Numeric(18,0), PriorYTD Numeric(18,0), PriorAvg Numeric(18,0) ) The reg and dept is populated from two...

I have the following code: Private Sub cmdImportRanFile_Click() strCnxn = set_connection() Set cnxn = New ADODB.Connection cnxn.Open strCnxn strSQL_Execute = "dbo.Ran_BillingDelete" cnxn.Execute strSQL_Execute, , adExecuteNoRecords Dim dkg As Variant, str...

I have the following code: Private Sub cmdImportRanFile_Click() strCnxn = set_connection() Set cnxn = New ADODB.Connection cnxn.Open strCnxn strSQL_Execute = "dbo.Ran_BillingDelete" cnxn.Execute strSQL_Execute, , adExecuteNoRecords Dim dkg As Variant, str...

I have the following code: DECLARE @sYEARMO AS VARCHAR(8); SET @sYEARMO = (SELECT max(Business_Date) FROM [Exchange_Rates_Entry_Table_Daily]) PRINT @sYEARMO TRUNCATE TABLE [Exchange_Rates_Entry_Table_Monthly] INSERT INTO [Exchange_Rates_Entry_Table_Monthly] ( [Currency_Name]...

I am using visual studio 2005 and am trying to use a foreach loop container for the first time and have run into a snag right off the bat. I want to loop through a directory and select a file from that directory, copy that file into that same directory and rename that file. Every resource I...