CJ_London's latest activity
-
CCJ_London replied to the thread Solved row number in subform.You would need to include in your dcount criteria the form filter - presumably the subform link master value so would be something like...
-
CCJ_London replied to the thread Solved Transform Columns in multiple rows.you can use two crosstab queries, one for starting date, the other for ending date. Then join the two together. You would need to...
-
CCJ_London replied to the thread DAO to ADO.It’s been a while (although I use disconnected recordsets for a number of things) so perhaps things have changed but that is my experience
-
CCJ_London replied to the thread DAO to ADO.Be aware that reports do not work with ado recordsets and some form functionality such as filter and sort will generate an error...
-
CCJ_London replied to the thread Is this possible.Depends on what you are counting- a shelf stacked 5 items high by 4 deep by 10 wide? You really expect the user to effectively unload...
-
CCJ_London replied to the thread Access When emailing brings up Outlook 2016 wizard to add email account.Not just Access - also those who use macros in Excel and Word have the same problem
-
CCJ_London replied to the thread Access When emailing brings up Outlook 2016 wizard to add email account.Old outlook is now called classic outlook. In the search bar on the taskbar type ‘classic outlook’. Huge number of links out there for...
-
CCJ_London replied to the thread Expanding related tables and splitting database.Just read your introduction- so the design principles are much the same as web development- only bring in the data actually required to...
-
CCJ_London replied to the thread Expanding related tables and splitting database.click on the table click on create in the ribbon select More Forms select multiple items do this for the main form, then your subform...
-
-
CCJ_London replied to the thread Solved form in navigation pane... is a pain ?.or if you are referencing it from within the navigation form subformcontrolname.form.comboname
-
CCJ_London replied to the thread Closing all MDI child forms when Ctrl-F4 not available.What is the file extension? if .mdb or .mde it should be possible to view tables and queries - and with .mdb the forms and code as well...
-
CCJ_London replied to the thread Solved Access Database Locking Issue.If it is only locked to other users when another user already has it open, I’m not sure read/write permissions to the back end folder is...
-
CCJ_London replied to the thread Solved Access Database Locking Issue.That suggests something to do with settings - probably being opened in exclusive mode as a default - in access on those machines go to...
-
CCJ_London replied to the thread When accHitTest generates an 'invalid procedure call or argument' error.actually you are probably right, I wasn't thinking it through....
-
CCJ_London replied to the thread When accHitTest generates an 'invalid procedure call or argument' error.Thanks for the clarification - so not a win11/365 or 64bit issue as I didn't experience it with win10/2010/32bit - but then I didn't...
