Search results for query: *

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...

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...

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...

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...

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

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...

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.

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.

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...

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...

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...

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...

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...

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...

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...

This is the error that i have encountered right now. it say "Index was out of range. must be non negative and less thatn the size of the collection. parameter name: Index.

Hi Jim, Below is the code for insert records to ms access and also my dataGridview codes. thanks. Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click Dim conn As New System.Data.OleDb.OleDbConnection()...

Hi Jim, Just run the code and i got an error message. "Object reference not set to an instance of an object" Then I added this code adp = New OleDbDataAdapter adp.InsertCommand = New OleDbCommand(strSql, con) adp.InsertCommand.ExecuteNonQuery() and here is the...

Hi John, Thank you very much John. I found your blog and this is a good read for me as beginner. By the way, can you please take a look my final code and also i found a data access code created in a class from other forum and i used it. May i ask favor if you can check the code. I have an error...

Thank you very much.