Search results

Combo boxes in forms are awesome. There really isn't a substitute with all the rich functionality.

I deleted the combo box information and changed the Display Control to Text Box. I don't get an error message. If you are still having issues, consider sharing your current file.

The issue is your lookup field (not a good idea) definition in your table design. The Row Source for [ID Unit Kerja] is set to: SELECT [Unit Kerja Peserta].[ID Unit Kerja], [Unit Kerja Peserta].[Nama Unit Kerja] FROM [Unit Kerja Peserta] ORDER BY [ID Unit Kerja], [Nama Unit Kerja]; FROM [Peserta...

First, I would check the SQL of the Row Source since this provides an opportunity for your error. Then I would delete the combo box and re-add it.

Did you try adjusting the height of the buttons and/or font? Microsoft is known for changing default fonts which can affect the rendering of forms and reports.

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”?