Search results for query: *

I am unable to install "Microsoft.ACE.OLEDB.12.0" I have Office 365 which is downloaded. Anyway I found the following code which read the rows into an array. then I thought I would load that into the grid. The issue is the dates in the array are numbers such as 43810 = 12/11/2109 and 43782 =...

I have two tables, one stores a record for each item each time it is used. The second holds the main item list and has a record for each user. So an item could be in the table multiple times. I see now this needs to better normalized. But is there a way to make the following query return one...

I have a lot of desktop icons and I am using 3 monitors. The other day the video driver updated throwing all my icons on the main screen/Monitor. The screen is packed and I think some are not displaying (are off the screen entirely, since the entire screen is full of icons; (I know I need house...

I was using Excel 2016 90day trial for free. In the formula bar at the top of the grid was a smaller box showing a ƒx. It was on the left side of the formula bar so you could click it and add a formula quickly. Also the Named Range box is not showing either. However when I paid for the Office...

I want to verify a row is deleted. I am passing both the table name and the value in question to my stored procedure. It deletes said items and I want something returned back. I created @ItemFound and want to let it equal to the count. But it is not getting set since its inside of the SQL...

this is the example on W3Schools: https://www.w3schools.com/howto/tryit.asp?filename=tryhow_js_slideshow Here is my WEB page on my side which does not work correctly: http://www.doogiestoyshop.com/Cool%20Crafts.aspx this is the error I get; which is highlighted in my code near the bottom in...

Newbie question about making functions to pass styles parameters... I found this on another site which works great but I would like have functions so that I can call the same code over an over, instead of duplicating it many times. The top part is a table with 3 images. But the original code is...

I have a WEB page which I want a user to select a "Group" from a drop down box. If the user selects "Show all" I want it to show all items. If they select something else I want it to filter for that in the Where clause. here is what I have so far. The reason I am not doing this in code is I'm...

I downloaded the Excel app for Android and it works great. Is there a way to be able to talk to it using a Plantronics Voyager Plus? I know I can click the microphone button in the app but I would like to be able to press the button on my Voyager to activate the voice and then... What command do...

I tried a couple of things such as dr(dc.ColumnName.ToString) and CSTR(dr(dc.ColumnName)) but neither work. what do I need to do? I am currently trying to get the data type but no luck. Error message on line in red below: An unhandled exception of type 'System.ArgumentException' occurred in...

I fumbled my mouse and they all disappeared. restarting SSMS did not fix it nor does dragging a variable down there. I am lost without knowing what's in the variables while I am debugging. this is SQL Server Express 2014 The 'Auto' window is there and has headings of Name Value Type but there is...

In prior versions of Excel you could see multiple sheets without the entire program, its using the Windows OS Show side by side. Is the anyway to show just the Excel sheets in one Excel program? like the old days. It wastes so much screen real-estate it is completely worthless, even hiding the...

this is from the Help About Microsoft SQL Server Management Studio 12.0.2269.0 Microsoft Analysis Services Client Tools 12.0.2000.8 Microsoft Data Access Components (MDAC) 6.3.9600.17415 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.11.9600.18283 Microsoft .NET Framework...

When I key in a contact it automatically puts a comma after whatever word is last. so it defaults to Lastname, First name. Likes Sears Corporation gets changed to Corporation, Sears. Then I have to always change it back to Sears Corporation in the list below. Is there anyway to shut that off...

First of all the requirement is to not have to use Order by when viewing the raw data. "Select * from tablename" should show them in order as mentioned below. The table the records are from is sorted correctly by Date Descending and Time Descending. However when doing an insert the records get...

I am trying to count the number of 'G's in 3 columns for 2 rows. The top script is one of the 3 which is causing a problem. Count(RGB_STSOnly) returns a 1. In double checking I ran the bottom script and there is nothing showing but an empty box in the "Results to Grid". The RGB_STSOnly column...

The Connection string is correct since I used it as a variable prior. Error is "ConfigurationManager is not declared. it may be inaccessible due to its protection level." here is how I'm trying to call it Imports System.Configuration Dim ConnectionString As String =...

This requires the Group by since the RecordID's are out of order and the data is synced by Record ID. The Error is "Msg 8114, Level 16, State 5, Line 15 Error converting data type nvarchar to numeric." UPDATE [dbo].[HistData] SET [TCKR%] = CAST(Ticker as decimal(9,6)) FROM...

I have no idea why I can't get the [highlight #FCE94F]value[/highlight] of a ADODB field now in .NET. It returns this: "ADODB.InternalField" instead of its value, this "AD1453". I need to open an Excel file and load the entire thing into a SQL table I want this to be Local SQL .sdf file but...

Unhandled exception at line 103, column 5 in http://localhost:49781/Map2.aspx 0x800a01ad - JavaScript runtime error: Automation server can't create object. on yellow highlight. This is an issue now with IE 10. IE 10 blocks the ADODB as a threat. Need another way to open a SQL connection other...