Search results

I want to run an SQL select statement from a general module, activate on a button click event. This is my code; 'parameter query to display stock items based on selected distributor Public Sub DoSQL() Dim SQL As String SQL = "SELECT tblStock.DistributorNo FROM tblStock WHERE...

Hi there access gurus :) here's one for you that I am stuck on.... I have a invoice form with a 'Paid' checkbox. As soon as the checkbox is updated in the form I want this change to be reflected in the corresponding table so that I can then run a dlookup to see what the value of the form is...

I am trying to capture the value of a checkbox on the current report. I am using the IsNull to try and get around a "Runtime error: 2427 You entered an expression that has no value" when I use the code; varPaid = Me!Paid I am assuming I get this error because sometimes the checkbox isn't...

Can't see why I am getting a Error 3464: Data type mismatch in critical expression on the following code; Private Sub Quantity_AfterUpdate() Dim intStockCurrent As Integer Dim intStockSold As Integer Dim intStockNew As Integer intStockCurrent = Nz(DLookup("[StockOnHand]", "tblStock"...

okay here goes... my first post on a forum other than my uni site. I am building (trying to anyway) an access db. I have a invoice form that is based on a table (invoice table) and I have a checkbox field in another table (customer table) that I need to get into the invoice form so that I can do...