Search results

I don't think that is possible, unless you make an image of your current image plus text, and use that as the image.

The delta between "30-Jul-2024" and "29-Jun-2027" is 3 years minus 1 month minus 1 day. Is that REALLY what you meant, or is there a typo?

@Edgar: you forgot the part where you set a Reference to the library named: ???

Maybe I wasn't clear enough. With both browsers I ran your code, and got no prompts. I conclude it's not a matter of crafting the URL.

Firefox is my default browser and it does not prompt for anything; just opens that page. I briefly made Chrome my default browser and again, no prompt. Maybe you can carefully review your browser settings. At this point it's not an Access question anymore.

Check the help file. You need to test with NoMatch rather than EOF.

The *Render events are related to Pivot Charts (as it says in the doc you attached), and those have been deprecated.

That's right, and rather than DoCmd.CancelEvent set the Cancel argument to True.

What is TCP in your case? What are the tables and fields involved? Show us a screenshot of your Relationships diagram (with the relevant tables nicely laid out).

You declare "db", but never set its value before using it. Add: set db = currentdb before the "set rst" line.

As already mentioned above: you need to discuss with higher-ups what computing environment will be available to you. "None" is not a good answer, but if that IS the answer, then you may want to reconsider if this is the best company for you. Of course before you talk to them, you read up on...

Would be good to post this in the User Interface thread we had a few months ago.

Let's not forget that the OP is in India, and the business rules would likely be different than they are in the USA. Prabha, is this for an Indian hotel?

As an aside: MSFT is working on providing better support for high-DPI devices. The old 16-bit coordinate system is on the chopping block.

Crosspost Change column sizes in modern clustered column chart in Access - Microsoft Community But indeed, Sophia's response was about the old ActiveX chart control which you should not be using anymore. Alas, Modern Chart does not seem to have an option for this. You can provide feedback in...

@CJ: That has apparently been corrected after you last looked at it. In this test I created your query on Companies table, saved it, then renamed the table to CompaniesTest, and the query was fixed up.

I'm working on a similar project. We have a list of templates which are fragments of a letter, to be inserted at the insertion point into a large textbox upon a button click (or if a listbox, upon double-click). The dropdown would have 2 columns: select TemplateID, TemplateName from tblTemplates...

This?

@KitaYama: I agree, this is a job for Name Autocorrect. Assuming a split database per best practices, the tables would first be brought in the FE, their relationships re-established, and then change the table name. That will change the related queries as well. Of course, if you have VBA that...

Copy the BE to your local machine, just to run your procedure on. Although copying takes time too, that should be MUCH less overhead than pulling the data across the network in your procedure. Also worth running the Performance tab of Task Manager while running your code. You can see if the...