Recent content by PaquettePaul

In the current report Page Setup, the Size is set to Letter and Source is Main Tray.

When I am printing a report, I use the command “DoCmd.OpenReport xreportnamex, acViewNormal”. This works fine when there is only one tray in the printer. A problem exists where the user has two trays, one for letter and one for legal size. Access is always selecting the legal size (11x14)...

Ok, thanks for the feedback

When I use the OutputTo command to generate and store a pdf, the system throws up a brief message regarding that activity. I would prefer to suppress this message. Using the set warnings code does not affect this display. i tried a set display option using the Application command but that is...

So, I decided to change the database for my wheels up and down times from date fields to 4 character fields. I am using the routine that arnelgp provided for time validation with some modifications. A statement is in there to determine if non numeric characters exist. The issue is that the...

Nope. I have error handling and the form event and overall form level.

Not really looking for a solution but thought I would share an experience. I develop my code using Access 2019 and it operates in production using the free RunTime version of Access. I have a routine in my financials generation process that calculates a base taxable amount and applies a 5% tax...

Isaac, in some cases, people only have a sense of what they want to accomplish but do not know if there are better ways to implement things. Case in point is finding out the last day of the month and the first day of the month. I used to have a function with several lines of code to accomplish...

Ebs17, given the complexity of my forms, stripping the app to a simple database to demonstrate the problem would be a lot of work. I could have provided an image of my form to demonstrate the issue but images are frowned upon. So, I try to explain the issue as clearly as possible but not...

Btw, I did copy arnelgp’s code in my general function routine so that I do not lose it.

All useful responses to a problem should be praised, whether the full response is used or not. I never used the input mask for data entry before and found it useful. Same with the simple validation in the sample database. The responses provide me with an option that i did not know before -...

ArnelGP, the code works as advertised. Thank you however, it introduced a problem that I have had before and not sure how to deal with. I am entering the data on a continuous form. I created two new unbound fields for the wheels up and down times, leaving the original fields hidden. The...

Ah, I need to set the input mask on the form as well. the only issue seems to be the invisible leading zero. Any suggestions?

Also, times with a Leading zero do not display the zero. 07:30 is shown as 730 instead of 0730.

I changed the input mask to 00:00 and the display format to hhnn. As shown in the video, when I enter a value in the field like 0823, it actually appears as 08:23 when I type it in and goes back to 0823 when I leave the field. However, this works when I go to the table directly and enter a...