Excel VBA tutorial for beginners- How to create login form in Microsoft Excel VBA with source code
In this video, we'll learn how to create a login form in Microsoft Excel using VBA. We'll show you how to create a user login form with a show and hide password textbox. This tutorial is useful if you need to create a login form for your website or application.
If you're a Microsoft Excel user, then this video is for you! In this video, we'll show you how to create a user login form using VBA. We'll show you how to create a user login form with a show and hide password textbox. This tutorial is useful if you need to create a login form for your website or application. So make sure to watch the video and learn how to create a login form with
Subscribe to my channel to find everyday new information in programming and Computerr Science
Subscribe to @programmingforeverybody
https://www.youtube.com/@programmingforeverybody/?sub_confirmation=1
Source Code:
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
passtxt.PasswordChar = ""
Else
passtxt.PasswordChar = "*"
End If
End Sub
Private Sub CommandButton1_Click()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Sheet2")
Dim i As Integer
For i = 1 To ws.UsedRange.Rows.Count
If usertxt.Value = ws.Cells(i, 1).Value And passtxt.Value = ws.Cells(i, 2).Value Then
UserForm1.lbl_user.Caption = Me.usertxt.Value
Unload Me
UserForm1.Show
Exit Sub
End If
Next
MsgBox ("Error username or password")
End Sub
C# tutorial: Retrieve data from SQL server based on comboBox Inside dataGridView with code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace combobox_dataGridView
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=students;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select code_student From marks_students", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
code_student.DataSource = dt;
code_student.DisplayMember = "code_student";
code_student.ValueMember = "code_student";
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=students;Integrated Security=True");
for (int i = 0; i <=dataGridView1.Rows.Count - 1; i++)
{
SqlCommand cmd = new SqlCommand("Select id,firstname,lastname,grade,marks From marks_students Where code_student = '" + dataGridView1.Rows[i].Cells[0].Value + "'", conn);
conn.Open();
SqlDataReader myreader = cmd.ExecuteReader();
if (myreader.Read())
{
dataGridView1.Rows[i].Cells[1].Value = myreader["id"].ToString();
dataGridView1.Rows[i].Cells[2].Value = myreader["firstname"].ToString();
dataGridView1.Rows[i].Cells[3].Value = myreader["lastname"].ToString();
dataGridView1.Rows[i].Cells[4].Value = myreader["grade"].ToString();
dataGridView1.Rows[i].Cells[5].Value = myreader["marks"].ToString();
}
conn.Close();
}
}
private void dataGridView1_CurrentCellDirtyStateChanged(object sender, EventArgs e)
{
if (dataGridView1.IsCurrentCellDirty)
{
dataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit);
}
}
}
}
How to create login form in Microsoft Access VBA 2023
In this video, we're going to show you how to create a login form in Microsoft Access 2016. This is a useful skill if you need to create a login form for a database or if you're developing a custom application. If you're looking to learn how to create a login form in Microsoft Access 2023, then this video is for you! We'll walk you through the steps necessary to create a login form in Access 2016, and provide some helpful tips along the way. Watch and learn! Subscribe to @programmingforeverybody https://www.youtube.com/@programmingforeverybody/?sub_confirmation=1
With source code- Visual Basic.net project: System calculate installments and due dates in VB.net
Public Class Form5
Dim dt As New DataTable
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dt.Columns.Add("Installment", GetType(String))
dt.Columns.Add("Value", GetType(Integer))
dt.Columns.Add("Due_date", GetType(Date))
DataGridView1.DataSource = dt
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim price_v, adv_payment, installment_value, n_intallments, final_installment As Double
price_v = TextBox1.Text
adv_payment = TextBox2.Text
installment_value = TextBox3.Text
n_intallments = Math.Ceiling((price_v - adv_payment) / installment_value)
final_installment = (price_v - adv_payment) Mod installment_value
DataGridView1.DataSource = Nothing
dt.Clear()
DataGridView1.DataSource = dt
DataGridView1.Columns("Due_date").DefaultCellStyle.Format = "MM-dd-yyyy"
For i As Integer = 1 To n_intallments
Dim date_payment = DateAdd(DateInterval.Month, i, Now)
dt.Rows.Add("Installment" & i, TextBox3.Text, date_payment)
Next
If final_installment <> 0 Then
Dim lastrow As Integer = DataGridView1.Rows.Count - 1
DataGridView1.Rows(lastrow).Cells(1).Value = final_installment
End If
End Sub
How To Create DATA ENTRY form in Microsoft ACCESS 2022
In this video, we're going to show you how to create a full MS Access data entry form in just
minutes (without using VBA). This data entry form will allow you to collect information from your users easily and quickly, and it will be easy to manage and use.
https://www.youtube.com/@programmingforeverybody/?sub_confirmation=1
VB.net - load data from SQL database format datagridview and use statement with
Contents🎞
Load data from SQL database 00:56
Delete the last blank row and Prevent user to add rows 03:59
Fill the width of the available display area in datagridview 04:35
Change font column headers (Type - size - Style) 05:25
Change Colors column headers (Backcolor - Forecolor) 06:40
Change alignment column headers 08:51
Change font columns (Type - size) 09:47
Change alignment columns 10:46
With...End With Statement 11:35
Subscribe to:
Posts (Atom)