Search results for query: *

Hello, I have a report that contains several subreports in it. I am trying to have the report always contain an even number of pages so that I can use duplex. (Adding a page if the report ends in an odd number of pages will prevent the 1st page of the next report from being on the last page, and...

Greetings, I have an unbound text box on a form that requires user input before pressing an update button that updates a table. How can I: 1) ensure data gets entered 2) ensure data integrity. Value entered should be a number 5 digits in length Thanks

Thanks, The following updates on one record but is not going to the next record in my table and updateing that record, etc. Any pointers? Private Sub Command66_Click() Set db = CurrentDb() Dim rst As DAO.Recordset Dim iMyCounter As Integer Dim rs As DAO.Recordset Nextadjno = DMax("ADJNO"...

Good grief...Ok lets try again. Just ignore ...thanks Table Name:tbl_Adjments AcctKey GRPNO LOCNO PURGESTAT ADJAMT ADJNO 3........ 1000.....500...... 0............. 500...... 0 4........ 1000..... 500...... 0............. 600...... 0 5........ 1000..... 500...... 0............. 700.......0...

Sorry tables should read as follows: Table Name:tbl_Adjments AcctKey GRPNO LOCNO PURGESTAT ADJAMT ADJNO 3 1000 500 0 500 0 4 1000 500 0 600 0 5 1000 500 0 700 0 6 1000 500 0 800 0 GRPNO LOCNO PURGESTAT ADJAMT ADJNO 10327 0 1...

Access Looping through Recordset And Incrementing Greetings, I currently have an access table with the following columns: Table Name:tbl_Adjments AcctKey GRPNO LOCNO PURGESTAT ADJAMT ADJNO 3 1000 500 0 500 0 4 1000 500 0 600 0 5 1000 500 0 700 0 6 1000 500 0 800 0 Data can be added to this...