Search results for query: *

I m really embarrassed. Everything seems to be working now. I think you should close this thread.

Me.SearchResult.Text = "TESTING" I did that as a test and nothing showed in the textbox. I have another issue. I have been trying to use substring. the following snippet shows what I'm trying to do. I'm experimenting because I have to retrieve data by query for telephone number from the caller...

I'm trying to get the result of the reader into a textbox on the form. It is named SEARCHRESULT. The strings that I'm trying to add actually contain data. Here is the code snippet: Dim strArr() As String Me.SearchResult.Text = "TESTING" Me.SearchResult.Text =...

OMG sometimes this old brain misfires. Thanks. Somehow I must have removed the following: cmd.CommandType = CommandType.StoredProcedure. No wonder it stopped working.

The code worked then all of a sudden I get an exception when the command.ExecuteReader(). I made the changes suggested in the post and it still does not work. The exception is: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. There have been no changes to...

the path is set to 'c:\users\default\desktop\' I've tried to use xlbook.saveas(gstrExcel_Path & "callerid.xlsx") and xlbook.saveas("c:\users\default\desktop\callerid.xlsx") they both generate the same error. is there a setting in the IDE that determines the path for saved files which cannot be...

I have created a brand new excel book. I've added a sheet and named it. now I want to save the file, but I can't seem to get it to work. ' xlBook.SaveAs(gstrExcel_Path & "CallerID.xlsx") This is the error I get. what I don't understand is the number D94B8010 that is at the end of the path it's...

I got it to work with the help of the help of the internet. Here is the code: Private Sub Button_Search_Click(sender As Object, e As EventArgs) Handles Button_Search.Click Dim i As Integer Dim iFields As Integer Dim strName As String = "" Dim blCheck As...

I am new to VB.NET and some of my questions are probably kind of dumb. I wrote the app originally in VB 6 and had very little trouble getting it to work. I am running a select query with 1 parameter which returns data from an access database. I know from running the query in access that it...

Thanks that solved the issue.

there is a bit before the snippet cmd.CommandText = "qselphone" cmd.Parameters.AddWithValue("parPhone", "6475311136") cmd.CommandType = CommandType.StoredProcedure

the code snippet gives me 2 problems: Dim cReader As OleDbDataReader cReader = cmd.ExecuteReader() End Try stext = "" Do While cReader.Read() stext = stext & ";" & cReader.GetString(0) Loop in the do while loop creader is...

Thanks for your help. I have it working. I will also do a better job of including code in future.

One interesting point. When the connection.Open() is executed there is an ldb file created and it is gone when the app is done. So obviously there is some kind of connection but nothing happens when you execute a query or stored procedure.

I have a small bit of test code: Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load End Sub Dim connectionstring As String = "Provider=Microsoft.jet.oledb.4.0;data source=C:\PPCIS745DemoData\CallerID.mdb" Dim con As OleDbConnection =...

The question then is: how do I change the setting for the database so that it does not appear in other projects?

I posted an earlier question about queries etc. This issue appears to be resolved by using the connect to database in the tools menu. after going through that process I have a strange situation. Azure, data connections, and servers are now permanent entries in the IDE even when starting a new...

thanks for your help I guess I have to type the queries in my VB.Net program and execute them. When I open the file in access everything works beautifully. The mdb is set up with ODBC and has 3 tables linked to a MySQL database. I don't manipulate any of those tables. There is a 4th table that...

I selected views but only the tables show up. The queries don't show at all. and under the tools for dataset everything is dimmed.

I may not be in the right place. I added an mdb file using the add new datasource. this isn't terribly complicated. there are only 3 linked tables and some SQL queries. In the IDE when I display the dataset I can see all the tables but I cannot see any of the queries. Do they get imported when...