Search results

Hi All Looking for an experienced Access developer (Aberdeen or anywhere in Scotland) to improve two Access applications. Both are for CMMS Maximo. One for equipment hierarchy, second for maintenance. The scope includes: Joining these into one database (plus a separate file with linked data)...

Hi there See below part of my query result. I would like to display the count of custom concatenated fields 'concat2' as another field. So the new field would be 2 for every row. I tried various ways but no luck so far... | Operation | concat2 | 10 | RUATAC14 50000038 | | 20 | RUATAC14...

Hey I need to find all MaintItems which field MIC don't exist in either MIC1 or MIC2. So the only result which I need to see is MaintItem '5100161086' as MIC <> MIC1 Unfortunately I can create query which would approve '5100662734' as well MaintItem ------MIC------ MIC1 ------ MIC2 5100634036...

Hello again experts Im strugling with accessing a subform via VBA which is placed on another form on a tab control. So the form Im looking for is called: 'TreeLevels subform'. It is placed on form: FormTagValidation which is on tab control's ("TabCtl0") page - 'Validation'. Tab control is on...

Hi there I have a form with datasheet view and I need to make user that user fills in all fields before he moves on to the next row. Any idea how to catch the moment of moving to another row? /:banghead:

Hi there Im trying to build a subsystem treeview. So I'd like to build a treeview For selected node's children only. I thought I could do that by building hierarchy levels in another field called 'Sublevel' in my treeview table. So macro works like: clear all existing sublevels (not done yet)...

Hi there I'm hoping to hear some good ideas not necessary a ready solution. Discussion would do :) First column of mainform consists of links(strategies' names) opening a subform for each row(strategy). Clicking first will open the subform attached Than from subform I can send current...