Search results

  1. Adelina_RO

    OnPaint Event for Form

    Hi people :) Basically i have one question: why does Access repaint each row by a random number of times and in a random order? (Are those two questions... :unsure:) Here is the layout: i have a continuous form where, in the OnPaint event i do some stuff (format some textboxes based on values in...
  2. Adelina_RO

    Method 'Recordset' of object '_Form_FisaApt' failed (run-time error 2470)

    Here is an interesting question. I have a form with a subform bound to a ADO recordset. I set this like so: Set Me.Recordset = cMED.Execute("CALL `FisaApt_C1`(0, '" & ADO_Path(CurrentProject.Path & "\PNG\") & "')") - and it works just fine. Then, on the parent form, i have a textbox which acts...
  3. Adelina_RO

    Solved Form with ADO recordset not showing correct filter

    Hi again :) Here goes: I have a continuous form to which i set the Form.Recordset property at runtime based on a ADO recordset which runs a saved procedure on a MariaDB server like so: On Error GoTo Eroare SQL_SVN_OC 'function that checks if the public ADODB.Connection is running and restores...
  4. Adelina_RO

    Simple yet complex close form problem

    The setup: I have a main navform with a few navsubforms. In one of them, depending on what the user clicks, some textboxes turn red or green. Te problem: when i navigate away from the said subform, access is asking if i want to save the changes to the form or not. I want to disable this message...
  5. Adelina_RO

    Navigation Control BrowseTo Error 6054

    Hi people :) I return with another question that has me stumped... I have the following setup: Main Form (A) -> NavigationSubform with two forms (B and C) -> SubForm B -> NavigationSubform with two forms (B1 and B2) -> SubForm C -> NavigationSubform with three forms (C1, C2 and C3) I...
  6. Adelina_RO

    ADO Query based on MariaDB

    For the last 17 years i've been using DAO recordsets and i LOVE them, but recently i got a new project which has the BE on a MariaDB server. All fine and dandy until this issue: I have a simple "Select * FROM" passtrough query which doesn't see changes made to the underlying table. I've tried...
  7. Adelina_RO

    Access query design window

    Here goes another question, for you guys: is there any way (even if i need to modify the windows registry) to change the default size of the query design window? As it is, it opens all over the screen, and if i have the Properties window visible, it goes beyond that too...
  8. Adelina_RO

    Solved Access Pass-Through MariaDB

    So, here it goes: i've been using Access since the 97 version (yeah, I'm old...), but only recently i had the need to use a MariaDB server as the backend and I'm stomped... I've been trying to make a pass-through query to append some rows in the said backend to noavail... This is the...
  9. Adelina_RO

    Hi! I'm Adelina and I need some help :)

    So, here it goes: i've been using Access since the 97 version (yeah, I'm old...), but only recently i had the need to use a MariaDB server as the backend and I'm stomped... I've been trying to make a pass-through query to append some rows in the said backend to noavail... This is the...
Top Bottom