Search:

Hello,

I added a feature to copy bulk data from Excel or anywhere and paste it in Datagridview using (Ctrl-V)
I am using this code:


Private Sub datagrid_KeyDown(ByVal sender As...

Great !
I didn't know that I can use RadioButton as a button.
I am trying to do this since 2 weeks using the codes, I cannot believe how simple is your solution. Absolutely, this is the best...

Thanks OptionBase1 for the code, it is working but the background color is not what I am looking for

This is the result for your code:

155155


And This is the background I want:

155157

Thanks Niya for the detailed reply. I know how to change the button background when selected but the background color will be solid not same the light blue in my screenshot.

Hello,

I thought it would be a simple question but I really searched for long time and I didn't get the answer.

Q: How can I make a button as selected with this background color?

155147
...

Thank you very much
I updated the connection string from "My project >> Settings >> connection string value", now when I publish the project, the data will be saved in same directory I want
...

Finally I found the updated file here:

C:\Users\username\AppData\Local\Apps\2.0\Data\10QAVELZ.GBQ\A7J64956.DX1\comm..tion_1869e380d5f25fcd_0001.0000_4ec05dca23467d69\Data\AEOM_COM.accdb
The...

I tried and you are right, it is not working in another PC.
In publish option (application files), I included all the files and I changed the database to (Data file)
But still I got error message,...

Hello,

I completed my program and I used "publish" option in visual studio 2015 so I can give the setup file to the others.
After I published my program, everything is working perfect, I can read...

Hello,

I am using MS Access 2013, if I have a database with 3 tables and each table has one column:

Table1:
column_1A

Table2:
column_2A

Genius idea =)
This is working perfect
Thank you very much dear, this will help me a lot in my project

You must spread some Reputation around before giving it to jmcilhinney again. :p

I will appreciate that.
I tried manytimes but still I am not able to do it

Thanks dear

Let me summarize what I did.

1. I created new project, I added the database using the wizard, then I added the datagridview.

2. From DataSet Designer, I changed the expression...

Yes, I put this value in Field3 expression ([Field1]*[Field2]) exactly same in access
I got this error

137411



Could you explain more about this step? :)

I didn't write the code for database in VS, I added the database then I added the (datagridview) by drag the table into the form and the code for datagridview was automatically generated.

I...

Hi,

I have a database in MS Access with some calculated columns, for example:
column1: a number (normal)
column2: a number (normal)
column3: column1 * column2 (calculated)

Then, I linked...

Thanks Frab
You guided me to the solution, I fixed it using another way

I opened (*.vbproj) with notepad and I searched for (Form1)
I noticed slight different between (Form2) and (Form1) code
...

Hi,

I opened the program to complete my project but I didn't find the (design view) for ONE form only (Form1.vb)

I noticed that:

1. The icon for Form1.vb is different, see this screenshot
...

Hi,

I am using DateTimePicker to search in database by month, I completed the coding stage and it is working perfect but is it possible to change the DateTimePicker view mode to be by month like...

However, is it possible to do that in VB ?

Sorry I forgot to add the second code:

I used this code but it is no working with filter, it will give the summation for ALL rows in column "amount". I want the summation for the filtered rows...

Hi,

I have "DataGridView" and a button to filter the "DataGridView" by choosing a specific date, I am using this code to filter the results:


Me.AvailabilityBindingSource.Filter = "TheMonth...