Search results

  1. T

    SubDataSheets

    This all got started because we seem to be the only developers that don't have a tool for showing expanded list with indentions.
  2. T

    Modular Design Theory

    CL, Same server, different frontends. When is it the right thing to do?
  3. T

    Modular Design Theory

    Not really planning it. But as Pat said I can see a situation where the user may not overlap. This is what got me going on this. Now that the chemical plant software is converted to SQL, with only a few minor changes to be made, other opportunities for it are becoming available. Mainly, small...
  4. T

    SubDataSheets

    Who likes them? Who doesn't? Why or why not? Thanks
  5. T

    Modular Design Theory

    Doc, thanks for that story. Gina, of course it would include code modules, and everything else needed to be a plug and play. vba_php, Maybe less detail is needed. The question is: When you are assembling a new system from components, how would you decide when to use a second database front end...
  6. T

    Modular Design Theory

    Databases with well developed core functions are useful for many businesses. However, addressing the differences is imperative, and costly. So for these problems we can either create custom systems, or use modules. Not "code modules" actual components that are more customer specific and...
  7. T

    Possible Circular Design Issue?

    Agreed. I use the Relationship Form as visual tool to keep it all straight, I agree I do not use referential integrity unless it will save a lot of cleanup or control code. When you switch to SQL you will have to address those areas, much better to have tighter code if possible.
  8. T

    Possible Circular Design Issue?

    My backends only contain tables and maintenance objects. One thing I do is create is Saved Queries to use in the Relationship Form. It allows you fine tune the display.
  9. T

    Reading Text Files

    I got it. So you could make a Table, or an Array.
  10. T

    Reading Text Files

    Hey Guys, Can anyone tell me what is the purpose of the second variable, please? Dim MyStr1 as string dim MyStr2 as string Open "TESTFILE" For Input As #1 Do While Not EOF(1) ' Loop until end of file. Input #1, MyStr1, MyStr2 me.txtStr1 = MyStr1 me.txtStr2 = MyStr2 Loop Close...
  11. T

    Outlook Integration Subjects Missing from Text Messages

    Correct. And this is what you have to do to remove I Phone Title: Expr1: PlainText([otBodyPlain]) Removes HTML Expr2: Replace([Expr1],"Sent from my mobile. _____________________________________________________________ ","") Removes I Phone Title Expr3: Trim([Expr2]) Removes leading Spaces...
  12. T

    Outlook Integration Subjects Missing from Text Messages

    It's worse then that. Verizon and T Mobile have a Text file with the plain text. this is good for either Android or I Phone Sprint: Android Good the .Body object has no extra code. I Phone Bad: Adds extra I Phone BS It will probably need to be specifically deleted. In case anyone is...
  13. T

    Outlook Integration Subjects Missing from Text Messages

    I guess the solution (work around) is to insert it into a Rich Text field from this object Mailobject.HTMLBody. It's not perfect, but better than a bunch of invisible hard to delete HTML. If anyone has an idea of how to strip the HTML out, I definitely say thank you.
  14. T

    Outlook Integration Subjects Missing from Text Messages

    Using Mailobject.HTMLBody instead of Mailobject.Body to insert the record I get this Debug.Print Mailobject.HTMLBody <html><head><title>T-Mobile</title></head><body marginwidth="0" marginheight="0" leftmargin="0" topmargin="0" bgcolor="#ffffff"><table border="0" width="600" cellspacing="0"...
  15. T

    Outlook Integration Subjects Missing from Text Messages

    I couldn't agree more. The question is how to deal with this extra html code? This might work if the code was VBA. Do While Left(Mailobject.Body, 1) = Chr(13) Or Left(Mailobject.Body, 1) = Chr(10) Or Left(Mailobject.Body, 1) = "" Mailobject.Body =...
  16. T

    Outlook Integration Subjects Missing from Text Messages

    Ok new info: What I'm doing is creating a new local record (Access) in a Long Text (Memo) field. It turns out that changing the field formatting to Rich Text eliminates the line feeds but leave a few spaces. I'll try updating the record with the Trim() function on the table on the table after...
  17. T

    Outlook Integration Subjects Missing from Text Messages

    There are no subjects in Text Messages, I jumped the gun on that.
  18. T

    Outlook Integration Subjects Missing from Text Messages

    Yes and no. I have been using VBA code to remove the line breaks, but I need to use HTML. Got a little more work to do.
  19. T

    Outlook Integration Subjects Missing from Text Messages

    The answer is weird. I was viewing the table with one line displayed. It turns out the text was buried several lines down. This is solvable by removing the leading spaces.
  20. T

    Outlook Integration Subjects Missing from Text Messages

    I looked at an old table and it appears that both the Subject and Body fields have always be blank.
Top Bottom