Search results for query: *

KiaruB, I was looking to avoid passing the variables to the ErrorLog because the number of variables will depend on which sub is calling it. So in some case I may only have 2 variables I need in the log and other times I may have 15 variables that need to be in the log. I was hoping there...

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

Gruuuu, Thank you for clearing that up, it was a big help. sabloomer

Gruuuu, That is a big help. The big question is performance, and if there is no advantage I am going to stick with what I am more comfortable with. Just for my knowledge, Did I provided an example of a "traditional" inner join? Is there such thing as a "traditional" outer join? Thanks...

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

Geoff, That worked like a charm. I was able to replace the mystery box character (carriage return) with a vbcrlf and it looks perfect. =Replace(Fields!FieldName.value,chr(13),vbcrlf) Thanks!

I will give that a try!

I am not sure what to search for. When I look at it while creating my datasource for the report it shows two square boxes. I will see if I can figure out what SRS thinks those boxes are. Thank You, sabloomer

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

Thank You. It looks like I have some reading to do about threads!

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

PHV, Thank you. I will try using the global variable first. It sounds like less of a pain then changing eveything to a function. sabloomer

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

Sorry for the delay in getting back to you. Thanks to your suggestions I found... http://msdn2.microsoft.com/en-us/library/ms807027.aspx Which was a big help. I also needed to change my provider on the connection string, but once I was using the SQL Server driver and Execute Method all things...

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 using SQL Server 2000.

Qik3Coder, Let me start with thank you! There are a two tables in play here. First is the "Items" table. It has a lot of fields, but the three that are meaningfull here are ItemNumber MakeorBuy ItemKey I need to limit my search my search to "buy" items. The second table holds purchases...

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

mrdod, Thank you for the feedback. I was trying to avoid having to write one record at a time, but that may not be an option. If I can't find a bulk method soon I will using your suggestion. Thank You, sabloomer