Does anyone know of any reason why my FilmID field (which is an autonumber) is going backwards? When I add a new record, it is going -1, -2, -3, -4, instead of carrying on from the last number. If you need the code, just ask, but I was thinking it might be something in properties or something?
View 3 RepliesI would like to retrieve the ID number for that row that was just inserted into the database. after saving it I want to get the value of its ID and pass it to another table.
View 3 RepliesI am trying to insert into a access db and the PK is an autonumber that is generated by the DB. I am getting a syntax error for the insert statement and dont know why. If possible I would like to return the autonumber value in the same statement.
[Code]...
I'm wanting to alter a column in an acces database, to a Random AutoNumber I know how to do it for incremental e.g."ALTER TABLE MyField Counter(1,1)"but how do you do it for a Random Autonumber??
View 10 RepliesI am using VS2010/VB.NET/MS Access 2007 I had added a database from ms access to the vb.net application (strongly typed)that table contains an autonumber field.I made a button to add new row and another one to save the row the problem is that I want to get the last autonumber from the database so that I can save the row.
View 1 RepliesI don't believe this is possible by conventional methods, but something like this verbose code: For Each s As String In myStringList Step -1 //' Do stuff here Next I will probably have to invert the myString object before a conventional For..Each Loop, correct?
View 9 RepliesI have a simple application that I have to migrate backwards from ASP VB.NET 4.0 to 3.5 because of client limitations.
View 2 RepliesIs it possible to make a For loop which count down. Like:
For i as Interger = 5 to 0
'Do stuff
Next
I want to read a file starting from the last record and proceeding to the first record. How can I do it [if it can be done]?
View 11 RepliesWas just wondering, is VS .NET 2008 compatible with SQL Server 2000?
View 2 RepliesI'm working on a webcrawler in VB.net, and using the System.Forms.WebBrowser object for handling navigation on sites that use javascript or form posts, but I'm having a problem. When I navigate backwards (WebBrowser.GoBack()) to a page that was loaded with a form post, the page has expired and I have to do a refresh to resend the request. When I call a refresh (WebBrowser.Refresh()), a dialog box pops up to confirm. Is there a way I can get around this modal dialog in code?
View 3 RepliesI have.. Textbox1.Text = Textbox2.Text
I want it so that when you type text in Textbox 1, textbox 2 says it backwards.
Is there a command for this, if so how do I use it?
I have made an application with VS2010, meaning it requires .NET framework 4 to run properly.If the program is ran on a machine with .NET framework 3.5, it returns an error stating I should install 4.
View 7 RepliesMy WebBrowser1 keeps going backwards like 8 pages and then coming forward, I don't get it.
[Code]...
I could crop up a string to give me a cirten value.
The specified string involves a username, and a price, along with other numbers as a result of math.
"Would you like to buy "Relic TV System" from Demi0092 for $1,009?"
So in this situation I want to gather the "1,009" without any of the other text.
I have two textbox controls and I want to accept input for textbox 1 and textbox 2. However, when user enters text into textbox 1 I would like textbox 2 to mirror the same text as it is typed. I am sure this is a very simple procedure however it is new to me and I am having trouble finding an answer with search engines. Most result are coming back as text that one can read backwards in a mirror which is not what I am looking for.
View 1 RepliesSo work uses an Excel sheet with controls in it they designed a while back. however when they load it, all the normal text looks fine but the comboboxes and listboxes have backwards and upside down text. When i open the list options the text looks fine, but as soon as i select something it goes back to upside down and backwards. Anyone seen this before?
View 3 RepliesI have one table in MS Access 2007 called "Case" and this database is link to my project in VB2010. The first field in the table is called "Auto" i made this one as autonumber. What i'm trying to do now is to create the "Case ID" with the combination between current date and current autonumber in "Auto" field. eg: 191010-12.
I am using this code to add a duplicate of a record. What I need to know is what the AutoNumber is of the new row that I just created. Is there a way to get the AutoNumber of a newly created row? I am using Access 2003 as a backend. Dim da2 As New OleDbDataAdapter("SELECT TaskNumber, JobPlanNumber, TaskDescription FROM tblTasks WHERE JobPlanNumber = ?", cn)
[Code]...
I am writing a program to be able to input a password and take that password and display a new password in a label. the new password will display the results as follows. Any vowels in the old password will be displayed as an x in the new password and numbers will be displayed as x's, and the last part it will display in reverse order so if I enter in timmy1 it should display zxmmxt. I do not know how to write the code to be able to reverse the string to be able to display the password backwards.
Option Explicit On
Option Strict On
Option Infer Off
Public Class frmMain
[code]....
I am trying to do a user defined autonumber when I click on a button. The code worked fine when the recordset is empty, it give me a 1 on my first record, however, after I click on the button again, it give me 1 again. Here's my code.
Private Sub BtnNew_Click()
Dim rsClone As Recordset
Dim pVal As Integer[code]......
how to create an autonumber field using DAO.
[Code]...
I have a table hasn't primary key in oracle 10g and I need to add autonumber to table and use this autonumber in vb.net 2005 to control in update ,delete command in vb.net
View 4 RepliesI have a following controls in my vb.net form:
CODE:
This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated in for digit i.e. 0000, 0001,0002, .... and so on.
When the form is opened next time and when the user adds the new record, the ID should generate next value coz the ID will not be duplicated.
I have a following controls in my form:
txtID
txtName
[code].....
I need to add a record to a database and would like to get the value of the next autonumber value in the key field before the add.
View 9 RepliesI have this code that works for adding a record.
Dim da As New OleDbDataAdapter("SELECT TrainingTitle, TrainingDate, TrainingInstructor, TrainingDescription FROM tblTrainingHistory", TRAININGcn)
Dim ds As New DataSet
da.FillSchema(ds, SchemaType.Source, "tblTrainingHistory")
da.Fill(ds, "tblTrainingHistory")
[Code]...
But I wanted to show the autonumber to the user for reference. How do I know what the autonumber is?
i'm using VB 2008 and MS Access as my database for my assignment. I want to know how to get the value of the last Primary Key ID which is an Auto Number after I insert a record.
Private Sub saveBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles saveBtn.Click
Dim save As DialogResult = MessageBox.Show("Do you want to save the Anime?", "", MessageBoxButtons.YesNo)
If save = DialogResult.Yes Then Try Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App_Path() & "Anime Database.mdb;"Dim myConnection As OleDbConnection = New OleDbConnection
myConnection.ConnectionString = connString myConnection.Open()
[Code]...
How can I increment a field without using Autonumber,
like reading from its last value and then increment it?
I'm new to vb.NET and really need a detailed explanation.
s = "update Color set Color='" & ListView1.Items(y).SubItems(5).Text & "' where ID='" & CInt(ListView1.Items(y).SubItems(1).Text) & "' "
View 1 Replies