Search results

KitiYama’s second comment indicated that any unhandled error will cause global variables to be destroyed. First, what is an unhandled error - I capture unknown form errors and write to an error log and is that considered handled? Second, is this a true statement re variables being destroyed...

@Armelgp As soon as I enter the first character in the main form, the BeforeInsert process is invoked. So putting a validation there does not give the user time to go anywhere (unless he starts at the field in question) before the error condition is invoked. However, as soon as the user leaves...

Not to get into this more than it needs. I said in the first post that gblQt was a constant set to “. See second paragraph.

As noted in the first post, I did supply a file name extension as .xlsx.

Sorry, my bad, Yes, the filenames I used had the extension and should have been noted as D:testme.xsls and D:testme pls.xsls in the text that w The leading and following double quotes that I used were the issue.

gblQt is a global constant that has a value of “. So rather than putting in “”” which is weird looking to me, I just put in the constant. i had to use the leading and trailing quotes because my File path and name for storing pdf files fails without it. (Or did, aargh) I went to the basics...

Nope. Like i said, the pdf’s worked fine and this is on my laptop. But good effort 😃

I have a configuration field which identifies the path where pdf reports are to be stored. I join the path, a file name, and a pdf extension, use the OutputTo command and it works as expected behind the scene. However, when I try to do the same with Excel, it rejects the request. If I leave...

My brother is the only client and we can force him to get a 64 bit version. Lol

I have a 64 bit 2019 version. So, I guess I should be using ACCDE. Thanks guys. Does anyone have a link to download the free runtime for 2019 64-bit access.

Yup, that is my next step. Copy everything over to a new report base and see what happens. I have other reports where the alternating colours and conditional formatting work fine.

with MS Access 2007, I would split the database into data and the user interface (using and MDE file). With MS Access 2019, I see that the ability to split the database still exists but there does not appear to be an executable object (unless the database split creates one?). what I am looking...

Tried it with just a red background for less than zero, and the field label and field value in all cases is a medium grey.

Yes, I used conditional rules for the total field just like you had in your sample db. I tried just the <0 and >0 rules and all the invoices come out with a green background for the field whether less than, greater than, or equal to zero. The red background rule is followed by the green in the...

I have an invoice report where I show all the merchandise/service charges, total it up, add tax, show the invoice charge and then show the client’s current account balance. This works just fine for the numbers and data retrieval except for two features that I thought were standard: 1)...

Some days, I just feel old and forgetful. Simple solutions. I forgot about the record selector attribute. Switched that on for the two continuos forms. Now I have a way for the user to select a specific record, even those that are locked. When the record is selected, the OnCurrent routine...

i had thought about that idea but discounted It because it would be intrusive into the database. Code is fine. I was thinking that the key of the record where the user has there cursor could be identified somehow and stored in a global key. When the user hits the delete button, the code could...

I have two sub forms that show records for the master event. I would like a simple way for the user to select a record and then press a Delete command button to remove it. i thought about having a Delete button in the form footer and a yes/no box for the record. However, when I select a non...

Searching for other information, I found this nugget that solves my rounding issue. As previously stated, MS Access uses bankers rounding which causes numbers to be rounded towards the nearest even number. However, the Revenue Canada guidelines state that standard round up on .5 is the...

The subform is a standard one record form.