Search results

I have a complex IF Statement within VBA when I step thru the code the if statement variables should return true but instead treats it as False. See '>>>> this happens on the 2nd Pass of a Do Loop Statement, the First Loop the if Statement Returns True Variable Values: Record 1 contractNo...

I have to loop thru 2 recordsets. I need to first determine the quarter , then retrieve a value from each of the 6 fields for that quarter and compare that value against a previous years value that is also stored in the table for each quarter. the following is the field names not the field...

I have a mainform/subform. Combo for Vendor Name is on subform. If the user needs to add a new Vendor name, I use the Liimit List Edit form - allow the user to add a new vendor. however, when the user returns to the Mainform/Subform to continue to enter the invoices, it does not set the...

I have code that will update SQL tables and uses a Stored Procedures to gather the information. The following code works successfully and updates the SQL table. I am looking for assistance in now using these functions to capture information regarding the processeing of the databases. I need to...