Recent content by diannebcgray

Wow, it worked like magic! I got the behaviour I was looking for. Thank you!

Wow, ok, that is an overwhelming amount of code. How do I apply it to my situation? I'm looking for as much simplicity as possible as programming is not my strongest suit.

Hi, I am struggling to reference a field name in a query in VBA. I want to use this field name to set my current form text box's value to that value when a client name is picked from a combobox. The query will look through my table and pick the client's information from the most recent record...

Great, thank you so much for the info! This really helps. I guess the problem with using desktop Power Automate is that every computer using the database would have to have it installed for it to send e-mails on the database's behalf, correct?

That sounds like a possible alternative, although I have read that the CDO method is old and there's a chance Microsoft might stop supporting it. Thoughts?

Hi, Is there some compatibility between MS Access and Microsoft Power Automate? For example, creating a new project in Access that triggers an e-mail? My best guess is no, due to Access' local architecture and Power Automate's cloud architecture, but I still thought it is worth asking. (I am...

Sure, and maybe it's not possible but this is why I'm asking. The specific example is to send parameters from a newly created project, such as a project name and number, client name, etc. to create a new project in CORE.

Hi, I have previously created charts in Excel that reference a link to queries in Access a long time ago (there are a bunch of linked query connections in this Excel file). However, I cannot figure out how I referenced them. Here's an example: They are not pivot charts, just normal charts...

I couldn't actually post the link for whatever reason so here's a picture of the link.

Hi, I have almost no experience with API's but we have a custom database created with MS Access. I'm not well-versed in Javascript, although I've done coding and scripting. I would like to know if anybody has tried developing some kind of API communication between MS Access and BQE Core...

Great, thanks everyone for your tips!

Interesting. Ok, makes sense. The text box method is working for me, though I want to better understand the code methods. If I try using OpenArgs or the code method mentioned immediately above, how then do I apply that to a report or chart title? What would the reference look like for the...

Hi, I am stumped out of my mind. I am trying to use a form control value in the simplest way possible in a report. I have a form as shown below, where a date range determines query values that are displayed in a report as pie and bar charts. When you click Generate Report, this is the code...