Hi, I've re-framed my question. Could anyone solve this for me.
I'm using VB 2010 and Access Database file. The database consists of a table called 'usertbl' with 'username', 'type' and 'level' fields. The records are like follows:
Record 1 - Username: admin Type: admin Level:1
Record 2 - Username: user1 Type: user Level:2
Record 1 - Username: user2 Type: user Level:1
User's Combobox (cboUser) which...
dheerloveguru
Last Activity: May 27 '13, 07:46 PM
Joined: Jan 15 '12
Location:
-
How to populate combobox in VB.net
-
How to populate a second combobox when selecting item from the first combobox
Hi, Could anyone help me out!!!
I'm using VB 2010 and Access Database file. My problem is I'm unable to populate the second combobox when selection of item is made from the first combobox.
Here is my code:
...Code:Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim con As New OleDbConnection Dim dbProvider, dbSource As String Dim ds1, ds2, ds3 -
I've done as u said, when I ran it from my computer it works but after building the project. I launched the Vb Application on another computer found on the network, the connection string failed to response. my connection string is like that:
Dim connetionString As String
Dim cnn As SqlConnection
connetionString = "Data Source=.\SQLEXP RESS;AttachDbFi lename=C:\DBMS_ DataSource\DBMS _Database.mdf;I ntegrated Security=True;C onnect... -
How to use a hosted SQl Database on a LAN Network????Leave a comment:
-
Thanks bro for replying but how the can each user connected to that project and update the database. I've copied the database to the folder and share the project folder on the LAN... the forms are load but not the data from the database. One main thng I've installed sql server only on my pc and not on others....Leave a comment:
-
How to use a sql server database on LAN network using VB 2008
Hi, could anyone help me....
I've already installed VB and sql server express 2008. I've created a database in the sql server and connected the database to VB project which works fine. My problem is... how to use this VB project on a LAN network. If I complete the project using the database which is on my hard drive, how Could I build this project and put it on the network, so as other users using the project to update the database.... -
How to use a sql server database on LAN network using VB 2008
Hi, could anyone help me....
I've already installed VB and sql server express 2008. I've created a database in the sql server and connected the database to VB project which works fine. My problem is... how to use this VB project on a LAN network. If I complete the project using the database which is on my hard drive, how Could I build this project and put it on the network, so as other users using the project to update the database.... -
How to display on a form unbounded text box
I've to query on two fields: (1) Date field and (2) Time field. My query sounds like that between 5/12/12 07:00 to 5/13/12 07:00. I've made a sql query; firstly I've joined the date and time fields to a new field, then uses the where clause such as: Between #5/12/12 07:00# and #5/13/12 07:00# which works perfectly.
My problem is that how to change the date and time on the sql query to a form unbounded text box that is Between Forms!Form1!txt StartDate... -
Reply to NeoPa...
Actually the form look like that:
link... http://www.mediafire.com/i/?ub1rbe9lt2482m8
Please let me know... if it's possible or have to find another way...Leave a comment:
-
Thanks for replying.... I just wanted to no if it's possible if I select "Total Vehicles" from the combo box as a new record, there is way that it will add the value for Car/Van or Lorry to Total Vehicles.... If there is any code that I could write in the Item control source property in a form and if it could be like that:
IF items = "Total Vehicles" Then
(lookup the items = 'Cars', "Vans', 'Lorries'...Leave a comment:
-
How to calculate a field value
I'm working on a project named Export and I'm stuck..... I just want to calculate the Total Vehicle which for the time being I'm doing it manually.... My project looks like that:
Table - Export
Fields
ID
Date
Shift (First/Second/Third Shift Duty)
Items
USA
UK
France
Italy
TOTAL
The data entries are being done in a subform...
No activity results to display
Leave a comment: