Communicating With Access Database?
Feb 15, 2011
Im new to using databases in my programming and to be honeest i am struggling.i need to get the program to communicate with my database to allow the user to login this is the code i have so far as i say i dont know much about it so its a bit bodged.
[Code]...
View 4 Replies
ADVERTISEMENT
Jul 24, 2009
I have built a matrix style controlboard ( many pictureboxes used as buttons) To call on a simple database. Being a beginner, I have not yet found any code for doing a query of sunh simple nature as this database. The Northwind samples are far more complex than what i have, but this is my main program, the reason I got into VB in the first place. 2 pictureboxes say PB1 & PB2. PB @ ontop of PB1. PB2 is invisible, but blocks view of PB1. Clickon 2, & it Hides(). Click on 1, & 2 Shows(). a simple math control box counts the events & turns the group inputs into binary output... 4textboxes per group is the way I chose Ther are roughly 200 pairs of these sporadically placed, this is just 1 pair. Textbox 16, & 18=0 @ form load 17 fixed ="1" 15 sets of these, TextBox42= binary value. This is the one that triggers the events for column "C" in the database. ( Their not in perfect order)
Anyway, this is where I need to get information tfrom the database to the listbox, heres that situation: Database has simply named columns A,B,C,D,E,F, G, H, ect.. Then the rows are equally simplistic row, rowB, rowC,..Any combination is represented here, Each row has several, but not all of the columns values. Since if only 2, or 3 of the variables clicked can = several different groups, a multiple reurn to the listbox is nessessary. I seen some code in an exercise that I think will do that, but how do I query the database to start the listbox load? The lesson shows a completely different situation for loading the listbox, but I think I can amend that easily enough. I just can't ask the simple question to the database.
Question is, if picturebox related to column "C" is clicked, how do I call the group names ( rows ) of those positive in Column "C" to the listbox? The Database is litterally that simple. Just 1 situation of columns & rows, not mutiple as in the lessons. If anything, I fear I'm too much a simpleton. I have added the PB's code
View 2 Replies
Jun 4, 2011
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Replies
Oct 15, 2011
I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Replies
Mar 30, 2009
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
View 1 Replies
Jun 22, 2010
I am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 Replies
Jan 3, 2011
I want to code an app with recreational purposes. This should be a Desktop app that detects itself running on other computers on the same LAN and communicates with them. By communication I mean that I should be able to pass anything from on to another. note that although I'm not asking for code (that would beat my purpose, of course) I think some small snippets wouldn't hurt. In any case what I really want is the "recommended procedure", I mean what Microsoft recommends for this environment, and documentation :)
View 3 Replies
Feb 3, 2009
is there a way through vb visual express 08 to ask a printer if it has toner or paper? im not to sure on how to communicate with printers in this way if it is at all possible.i am writing a program to display the status of the printer and this is key.
View 1 Replies
Mar 8, 2012
I've set up this function in my web app to send push notifications to Android devices:
Private Function SendNotification(ByVal authstring As String) As String
Dim request As WebRequest = WebRequest.Create("https://android.apis.google.com/c2dm/send")
request.Method = "POST"
[code]....
However, whenever I call this function, I get the following error message: The remote certificate is invalid according to the validation procedure."
View 1 Replies
Jul 25, 2009
I have VB.net Simple application with form1.vb , UserControl1.vb and a simple Dataset with few records included. In my UserControl1.vb I'll added a Bound DataGridView1 with Products Datasource. My question is.. How can i filter the Products table from UserControl1.vb? The Filter Value ("ProdID") is from Form1.vb with textbox1(receive the value.). here is my Form1 code
[Code]...
View 4 Replies
Aug 20, 2009
Alright today im going to make a chat program in C++ and VB.net VB.net will be the server and C++ will be the chat room. Im doing this becuase some people dont have .net and the program fails so im trying this so then everyone can use it. How would i do this? Like C++ sending information to VB.net and printing it out on a textbox
View 2 Replies
Aug 8, 2011
I need to communicate between multiple applications (one server and multiple clients) in the LAN. While googling I came across 3 concepts (TCP/IP, Named Pipes and WCF). I also understand WCF needs lot of study for a starter like me. I need to have one (server) application running on one machine, the values generated by it should be displayed immediately on the other (client) application which will be running on multiple machines in a LAN. Also when the user pauses the process from the client application, it should pause the process on the server application.
View 2 Replies
Mar 9, 2009
I have an application which the user can open multiple instances on the same machine. However, a section of the app would have sync problems if more than 1 instance has control over it. This is where I thought of transferring control, or sharing, between them. What should I be looking into?
They would have to be able to identify which one of them has control and to send text information over. I thought IPC or Named Pipes could do the trick, but I'm unfamiliar with them and examples seem to indicate only a single server will work. Here, I have multiple instances of the same app and every one of them needs to be able to listen for that request for control.
View 25 Replies
Feb 19, 2010
I am communicating to a device using a USB to serial port (VCP). I am having a problem with the usb failing. When the usb fails my app will lock up and the com port is lost. I have seen a post about this but cannot find it.
View 3 Replies
Sep 23, 2011
I have a Delphi program that communicates with a vb.net dll that I created. The vb.net dll communicates with a Fluke scope meter via an RS232 connection. I have created a program that communicates correctly via RS232, giving me the anticipated value. Though, when I package this up as a dll and access the dll from my Delphi program I always receive a value of "1", rather than the value I was expecting (most cases a value in and around 240).I know that my delphi program is definitely communicating correctly with the dll and that my dll is definitely communicating with the scope meter
Here is my vb.net code:
Public Interface IFlukeComm
Function GetReading(ByVal Command As String, ByVal PortNum As Integer) As String
[code].....
View 1 Replies
Oct 1, 2009
I've been trying for a long time to do what seems to be the most simplest of things..I have a remote host and I need to know if certain posts on that host are open or closed.Many examples on the net that I have found arent complete, and because I havent worked with VB.net for long I dont knowhow to complete them.Here is my code:: The issue is with this it tell me the target port is always closed, when I know that it is open.Code:Dim host As String = "www.google.com" Dim port As Integer = 80 Dim addr As IPAddress =CType(Dns.GetHostAddresses(host)(0), IPAddress) Try Dim tcpList As New TcpListener(addr, port)tcpList.Start() Catch sx As SocketException MessageBox.Show("port is closed") End TryA friend of mine suggested using WinSock.. I've not dealt with it before so I don't know what he's on about.
View 2 Replies
Jan 10, 2011
I have a project in VB .net 2008 and would like to communicate with a Sharepoint site on our companies SP server. Is it possible to interact with the SP site such as:
Create sub-folder
Upload and download files
Change authority levels on folders
View 5 Replies
Sep 25, 2011
I am basically after some information on what you would believe to be the best way to send strings from a mobile device (possibly a windows mobile phone) to a PC and vise versa. Just so you know the distance could be upto 4 miles and no direct line of sight.
View 6 Replies
Jul 27, 2009
I have created a windows service that monitors power events on the host machine. The next step that i wanted to do was to send custom messages to the service. To do this i have created a windows application and added a service controller control to it (drugged it from the toolbox). Initially i tried to send messages to my machine which worked fine (both the service controller and the service were running on the same machine)
Dim scSL As New System.ServiceProcess.ServiceController("MyFirstService", ".")
scSL.ExecuteCommand(128)
but when i tried to send a message to a remote machine on the network
Dim scSL As New System.ServiceProcess.ServiceController("MyFirstService", "machine001")
scSL.ExecuteCommand(128) i got the following error:
"System.InvalidOperationException: Cannot open Service Control Manager on computer 'machine001'. This operation might require other priviledges. ---> System.ComponentModel.Win32Exception: Access is denied.
Anyone knows what priviledges i need to set on the machine that has the service controller? Alternatively can anyone recommend a solution to this issue?
View 6 Replies
Aug 10, 2011
I am building a client-server type applications and they are communicating over sockets. This is the first time I am doing such a program and I have been learning off a web example and thought I understood it all but it would appear I am missing something as it starts to work then errors. Here is what I have:
VB
Dim serverSocket As New TcpListener(ListeningPort)
Dim clientSocket As TcpClient
Dim netStream As NetworkStream
Dim BytesFrom(1024) As Byte
Dim DataFromClient As String
[Code] .....
All of the above works and if I open up a telnet command window I can connect to my machine running this code on my specified port and in the command prompt window 'IDENTIFY' appears as it should from the above code. But it then gets to this block an errors on the second line:
VB
'RECEIVE FROM CLIENT
netStream = clientSocket.GetStream()
netStream.Read(BytesFrom, 0, CInt(clientSocket.ReceiveBufferSize))
DataFromClient = System.Text.Encoding.ASCII.GetString(BytesFrom)
Now as far as I can tell it shouldn't be processing the first line
[ netStream = clientSocket.GetStream() ]
Until I send something back from the client because then going on to the second line its trying to process something that isn't there yet.
The actual error I get is:
Specified argument was out of the range of valid values. Parameter name: size
On the line:
netStream.Read(BytesFrom, 0, CInt(clientSocket.ReceiveBufferSize))
View 8 Replies
Dec 2, 2009
I have a need to be able to communicate with a VB6 application (I have the source code) whilst it is running. I just need to get it to display some predefined forms. Any tips on how I could achieve it. I was thinking along the lines of using Sockets.
View 1 Replies
Apr 19, 2010
I need to interface between a PC and a Microcontroller based Controller to transfer data between the PC and the Controller?
Ive got acces to the register numbers or names in the Microcontroller.
View 2 Replies
Dec 3, 2011
I am attempting to communicate with set of scales with a vb application that i have written using the comm control. The scales are a Kelba KHX-30 I can read the data from the scales but i have to manually press a button on the scale.
View 4 Replies
Jul 13, 2009
We have a web app in a web browser running on an intranet so security is less of an issue. We have a separate win form app. Is there any way the Win Form app could call javascript in the web browser. The browser can't be embedded in the WinForm.
View 12 Replies
Jan 6, 2011
I'm going to create an application that will act as some sort of task manager. For stability reasons I will not use threads but processes instead. I have to deal with several third party libraries and/of COM servers that are not always that stable and can produce severe crashes sometimes. This may (of course) not affect the task manager
Problem with using processes is how to communicate with them? The process must f.e. give a status back of what it's doing every x seconds.
I was thinking of using TCP over a separate port per process, but is this the best way of doing this?
View 5 Replies
Mar 14, 2011
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
View 5 Replies
Apr 22, 2010
I am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
View 2 Replies
Feb 16, 2012
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
View 9 Replies
Mar 16, 2011
(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:
View 18 Replies
Oct 13, 2010
I have a similar problem posted in the forum similar to this : started learning VB. I am not able to get my example code to work to access an Access database through automation. The author of my book suggested that I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/14/2009, Prod Ver 4.00.9756.0.
View 3 Replies