I'm trying to use the ComboBox items to reference specific spreadsheets at location 1 and copy them to one singular spreadsheet as location 2.
oExcel = CreateObject("Excel.Application")
myDirM = "L:DC Productivity ReportTA Temp"
oBook2 = oExcel.Workbooks.Open("C:TestBook1.xlsx")
[Code]......
I am not sure I am even asking this question correctly, but what I am looking to do is re-center a google map based on an address obviously. I currently have a map that displays one property and six nearby other propertys the center is based on the one property. I want to give the user the choice of re-centering the map based on one of the six nearby propertys whose address is stored in a textbox.
[Code]...
I'm not sure exactly if the folder icon is in shell32.dll, but nonetheless if it is.Basically, whenever I come across a folder in a FileSystem list, I want to add the icon for a folder to the image list that I am using for the ListView. The problem is that I'm not sure how to reference a specific icon location in a icon collection in a dll.Is this possible with Icon.ExtractAssociatedIcon and shell32.dll?
View 14 RepliesI am going through a problem, i want to add some dll in my Project from another location.
Scenerio:
1-I am using a third party control
2-Installed it
3-All dll are in reference list, if i add them from their default folder and make local copy true,it works fine
i want to add them from "MyFolder"??How to refer them in my project?? current it gives error like
"could not load file or assemblies..*.dll.."
I am using VB.NET together with ADO.NET to create a program. I have set my TableAdapters as needed and bound the correct tables-columns to my comboboxes.My problem though is this:My combobox2 item is bound to a datatable. The table adapter's Fill method (the select command basicaly) includes a public variable in the where clause to fetch the correct results. I ll put some code here to clarify it a bit more.Public Class Frm_inv
[Code]...
I want to get all items from one column of database table to the combobox items.
View 2 RepliesI want to create a treeview of a specific location, lets say D: drive. I cant seem to find any examples of how to populate a treeview with this info...
Can you anyone recommend any links with extremely easy to follow instructions, or even if its a short code perhaps an example here to get me started?
i m using vb. net when i run my form
View 1 RepliesIm working on a way to use a Select statement to set the image of a picture box.[code]...
View 5 Replieshow can I printscreen a specific location or area in my screen that can be save in gif or jpeg files
View 8 Replies[Code]...
I'm making a combobox on a form. I want the combobox to have a list of choices from a table in a db. The two columns are a String and a Date. I want the date column to only show the year. I'm hoping I have the code right as it is above, but I'm not positive I've done the whole date thing right.
We have several VB.NET websites running internal applications. These sites are often modified with minor changes, and are maintained on the server as uncompiled code. I'm looking for the best way to maintain classes so that we can reference them from multiple websites.
Specifically, we're looking to put some common functions (error logging, common database calls, etc.) into a centralized location where they can be maintained separately from the sites and called as needed. And we'd prefer to have this on the server as uncompiled code, so it can be uploaded without precompiling. I feel like I'm missing something obvious, but what is the best way to set this up?
I'm writing a small program where i need to insert a small piece of text in an existing text-file ( .txt).
Let's assume that I have a text-file with the following text in it:
123; train; 1234;
144; train; 1554;
124; train; 125;
[Code].....
randomizing picturebox location given four points example:i have 4 picture boxes. these boxes should be place at points (145, 190) (210, 190) (290, 190) (37, 190). this will display the pictureboxes at a horizontal line. i'm adding a functionality that when i press spacebar or click a button, these coordinates will be randomized and be assigned to my four pictureboxes just like in text twist but no animations.
View 7 RepliesIm working on a way to use a Select statement to set the image of a picture box.
select case currentno
case 1
PictureBox2.Image = Image.FromFile(C:UsersValued CustomerDocumentsVisual Studio 2010ProjectsChiroReportChiroReportChiroReportPnt_GuideLAT CERVlatcerv52.jpg)
[code]....
The Select statement should work fine but the path to the file i want to open doesnt. Id love a way to reference the Pnt_GuideLat Cerv directory based on where my program gets installed on the Hard drive.
I have a form in my vb.net application used to take the data about the returned stock. The form contains two comboboxes. One, named combobox5, contains invoice numbers and the other, named combobox3, contains party codes. Both the comboboxes are pre_loaded using sqldataadapter.
Now what i want is to change the party code in combobox3 when the invoice number is changed in combobox5. Elaborating it further, When Stock is issued the party code is stored along with the invoice number to keep track of to which party was the stock issued. Now when stock is returned i want to keep track that which party has returned the stock and i want that the party code should be automatically selected when the invoice number is changed and it should be what is stored in the database against that particular invoice number....
I'm using the following code for doing so:
Private Sub ComboBox5_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox5.SelectedIndexChanged
' defines a new connection to the database
Dim con As New SqlConnection("Data Source=TAHA;Initial Catalog=ADT;Integrated Security=True")
[Code].....
i'm creating a simple search application which have a TEXT box and some combo boxes and radio buttons and a search button.radio button names "Videos", "Audios", "Pics" etc..when radiobutton of video is selected, a combobox is appear having options "DailyMotion", "Metacafe" etc I want that when i click "Metecafe" item in combobox of video, an other combo box appear having items Like "Entertainment", "How To", "+18" etc(categories of video search).
if combobox1.SelectedItem = "PAKISTAN" Then
combobox2.Visible = True
End if
if combobox1.SelectedItem = "INDIA" Then
[code]....
I'm trying to do the following I'm not sure if it's possible using VB.NET. I want to specify default saving point for all files type for example: In my program you choose the path "C:UsersMarkusPictures" for pictures and everytime you download pictures files from website, or using skype or any other program when Save File Dialog opens up (external one not via my program or connected to vb.net just the windows default one) then it will show "C:UsersMarkusPictures" always for .jpg .gif type of files etc...
View 2 RepliesI have a bunch of controls loaded into the same row/column in a TableLayoutPanel. I only have one at controls visible property set to TRUE at a given time. I want to be able to loop through the controls that specific row/column position in the TableLayoutPanel and test for a condition (control type) and then set this control's property to TRUE and all others to FALSE. Bascially I am turning controls on/off.
I know can loop through an entire TableLayoutPanel like this:
For each control in TableLAyoutPanel.Controls
Next
How do I restrict this loop to a specific row/column in the TableLayoutPAnel? Can you qualify where specifically you want to look in the container control?
I have the following code used to enter the name of a text file and then display it in a richtextbox. This is working but I would like it so that I could take out the initial part of the filename detailing the location of the filename to simply set it to the project folder, is there any way of doing this using the App.path function?
My code is as follows:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I finished every piece of code in my program save for one tid bit, how to pull two numbers from a text file. I know how to pull lines, I know how to pull search strings, but I cant figure out this one to save my life.[code]The two numbers that I need out of this are the two ones that I put in the **'s (the asterisks are not normally there). These numbers will be different every time this sheet is generated, and the number placement might be different as well as some of the numbers could have 4 digits, 5 digits, or 6 digits.
View 1 RepliesIm trying to get my webbrowser to display Specific location of the website it's loading i.e login
Instead its showing me top right coner of the banner :s
Is there a way for my webbrowser to display whats on middle of the page and not on top of the site it self ?
Does anyone knows how to export/extract/copy (or whatever is the right word) a file wich is added to the soulution, on the startup of a program, like somekind of installation?
View 5 RepliesI finished every piece of code in my program save for one tid bit, how to pull two numbers from a text file. I know how to pull lines, I know how to pull search strings, but I cant figure out this one to save my life.
[Code]...
What is the best and fastest way to find the exact location(Drive/Folder) of a specific file, without scanning the whole drive. Right now, I am using those two instructions to locate EXCEL.EXE so I can properly call it with a shell command.[code]It is quite a long process, and I have to deal with some access denied folder like System Volume Information. I am quite new to VB programming.
View 3 RepliesI've created a very simple form with one button on. I need it so when the form runs, it opens in the bottom right hand corner of the screen regardless of the resolution. It also needs to be always on top of all other applications.
When the buttons pressed, i need it to close all iexplore instances and reopen a fresh instance.
I've tried to search for the answer but to no avail.
As I have no idea on how to retrieve access data at the specific location in the table, so I wrote VBA code t export the entire access database to a datagridview which is located in the form1. There's a column of datagridview contain complete address information of a image. I'm thinking a way to link image source (of form 2 or xaml file) to the the column so that the image will be displayed. is there any code to get cell value at the specific location in the table? In excel VBA, sheets("Sheetname").Cells(rownumber, columnnumber).value is used to get the cell value, but how about code for this case?
View 2 RepliesMy project that I had built used spreadsheets and charts within the forms to provide the user with the necessary data. This worked fine for VB2008 as it had all of the ActiveX office web components built into it. It seems that VB2010 has a different set of base components and emphasis office 14.0. I was wondering how people have gotten around this or if they can. I tried using DataGridView, but it doesn't seem to be able to do what I want to do. I need the ability to have users enter data into a table and then use that information to be able to build graphs real-time based on their data.
View 2 RepliesI am loading a KJV.rtf file at program startup into RichTextBoxDisplay. When I want to select, lets say, Matthew Chapter 1, I want the program to take me to Matthew Chapter 1. I know I could just load a seperate file into the rtbDisplay, but do you know how many chapters and books are in the Bible..
View 2 RepliesI am trying to write code that will compare the information in all row(one column) in the two spreadsheets and if they are not the same update another column on the row with a difference with Updated. but i am getting this error
countExcel = xlsSheet.UsedRange.Count
first_index = 1
last_index = countExcel
[code]....
