Microsoft Development

47K

Solutions

32K

Contributors

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Share tech news, updates, or what's on your mind.

Sign up to Post

Everything was going well... playing around with Visual Studio 2017 for the first time...

Had a weird problem (#1, but not really what the question is about where even though I set the Assembly Name and Root Namespace names, ApplicationName was still returning "WindowsApp1" when referenced... so I thought maybe it's building using that temp name when run from VS IDE.  So I compiled it into an app and deployed it.  Same result...

So I try re-opening the project - I can't open forms!  I can a new form, but when I try to open the main form, the only "main" reference I have is main.vb.  And when I open that, I don't have any code either!  I have one other form in the app and I can't open that either (but the code is visible).

I'd really like to continue this project but I need to see the forms!  HELP PLEASE!?!

(Classic Windows Forms app).
0
Want to be a Web Developer? Get Certified Today!
LVL 9
Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Hi There!

I have a customer who is a developer. They have 12 staff. 5 Developers 5 support people, 1 director and 1 sales/admin person.

They have an action pack, which covers up to 10 users of Exchange, Windows CALS etc, and that's fine.

What they are trying to do it make sure they are correctly licensed for dev machines, dev environments and testing labs.

It used to be that companies bought MSDN Subscriptions but I think those are now only for individuals and not for use in businesses at large? I had heard about MSDN Platforms but when I checked the pricing the customer just about died.

Anyone know of a more cost effective way for a company this size to correctly license their environment?
0
Hi Team,

Requirement :   I want to roll up the measure values(Qty/Amt) from Week-->to Month-->to Quarter-->to Year.

Issue : measure values are not rolling up.

Methodology Used :

Used roll up function in sql server and pushing the aggregated values in to temp table(#) . Then pushing the values from temp table  in to respective physical tables based on the column values (Fiscal_Year/Fiscal_Month/Fiscal_Quarter/Fiscal_Week).

Reason to use this method :  
Underlying table( mba_related_sales_by_day ) has billions of records . Henceforth can't afford to do repeated aggregations from Year table  to Quarter table  to Month table  to week table  as this consume lot of time . In order to reduce the timelines of the ETL processing ,used this method.

Please correct my code and help me  with the solution. Will appreciate your help in this regard.

Here is the code used in stored procedure.

IF OBJECT_ID('tempdb..#tmp_mba_related_sales_agg') IS NOT NULL
	DROP table #tmp_mba_related_sales_agg;

Create table #tmp_mba_related_sales_agg
(
datasource_id int null,
calendar_day smalldatetime,
fiscal_year int null,
fiscal_quarter nvarchar(100) null,
fiscal_month nvarchar(100) null,
fiscal_week nvarchar(100) null,
business_unit_id nvarchar(100) not null,
sales_item_hierarchy_level int not null,
sales_item_id int not null,
related_sales_item_hierarchy_level int not null,

Open in new window

0
I declare a serial connection
Public WithEvents serialCOMDiscover As New IO.Ports.SerialPort

Open in new window


and I use the following code in one form to listen for the interaction:
  Private Sub DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles serialCOMDiscover.DataReceived
 strDataCOM1 = serialCOMDiscover.ReadExisting
                wirelessArray = strDataCOM1.Split(New Char() {Chr(13)}, StringSplitOptions.RemoveEmptyEntries)
end sub

Open in new window


I would like to be able to still use this connection in another form (a different form) in case I need to write something over to the COM port.
0
Morning techs,

I work for a large Computer Aided Dispatch software support company.  We supply the HW and SW that runs in Police and Fire Departments all over the world.  

At my Tier, the Tier one we basically gather logs and screenshots from the dispatchers computers to escalate tickets to the Engineers.  There is an error report functionality but the DISPATCHER (whom you know is extremely busy) must MANUALLY run it themselves at time of event.  

Are there any *light* tools out there that can be installed onto the dispatchers computers that would log error reports automatically?

Computers are running Win 7 with just the dispatching SW

Thank you,
Mark88
0
Hi , When i'm downloading the excel file,i'm getting following attached error.How avoid this error

XML file output


<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error042240_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\abc.com\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\PGARRIST\Report_Isys.xlsx'</summary>


-<additionalInfo>

<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>

</additionalInfo>


-<removedParts summary="Following is a list of removed parts:">

<removedPart>Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml character. Line 1, column 267478.</removedPart>

</removedParts>

</recoveryLog>
1.png
0
hi,
I need to write bookmark with parameter in ssrs.
and I don't know the syntax.

Can anyone help me?
0
howshow.png
How to show columns?
0
Hi, new member here and first post. My goal is to create a basic tab control using the Win32 API that contains a canvas for rendering OpenGL. Please see attachment for my source code. I created a tab control with two tabs; the first tab contains a button and the second tab contains the rendering context. The first tab, when active, successfully displays a button. The second tab, when active, does not display the OpenGL canvas. The only way I can get the canvas to appear in the GUI is to exclude the tab control (comment out the CREATE_TAB_PANE macro in my example to do this). I am rendering the OpenGL context within a static control. Thanks in advance for your help.
OpenGlTabWin32.cpp
0
language : c++
(tools : visual studio , acrobat reader)
thanks a lot
0
[eBook] Windows Nano Server
LVL 1
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Hello There,

I am trying to create two column report for labeling purposes, I followed instructions on the following link : blogs.wrox.com/article/creating-mailing-labels-in-sql-server-reporting-services

but the data keeps appearing on one column and not on both columns, I changed all sizes and tried tables and lists same results, it just wont populate the second column : ( .

Any help is very much appreciated.

Thank you in advance.
0
Guys, i have a question as specified above!

 '' Enable Double-Buffering for everything.
    Protected Overrides ReadOnly Property CreateParams() As CreateParams
        Get
            Dim cp As CreateParams = MyBase.CreateParams

            cp.ExStyle = cp.ExStyle Or &H2000000
            Return cp

        End Get
    End Property

Open in new window

0
Hello all, I'm new in Exchange Server, and I'm installing at my office Exchange Server 2016, when I test it with the microsoft connectivity analyzer with the option "Exchange ActiveSync"  at  https://testconnectivity.microsoft.com I get the next tons of errors, and I dont know how to solve them :( , hope some one can help me, thanks in advance


Attempting to test potential Autodiscover URL https://mydomain.mx:443/Autodiscover/Autodiscover.xml
Testing of this potential Autodiscover URL failed.

Attempting to contact the Autodiscover service using the HTTP redirect method.
The attempt to contact Autodiscover using the HTTP Redirect method failed.


The Microsoft Connectivity Analyzer is checking the host autodiscover.mydomain.mx for an HTTP redirect to the Autodiscover service.
The Microsoft Connectivity Analyzer failed to get an HTTP redirect response for Autodiscover.
Additional Details
An HTTP 403 forbidden response was received. The response appears to have come from Unknown. Body of the response: HTTP Response Headers: X-FEServer: BLMEGNAHCXE Content-Length: 0 Date: Wed, 28 Jun 2017 01:53:57 GMT Server: Microsoft-IIS/10.0 X-Powered-By: ASP.NET
Elapsed Time: 178 ms.


Attempting to contact the Autodiscover service using the DNS SRV redirect method.
The Microsoft Connectivity Analyzer failed to contact the Autodiscover service using the DNS SRV redirect method.
Additional Details
Elapsed Time: 90 ms.
Test Steps
Attempting to locate SRV record …
0
Hello Experts,
In continuation to : https://www.experts-exchange.com/questions/29014655/Powershell-help-for-creating-accounts.html
I have a further enhancement request,
I have 2 Columns in SQL
ADGroup & O365Group

These columns contains values, which are separated by comma (,) these are existing groups in AD & O365
I want them to be integrated into the script so that when the new user is created he is added to the respective groups in both the places.

Thanks in advance.
A
0
I want to create a program or a service which keeps an eye on the usb ports, and sends an email when the usb keyboard would be removed or tampered with!

Can it be done in the task scheduler, so that an usb event kicks off the task of sending an email to a certain address, in an some email application ?

Or do You know off an utility which can do it?
0
Hello, I have Windows 10 and Windows 7 systems  in a SBS2011 domain environment and at least once a day the windows explorer freezes and I have to reboot. After selecting reboot it hangs at reboot mode. I have to force it to shutdown and and start it again for it to work.  Most of the time windows explorer does not work and also internet access goes away too. I even can not access the C-Drive and the Network Drives. Nothing at all.  I have Symantec Endpoint and Malware Byte endpoint protection installed on these systems. Please help.

Thank you
0
I have a build definition for the build of a web project. The Visual Studion Build argument is set as below:
/p:Configuration=Release /p:WDPMergeOption=CreateSeparateAssembly /p:DeployOnBuild=true  /p:WebPublishMethod=Package  /p:PackageAsSingleFile=true  /p:SkipInvalidConfigurations=true  /p:PackageLocation="$(build.artifactstagingdirectory)\\"

In my log it says that the build has succeeded but there are no resulting dlls in my bin folder for me to deploy to the remote server. Since I am looking for single assemblies, I am looking to see *.compiled, *.aspx.cdcab7d2.dll ect.

Where am I going wrong with this?This is what I want to see. I am not seeing any of these dlls
0
Guys I've tried everything that you guys said but none of that works I don't know if my computer have some other problems or something, does any of you guys know any method I could use??
0
hello

When I create a new variable in a vba file in class module and I try to save this vba file for excel, excel crash
Is someone can explain me why I can't modify this vba file ?
0
Free Tool: ZipGrep
LVL 9
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hi Guys,
I have Data sheets that contain numerous ever changing numbers but Excel wont distinguish between (examples)  501550.500 and 501550.5 or 1.2 and 1.20 etc... which are two totally different numbers and I'm trying to total each set/group individually ?
I'm using this =--(LEFT(A1000,SEARCH(".",A1000))&RIGHT("0"&REPLACE(A1000,1,SEARCH(".",A1000),""),2))
but it is placing a zero in front of numbers like 15.2 which becomes 15.02 and still wont distinguish between 15.02 and 15.0200 ? see my problem?
Can You Please Help??
0
I open my visual studio 2010 load a website and all toolbox controls are grayed out..

How can I enable them?

Or how do I start a new project with the controls enabled?

Any ideas?
0
I have a color filled rectangle.  I want to animate a shape travelling across the rectangle such that it is not visible beyond the rectangle's bounds, but still appears to be entering and leaving the rectangle.

In WPF this could be easily accomplished by setting the ClipToBounds property to true, but this doesn't exist in UWP :(

Any ideas ?
0
I have a command prompt utility (EXE file) built under windows 64bit.
This utility uses 64-bit DLLs

Utility runs from command prompt without any issue.

Now I want to launch this 64-bit EXE from a 32-bit COM object.
64 bit EXE launches fine. It performs some actions just fine too.
However, when inside 64 bit EXE there is  call to 64  bit DLL, then it breaks and stops working,.

Is there any reasonable explanation to that ?
0
With VBA, in MS Access 2013, I need to be able to read a MS SQL Server database diagram. I am working with a .accdb
0
hello guys iam working on making a software to connect to sabre API s from my program
but when I try to connect i have authorization issue i want to know how to connect to a Sabre API using Vb.net
0

Microsoft Development

47K

Solutions

32K

Contributors

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.