Search results

That sounds feasible. I shouldn't have too much problem figuring out the grouping aspect in the report end of it, but you wouldn't happen to know the code that would assign sequential numbering to x amount of data rows? -aldo

I am attempting to create a report that breaks down a field of 'ID' numbers into groups of x. In the sample report below x = 12 and the report will apportion the first 12 'ID's to the first page and textboxes with extra large fonts will signify the start and end of 'ID' numbers for that page...

Thanks Simon. I was hoping for a simple fix here. Not a problem though. I reworked the query and broke it down into a few separate queries and it works great now. -aldo

Hi all, I've tried the ‘is null, '=0" and ‘nz’ routines on the Count(Tablename.Fieldname)'s, but can't seem ‘to get them to output a value of 0 in the null fields. I must be doing something wrong. Any and all help would be very much appreciated. Thanks much, aldo

I have a report that prints blank serialized forms and I basically need a query to generate a field where if I request 4 sheets to be printed the list generated would look like this: IDNo 1 2 3 4 -aldo

I've decided to replace the navigation buttons and add the code via click events. This seems to be working, but I am having trouble getting the buttons to behave like the normal navigation buttons. I need to disable the 'GoToNextRecord' button when I reach the last record. And how do you get...

The 'Verify' checkbox is selected to place data entry into a verification mode at the beginning of data entry. It is not to be selected for every record entry. It works in the background to remind you that you may have overlooked setting a record to 'Updated'. There are essentially two modes of...

I have the following code entered on a subform:Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Verify = -1 And Me.Status = 0 Then Dim strMsg As String strMsg = "This account has not been updated." & Chr(10) & Chr(10) & _ "Do you wish to update the account now?" If MsgBox(strMsg...

Thanks lightray. -aldo

Is there a way to set up a query/report to display rows numbered 1 to max(AccountSize) and display the Count(AccountSize) that match the row number even if they are zero quantities? I'd appreciate any help I can get. Thanks much, aldo