Search results for query: *

I have an Access application that has multiple subs to do different tasks. One sub is used to write to a log file as it works through the different processes. This sub is called from many other subs. As part of the error trapping, if there is an error the logging sub writes the error...

I have been using SQL Server for the last couple years and now find myself having to write queries in Teradata SQL Assistant. I have been looking all over the internet, but can't seem find an answer to why so many examples I see have a "From" clause that contain no join information. I keep...

Related to thread1462-1071902 I have an accouting system that stores addresses as a single field. When I create my data source and run it I can hover over the address field and the pop-up box shows the data with carriage returns. When I add the field to the report it flattens it out into a...

I have an Excel Book that several users have copied to their local computer. The Excel Book opens a connection to an Access database and transfers data the to Book using the CopyFromRecordset command. All users have the same file, but only one gets the "Runtime Error 2147467259 The Database has...

I have a form that is used to launch a couple different import processes. The code that does the importing is located in a Public Class Module. How do I get a "stop" button on the form to stop the importing proceces? A little about the process. The import reads an Access table and loops...

I have a procedure and basically organizes the sub-procedures for a nightly process. When there is an error in a sub-procedure the error trapping on that sub-procedure calls another sub procedure to write to the log file and e-mail me. I can use the "exit sub" to end the sub-procedure, but how...

I have the existing code that works great... 'Create a connection to sql server Set con = CreateObject("ADODB.Connection") Set recordSet = CreateObject("ADODB.Recordset") con.Provider = "SqlOleDB" con.Properties("Data Source").Value = "MySERVER"...

I am looking for suggestions on how best to solve this problem. I need to create a stored proc that finds the last 5 times a certain type of item was ordered and caclulate the average price. My first thought was to make a temp table with a list of the desired items then somehow loop through...

I have an Excel 2007 sheet that has several data tables, Access is the source. Some tables are large, others small. My goal is to have the users modify the data in the tables and then save it back to Access. I know I can loop through a range and execute one append/update transaction per...

I am new to VB.net am having an issue with a VSTO Excel 2007 Add-on that I am working with. This add-on has an Actions Pane that acts like the summary section of the sheet. When the user updates values on the sheet I want the pane to update. So far I have a working Actions Pane and I have...

I am new to VB.net am having an issue with a VSTO Excel 2007 Add-on that I am working with. This add-on has an Actions Pane that acts like the summary section of the sheet. When the user updates values on the sheet I want the pane to update. So far I have a working Actions Pane and I have...

I have an Excel 2007 Add-In that displays an Actions Pane. The pane is pretty simple, two text boxes and two buttons. When I click one button I can insert the text from the boxes into the sheet. I can click the other button I can can take data out of the cells and insert it into the text...

I have a sheet (Office 2007) that has a lot of hyperlinks. I am adding code to the Worksheet_FollowHyperlink sub. I need to be able to capture where that hyperlink was called from. This event seems to be an "after" not "before" event. When I ask for the active cell, it gives me the cell on...

I have an Stored Procedure that I am using to gather variables and use them as criteria for my report. My Stored Procedure is looking at invoice level data, meaning a record for each line on an invoice. The Stored Procedure is working great. When I get to the report I want to the report I...

I have a form with a combo box that holds, amoung other things, the name of a procedure I want to Call. Is there some way to Call a procedure when the procedure name is in a variable or form object? I would like to avoid a Case Statment becaue this combo box will end up holding over 100 items...

I am working on a project where I am given import templates in Excel (Field Name, Size, Field Type, Valid Entries, and Notes) and I have to create an Access table that matches it so people can start entering data and ultimately import that data into our new accounting system. I can use code to...

Can anyone tell me why the folloing code only works sometimes? I tested it without the Recorset Set loop and it would work sometimes, but not others. In one case I put a MSGBOX infront of and behind the code where I set the description. I ran it and it worked. I changed nothing and I ran it...

Can anyone tell me if I have the right software? I am just starting out with Business Intelligence reports for SQL Server (SRS). I have taken a few classes, and I am now trying to setup my system. My SQL Sever is 2000. I have installed SRS 2005 and think I have it configured. When I go to...

I am trying to start using SQL Reporting Services and using VB.net to make reports. I can not get Business Intelligence Projects to be an option in the New Project window. Here is my setup. I am using a SQL 2000 Server database. I have installed SQL Reporting Services 2005 from my SQL Server...

This is a repeat of thread 962-1320329 without the typo in the subject... I am trying to figure out what I have done wrong. I have installed SQL Server 2000 Developer Edition. Everything I read said that SRS was included in Patch 2, but Patch 4 was available and included everything in Patch...