Hot Solutions

Public Shared Function GetScriptReference(ByVal scriptPath As String) As ScriptReference

        Dim sApplicationUniqueId As String = ""
        If Not IsNothing(HttpContext.Current.Application("unique_id")) AndAlso...

i am trying to create crystal reports.

 the problem is, in my database application, i access my database remotely by giving the database path and provider statement at runtime. Which helps me to load the data into my dataset and then to my...

Although I can set the .SentOnBehalfOfName property in the MailItem_Send or Application_ItemSend event, and even though I can get the property to display in the "From:" box of the outgoing email with a Recipients.ResolveAll (thanks Chris), the...

Hi:

We're creating web applications using Visual Studio 2010 and Visual Basic.

We saw in the list of data sources offered by VS 2010: EntityDataSource, ObjectDataSource, and LinqDataSource beside AccessDataSource (used with Access db) and...

Hi,

I hope that someone is able to help. I have created a simple application that opens a crystal report using the crystal report viewer. The environment is windows server 2003 x64 bit.

I receive the following error below:

See the end of...

I'm not sure the best way to resolve this issue.
I have a page that has data for an individual person, but I want to convert it to a page that does  a do while loop for all the people within the specified group.  
I need some guidance on doing...

Hi,
One of our users updated their PC yesterday and after the reboot everytime he opens excel he gets the following error message with the title Micrososft Visual Basic;
"Compile error in Hidden module: modMain"
I have read that it's an Adobe...

I want to create a UserForm that has TextBox1.  How can I bind TextBox1 to a mail item object so that the TextBox1 value is the .To property of the mail item and so that if I type in TextBox1, it will replace the .To property's value?  And how...

Hello experts,

I'm developing some custom application for the RS232 -Serial Port

It connects to a barcode scanner.

The scanner is directly connected to the port and set to COM1

when reading the barcodes that are UPC it reads two...

We have a database that was developed using Microsoft Access 2003 and then was migrated a couple of years back to Access 2007. It ran fine for years.

This past week, we upgraded to Access 2010 and the database appeared to be running fine, all...

Below is the link for the crystal reports that needs to be installed on visual studio 2010

SAP Crystal Reports Link

i am not sure of what i am suppose to install on my computer.

i have a 64bit pc with visual studio 2010 installed.
...

I have been asked to write a DLL that exports functions through __stdcall.  I'd really like to do this using Visual Basic.NET (2010 currently) as that is my preferred programming environment.

I've spent quite a long time searching for samples...

Experts,

I have a text box on an asp.net page written in VB and the textbox has a calendar extender attached to it.   What I need is when I change the date in the textbox (txtDate1.text) it inserts the Julian date into another textbox...

How to create crystal report fields progromatically.

Language used vb.net, visual studio 2010

database used: access 2007

Hello all.  Our company just purchased some Motorola LS2208 scanners.  I need to integrate the use of these into a vb.net 2010 project (.net 4 framework).  My objective is to have the program react to a barcode scan at any point in time and...

I installed Crytal XI R2 to use with .Net 2005.  How do I expose the AxCrystalActivexReportViewer Control in the toolbox?  The viewer that is currently exposed is CrystalDecisions.Windows.Forms.CrystalReportViewer version 11.5.3700.0.

I have a SQL Server database (2000-2008) that is used as a back-end to a VB.Net 2005 Windows application. It currently uses varchar and text data types that will need converted to unicode. I understand the nvarchar and ntext part of this...

I need a httpwebrequest script that can submit details of login form programmatically and then be able to get page source of pages that requires the login.

FORM:
 

Wireshark Data - On form submit (POST /login.php HTTP/1.1 ...

I have some programs that run in Dynamics GP VBA that use the SendKeys command to simulate a keyboard key.  An example is:  SendKeys "{TAB}".

This has worked for several years.  But one of my clients installed the program on a Windows7 machine...

Hi,

I am using visual studio 2010, and i needed crystal reports so i installed crystal reports from the SAP link and below is the link that i used to install.

SAP Crystal Reports Link

And I installed,
SAP Crystal Reports, version for...

I need to make a crystal report using the data from the datagridview.

Also I have to be able to design the crystal reports (i.e. aligning the fields and putting headers etc...) using the crystal reports design page.


Thanks in advance

Hi:

We're creating a web application with VS 2010 using Visual Basic.

We'd like to update an access database table using OldeDb...

For some reason, when we run the code, the program hanged and a message: "syntax error in WHERE clause".
...

Using DecodePixelHeight, I can change the size of the image.

But I only want to limit the height of the image to a certain value.
e.g.
The maximum height I want to insert is 48 pixels.
If an inserted image has a resolution of 64x64, then...

I am migrating my Visual Studio dev environment to a new PC and getting an error when building a solution:

Could not load file or assembly <file> or one of its dependencies

The dll is there, in a right path. I don't see any warnings about...

Hi. I am trying to apply a theme to my PowerPoint 2007 presentation using the following code

    oPresentation.ApplyTheme("C:\Program Files\Microsoft Office\Templates\Apex.pot")

I can't seem to find where the themes reside on my system. Is...

Hi

I have a button with a flatstyle property set to "popup". What is the best way to change the back color to dark orange on the mouse hover. If I use the FlatAppearance>MouseOverBackColor property it doesn't change. Should I just use the...

Hi guys,


I am using vb.net and access 2010 database.

I am using an insert statement to send a double value from a grid-view cell to an access database.

The cell contains a double value.

The problem is i am able to send the values...

Hi there...

I have this code to insert data into the array:

 

I think I'm doing something wrong. Basically I need an array that would have 2 columns 1 for ticket id and the other for account id. Then i need a code to get those values out...

I have an Infopath 2010 form with several sections. In each section, the person doing data entry must input several numbers (text boxes field1, field,2, field3, etc.). This can't be a Repeating Table. At the end of the section, I created a...

Hello experts,
I have a string like
string str = "A=1&B=2&C=5=6&D=7=8&E=9";

Dictionary<string, string> dict = str.Split('&').Select(x => x.Split('=')).ToDictionary(x => x(0), x => x(1));
using above Linq I get the output as

A = 1
B = 2...

Hi,

I have the following code in my VBA program which try to find the column location of a currency code in row of my current spreadsheet.

Code are as follow:

Dim CNYcol As Variant
CNYcol = WorksheetFunction.Match("CNY", Rows(2), 0)
...

Hello experts,
I am using visual studio 2008, to print out a label.  I am replacing a spread sheet that is currently printing the label.  The problem is, in the print properties of the spread sheet, it is set to center on page horizontally.  How...

I want to give effect to this:

I would also use Variants here since it will always save you having to do two calculations and possibly three. Further, I would load the entire range into a Variant to start with rather than reading cell by cell....

Hi:

We're creating some web application using VS 2010 with Visual Basic.

We try to insert a new record into an ACCESS table, or update/delete an existing record using DetailsView associated with AccessDataSource

We configure DetailsView...

I am programming in Visual Studio 2008 using vb.net.

I have a web program that contains pages with many fields.  I have the following code that converts enter to tab, but only works in i.e.  This app must also work in Mozilla Firefox and...

I've found this function that I use for uploading a database file to a FTP server, and it works fine. But I need to have an additional parameter in the function, so that after uploading the file to the folder indicated by the sDir paramter, it...

Please help!  I have been banging my head against the wall for  days.  I cannot figure out why this all of the sudden started happening.  I am well aware of the breaking change sp1 win7 does to MDAC and I've posted ad naseum in those threads...

 

The above function needs to be able to handle any message, regardless of what special characters might be in it.  I thought adding the escape() around the message, but it did not help.  It will not display this message (which I was expecting...

I have a report that successfully opens in test.  However, when I switch it to production, it bombs.

The actual Crystal Report points to the development server.  However, in production I thought this call would redirect it to the correct...

So I have spent some time researching FindWindow and the link and I have a slight problem. When I attempt to reference an object I am hitting the first one. The code I am using is:

 

I need to find the specific instance of an incData. I...

On login to my website, I create a session variable. I'm trying to find out if there's a way to remove that session variable if the user leaves the web site (ie they close that browser tab or just type in a different url).

After doing some...

The following loop is intended to keep going until 1 is reached but it is outputting 0.  What am I doing wrong?  Any assistance offered would be greatly appreciated.  
dim intCounter as integer
 dim intAnswer as integer
 
 intAnswer =...

Hi,

I need to create crystal reports from sql query.

i.e. using the output of a sql query from a database, i need to create a crystal report from the output of the query from the database.

Language used: VB.Net

Database Used: Access...

Hello all,

I'm developing an application for myself to force me stop gambling when I get reckless. The application is in my startup folder. What I want to do is to force shut down for two hours. I'm using the following command: ...

Any examples or suggestions on how to access/display the client side web cam on a aspx page using vb.net and click a button to save the image would be helpful.

Hi there, I was just wondering if it is possible to make a client + server application that would allow the client application send data via servers ip address.

Basically client's application would only have a webbrowser in it, but all the...

Hi Experts,

I have menu name names stored in a SQL server table. I need to fetch this menus, loop through them and disable on the main form. I have been unable to to do so. Please assist.
 

Hello,

I am using the code below to load my combobox. How do I modify it for the combobox to only display the first four rows?

  Dim CCF As New DataSet
            CCF.ReadXml(Server.MapPath("~/App_Data/CCF.xml"))
           ...

Hi there,

I have been searching high and low for a solution to what seems like a standard layout for a navigation pane. I have managed to obtain outlook 'accordion' style navigation panes from around the net.

The one I am currently using...

Hi,

I have a two lists in excel (named ranges) :

NamedRange1: called taskIDs - has two fields
taskID, taskName

NamedRange2: called taskRelationships - has two fields
parentTaskID, childTaskID

Both named ranges are dynamic named...

I have to load a TreeView's images from an array of image names (not indexes). Is it possible to load an image from resources to a TreeView node?

Hi experts,

I have a asp.net project using VB. In the main project directoy I have a login page which is my main page. It’s called Login.aspx

So once a users logs in then they are taken to Main.aspx which is the home page.

So on my main...

Hello

This is driving me a bit nuts, I can't see any reason why this isn't working.

I'm trying to change the cssClass of a div inside a repeater control using the code below:

 

This is being done in the ItemDatabound Method and works...

I'm reading a text file and I want to look for specific sets of text between two distinct lines.
For this example, the first line will be the first instance that reads "Pressureandleaktests" and the last line will be the next read instance...

I'm trying to put an app on the web and I'm having some trouble with the login control.  Everytime I try to log in I get this error:  Your login attempt was not successful. Please try again.

I've gone through this entire site: ...

Novice question:

I am perplexed about how it is that the arbitrarily (meaning not apparently connected to anything at all) dimensioned "Dim ArrayStr As Range" is recognised by the "For Each" loop as being each following cell in RangeToSum.
...

Hi there, I would like to know how to click submit button on the HTML form in a webbrowser control.

HTML FORM:

 

PS: I have no access to the page, so I cannot change the source code, it has to work with the one above.

Thanks

Hi there,

How to bind data to combobox?

Thanks!!!

I have users who change their Start+ControlPanel+Display+Settings - from
1024x768 -to- 1280x1024 -to- 1680x1050 etc, etc, etc ... Why? Don't ask, it's a long story with a lot of screaming and pounding of fists on table tops (smile).

I have a...

Hi ,

I need a way to swap 2 cells on datagridview with drag and drop.

The problem is the drag and drop work only beween 2 objects and I have only one object.

Is possible do it ?

Thank you !

Hello,

We are using visual studio 2005 and want to know that how to programatically add text box and its leave event in winform ?  We are developing this windows application using VB.NET.

We know that it will need event registering steps...

follow on from here a37709867

 

Is this:

InStr(varData(n, 1), Lookupvalue & ",") > 0

any faster than this:

vlookup(lookupvalue, Evaluate(varData(n, 1)),1)

Ans: ok, I get it, of course it is, it's checking the existence of...

I've to append a row to a file every time a scanner read a barcode. I'm thinking to use a StreamWriter object with append option set to True. The rows appended are modified by another application (called AppA). I'm confused about this:...

I'm getting an 'Object reference not set to an instance of an object' error that I can't interpret.  Here's the code:

 

I'm getting the error on the 'theElementCollection = WebBrowser1.Document.GetElementsByTagName("select")' statement. ...

Hi I have a simple web page that I change the Title of it using javascript.
This works fine when viewed in IE/FF Safari etc. Very simple stuff.

When I load that page into the Webrowser component in VB2010 it picks up the initial title using...

Special tags are being encoded.  How can I decode them?

For example, they are being rendered like this:
&lt;em&gt;Hello World&lt;/em&gt;

Instead I want them to be rendered like this:
<em>Hello World</em>

This is my my .aspx file:
 
...

Hello experts,

I have an application in VB.Net which stores data in a SQL server database.

I'm using ColorDialog from the "System.Windows.Forms" Namespace to let the user select background and font color.

If the the user selects Blue for...

I have created a crystal report using CR v11. Its a simple data driven report and uses ODBC connection.
I added that report to Visual Studio.Net 2008. Now when I try to run that application the report doesn't open up.
It gives an error that...

Hi:

We're creating some web application using VS 2010 with Visual Basic.

We try to update/delete an existing record using DetailsView associated with AccessDataSource

We configure DetailsView to bind with the AccessDataSource and also...

Hi,

Does anyone know of a good applicaion that you are able to run on a vb.net application that gives you feedback on your code such as code not used / variables not used / and other issues such as loops where the program can get stuck...

I am trying to requery for the combo box in another form.

I have two forms.
frmPublication/frmqryAffiliatiion_subform
frmAuthor

When I adda new record in the frmAuthor, I want to requery the combo box in the subform of the frmPublication....

Not sure if this is possible, but I wanted to use a FillBy query to populate a datagridview on a form I have.  The issue I have is with the Where clause.  If I hard code the item to lookup it works fine

Where TrustName = 'Smith Trust'

I run...

I have a simple subroutine that takes data pulled from a web form and submits an email request.

Ultimately, rather that sending the email I want it to save the email as an RTF file that retains the formatting.

If this isn't possible could...

I am trying to copy contents of a folder from folder A to B but it is not working. There are no errors thrown and I can't figure out what is going on.

I have used this before to copy entire contents of a folder from one to another but have...

Hi

Can sombody tell me if its possible for VS 2005 that runs on a 32-bit, can be deployed onto a 64-bit server? and do i need to install the 64-bit SDK for it to run ok? and as the application has always ran as a 32-bit what are the dangers of...

I'm an experienced VBA developer but fairly new to Visual Studio. I've got a Visual Basic project.

I copied an existing form from the Solution Explorer and renamed it to "FrmList".

I realized I copied the wrong form, so I deleted that and...

Hi

Can anyone direct me to a simple set of free startingvideos for C#. If possible looking at it
from the position of a VB.net developer.

Thanks

I have a minimal working test application that uses globalisation and the contents of the URL to load specific resc files. This is all working fine and the code is below.



I duplicated this code to the actual website I need to use the...

Hi. I need to get a range eg "A2:B6" after the user selects it. The problem is that the following code returns "$A$2:$B$6. The $ signs cause errors

            Dim R As Microsoft.Office.Interop.Excel.Range
            Dim A As String

     ...

I have a number of buttons that perform actions on the selected record in a bound datagrid.

I only want to enable the buttons if a record is selected and the values of certain properties for the selected item meet the right condition.

I'd...

Hi,

I read a DBF file (with more than 1.000.000 records) into a datatable.
I can read that data, but now I want to group by on 2 columns (sampnumber,testcode)

Once I know the unique records by (sampnumber,testcode), I want the last 29...

Hi Experts,

I currently have the following WHERE clause...

WHERE     (DateReceived BETWEEN '2012-01-01' AND '2012-12-31')

I need to alter this to be a date between the current date and 1 year previous.

Thanks,
Dean.

Hello EE!

Trying to query a datatable using LINQ to enhance my application.  I'm able to get the query working just fine but want to return it as a list and further bind it to a gridview.








 

Hi Experts,

I am using ListView on my form, and it is filled with two columns of data.

I am very much familiar with datagridview, because i access cells' data in the datagridview by locating the row index and the column index.

But in the...

We are using .NET to create various reports (in .txt format) - so files created are text files. Using streamwriter and corresponding code like writer.WriteLine(.......)'s to format the output on the report.  Lot of reports, so lot of manual work....

I have a parameter in a crystal report that can contain multiple values.  i.e.
["10000","20000","30000"]

I select on this using the "is one of" function.  

If I load the report in crystal, and select mutiple values it works flawlessly. ...

Hi Experts,
I want to convert a Visual Basic 2010. It is now targered for framework 3.5 and I want to use framework 4.0. Everything works fine except for the Crystal Reports modules. They are still dependent on v.2.0.50727. I have installed the...

This is going to be a strange issue and I don't expect an answer, but I would appreciate any insight.

I'm using Ghost32.exe to image HDDs within a Windows PE environment. With the release of WinPE 4.0, we can now use the 4.0 .NET framework. So...

Hello EE,

I have a DataGridview I would like to export to excel. I know how to do it with for next...
my problem is the column order in the excel needs to be a little bit different.

lets say Columns in the dataGrid are :

TotalCredit    ...

Experts,

In inhertied this add-in and am charged with getting it running on our new appplication.

this is a very short file (about 22 lines without the comments)

The previous applicaiton it ran on had FoxPro Tools and the new...

Hi:

We wrote some visual basic 2010 code to read data into a DataGridView.

The code runs correctly and data is displayed accurately in the DataGridView.

However, when we wrote extra code to verify the number of rows of the DataGridView,...

I have a DataGridView that is bound to a list of class objects.  I have added two additional checkbox columns to the datagrid view to allow users to select which items a user should have access to and which one should be the primary item.  This...

How can we have a config file to change the pointing server, as in .NET apps, for a crystal report.  We need to change the server to test the apps in different SQL instance.

I am trying to get the first letter of a first name
What I have is
            Dim trimString = txtFirstName.Text
            Dim stringLength = trimString.Length - 1
            Dim Initial = trimString.Remove(Right, stringLength)
         ...

Hi,

I have a form with main/subform.

I am trying to get the name of the combo box in the subform.
I do n't see the name of that control.

What does  not it show the name

Is it possible to get the mac address of a user when they are running a silverlight 5 application in their browser?

We have a vs2008 vb app for mobile devices, running Windows CE in the compact framework environment.  If I user has not used his mobile device for 60 seconds, I need to know, so I can have the app make a backup of the database.  I found this code...

I am trying to make a program that will give me a list of nouns that sound similar to a particular word. I have found websites that will give me lists of words that sound similar but I then need my program to identify which of those similar...