Recent content by yahoo

  1. Y

    Access developer wanted

    how can I contact you?
  2. Y

    Access developer wanted

    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)...
  3. Y

    another countif issue

    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...
  4. Y

    find if value exist in either of 2 fields

    that doesn't work unless I fill MIC2 empty cells with some string
  5. Y

    find if value exist in either of 2 fields

    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...
  6. Y

    Problems with accessing datasheet subform on a tab control

    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...
  7. Y

    Check if all fields in new row are filled in

    well Ive done a lazy one :P Private Sub Form_BeforeUpdate(Cancel As Integer) If "" & Me.[Drawing Ref] = "" Or "" & Me.Grid = "" Or "" & Me.[Object type] = "" Or "" & Me.Status = "" Then MsgBox "Please enter data in all fields" Cancel = True End If...
  8. Y

    Check if all fields in new row are filled in

    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:
  9. Y

    sub treeview

    thats sorted now thanks to one of your previous post (dont have rights to post links) I already have a nice treview built (for all data), but I want to allow user to clear existing tree and create a new one with selected node as a root node. I build my trees basing on hierarchy levels. So first...
  10. Y

    sub treeview

    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)...
  11. Y

    Looping through subforms

    So all I need to do is change references from me.form... to current 'byVal strategy' and call exportToWord macro for every run thx
  12. Y

    Looping through subforms

    that would mean redoing the whole export to word code which is really complicated. I'd rather avoid it ;) If i do this, I would write a new separate printing macro(looping (ADODB.Recordset) through strategies from current (user input))batch. I hope there could be a smarter way...
  13. Y

    Looping through subforms

    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...
Top Bottom