i'm having trouble with the relationships in VS when relating from long to Autonumber.I got an answer that fields should be declared integer, but ACCESS explicity states that fields realting to autonumber must be delared long.
View 3 RepliesWhen i try to stablish a relationship in dataset designer of these two types i get a "no matching field type" error I'm working with an accdb database
View 2 RepliesWith this code...
vb
...Dim random As Long = RandomNumber(1000000000000000, 9999999999999999)... Private Function RandomNumber(ByVal Min As Long, ByVal Max As Long) As Long Dim Random As New Random() Return Random.Next(Min, Max)End Function
...I am getting a OverflowException. Is it so that Random class can't handle Long values?
I would like to ask for some on how to create a random string with number and letters in 8 characters long in VB 2008
View 1 RepliesI am making a project in which if SID 001 is saved .after this SID textbox should display 002 automatically .I am using an Access Database. My code is as shown below:
Private Sub Sales_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
[code]....
Is there a easer way of coding in stead of wrighting long long paragraphs like this in one line [code]All of this is on one line and i got lots of info to put down.."The game will begin on your 16th birthday with your mother waking you up. Today you are to go to the castle for the first time. Leave your bed and open your dresser for a Strength Seed. "
View 2 RepliesI created a access table with three fields, CustomerID, FirstName, LastNameI set the CustomerID field to the primary key and the type of AutonumberIn my VB app I dragged the three fields over to my form.I clicked on the plus sign at the top and it displayed -1 in the customer field, I entered a First Name and a Last Name and press the save button. I repeated the process 2 more times and the CustomerID field went from -2 to -3.I looked at my table in acces and all three records showed 1, 2 & 3 as it should. When I exited the form and then open the form again it shows record numbers 1, 2 & 3 as it should.How come it takes exiting the form and then back in to see the correct CustomerID's ?
View 4 RepliesI'm trying to generate random dates in between two dates that are selected with a date and time selection control.Ideally, I would like to get the 'ticks' of each date, generate a random number between those, and then convert that back into a date.However I'm getting arithmetic overflow errors when I try to generate a random number from the between the ticks. I've tried many approaches - directly seeding with both the low and high date ticks, as well as subtracting.
Private Function randomDate() As ULong
Dim rand As New Random(Date.Now.Ticks Mod Integer.MaxValue)
Dim holder As ULong = DateTimePicker2.Value.Ticks - DateTimePicker1.Value.Ticks
[code].....
i am reviewing variabes, and just wondering any variables that can be used in math to hold a value this big =)
[Code]...
My homework assignment is to create a project where a user enters a password that must be at least 3 characters long with at least 1 number and 1 alphabet character. After that the password has to be encrypted so that vowels become X, numbers Z, and it reverses. For example, a password of CS2301 would be ZZZZSC. There's supposed to be Loops to extract 1 number/letter at a time and search for them in the string to validate, and I don't know what to do. The form itself has a Text Box to enter a password and a label to display the new one, and a Go button.
This is what my code looks like so far.
Option Strict On
Option Explicit On
Public Class Form1
[CODE]...
I am building a library database for a local charity using Visual Basic 2010 and I need to get the lending structure working properly, to that end I have created a dummy project to test my code.
This what I have done so far
I have started a WindowsFormApplication and to that I have added a ServiceBasedDatabase.
NB. For speed I have abbreviated the fields... A=Author, U=User, LN=LastName, FN=FirstName
In Database1.mdf, I have added 3 Tables with the following columns, and also added some dummy records to test it.
Code:
Table 1
T1ID int Nulls disallowed Primary Key Identity Specification On
ALN varchar(50) Nulls allowed
AFN varchar(50) Nulls allowed
[Code].....
How do I add a second table search so I can browse both Table 1 & 2 simultaneously?
I've seen a lot of posts over time relating to importing and exporting CSV. Most of the answers involve using TextReader.readline and String.split, which will not work with any but the simplest data. When you are writing for users who have the expectation that your application will work with anything they export from Excel, you will have to cover all the CSV bases.
I hope that this post will give you a clear idea of what you're involving yourself in when you decide you need to read a CSV file. The characteristics of CSV data are:The comma character is used to separate the fields. (This is obvious, but I thought I'd start with a couple of obvious points to warm up) The last field on the line is ended by the end-of-line character or the physical end of the file.Any field that contains commas, double-quotes or control characters will be surrounded by double-quote marks. Any double-quote marks within the field will be "escaped" with an extra double-quote character. For instance, the value Paul "Chuck" Norris would be converted to "Paul ""Chuck"" Norris".After the opening double-quote ANY character is valid. Including line breaks. This is why you can't use readline.I have a parser class that works nicely and I'll post that on this thread in a little while, along with some notes on using it.
where I can get access to information relating to 'Application Configuration' for the .Net Framework?
View 4 RepliesI'm looking to add reference object libraries relating to excel and none are available to select from my directory. I have Microsoft Office Excel 2010 Express installed. Where can I retrieve this object library (and others?). Looking to import and export data to/from excel.
View 7 Repliesi'm importing a text file into a access table like this:
vb.net
sql.CommandText = "SELECT * INTO [tblMailList] FROM [Text;DATABASE=" & frmMain.FolderName & ";HDR=NO].[" & frmMain.TextBoxFileName.Text & "]"
sql.ExecuteNonQuery()
my question is what is the best way to add an autonumber to the table? i currently do it like this:
vb.net
sql.CommandText = "ALTER TABLE [tblMailList] ADD COLUMN [ID] AUTOINCREMENT;"
sql.ExecuteNonQuery()
but when the file is too large i get this error: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry."
and yes, i have tried to change the registry entry and it didn't work:
vb.net
My.Computer.Registry.SetValue("HKEY_LOCAL_MACHINESOFTWAREMicrosoftJet4.0EnginesJet 4.0", "MaxLocksPerFile", "9000000")
How can i auto generate number in vb.net
View 4 RepliesI had the following code :
Dim row As Integer = 0
For row = 0 To pdgvDataGridView.RowCount - 1
pdgvDataGridView.Rows(row).Cells(0).Value = row + 1
Next
it's to add auto number into first column of each row. The codes running well, but after the codes completed, the first column of each row remain empty.
I am working on a VB.net (VS-2010, Win XP Pro 2 SP3), Employee Management Project. I need to keep track of Employee Leave Attendance and also each Equipment assigned to an Employee. How can I achieve this using SQLlite.
It will be very useful if you could provide me with examples as I am completely new to the field of SQL and VB.net I think this can be done with two tables where one has the primary key while the other has a foreign key, but I am not sure. Also how many tables will I need for storing data in Leave and Equipment Form.
I'm using a Data navigator to navigate (duh) through some records that my BLL fetches from the DAL. I use DataTables to fetch the recrods. Some of such records have one to many relationships. Lets say for example a person has may telephone numbers and my navigator goes through all the persons whose name are Joe. So I manage to show all the Joes through my navigator in the controls but I want to be able to show all their telephone numbers also. Persons is one Table, TelephoneNumbers is another. Each Telephone number has the person it belongs to. I access them through a DataSet and my BLL controllers return DataTables in their search methods, as said.
View 8 RepliesI have 4 Columns in a ListView. The first one is called Serial No. Every time I populate it, the serial number increases automatically. After populating the ListView couple of times, I select any row(s) and remove it. When I remove one or more row(s) from the listview, serial numbers stays same. I want the serial numbers to be fixed automatically when I remove any number of row(s). How can I do that ??? Here is my code -
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Str(4) As String
Dim newItm As ListViewItem[code]....
Probably a simple question for most of you. I'm putting members of a group into a SQL Database so we can better manage attendance and 'points' that they earn for doing work. I've written the program in VB and have the SQL server running fine. However, I have created a separate table to handle the points and have marked the relationship between the table - the column is named 'PointID', and should be unique for each person. When I add a new user to the database, I want it to automatically assign a value to that without me having to do anything extra beyond pressing save. From this PointID, it should identify the user and it will bring up the person's points.
View 12 RepliesHow to display the auto generate next number from sql server 2005 to vb.net 2005 textbox. This code below is not displaying any data in the textbox after retrieving the data from the database.
Code:
Imports System.Data.SqlClient
Public Class NewConnection
[code].....
I want to create auto increment number in vb.net like : -
01, 02, 03, 04 etc.. so it is in order.
I am using VB NET 2008 EXPRESS connection OleDb to MS access
I want to do the auto increment for my textbox MemberID
I have tried multiple ways and had no luck such as : -
If txtMemberID.Text = "" Then
txtMemberID.Text = 1
Else
[Code]....
I want to write the code not use the autonumber in Access as my lecturer does not want me to do it this way
I am building an application in VB that will use a JetDB backend (Access 2007 db). I am trying to figure out how to capture the autonumber PK from the database when I add a new row to the table so that I can then load that value into a variable. I am currently using the IDE tools for my database queries (dataset designer), so if this is not something that can be done through that, I would need to know how to code my database query.
Here is what I have:
Table (mainTable):
ID (autonumber PK)
[code].....
I have created a field which automatically in sql server.I want a code in vb.net so that user the text on the get focus, the automber would display the current no on the form.This autonumber is primary key in table1(tran_head) and as foreign key in table2(trans_Detail).I want another so that when the data is saved, it would automatially update the second table with current automber displayed.
View 10 RepliesI have a windows form having combobox and textbox controls.. I have to generate a part number, consisting of combobox and textbox values included.. I can explain in detail.. This is the code i have used to define a variable "type"..
[Code]...
I had the following code :
Dim row As Integer = 0 For row = 0 To pdgvDataGridView.RowCount - 1 pdgvDataGridView.Rows(row).Cells(0).Value = row + 1Next
it's to add auto number into first column of each row. The codes running well, but after the codes completed, the first column of each row remain empty.
im working with my thesis, to generate auto increment number. for example,when the form load for the first time it will appear transaction 1, and then next time i'll load the form it will be transaction 2, so on and so forth. i am using a VB.net and SQL server.
View 1 RepliesI am trying to generate autonumber the sequence is like this. From left to right, last two digit from Year, Month in numeric and the last three digit number be from 001 to 999. I tried with the below coding but the sequence is not coming correctly.
<code>
Imports System.IO
Imports System.Data.OleDb
[Code].....
i want to auto account generate account no in their name format for eg if the account name is ABC Travels account no will be A0005 if account name is XYZ Travels account no will be X0003 etc for this i want to know 2 things.first of all how to get 1st alphabet from a textbox for eg. textbox.text is QWERY so how to Q from it.Secondly from database data how to seperate Number from word. for eg if last account no is A0009 Now how to seperate 0009 or how to add +1 in A0009?
View 4 Replies