Search results

Last night, I checked the contents of the combo box. In most cases, the rate plan combo box would indicate the proper stored number and the five columns in the combo box would be filled as per a msg box. After clicking on several entries, the problem would occur where the value of the combo...

Thank you. Will try both options

That would work 😂😂 thanks

As mentioned, there really is not any code. The master/child relationship between the form and subform works fine, the data field to link the cascade combo box works fine in data entry, and there is no other code. My unknown issue is why the aircraft rate combo box is not being filled when the...

Until the 5th day of the current month when the tax calculations are generated for the prior month, the user is able to change or delete any invoice information for that period. Once the cutoff is reached, I would like to allow the users to view the information but not make any changes...

I have a form with a list box that has the key identifiers for a table and a subform for data entry/review. When the user clicks on an entry in the list box, the master key is set which changes the view in the child subform. In the subform, I have two combo boxes: a list of aircraft and the...

I decided to turn the ribbon off when I opened the main menu form and turn the ribbon back on when I close it. Easier that way.

My understanding is that Microsoft products use bankers rounding on decimal places; i.e., the decimal is only rounding upwards if the decimal being rounded is 6 or higher. I looked at rounding in Microsoft documents and found Math.Round(value, MidpointRounding.AwayFromZero, decimal places)...

Thank you

DoCmd.OpenReport ReportName, acViewPreview

Whenever I print preview a report, the report ribbon appears and then disappears when I close the report. How do I prevent the display of the report ribbon in this circumstance? Is this in a report property?

Yup, that did the trick.

I have a report based on a query which provides financial activity for a person. In the query, the data is sorted by student, effective date, and financial type. When I look at the results of the query, the student and date information are correct as well as the financial activity - goods and...

I have a form that opens up a report for a person. i set up a global filter in a module to ensure that the data is accessible to both the form and the report. In the form, this code is used to set the filter gblFilter = “PersonId = “ & specfiedPersonId The report is invoked with a...

with regard to importing data, I import the data as is into a new table definition with the desired field names. After the load, I went and modified the field settings to good values such as single decimal places. I guess I could go back and change the Excel format to currency but that would...

Forgot so much after 12 years. I needed to be in the page section to look at the properties for that section. Another well duh moment

I have used this approach in the past with no problem. I started with a new report design and I cannot get the code to execute.

Even with a msg box command or a debug checkpoint, the code never gets executed

Quick question. I have code in my report page header that fills in some fields. However, this section of code does not get invoked. I tried with the debug pointer on and nothing happens. Been a while, but there does not appear to be anything on the report that says there is an event...

Yes, I did change from single quote to octothorps (#] and dates are working fine. With regard to extended decimal places for some values, it appears that it only occurs where the original value was calculated in Excel (e.g., 854.7 - 832.4] rather than entered as a value with a single decimal...