Recent content by DrewConn

I'm sure this is a basic question but if I have weekly recurring project meetings with x number of resource attending each meeting, and that meeting task duration is 1 hour how do I get prject to allocate one billable hourly rate for each attending resource? Currently it is dividing up the...

OK, I thought this forum was to get constructive help , not simply pick on your code. So far two responses neither of which even try to address the issue. I have no problem changing code if it speaks to the issue at hand but this code, old or not does work in .NET

I am getting the error on the following line myfile.Writeline(mystr) Also I only threw that on err statement for debugging.

Trying to write a simple data file out from a database table but keep getting 91 object variable or with block variable not set error. Any idea's ? Imports System.Data.Odbc Module MainModule Public Sub Main() Dim mystr As String Dim dbconn As New OdbcConnection...

Trying to write a simple data file out from a database table but keep getting 91 object variable or with block variable not set error. Any idea's ? Imports System.Data.Odbc Module MainModule Public Sub Main() Dim mystr As String Dim dbconn As New OdbcConnection...

Trying to write a simple data file out from a database table but keep getting 91 object variable or with block variable not set error. Any idea's ? Imports System.Data.Odbc Module MainModule Public Sub Main() Dim mystr As String Dim dbconn As New OdbcConnection...

I need to insert records from an Excel sheet into a temp table in SQL without using DTS. I have tried the following: Select * into NelNet_tmp FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=B:\MIS\MIS\Extracts\NelNet\MIPRIV 1282005(2).xls;HDR=YES', 'SELECT * FROM [Report1]')...

Still get a save as prompt using this command.

I am running this module as a stand alone .exe to auto refresh an excel file. The problem is how do I avoid the save prompt from appearing to make it fully automatic? Public Sub ExcelRefresh() Set objExcel = New Excel.Application objExcel.Visible = False objExcel.DisplayAlerts =...

Yes I want to ignore the time and only bring in the date

I am trying to import date data in the following format into a datetime field using DTS and the DateTimeString transformation tool to do it. However when ever it hits an hour field > 12 it throws a conversion error: The raw data looks like this: 20050522142901 Source data format used...

I have pub 97 installled but have several pub 2003 version .pub files I need to open. 97 won't let me open these files as they are a different version. Is there any way I can convert these files or find a way to open using only publisher 97? Thanks.

That code worked , I was tring to cast the char field instead of the else result field. Thanks.

I am having trouble with the following statement: select top 100 [decision_score], case when [decision_score] between 620 and 639 then '620-639' else [decision_score] end as ScoreBand from tblCMSImain where [initiation date] > '01/01/04' Getting error: Server: Msg 245, Level 16...

Nope, I am looking for the minimum(or first) value the and the max(or second) value tied to the acct_num field.