Recent content by JohnV

  1. J

    sample design Feedback System

    My initial design that comes up in mind: the first part will be the name of customer. the department that belong the customer, date and transaction number. the second part: see below 1. create combobox that contains all list of report that send out to department 2. create a combox box that...
  2. J

    sample design Feedback System

    Hi forumers, I was instructed or give a task to develop a simple application for Key Performance evaluation basically a feedback System. Let say, My department "Analytics" has performed or provides reports and data to different department. The department head as customer will evaluate if how...
  3. J

    Movable connection string

    Hi Jim, I would like to ask when i run my application the database that was access is stored in bin/x86/Debug folder . Why not this path below instead C:\Users\JV\Desktop\FeedBackSystem\FBSystems\FBSystems\Data. Below is the codes I used to connect. Dim conn As New...
  4. J

    Movable connection string

    Hi, I would like my vb.net (MS Access) connection string to be movable and not in permanent place. basically I wanted to not specifying the whole path or address. I will use one work station as my main server and 5 user will access that application. Here is my MS access connection string...
  5. J

    Data Binding to a listbox and label

    hi jim. just fixed the issue by adding this code before the DataGridview setup. Thank you very much. dt.Columns.Clear()
  6. J

    Data Binding to a listbox and label

    Sorry Jim, i copied a code from my sample form not from the orignal form. Its only one listbox. below is the modified code and its working now. the error was not displayed anymore but another error appear. it say a "column Name ItemNumber already belong to this datatable". the cursor point to...
  7. J

    Data Binding to a listbox and label

    actually i'm using this to displayed the ratings and tick or select a desired ratecode with corresponding Ratedescription. what should i do to fixed this error. thank you.
  8. J

    Data Binding to a listbox and label

    I got this error after the data entry and i close the form. When trying to open again the form this error appear. Item collection cannot be modifed when the datasource is set.
  9. J

    Data Binding to a listbox and label

    When I try to use this code. The adpt.fiil(myDatatable) was underline by color green and it said variable "myDatatable" is used before it has been assigned a value and no records displayed in my listbox. Dim myDatatable As DataTable adpt.Fill(myDatatable) for this portion, I use this code...
  10. J

    Data Binding to a listbox and label

    Thank you very much Jim. Here is the working modified code. Dim str As String = KPI.accdb") Dim con As New OleDb.OleDbConnection(str) Dim cmd As String = "SELECT RateCode, RateDescription FROM tblRating" Dim adpt As New OleDbDataAdapter(cmd, con) Dim...
  11. J

    Data Binding to a listbox and label

    Hi, I have a requirements to bind MS Access records and binding to a listbox and Label. I have two column a RateCode and RateDescription. Once i choose a ratecode the description should be displayed. For ex. I choose number 3 from the list the equivalent description "Exceed" will be show in...
  12. J

    Loop to insert records

    Hi Jim, This is the code that display the form. By the way, May I ask your help on how to automate the numbers in datagridview. once i entered an item it will automaticall create a number item. thanks. its okey with you if i will ask question on this thread or i will create a new thread. thank...
  13. J

    Loop to insert records

    ah ok. why i did not encounter an error when i run the code. where should I place this code. thanks. Btw, I just encounter this error. When i try to run or my first transaction (insert multiple records) is successful then i close the form, then i open again the the same form to do transact I get...
  14. J

    Loop to insert records

    Hi Jim, thank you for your usual support. By the way, Still got an error. say Index was out of range... could not fix. I check already the table, spelling still getting the error. However, I modified the code and it was successful. May I ask your opinion on this code. thanks. By the way, i...
  15. J

    Loop to insert records

    Hi Jim, Thank you Jim for your reply. Just removed the codes you mention above and still got an error it says" Object reference not set to an instance of an object". I notice when i debug the code the cursor stop in this portion "With adapter.insertcommand.parameters" the cursor loop and went to...
Top Bottom