Search results for query: *

You might want to Compact the Database. Although it won't fill in a number that has already have been missed, it does reset numbers that have been deleted at the end of the record set. For Example: AutoNum ------- 1 3 4 5 *Deleted* 6 *Deleted* Adding the next...

Thanks Databaseguy! (a star is on it's way) I had to modify your code, as there was some errors when I tried to run it. I also changed the output to the debug window rather than a message box. My modifications are below in case anyone else would need to run it. Private Sub ListLinks() Dim...

When I tried to refresh the link to a DB2 table using the Linked Table Manager in Access 97, I received the following Error Message... "Invalid Procedure Call or Argument" The message occurs before the Linked Table Manager window is displayed on the screen, and does not allow me to...

I printed the report and got the same results as NCYankee1. The reason why this occurs is because the 'On Print' event is not triggered when the report is printed and the intLnCount variable is not reset to zero. To solve this, place the code to reset the intLnCount variable in the Report...

To clarify, the 'On Print' code should be placed in the 'On Print' event of the Detail Section. -GCam

Hi NCYankee1 First draw your line in the detail section just below the text boxes. Name the line DtlLine. Declare the following in the General Declarations of the report. Dim intLnCount As Integer Const MaxLnCount As Integer = 3 Add the following code to the 'On Print' event of the...