Recent content by MatthewB

  1. M

    Tabs within Tabs

    Before I dive deep into this question with details, can I create a Form_B that has a Tab Control with sub-forms, and then on one of the Form_B Tab Control Pages have another Tab Control? Thanks
  2. M

    Cannot Save as

    I will check.
  3. M

    Cannot Save as

    Yes, I can save the file. It is when I try to change the name.
  4. M

    Cannot Save as

    I am trying to save a db as another name. I get the error message; ! Could not find field 'kf_82_Services_ID' I do believe Access might be say, "you have a reference to this field that no longer exists" . Could this be right? How would I find this reference? Thanks
  5. M

    Tables - Multiple Instance - Why do this?

    thank you. Your example is interesting. So what happens, or what disadvantage is there if you point BillToState and ShipToState to the same Table instance? Any?
  6. M

    Tables - Multiple Instance - Why do this?

    Can one do this as a way to create less of a spider web in the relationships window?
  7. M

    Tables - Multiple Instance - Why do this?

    When building relationships in the relationship window, it is possible to add multiple instances of a table. Generally they look something like this; Contacts_T_1, Contacts_T_2, Contacts_T_3., ect... Why add multiple instances of a table? Are these instances related. So for example if you have...
  8. M

    Background Color on a Continuous Form - based on Boolean

    Okay thanks GTH Let me add. If I set the Form![BackgroundColour].Back Style = Transparent , the conditional formatting (which changes [BackgroundColour] to the specified colour based on the state of the boolean Form![Completed]) does not show the colour. Presumably this is because the Property...
  9. M

    Background Color on a Continuous Form - based on Boolean

    Yes. In the example db I provided the concept works. When I try the same setup on the db proper it does not work. I cannot understand why. I have noticed is that the concept works if I make the BackgoundColour field property Back Style - 'Normal'. Then my conditional formatting...
  10. M

    Background Color on a Continuous Form - based on Boolean

    Yes, that does not work. To clarify. A continuous form has a property that allows one to alternate the row background colour. This is for ease of reading. If I create a 'Background' field and size it to the row the alternate property is lost. So it seems to me I need to write a code that makes...
  11. M

    Background Color on a Continuous Form - based on Boolean

    I have a continuous list with a field (boolean) [Completed]. When I check it the conditional colour changes. This produces a visual sort of task completed. It only works if background colour of my [Background] field is 'Solid', not 'Transparent'. So I need to write an Expression that says...
  12. M

    A list within a list

    Here we go again :) I have a form with a subform in a parent child relationship. The subform is a list of tasks associated with a building. (wash the windows, fix a hole in the wall kind of thing). I want each task to have a collection of notes - short texts. This way I can make notes of...
  13. M

    The object doesn't contain the automation... timestamp

    Okay, my apologies to all. I think I had created a macro to set the property, but the table default Now() did this - it set the timestamp. So I had a completely purposeless macro. I deleted it. Error no more.
  14. M

    The object doesn't contain the automation... timestamp

    Okay. I will try send the db but this mean redacting the data. It not like banking info I have but privacy is privacy. Just a lot of work .
Top Bottom