AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question Hi Scott,Please I needs help on Access.I have a Form with this field DATE,QUANTITY,BOOKS,ISBN & AVAILABLE UNIT (of Books) and I want to add command button (like CHECK]and MsgBox)to it.I want the MsgBox to tell the User to enter the date and quantity.I also want the MsgBox to tell the user if the quantity requesting exceeds the available unit.I will like to know if I can use CONTROL and MACRO to execute the action?Your help will be appreciated.Am using Access 2007 for my database.Thanks.Femi
Answer First, you do not have fields on a form, you have controls that may or may not be bound to fields in a table. Second, I'm not sure if I'm following what you want. It sounds like you are trying to set up an ordering system for books. Is that the case? If so, wouldn't you want to provide the ability to order more than one book?
If you let me know what your table strucutre looks like I can make further suggestions.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
