I would like to be able to read a column of numbers from an Access database into a VB.NET program and then manipulate that data.For example I have a column of numbers and want to add them up and then take the averageThe maths is not a problem but how do I read the column of data into the program. I know how to do this if I first export the Access data into a CSV file, but
View 11 RepliesMe Again, Can anyone tell me how to go about using Visual Basic 2010, on getting file information off of My CD'S/DVD'S as I have Many of them with No titles written on them.basically i would like to insert a CD or DVD into my computer and when i click a Button, A textBox will have all the files from the CD or DVD. and then i could print the list and keep a record of my CD/DVD.
View 8 Replieshow can i create and update mdb [ access ] files in visual basic 2008..and also if i have a dll library how can i get all of its syntax for using it in visual basic?
View 2 RepliesI followed Ziannb article on involking powershell from visual basic. It works great but it doesnt allow me to run scripts with [URL]
- how can i run powershell scripts with arguments from VB
- how can i run one powershell command line at a time from VB. When i use below two command, it pipes the first command to the second one..instead of running them individually :
MyPipeline.Commands.Add("get-childitem")
MyPipeline.Commands.Add("get-date")
My Form 1 has a drop down list for user to select username, followed by a textbox to enter password. If correct password is entered, Form 2 will show.
Form 2 start from cbxCategory for category, then another cbxItem for item. Then a button to click �Borrow� Then it should insert.
This is my form 2_load codes:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Form1.Hide()
[Code]....
I keep getting an error when I try to insert the record. What's wrong with my code?
I am trying to delete rows of an .sdf file using the Database Explorer utility of Visual Basic. When doing so, I get the following error message:No rows were deleted.
A problem occurred attempting to delete row 1.
Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(48 rows). Correct the errors and attempt to delete the row again or press ESC to cancel the change(s). It is correct that the data in the rows are not unique (and not supposed to be; there is no "error" to correct), but why should this prevent deleting them?
I have th is little programm:
Dim dbOud As ADODB.Connection
Dim rsOud As ADODB.Recordset
Dim strCnnOud As String
[code]....
I have used ADOX for create some fields in my database in access but the required property of this appended fields (columns) are set in "yes" but I want to be them "No" who knows how can I solve this problem
View 3 RepliesI have a database in access and one of the fields is 'Is Quick'. I have a query that filters all of these out. How would I get the data from that query in Visual Studio 2010 (Express). VB code please.
View 1 Repliesi seem to have a problem when i try to update a certain record in an Access 2007 Database. I have a small Access 2007 database with 1 table which has 3 Columns and several records. The 3 columns are RecordNumber (Primary Key and it is autonumber), FirstName(text) and LastName(text). What i am trying to do in VB 2008 is implement a search form which when you find a record you can update it. I do not have any problems with the search, but i cannot seem to edit any other record than the first one. For example i search for John which exists, if that record is the 3rd record when i try to edit it whatever changes i make (for example change that to James), the changes i make are made to the first record and not the current one. I tried a lot of things but nothing works, here is my code:
[code]...
I am trying to build an app that can search column A in an excel document (with textbox control). In column B, I have info about the column A items. When a column A item is searched, I would like a textbox (or similar) to display info about it from column B.
View 6 RepliesFor the application I am making, I want a unique identifier (a weak one is fine, just something that would hopefully tell two computers apart). I think I found the right value for the job in the registry, but for some reason it does not want to read intothe program am going after the following key:HKEY_LOCAL_MACHINESOFTWAREMICROSOFTWINDOWS NTCURRENTVERSION ----> ProductIDThe code I am using to attempt to do this is as such:My.computer.registry.getvalue("HKEY_LOCAL_MACHINESOFTWAREMICROSOFTWINDOWS TCURRENTVERSION","ProductID","x") (that last one is just because I need to return some sort of string)However..... I only ever get X returned, and I'm not sure as to why. I tested this with other keys in LOCAL_MACHINE in case it was somehow protected and they worked
View 11 RepliesI've got the following txt file:
[code]...
Now I want that presented in the listbox with the semicolon and it should be aligned per column so that the numbers, the names, the prices and the quantity are exactly aligned per column.If I read the file like this:
[code]...
Then the semicolon is not presented in the listbox and I don't have any alignment per column. As the names of the woods are not equally long the prices and the quantity are not aligned directly below each other...
My questions are:
1) How to add the semicolon in the listbox as seperator of the columns
2) How to align the 4 columns in the listbox (as I have an array Item(3) )
Later on I need to be able to change the quantity (last column) from 0 to > 0 (that's why I have to use an array)
Is there an easy way to consume xml to access any of the nodes directly without reading line by line?Here is a sample set of the xml working with. It contains two records of data. I am trying to find a way to load it so if I wanted to get say PostalCode and say Site SID value quickly.
HTML
<?xml version="1.0" encoding="utf-8"?><MainSite><MainSites Found="201" Returned="20" Status="0"><Site SID="123456"><Relevance>0.985</Relevance><Title>JDoe</Title><DateModified Date="2010-01-29T01:05:00">1/29/2010</DateModified><DateCreated Date="2010-01-29T01:05:00">1/29/2010</DateCreated><PersonalData><Confidential>0</Confidential><Name><First>John</First><Middle>
[code]....
I wrote a programme about 12 years ago in visual basic 3.Since then I have moved interstate and changed jobs quite a few time and lost the original Visual Basic 3 discs.Visual Basic 3 saved the files in a binary format that has not been used in any other version of Visual Basic. So now I cannot read or modify the files.
View 3 RepliesI would like to iterate the files in a folder in Visual Basic. I want to check for each file's name. I heard about a Dir function or something, but I am not very sure how to use it..
View 1 RepliesFor instance, I would like to read the picture's dimensions (width, height) and modify them to fit space available on a page. I have many pictures, so don't want to do this by hand.
If this involves using components or objects, where to find useful documentation about properties, methods, or whatever I need in order to write a program.
I'm using Vis Basic 2010 Express in Vista Ultimate.
I am making a desktop cleaner and I want the program to search For files extensions and move them into a new folder each named after the extension name. Here is what I have.
Public Class Form2
Private Sub Form_Load()
End Sub
[Code]...
I want to use Kill(Me.FileReference.Text("*.txt")) to move the files with .txt extention in the Directory which the textbox named Filereference.text contains which is extracted using MyFolderBrowser.SelectedPath.
How do I run files/application with standard editor/viewer?
View 1 RepliesIn VB, i see file format in wav, but how we can run other formats through vb code my.computer.audio take wav format is there any other posibility
View 5 RepliesI have this
[code]...
Still it shows the message box, this shouldn't be the case and is a tested and proofed situation, in this case it didn't, what am I doing wrong here?
Kind Regards, Starf0x
I am trying to locate the runtime install for Visual Basic 6 Runtime Extended Files. I am not a developer just the guy truing to get it onto the systems for them. My question is simple anI hope the answer is the same. We are converting our systemsfrom Windows XP to Windows 7 and we need the extended runtime modules so a number of our applications will actually work.
I cannot locate the install for this in the Visual Studio download area. Is the re-distributable part of the studio install (so it should be on one of the developers systems) or do I download it from somewhere else.
What files do I need to include when I share my published VB form. I see in the "Application Files" folder there are all my version that I have published. Do I need to include all these or just the most resent with the Setup.exe?
View 1 Replieshow to merge records in ms access 2007 in just a click away??i need visual basic code for merging files.
View 6 RepliesI currently have these group of files I want to rename:
C:Users medinaDocuments estenviromentTestfolderfile1-1111.doc
C:Users medinaDocuments estenviromentTestfolderfile2-1111.doc
C:Users medinaDocuments estenviromentTestfolderfile3-1111.doc
C:Users medinaDocuments estenviromentTestfolderfile20-1111.doc
I have a text box on my form where a I would enter a string of text which will replace the '1111' to whatever the string is in the text box field.
So for example, On my app, in the text box field, I would enter 2222, then when I click on button1, it will rename file1-1111.doc to file1-2222.doc, file2-1111.doc to file2-2222.doc, etc.....
This is my VB code I currently have:
[Code]...
how to sort the group of files in the directory using Hashtable by values?
i'll have more than 500 no of files in the below format:
prod_orders_XXX_<TimeStamp>.dat
XXX = symbol of the product and the length may varies.
<TimeStamp> = date and time
Multiple files for the same XXX are possible with different time stamps.
Here are some examples:
prod_orders_abc_20122001083000.dat
prod_orders_abc_20122001083111.dat
prod_orders_xyz_20122001093157.dat
[Code]......
I have posted a similar question before but this time i need this specificly using Hashtable.
I've made sort of a "Game"
I want to add an Item to all accounts. I know HOW to write into files and add the item but it's adding it to ALL accounts.
Accounts Dir: C:DatabaseAccounts"Username"Items.txt
Without adding EVERY Account file as a streamwriter how would I make the streamwriter do all available directorys for the account's name.
I have an issue with creating a VB program. I reference files on my computer that are displayed in a webbrowser in the program. The issue comes when I install the program on another computer because of the file path. The program is looking for the files on the computer I created the program on because of the file path, instead of looking for the files within the program resource files.
For example, I created the program on Computer A and referenced File "C:ComputerAMy DocumentsHelp.txt"
Once installed on Computer B, the program doesnt display the image because it's looking for "Computer A" in the file path.How do I correct my programming so that the files are universial and can be found on any computer the program is installed on?
I am trying to 1) write code in VB2010 that will get a JPG image from a Access Database field and write the image to a PictureBox 2) write code which will write a JPG file to an Access Database field. I have already sucessfully coded this in VB6, without fully understanding what I was doing.
Browsing the various forum's I have come across a few discussions on this subject, but due to my complete amerture status I don't seem to be able to follow the logic.
Below is the VB6 code
Writing JPG file to DataBase:
Dim bytBlob() As Byte
Dim intNum As Integer
[Code]....
look i need to access to function but this function is found in a library dll, in the object browser appear the description about it using Visual Basic 6.0
Function GetFullUserName() As String
Member of RNASECURITYINTERFACESLib.IRNASecurityToken
method GetFullUserName
i don't how to write the code to access to this function