Search results

  1. K

    invalid operation after split-database

    My database was working fine before an access back-end was created. I was able to click buttons on the form that took me to other forms. Now after the database was split, when I click the buttons, I get an "Invalid Operation". Here is the code behind the button. Does something need to be...
  2. K

    Problem with DB_OPEN_DYNASET after split db

    Hopefully I make sense when trying to explain this.. Before I split my database into a front and backend, the code blocks listed below worked fine and the buttons on the forms did what they were suppost to do: Dim MyDB As DAO.Database, Mytable As DAO.Recordset, x As String Set MyDB =...
  3. K

    Problems setting button visibility

    I have a maintenance button on a form that I want to be visible/invisible based on user-level security access. However for testing purposes in the form_load I set the button to be invisible, but it is still visible. Here is the code: Private Sub Form_Open(Cancel As Integer)...
  4. K

    Enable/Disable button from Module

    I know "Me.btnMain.Enabled = False" will work in the form that the button is in. However, what code can I use to enable/disable a button on another form from a module?
  5. K

    Error using DLookup to retrieve from another form

    I have two forms (form1, form2). Form1 has a combo box named "Owner" which lists locations. I want a textbox in form2 to update with whichever location the user chooses from form1. Im using the DLookup function: =DLookup("[location]", "tblAddress", "[location] =" & Forms![form1]!Owner) Any...
Back
Top Bottom