Search results

I would mess with the font size or button height.

You can use code in the on format event of the report section to change the font size. Your code will also need to return the font to the regular size as needed.

So, you expect the top property of the bottom subreport to decrease if the other sub reports are not present? Are the 2 middle subreports set to a very minimal height? Can you share the design view screenshot of the main report?

Did you first attempt to compile the code? I don’t think you had Option Explicit at the top of your report’s module.

This is a common mistake.

Also, code does not run in the report view. I tested using Print Preview which will run the event code. The vba sets the max to 50 which is less than the minimum value.

I moved the code to the On Format event of the Detail section and it worked as expected.

Probably not plausible in a continuous form however a single form view or report would be fairly simple with some VBA in an event.

Thanks George, I had already successfully tested this #46. Since retirement four years ago I spend more time on my iPad than my laptop. This is more convenient but doesn’t allow me to futz with Access.

With SQL Server, I believe you can insert identity by issuing the command: IDENTITY_INSERT to ON. SET IDENTITY_INSERT Products ON; Remember to set this off when finished.

Thanks, I just tested this myself to confirm this could be done,

I had not known you could insert an Autonumber between two other values. For instance if you have five records with values 1-5 and delete the 3 record, I wasn’t aware you could insert a record with 3 as the autonumber. I would appreciate if some could provide a small database with a demo of how...

So is this tblpayrolltaxes.MyUCA)=391 what you need to be the same?

First, welcome to Access World Forums. Do you have comments in code that explain COGS with FIFO or do we need to research this prior to answering?

What exactly do you mean by “be able to modify the table links”?

You most likely have user entered updates along with code updates. This will cause your error.

If the tblVisits is linked, you can create a query with this SQL to find out where the backend database is located: SELECT msysObjects.Name, msysObjects.Type, msysObjects.Database FROM msysObjects WHERE msysObjects.Type=6 OR msysObjects.Name ="tblVisits";

I continue to wish you would use your words rather than expect us to understand Excel functions.

Can you use words to describe your requirements so we don't have to guess and reverse engineer?

What do you get if you open the debug/immediate window and enter: ? acReport