It is read-only and cannot be altered in Access. The data types are correct in Access, They are just not displaying correctly. In the tables and views Access is dropping zeros instead of showing two decimal places (115.1 instead of 115.10). Also in the view one NUMERIC(18,2) field is showing a...
It is for an end user doing read-only analysis. He is writing queries and creating formulas. A form or report would be ideal for me but not for his purposes. He is an actuary.
I have an MS Access 2013 mdb linked to a SQL Server 2012 DB. There are tables with NUMERIC(18, 2) fields in SQL Server. I link to those and the linked tables show the correct precision and scale in the design view but not when you view the data. It drops the zeros off of the decimal places. So...
When I have an Excel file open and minimized then open another Excel file it activates the minimized file and puts it behind the new file. How can I stop that from happening? It is supposed to be a feature but it is annoying. I read that Word does the same thing but there is a registry hack for...
I have a parent SSIS that uses a script for calling a child package that parses XML and dumps it into tables. The child package runs fine when standalone but fails throwing the error when called from the parent. All of the child GUIDs have been updated. "POLICIES" is the first XML node. I am not...
I have a parent SSIS that uses a script for calling a child package that parses XML and dumps it into tables. The child package runs fine when standalone but fails throwing the error when called from the parent. All of the child GUIDs have been updated. "POLICIES" is the first XML node. I am not...
I have an odd issue with the available render options when setting up an email subscription. Currently I only have the options CSV, PDF and Excel. Anyone know why I am missing HTML, XML, Word and Web Archive? After searching the web and this site it does not seem to be a common issue.
Thanks in...
OK, I found the answer. It is ugly but works when you strip out the XML tags. Here is what worked.
DECLARE @TO XML
DECLARE @String NVARCHAR(MAX)
SELECT @TO = REPLACE(REPLACE(CAST(MatchData AS NVARCHAR(MAX)),' xmlns:xsd="http://www.w3.org/2001/XMLSchema"...
I pull the following XML from a field in SQL Server 2008 and need to query into the string to get the values. Each attempt has returned NULL or nothing at all.
<ScheduleDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">...
Thank you for your response.
The code runs very well but is returning a XSL Stylesheet instead of the data within the text file.I have done additional research on the method you suggested but am still haveing trouble getting the actual data returned. The creation of the new text file works...
There is a daily text file that is accessible only through a URL such as HTTP://somefolder/text.txt. I need to copy the file to a new network location. I have tried using the FileSystemObject methods but it does not like the URL path. Is there another method that will allow a copy through the URL?
The bookmark names were returned as well as their ID. All of the range values showed that square. I am not sure what the square value actually is though.
Actually nothing happened. The Debug did not start. Instead I put the code behind a button and dumped the values into a string to populate a multiline textbox.
Private Sub CommandButton1_Click()
Dim I
Dim strINFO
Me.GETANSWERS.Value = ""
For I = 1 To...
The code below returns in each field.
strPath = Me.DOC_LOC
Dim oWord As Object
Dim oDoc As Object
Dim I As Integer
Dim strFLD As Stream
'Open MS-Word via OLE.
Set oWord = CreateObject("word.application")
'Open the form...
Yes, I am using bookmarks but I did create fields as well. For some reason they are not registering... I have tried hundreds of combinations but still cannot get the values pulled over. At best I was able to pull some type of object over but it appeared as a small box like a line feed or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.