Dim sumObject As Integer
With 123DataSet.Table1
If .Columns.Contains("ID") Then[code]....
I am using VB 2010 and Access 2007 I have a form and I would like to get the Sum of one of the columns called QTY but I am having trouble with the coding. I tried a number of ways here is what I have.
I've tried this but it's giving me 'System.NullReferenceException':
For Each MyListViewItem As ListViewItem In MyListView.Items
MsgBox(MyListViewItem.SubItems("MyColumn").Text)
Next
[Code].....
I want to access this file which is in a particular url...[www.xyz.com/file]....when i type the address in browser im able to view all the files in that path..
View 1 RepliesI am designing a vb.net application and I want the user to be able to access a powerpoint presentation within the windows form. Can anyone direct me to a good site with good enough instructions for VB.net (not vb 6
View 1 RepliesI am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim SearchPatient As String = txtNPatientID.Text
[Code].....
Windows form application Access database Is it best practice to restrict user entry via keypress event
then validate all info entered & show error control message
or use dataset partial class columnchange as cannot restrict user entry here Could an experienced programmer suggest best way i actually prefer restricting keypress then loop through and validate all entrys
but want to be right
I have an aspx page and I want to access an application on the client after seeking user permission. Both the windows application and the website are to be made in VB.NET.
View 2 RepliesHow can you access the Start Menu from a VB form for both Windows XP & 2000?
I've done a lot of research and haven't found anything that works for this.
I only managed make the form always on top. But what I want is when the form is on top, user cannot access the other application in the windows.
For example : Some messagebox won't let users access the other application until the users hit the OK button.
The problem has been simplified for the purpose of clarity. I want to make a windows form application that uses an access database. The application will store the list of person's basic details such as name, age and country. The database contains two related tables ie person(id, name, age, country_id) and country(id, country_name) My windows form contains TextBox, DateTimePicker, ComboBox for Name, Age and Country respectively. Now I want to make CRUD operation Programmatically (Not using Visual tools) in the same form with some navigation buttons.
View 1 RepliesAny examples of of windows forms that interact with access databases in vb.net. What I creating is a form where you can enter data to a database and delete if need be. But display the contents of a database in a table or tree.
View 2 RepliesI'm having an issue with my app where IE will get brought to the front of the screen when I am switching between forms. Basically I have a form with the man menu which consist of a few command buttons that will start up another form once a user clicks on the button. I do not want the users loading up multiple forms in my application, so once they load one form I end up hiding the main form. So my code looks as shown below when a button is clicked.
[Code]...
With the following code i am able to update record in the first row. Can some tell me what i have to replace in this code to update a record for a selected row. I have a field "Sr_No" with primary key.[code]...
View 2 RepliesI have a form with a list that shows information from a database. I want the list the update in run time (or almost real time) every time something changes in the database. These are the three ways I can think of to accomplish this:Set up a timer on the client to check every few seconds: I know how to do this now, but it would involve making and closing a new connection to the database hundreds of times an hour, regardless of whether there was any change Build something sort of like a TCP/IP chat server, and every time a program updates the database it would also send a message to the TCP/IP server, which in turn would send a message to the client's form: I have no idea how to do this right now Create a web service that returns the date and time of when the last time the table was changed, and the client would compare that time to the last time the client updated: I could figure out how to build a web service, but I don't how to do this without making a connection to the database anyway The second option doesn't seem like it would be very reliable, and the first seems like it would consume more resources than necessary. Is there some way to tell the client every time there is a change in the database without making a connection every few seconds, or is it not that big of a deal to make that many connections to a database?
View 3 RepliesVB GridView control will not allow code in the vb code file to access a data column that has its visible property set to false. When it is set to true, the data column can be accessed with no problem. Any suggestions as to how to correct this? I have looked through the documentation, text books, and I have not found anything that gave me any clue as to what the problem could be. I thought that the property was just applied to the column, not that it would remove the column from being accessible.
[Code]...
Is there any possibility to access directly from a Windows form created in VB.net a protected Excel file? I mean, that the password for opening xls file to be stored in VB.net Windows form. I also have the same problem for a Microsoft Access protected file.
View 2 RepliesIs it possible to edit the Windows Form Designer generated code in VS2008?
View 4 RepliesI have a solution with several Projects in it. There is a Windows App project (called ImportClient), and a Class Library (Import.Library). The Import.Library has functions to perform data imports (I have other applications in the solution that also need to call it). But the interactive application, I want to be able to pass in some form controls, and have it update the GUI. No problem. But, I also want to execute a DoEvents() so that the loop execution doesn't hang other interaction to the app.
So, ImportClient has a reference to Import.Library. But I can't add a reference to ImportClient to the Import.Library, because the compiler complains about circular reference, etc. I don't know how else to define the My.Application object of ImportClient as a parameter to the data function in ImportLibrary.
(I realize this is a dumb question - problem is, for this project I have a tight timeline, and haven't learned how to do the BackgroundWorker process. If you think I could pick it up quickly, I'm open to some hints about how to update the progress bar on the GUI, and how to pause / cancel the background task.)
In my project, form_double Click and Form_Maximize is not working when i do break point. Its not Button_Click, Form_Load. I want to do like this. "My project design form grid column size is small when form load and want to be large grid column size when the form is maximize."
View 1 RepliesI have a .net Windows Service developed in VB.net. I have a settings file in the root directory called Connections.XML and I am setting the basedirectory [code]...
When I schedule the service this is working absolutely fine in my Windows XP machine. But when I installed the same service in our development server (Windows 2003 64 bit Server) for some reason it is not able to locate this file.
I am having a windows application. That downloads files from server and write into the local directory. It works fine. When we try the same appliication in Windows 7. IT shows an error Access to the path denied (While writing to the local directory).
View 1 RepliesI am an old mainframe programmer and have started learning VB and find it a whole new world. I am not able to get my example code to work to access an Access database through automation. I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/13/2009, Prod Ver 4.00.9756.0.
View 2 RepliesI had created a windows forms application in vb.net. It contained several windows. Now the users of that application are telling me to display all in one main form. They want to see all the details in one form. I had implemented MDI but they want something like tabs. On different tabs different forms should be displayed. How shall I implement this.
View 4 RepliesAny way to access a specific column and row of a datagrid generated by a sql-query in visual basic. The datagrid looks, simplified, like this:
Column1 Column2
Data1 Data2
Now I would need a function, that reads data2 out in visual basic (asp.net web).
I have a column in access table with numbers ranging 1-11.What I want to do here, is for the subsequent row to be +1.
View 1 RepliesHow can I change the background of my form to look like that of Windows Mobility Center in Windows Vista?
View 2 RepliesIt is possible to create windows service using windows form control in vb.net. give me the url or links. The windows forms control such as, Timer control, list-box, notify-icon control etc.
View 1 RepliesI have seen this happen before but am not sure how I resolved it in the past. On runtime the controls of my form change from the windows 7/vista format to an older version format as shown in the attached image.
How to display the controls in the format on the left (new windows format)
i am doing project of Order Accepting system for five star hotels.Scenario is Waiter will accept order using Window Mobile which is Connected to WiFi present in hotel.I want to communicate to database(Sql Server) present on My Machine (Computer present in kitchen) through WiFi and Add order into table present inside database. This should notify my application present on Compter and should print order. After completion of Order Application from kitchen will notify to waiter about completion. My problem is How to Communicate with database present on Remote computer using WiFi from windows Mobile.
View 2 RepliesIt is possible to create windows service using windows form control in vb.net.If yes then please give me the url or links.
View 1 Replies