Search results

  1. mike60smart

    Prorated help please

    It would help if you can upload a copy of your actual database with some non confidential data
  2. mike60smart

    Prorated help please

    Hi Welcome to the Forum This Link provided by Gasman will start you off
  3. mike60smart

    Estimate form with more than one entry

    Hi Jill Your problems are down to bad design. The Estimate has many details so you need to structure the Report so that the Main Estimate details are contained in the Report Header with all of the Details in the detail area.
  4. mike60smart

    Solved What causes a sub form being locked?

    Hi Pat My apologies for not saying what I did. The Op stated that they wanted to select Multiple Records. So I removed the subform and created a Listbox which was set as Multi select
  5. mike60smart

    Solved What causes a sub form being locked?

    Here with modified db
  6. mike60smart

    Solved What causes a sub form being locked?

    Is this what you need to achieve??
  7. mike60smart

    Solved What causes a sub form being locked?

    If you remove all of the Events from Both forms you are then able to do what you want.
  8. mike60smart

    When you choose a year in the form fill in the right records

    Hi Your 1 table is not normalised as it contains Repeating Groups. The fields listed below should be Records in a Related Table and not fields in this table. USENET USENETbegindatum USENETeinddatum USENETlogin
  9. mike60smart

    Solved filter \ sort in continuous form

    Glad to help
  10. mike60smart

    Solved filter \ sort in continuous form

    Hi Check this version
  11. mike60smart

    Solved filter \ sort in continuous form

    Hi This solution is based on your previous database. The form that opens is set as a Split Form and there is an Unbound Textbox in the header. Just type the data you want to filter by and hit Enter and it will filter for that data. The Clear Command button returns all data.
  12. mike60smart

    Extra columns on export query

    Hi Rick Your 1 table approach is not how Access works. You have Employees who work at various locations. You therefore need to normalise your Master table.
  13. mike60smart

    Solved nagivation control. where clause = new record

    See if the attached works for you. I put the following in The On Click Event of the Button Private Sub NavigationButton186_Click() 10 On Error GoTo NavigationButton186_Click_Error 20 DoCmd.OpenForm "FRiskPage" 30 DoCmd.GoToRecord , , acNewRec 40 On Error GoTo 0...
  14. mike60smart

    need formula \ code advice. min date

    Hi If you base the Main Form on a Select Query then you can add the criteria. See the attached FRiskPage
  15. mike60smart

    A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control

    Hi It does not involve a lot of work, you just select the Object ie Tables and click Select All, Do this for all Objects and that's it. Just 10 Clicks and you are done. If you try it and the problem still exists all you have done is waste approx 5 minutes.
  16. mike60smart

    A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control

    Hi No You have to Import all Objects - Tables / Forms / Queries/ Macros /& Modules. This has fixed this error for me in the past.
  17. mike60smart

    A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control

    On The Customers PC create a new blank Db and then carry out an Import of all objects from the Db giving the error.
  18. mike60smart

    Solved Access not displaying properly

    I know that someone with 2003 version needs to open the Db but I opened with Access365 to look for anything unusual.
  19. mike60smart

    Solved Access not displaying properly

    Was able to open using Access for 365. Saved in 2000 Format attached
  20. mike60smart

    Issue with Dlookup- Help Please!

    Why is the Combobox Unbound ? Normally the table would have a field named GradeID - Number datatype. Then you would have a separate table that lists all of the Grades. On your form you would create a Combobox and you would lookup the value you want from the Grades Table.
Top Bottom