I am designing a Point Of Sale system to be used by sales representatives. The sales rep should be able to place an order of a specific product on behalf of the customer. I have defined my relationships between the tables, Product, Order and Customer. When i try to save my orders i get an error that says "you cannot add or change a record becuase a rerlated record is required in table Product"
View 1 RepliesI have a thesis project. it is composed of a webpage created on php and a system using vb.net 2008. As of now , they are both connected to the same database. I am wondering if it is possible that if i packaged the system and live the website, will still be connected with one database?
View 1 RepliesI have a connection to an access database, I have used the data sources tool provided because in this particular instance I don't want to do much with it other than display the records (which I can do) and edit them (which I'm haveing some trouble with).I have created a system whereby the database is connected to using the preset tools available like; BindingSource, TableAdapter, BindingNavigator etc.
I also have a button for edit. This doesn't work and I was wondering if anyone could help me with this? I can't really provide any code for this, because I didn't code the connection by hand and the code I have been attempting to use for editting the records in the database doesn't even sort of work.
i am wondering if it is possible to get the source code for the following:
1. use vb.net code to set on/off primary key when connected to Access database
2. update a particular data.
for e.g: hostname: AES-19 *use source code to check data in Microsoft Access database
if hostname is new, insert into Access. if hostname already exist, update into Access
*so that i will not have duplicate data in Access.
[Code]...
I have a system that can add, edit, delete and search data that is in ms access. That ms access is connected to my vb 2008. I'm upgrading my system so that it can print the access file.
View 1 Replieswhen i will enter form no. in the text box this should check the on the lost focus event either this form no. is already exsist or not.if exist show msgbox?
View 1 RepliesWhen a vb project is connected to ms access(DB) whenever u make any changes in d db using addNew or insert or delete follwed by update command the changes are reflected in copy of original db in the debug folder of our project.in which updated values chnges with each run .. no changes are reflected in d original db.is dere any command to make dese changes permanent.
View 8 RepliesI have a windows app that has a bindingNavigator connected to BindingSource that connects to an Access database. I am manually adding a record to the underlying database using an OLEDBConnection/command (cloning the current record). The insert into the database works fine, what I am not sure on how to do is force the bindingNavigatgor to refresh and read the new record and refelect it in the record count/next/previous buttons.Jack
View 7 RepliesHow do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
i have created a projevt in vb.net.......and i'm going to deploy it......in my project i use vs2008 and sql server 2005....i already added database.mdf and .dll files in application option.....but when i run this setup on other pc ....project successfully runs......but when i want to use database the following error occured.."database could not be connected"......
View 1 RepliesI am working on a client system . How i will get IPAddress of all the system connected through lan.
View 1 RepliesI am using VB .Net to connect to an access databse when using several connection sometimes i get this erro "unspecified error microsoft jet database engine" even though i am an administrator on my local machine.
View 1 Replies(using VB2008) I am trying to automate Access from VB.Net. To do this, I added two libraries to my project, Microsoft.Office Interop.Access v12.0.0.0, and dao v10.0.4504.0. This seems to give me all the necessary commands, yet when I tried to open up an Access database via the following code:
CODE:
I wanted to create a Login System. I am using Visual Basic 2008 Express Edition, Microsoft Access 2007/2010 Beta.Ok this is my current code-the main problem I have is that I dont how to compare what the user puts into the textboxes and then check that against the data in my database. [code]When I run/debug the program and enter the correct username and password into the program it comes up with the MsgBox("Incorrect Login Details - Please try again.").The connection string for where the database is coming from is right, because I checked it..so must be something wrong with the SQL Coding I guess.
View 19 Repliesthis is my code for adding users in my database but it has an error on the INSERT INTO statement.here is the error: Microsoft office access database engine: syntax error in INSERT INTO statement.
vb.net
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
Dim conn As New OleDbConnection(cn)
Dim check As Integer
[code]....
What I'm looking to do is 'hook' a physical drive connected to the system so I can process data coming through the API before it's written to the disk. I have a sense DeviceIOControl is where I should be, but I can't seem to find any IOCTL code that uses a callback (which is what I expect I should be using to scan/process data on its way through the API).
View 2 RepliesI build a database system from access and made the GUI using vb.and i encounter this problem?
View 3 RepliesI'm having a hard time in understanding xampp. I will need to change my database from ms access to xampp. I already test it in a sample program and it works! Now I want to convert my whole system so my first step is to delete the database in my system (ms access) then create a code that will connect my system to xampp, I'm done with those things. The BIG problems are I'm having 98 ERRORS and I cant figure it out. I dont know the equivalent code to xampp. Here's the code that has error. Note that it is just one of 98 errors in my system.
Me.TableAdapterManager1.UpdateOrder = FinalSystem.FinalDatabaseDataSetTableAdapters.TableAdapterManager.UpdateOrderOption.InsertUpdateDelete
xampp doesnt have any tableadapater, but what should I do to insertupdatedelete?
I am trying to create a login system using 2 tables from MS Access to grant access for opening another form.
View 8 RepliesI work with VB.NET (Windows Forms) and database in AS400 iSeries. I wont to make an Update in one table. I have this code:
[Code]...
I have tried mulitple OS ( XP, Win7, Server 2008) using my administrative account as well as implementing in a WCF windows client service with local system rights. I have beeunsuccessful at commiting changes to the queue with a win32 access denied error on the commit line
Sub Main()
Console.WriteLine(PrinterDefaults.ToString())
Console.ReadLine()
[code].....
For whatever odd reason, we have a legacy data recorder device that runs at 9600 baud. Except when it needs to transfer its recorded data to a PC, in which case it switches to 57600 baud.
The old VB6 code worked, although it had its own set of problems of course.
The routine is this: Do several COMMAND/RESPONSE routines to populate a list of available records, listed by timestamp, at 9600 baud. Once a timestamp or several are selected, display a file save dialog. At the moment that dialog is closed, send a command to the device to tell it "hey we're going to warp", sleep for 100ms, then set the baud rate property of the persistent COM1 connection to 57600, before beginning to process XMODEM data and do the progress bar dance.
The problem I'm having is that it doesn't appear that the data received is ever really kosher as far as the byte marshaling is concerned. Which makes me wonder just how well SerialPort is at dynamically changing bauds on the fly. The VB6 version used MSComm.
I've even attempted to just use MSComm through the compatibility layer but "CTL_E is not supported" which makes it sound like it's incapable of doing XMODEM. (?)
I'm doing a search option in my system where if your searching for a entry even if you didnt typed the whole word, all of the entry that contains the letters that you have typed will appear, well i really cant explain it but it goes like this if i have entries:
reserve,reservoir,restaurant,jaded,mend,feed in my database and the searcher typed "res" all the word containing res will appear. i know it has something to do with the like parameter but i just cant do the code right.
I made a program for backup sql database. When I back up there's an error show like this
Cannot open backup device 'C:\aw.bak'. Operating system error 5 (Access is denied.).
Backup Database is terminating abnormally.
What it's means Operation system error 5?
This is my code
Public Class Form1
Dim cmd As SqlCommand
Dim conn As SqlConnection
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code] .....
I think its better if i attach my files for you understand what i wanted to happen in my program.
We are now in our finals and for our project we need to make a program that shows connection of database(sql or access) and vb.net so dont mind if it has a problem in design or anything bcoz the objective of this project is to show what we've learn in our subject IT Programming 1 (vb.net)
I dont know what to do in this part of my program. what to do first? why is it attaching zip files is not allowed?
I was just wondering if you could view the items on a connected Zune device (such as the Zune HD or any of the others. (4GB, etc.))Also, possibly listen to the songs / watch the videos on it with the Windows Media Player codec in the program, and view the pictures in a PictureBox? Is this possible at all? Can I at least view the items? Or is this strictly forbidden?
View 3 RepliesCan anyone provide the resource to learn making connection between computers over the LAN and retrieve files? EDIT: And can I browse the folders like its done in the local machine?
View 3 RepliesI'm trying to run a simple database and im getting a "System.NullReferenceException" error ) & "Additional Information:Object reference not set to an instance of a object" .
txtItemName.Text = rowCurrent.Item("ItemName") <-- highlighted in yellow
Code is as follows:
vb.net
Imports System.Data.OleDB
----------------------------------------------------
Public Class Form1
[code]....
I am using vb to make a hospital system which works with a access database. i am having an issue with the updating function to the database, this time round instead of hard codding the connection i used the connection/data source wizard, in microsoft visual studio 2008 and there fore most of the code has been auto generated for me, which includes the insert, delete and update funtions from what i can find and what i have read vb is ment to also auto generate this which it is not. the funny thing is that i can close the program down and reload it (as long as i haven't opened the database) and my changes are still there but if i go and open the database and it hasn't changed. also i can change the database through the use of the Dataset connections in the datasource tab but not int he program the code ive found and believe that is meant to update the database
This is running off a couple of buttons i also have a update query but have know way of accessing it
Me.Validate()
Me.TblPatientDetailsBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.PatientInfoDataSet)
I 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 Replies