Search results

I'm trying to create a VBA application that would allow for a given date (datetimepicker) to display in a datagridview a list of records (uploaded from a database) that occur before and after the given date(2 radiobuttons). What would be the best way to go about creating this application? If I...

I'm having issues with a form I created. Every time I click on the button to Add New Record the form gives me this error message. What are some reasons why I keep having this problem? Any help is greatly appreciated.

I will try to do this. I really appreciate the help. I have a question on another topic if you can help me: Update Item Set QuantityOnHand = (Select Item.QuantityonHand - Transaction.QTYPurchase From Transaction, [Transaction Item], Item Where Transaction.TransNum = [Transaction Item].TransNum...

Ah, that makes a lot sense. Sorry for such a simple question, I'm a bit new to Access. Thank you so much for the response!!

Hello all, I'm trying to run this query: Select CRSDesc, Category, CrsDur From [Fitness Course] Where (CrsNum = [Enter a Course Number] or CRSName = [Enter a Course Name]); I want to make it so that once I enter a Course Number, if that response is correct then it doesn't ask me to enter a...

Hello, my name is Steven and I'm a relatively new Access programmer looking to learn more about the program!