Amateur Question on Access VBA
I bet this probably comes off as a really newbish question, but I'm completely stuck!
I'm using VBA in Access 2000, and i'm trying to create an IF statement on an Access Form. What I'd like to do is create the statement using the field (Stock Level) from the Table 'tblStock'. I'd like it so that when Stock Level is equal to 0, a Message Box opens and says the name of the Product (Which is located in the Product field of tblStock).
I have the If code working with regular numbers, but I can't use it with data that can be found within fields that I've created.
Any help would be appreciated for a lifetime!
By alaska_eric in forum VB Classic
Last Post: 03-15-2005, 04:31 PM
By MKayHavoc in forum VB Classic
Last Post: 03-09-2005, 01:09 AM
By vinman in forum VB Classic
Last Post: 02-22-2001, 10:40 PM
By dave in forum VB Classic
Last Post: 02-19-2001, 07:07 PM
By John Simmons in forum Enterprise
Last Post: 02-09-2001, 12:42 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL