Recent content by HealthyB1

On my form I specify if the client gets trade pricing as distinct from Retail pricing on materials & labour, also if Sales tax is applicable or not for this job. I found that running two subreports on the invoice report did not always give the right answer. I tried using TempVars but again was...

I would like to import the contents of some text boxes on a form into a report that is called from a command button on the form On the form i calculate things like the total materials cost, total labor cost, Sales tax, discount percent given on this order etc I then call/open an invoice report...

There are a lot of examples in the forum that reference Allen Browne's web site. My browser doesn't seem to be able to find it today.

Hi George, I spent many years as a Computer technician on SINGER, NCR and DEC equipment (PDP 10's and PDP 11's etc). "If all else fails reboot" was used as a last resort, as you may not be able to reproduce the problem for hours, days or weeks. However in this case, YES I did try rebooting and...

I checked and it would appear that there were cumulative upgrades installed by Microsoft for both Win 11 and .NET framework today 10-Oct-24. Likewise for the Office 365. The problem has now disappeared. I shall wait a day or so and if it doesn't re-occur I will close this Thread. Thanks for...

Will do check in 5-6 hours I will check Access versions when i get on site. Yes it does open Print preview from Design view

Hi George thank you for your response and suggestions. My son rang this morning to advise that WIN 11 based system hosting the Access front end is working perfectly this morning. Re your suggestions:- I shall not be onsite to check out your suggestions for another 5-6 hours. The Access on...

Hi there, I have a long running home grown invoicing system with a backend data base and two front end Access apps that link to it. One of the Access front ends runs on Windows 10 the other runs on Windows 11. Both the apps produce a print preview screen. Once I obtain same I then either print...

Thanks for the update Jon. :)

The last one of these weekly newsletters I received was on July 4th 2024. I am unsure if I have accidentally deleted my name from the distribution list or if this weekly email has ceased being produced. Can someone please advise if it is still being generated and how to I resubscribe to same?

V-Tools seems to be a great tool. However is there a user manual for it please? I am trying to figure out how to use the DIB Pictures for controls on my forms.

Thanks for your suggestion. I have been busy over the past few days so only just saw your message / suggestion. I would be extremely grateful if you could share your routine with me. Thanks in advance.

Thanks Sonic8. Ques:- How do I access the DAO library?

Thanks for the explanation Doc Man. I tried to do a compile on the F/E but it is too big. Also the documenter will not work. No matter it will give me a task to do tonight.

Just wondering where are the execution plans saved exactly? Or it as simple as, once the query is run the first time it flags somewhere that the particular query has been run/executed before? A supplementary question if you will. All the comments that may be included in a VBA module...