Recent content by skydive

Howdy All, I create an XML file from MS-Visual Basic and then modify the file in Excel. In the generation of the XML, I create code like: <Row> <Cell> <Data ss:Type=&quot;String&quot;>Support</Data> </Cell> <Cell ss:StyleID=&quot;stENTRYCELLSHADE&quot;> <Data ss:Type=&quot;Number&quot...

I solved it (in case anyone has a similar problem) I created a new worksheet in the same workbook and created it in exactly the same manner as the first worksheet (except that it is hidden). This 2nd worksheet contains the database codes so I loop through both list of nodes at the same time. Not...

Hi, I am new to XMl so excuse me if this is a stupid question. I am creating a web based timesheet system where users can download their timesheet in XML format so they can edit it offline in MS-Excel. The user will then be able to upload the XML file and the system will update the database...

Hey Michael, Happy new year!! I open it using OLE Below find the code used: Set wApp = CreateObject(&quot;Word.Application&quot;) Set wDoc = CreateObject(&quot;Word.Document&quot;) With wApp Screen.MousePointer = vbHourglass Set wDoc =...

I open a word template through VB and populate it's fields. I then save and open it as an doc. That all works great the problem is the menu bar or title bar (you know file, edit, view, ..) is not displayed neither is the icon bar. I'm sure it can be set through a property of word.application...

I had exactly the same problem as R3D3 however my solution is slightly different. My function call was something like this: Public Function functName(abc As string) As DOMDocument I found that in order to get it working all I had to do was to call the parameter as byval. i.e.: Public...

Hey All, Ok, I got what should be a simple straightforward question for you. I want to get the error description, in my error handling routine, I want to determine what the error is and insert it into an error log table. I can get the error number using @@Error, how do you retrieve the error...

Hey Rosko, Thanks for that I tried the bcp out and opened the file, the data in the first column was strange looking the reason being that I had declared the first column to be exported/imported as SQLNUMERIC so it exported the number in binary. This was the reason I could not get it working...

Hi All, I have been encountering a problem with BCP which I cannot resolve. I have read all the posts on this site relevent to BCP but have still not been able to resolve my problem. I have enclosed all relevent information. Here is the destination table on Sql Server CREATE TABLE...

Thanks Vic, Excellent that works, Blue Skies! Skydive

Howdy All, I would like to pass a variable from one function to another function, change this variable in the second function and when returned to the first function the value would have been changed here. function f_main() { var i = 1; var retVal = true; .. retVal = f_sub_function(i)...

Hi Ed, Yeah I think you may be right, I wanted to stay away from using a trigger if possible but I can't see any other way of doing it. Thanks Ed for your help. Regards Colin

Hi Ed, Thanks for the reply, I'll explain futher what I am trying to do: I have a SQL script which creates the database and tables (I'm importing data afterwards using the MS-DTC from another DBMS) Below you'll find the troublesome table, I have made the problem line in RED create table...

Hi All, I am trying to write a database creation script and on one table I need to assign a default date to a column of data type &quot;DATETIME YEAR TO MINUTE&quot;. I wish to assign the current date. Any help would be great! Blue Skies Skydive.

Hi Martin, I think this will work! Sub martin_test_01() Dim db As Database Dim rs As Recordset Dim sql As String Dim i As Integer Set db = CurrentDb sql = &quot;select Col1, Col2, Col3 from myTable;&quot; Set rs = db.OpenRecordset(sql) If Not rs.EOF Then For i = 0 To 2 MsgBox...