mike60smart's latest activity
-
mike60smart replied to the thread 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... -
mike60smart replied to the thread Solved What causes a sub form being locked?.Here with modified db
-
mike60smart replied to the thread Solved What causes a sub form being locked?.Is this what you need to achieve??
-
-
mike60smart replied to the thread 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.
-
mike60smart replied to the thread 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...
-
-
mike60smart replied to the thread Solved filter \ sort in continuous form.Glad to help
-
mike60smart replied to the thread Solved filter \ sort in continuous form.Hi Check this version
-
mike60smart replied to the thread 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...
-
mike60smart replied to the thread 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...
-
mike60smart replied to the thread 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...
-
mike60smart replied to the thread 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
-
mike60smart replied to the thread 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...
-
mike60smart replied to the thread 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.
-
mike60smart replied to the thread 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.
-
mike60smart replied to the thread 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.
