Search results for query: *

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

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

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?

I have an Access DB front end that is connected to an SQL Server 2000 backend. We use a MS Word form to collect info that will be uploaded into the Access form after clicking the Access form upload button that I have created. I am able to open the doc and activate it but no reference to any...

I have a Gigabyte motherboard that will accept an AMD Athlon XP 2600+ CPU. The computer ran great for several months. I mean absolutley no trouble. Then it began to not "revive" from a powersave monitor shutdown, which is the only powersave feature that I use. I would reboot and all would be...

I have gone through many threads to try and correct my code but it seems the same as the solutions suggested. I am getting no errors and have stepped through the code. Each line seems to be executed but ultimately the cookie is not created. Here is the code: Dim Cookie As HttpCookie If...

I have a report with 3 subreports that will include a report header with 12 labels that dynamically change their caption. The month names will go into the labels relative to the current date. The problem is that either the header or the function will not accept the report name in any format...

I have a macro that runs some code to turn off the applications close functionality. I run this on the DB front-end before releasing it out on the network. What I would like to do is add a line in a macro or some code to compile the DB after that occurs. I have found a few threads that...

I have a form with 20 buttons. I get the number of unique values for a field, make the same number of buttons visible, and set the caption to the button number. The button names are &quot;btn1&quot;, through &quot;btn20&quot; I will use this to change the subform between values. I have...

I have a form where a project is selected in a comboBox and I need a second combobox called &quot;business&quot; to be populated relative to the project. In the project combobox afterupdate area I have code that finds the index number for the &quot;business&quot; combobox and am trying to...

I have a form that will show information regarding business areas including subtotals for each area. The subtotals are calulated from an invisible subform that is tied to a query. Not all areas will return data and this gives me the #NAME? error. When I reference the subforms field as the...