:confused: I am doing a project and i need to be able to add, record, search and delete customer bookings. I am using VB.Net 2003 and microsoft access 2003 and i need help on how to do this. Can anybody help me?? PLEASE?!?!
Basically i need the information that is entered in VB.Net to be stored in an access database e.g. name, tel no, date, time, table no, etc and search for the customer as well. i hope that makes sense.:confused:
show the effort and many people will help you :)
hi. sorry. erm iv got this so far (if it makes any sens) but i think it is totally wrong and i really duno where to go from here. iv tried a million books and got no help from them!!
Dim dbE As New DAO.DBEngine
Dim db As DAO.Database
Dim rs As DAO.Recordset
db = dbE.OpenDatabase(Trim(TextBox1.Text))
rs = db.OpenRecordset("UPDATE Bookings (Name, TelNo, Date, Time, How many people?, Deposit paid?, TableNo) VALUE ("")" + Trim(Txtname.Text) + "'")
Try
If (rs.Fields("Name").Value) = Trim(Txtname.Text) Then
Dim Name, TelNo, Date1, Time, Howmanypeople, Depositpaid, TableNo As String
Name = rs.Fields("Name").Value
TelNo = rs.Fields("TelNo").Value
Date1 = rs.Fields("Date").Value
Time = rs.Fields("Time").Value
Howmanypeople = rs.Fields("How many people?").Value
Depositpaid = rs.Fields("Deposit paid?").Value
TableNo = rs.Fields("TableNo").Value
End If
End Try
Someone asked a similar question recently and I did this short video clip on how to do it with the free version of VB.Net
Someone asked a similar question recently and I did this short video clip on how to do it with the free version of VB.Net
Thanks for that but I am doing my project in 2003. I watched it and tried but I am still lost! I forgot to mention that I am new to this as well!
Hi
I had the same problem as you a few months ago. Try the webiste www.homeandlearn.co.uk
this goes through what yo need to do step by step
Hi
I had the same problem as you a few months ago. Try the webiste www.homeandlearn.co.uk
this goes through what yo need to do step by step
Thanks. I'll take a look.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.