Search results

  1. J

    How to sum date/time field

    Hello everyone! I have a problem to solve: how to sum a date/time field inm access? I have a table with multiple fields, one of them it's the "Hour" field. When I apply the total option, I want to sum the total of hours in that fiel. I want to obtain the 09:00 result. But the accesss gives...
  2. J

    Filter a Calculated Field in Datasheet View

    Hello everyone, I have several calculated fields in an Access form. When I select the datasheet view of the form, Access does not let me filter the calculated fields. The calculated fields are based on the table linked to the form. Is there any chance to filter these fields in the datasheet...
  3. J

    Embed Power BI Reports into Access Forms

    Hello everyone! I need some help. I'm developing an MS Access Project, and I need that a specific form uses a WebBrowser Control. That's the easy part. The hard part comes next: I need that WebBrowser Control shows me an webpage that have a Power BI report (it's embedded in a sharepoint online...
  4. J

    Solved Want MS Access to notify me if a record already exists

    Hello Everyone and Happy New Year for You! I'm working on in a new project in MS Access. I need that MS Access notify me if a record already exists when I insert new data in the form, in this case the field "Cod". I attached an simple database example to show you the error that Ms Access...
  5. J

    Power BI with MS Access

    Hello everyone! I want to insert an Power BI report inside my MS Access system. Is it possible? ThankYou. Best regards.
  6. J

    Solved Can´t drag a table into the form

    Hello everyone! I have a recent problem with MS Access 2019: I can't move a table or query into form in design view. When I try to drag the table inot the form appears a circle with a line in the center. I don't why it is happening because I was previously able to do that! I post a photo to show...
Top Bottom