I am attempting to create a program for a business but i have no idea how to create a database to hold the information and allow me to access it when needed
View 1 Replies
I have written a simple program which receive data from serial port i.e (temperature) and display on a line graph. but i require accumlate the graph data upto 10 minutes on screen. after that it again accumlate next 10 minutes data.[code]....
View 1 Replieshow to create a program that can access information held in an excel database and show it in a simple form.
View 2 RepliesI have a bit of a problem. I am using an Access database to hold data for my VB app. In the VB app, I have a data source thats pulling data from the database.
I modified the database today, deleted some tables, added another one, but the data source in the project window does not show these updated changes. I had to reconfigure the datasource with the wizard to get the changes to update.
Is there a way that i can get the data source to update itself when the form loads?
I'm creating temp file to hold and pass information. What is prefered, XML or text files, and why?
View 3 RepliesI'm having a problem with loading my MS Access Database. I can get it to load but it won't load in a row. My friend told me to try this but it puts all the information in a column instead of putting all the information spread out accross the row.
Here's my code:
Dim lb_Connection As New OleDb.OleDbConnection
lb_Connection.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE = pass_database.mdb"
Dim lb_SelectCommand As New OleDb.OleDbCommand
[Code] .....
Also I'll attach an image of what the program does when I load it.
How to create a line graph in VB 2005? I will get the data from database and plot a line graph with the information i get from the database and display it out. I know i can use Microsoft chart control but i don't really know how to use that.
View 2 RepliesFirst, I would like to add a text box search field to this form (because navigating through several thousand users with arrows isn't going to work). When the search button is pressed, I want the username to be looked for. If found, the form (and each textbox, option button, etc.) is updated with that user. I can then modify the user's information and press save.
Second, how do I access and change information in a database with only code? For example, if I periodically want to check every user in the database to see if they have over "100 points" and if they do, I subtract 10 points from that user.
I am creating a medical record system using MS Access 2007. the finish product will be used for a small healthcare which has only one available pc for now i ve done all required tables and some queries. What I really want to do is to design the forms where user can access information using VB 2010. I ve read tutorials online about how to connect dataabase to vb and successfully did that.
[Code]...
I've got labels on my form using the following "Shift1Time1Label" to "Shift1Time8Label".I'm trying to get information from a access database and change the text of the labels.I'm getting the information, but having an "Object reference not set to an instance of an object" on the directcast to the label....
[code]...
I am at a stand still on this one. I know how to connect and add to the database, I just don't know how to retrieve the information so that a user can see it! If anyone could help me with code or another example.
View 4 RepliesI have been requested to implement a login form into a friend's Visual Basic .NET application. He specifically requested that I should do this using LINQ to compare the input to a table in an Access database. I don't really know why he imposed these restrictions, but who am I to judge? However, the problem is I am not overly familiar with VB .NET, or LINQ.
View 1 RepliesI want to store the contents of an XMl file into an array but struggling to work this out. I have managed to read the data in and store in labels as a test. I then created an array list and used a message box to display the data to see that it has been stored. It does but I am not sure how to group this data. There are 3 records in the file. the idea is to end up with the following:
[Code]...
does VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesThe problem is, I've never created a class before, not in VB, Java, or anything. I know all the terms associated with classes, I understand at a high level how classes work no problem. But I suck at the actual details of making one.[code]...
As for the Getter and Setter, the reason I put the question marks in is because I want to return the whole array there. The class will eventually have other properties which are basically permutations of the same data, but this is the full set that I will use when I want to save it out or something. Now I want to return the whole Array, but typing "Return fullDataSet()" doesn't seem like a good idea. I mean, the name of the property is "fullDataSet()." It will just make some kind of loop. But there is no other data to return.
have been developing an application for quite some time now. I have decided to create an mdi parent form to hold all the windows I have done so far. Is there an easy way to implement the mdi parent/ child associations?
View 12 RepliesBackground: (Office 2007 and XP Pro all Up to Data; Net Framework 3.5)Two data files are compared one to the other (in Access via VBA) to ascertain matches & non-matches. This aspect completed in Access because of Access's large datafile capacity
The matches and non-matches are passed to Excel via Offine Automation In short, I am attempting to ascertain the "Access-related" VB.NET References required in VB.Net Solution Explorer.
I have included snippets of the VBA code for examples of the Access objects.I would like some knowledge from an expert in Office Automation and VB.NET.
[Code]...
I need to update (well, rewrite really) a SMALL VB6 application which uses ADO to access a JET database, to a vb.net app in Visual Studio 2008. My research suggests that I should use LINQ, but it doesn't seem to be possible to connect to JET. If JET is now deprecated, what should I use? Or should I use ADO.NET without LINQ?
Please don't answer SQL Server! - this needs to be an app that end users can install easily in corporate or non-corporate environments, and must not require any ongoing technical maintenance. I started to install SQL Express, but stopped when it required at least 2 system updates, as that will be far too complex for this little app.
How does the GC dispose objects created in the following 2 scenarios?
1)
Private Function DoSomething() As Boolean
Return New DatabaseManager().Insert()
End Function
2)
Private Function DoSomething() As Boolean
Dim mngr As New DatabaseManager()
Return mngr.Insert()
End Function
In Option 1, I don't create local variable to hold the reference of the object. In Option 2, I hold the reference in local variable.What option is better and why? (if any)
I'm attempting to create a small app that allows a teacher to input 5 students with 5 test scores each. I need to create arrays of strings to hold the five students names, an array of five strings to hold each student�s letter grade, and five arrays of five single precision numbers to hold each students set of test scores.
[Code]...
im using XML as my database and uses dataset to hold the xml. which one do you think is better to backup my xml?
1. write the xml to 2 location, default location and the backup location
dataset.writexml(path1)
dataset.writexml(path2)
2. write the xml to default location and copy it to the backup location
dataset.writexml(path1)
copyfile(path1,path)
if you have a better way of doing it please dont hesitate to share it..
Have a populated listview with check boxes. If the item is checked I want to send it to report for printing. This code is bypassed:
Code:
Private Sub GetSelectedItems()
If Not Me.ListView1.SelectedItems.Count = 0 Then
[code]....
Count is always = 0. This seems to work only if the item is double clicked. And then only one item is returned in the msgbox. MSDN says "The SelectedItems property will not contain any items if the property is accessed before the ListView handle is created, which typically occurs when ListView is initially loaded for display in the form. You can check to see if the handle is created with the IsHandleCreated property."
When I tried to check for the handle, an error said something about overloading. So I added this:
Code:
Public Overloads ReadOnly Property GetSelectdItems()
Get
If Not Me.ListView1.SelectedItems.Count = 0 Then
[code]....
Which does not help. How to find the items checked/create the needed handle?
How can I create a list (of my custom structure) to hold only unique items? This list should be created from another list.[code]...
View 5 RepliesThe program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and runs the QueryDatabase() Function i am encountering an error of: "OleDB exception unhandled: No value given for one or more of the required parameters." This occurs on line 15 of the first code snippet. Can anyone explain this and/or identify any code issues if that is the cause.
[Code]...
I am using a vb.Net 2010 and sql server 2005.I want to run a solution that is windows form to another computer.There is No centralized server.
View 1 RepliesI have a problem with my program, and it's really bad because I need to burn it to disk within 12 hours and I can't get it to work: If I create a record, add information to it and click on Next Record, the ID, Status and Notes boxes content will change but the rest of the controls contents are carried over to the next record and I don't know why or how. It was working perfectly but now it stopped and I never done anything.
View 8 RepliesI am trying to create a database in access, and interact with it using a VB form and listboxes in particular. I am stuck on one small section which should open the rest up for me if fixed!The database has 5 columns, ID, Book Title, Author, No. Sold and Year Sold. I have managed to get my program to put all the data from 'years' into a listbox using this coding:[code]This nearly works, but the problem is that it copies ALL the Number Sold from every year, not just the one highlighted.
View 3 RepliesHow to create a ms-access database with table in run time .i mean i want to create a database when user run the application
View 6 RepliesI need to create a field in my database access throught code... I had this code in VB6 to do the job,but i'm a little confused with the way to do this in VS2008.Off course I know the way to open the database,but the way for create the field I don't know!
Dim tdf As TableDef, fld As Field, Top As TableDef
Dim nCtr As Integer
Dim bFound As Boolean
[Code]....
How do you create an access database dynamically?
View 2 Replies
