Search results

  1. J

    Form with pages -- controlling where new field goes

    I have a form with multiple pages/tabs (see attached). If I copy a button (or other control), it goes to the detail and appears on every page, even if I move it to a specific page. Is there a way to convert a control on the detail to a specific page?
  2. J

    Update local table from remote db

    I have 2 databases that I want to have run the same module, and update local tables. db1: contains universal module db2: calls module in db1 to update local tables db3: calls module in db1 to update local tables This way, if I need to make a change to the module, I can just make the change in...
  3. J

    I Keep Getting Logged Out

    Every time I open a new tab, or go to new page, it seems like I'm logged out and need to sign back in comment. Wassssup with that???
  4. J

    Save or Load Forms

    "Use Themes" was introduced in 2010, but it doesn't transfer when you copy and paste a form. Since I sometimes make substantial changes to my test database and would like to just transfer the whole form to Production, I wrote the attached procedures.
  5. J

    Save and Load Forms as Text

    The latest version of Access strips important information (such as whether a Theme is used) when you copy and paste a form or control. In order to avoid this, I created a module that would let me save and load one or all of my forms. This way, if I make multiple changes in a form, I can save...
  6. J

    Access VBA not changing Word Font.Color

    I'm using Access to change value in a Word document and I want to change the font color to red for numbers less than zero. Here's my calling code: Set oWord = CreateObject("Word.Application") oWord.Visible = True oWord.Activate Set doc = oWord.Documents.Open(fpath & "AF Final Costs Notification...
  7. J

    New to AW, not to ACCESS

    Hello all. I've been working with ACCESS, as well as EXCEL, WORD for quite some time, as well as VBA for all three. I'm largely self-taught but owe a great many thanks to forums like this!), I enjoy reading for pleasure and watching TV with my sweetie, here in Los Angeles, CA. Good to...
Top Bottom