27. VBA - Variables And Data Types (Programming In Microsoft Access 2013) 🎓

A newer version of this series has started for Microsoft Access 2016 here:
----------
VBA - Variables And Data Types in "Programming in Microsoft Access 2013". Hosted by Steve Bishop.
In this free beginner video tutorial series Steve will be going over Database Development in Access, creating the User Interface, and coding the backend of the application in Visual Basic for Applications (VBA).

Click here for the full playlist of"Programming in Access 2013"

Click here for the Work Files of this series:
----------
Become a member today for only $5 a month!

When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
----------
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.

[ProgrammingMadeEZ]

Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.

[sundaramsambasivam]

Hi sir, sharing knowledge is the best way of kindness to needed person, I have wasted so many years to listen to your vides, thank god at least now I am watching your videos, it is so simple, clear and precise. Great work Steve, pse keep continuing educating the people who are interested

[johntrav]

Hey Steve, there is no way i can thank you enough for these videos. I have a degree in computer science and in 4 years none of my lecturers managed to make me not hate programming. Not I can finally get my head around it and it's actually fun. Thank you soooo much!

[mohamedalkaabi]

Salute for the great effort man. Thank you so much for this unique demonstration =))

[JasonPurkiss]

Thanks for the videos, just for the record Pi is an infinite decimal and so geos on forever :) @ 10:15

[NBAGOAT-ggpk]

Extremely helpful content and I think it can be alot better, thank you very much!

[GlentonJelbert]

Awesome series though!  Thanks so much for sharing!

[happy......]

12:41 Right that "Billion" is almost Carl Sagan lvl!

[kadnacer]

Hi Steve, and thank's for this demo.
I want to know if you have a demo about using Temporary and local variables in VBA.

[dannycunningham]

About 10 mins in it is mentioned the long integer range is -2147483648 to 2147486647. The positive long integer max should be 2147483647

[pezguin]

Hi, thank you for the videos, they are very helpful!
If I'm expecting a value that could be 0 or with decimal places, which data type should I go with?

[megaseraa]

hi, I was just wondering, how would you calculate 10% off a price for example, but in a form? How do you calculations in a form in general? Thanks

[Phillsen]

Are you sure a boolean variable needs 2 Byte? ^^

[LokeshThakur]

what about lists do these work with access?

[kamar]

Good morning, Please I am trying to write a code to validate the data entries to avoid duplicates on a fault log database. it works for the stLinkCriteria which is a string datatype (short text) but not for stDCriteria which is a date data type... it keeps throwing an error "type mismatch" or "datatype mismatch" on this line (stDCriteria = "[datelogged] = #" & DateTime & "#".
It shows stDCriteria as 12:00:00am

Although the data type for datelogged is Date/Time in the database...

I humbly await your help.. thank you

Private Sub Form_AfterUpdate()
Dim NewTerminal As String
Dim stLinkCriteria As String
Dim DateTime As Date
Dim stDCriteria As Date

NewTerminal = Me.cboTerID.Value
DateTime = Me.txtDateLogged.Value
stLinkCriteria = "[serialptrid] = " & NewTerminal & ""
stDCriteria = "[datelogged] = #" & DateTime & "#"
If Me.SerialptrID = DLookup("[serialptrid]", "Fault_Log", stLinkCriteria) Then
If Me.DateLogged = DLookup("[datelogged]", "Fault_Log", stDCriteria) Then
MsgBox "This terminal " & NewTerminal & ", " & DateTime & ", has already been entered in this database." _
& vbCr & vbCr & "Please check terminal selected", vbInformation, "Duplicate information"
Me.Undo
End If
End If
End Sub

[samsum]

Thanks for the video.  What is a good book you recommend for VBA access programming?

[maricardecastro]

HI. Do you have a video for auto populating forms from different table depending on the data in the form?

[AbdulRauf-jqpg]

Hello Dear.!!

How are you ?
I have created a school database in MS Access.
I want one class to pass if it passes into the next.
Please help me!

[sajidmaqsood]

Mr steve it is good effort but you made a massive database with number of tables, queries, forms etc. which make it messy and confusing, if someone want to learn a single topic, he needs to go through this large series. plz use a new table or form for a single topic or use one r two table or form then videos will be more effective.

[terrygittos]

Boolean should be 2 bits not bytes :) Great vids btw!!