Recent content by bengiomanni

  1. B

    Accessing Emails via Outlook View Control

    That link no longer exists. Anyone have anything else?
  2. B

    Outlook View Control Access 2010

    I have done a lot of research on using an ActiveX Outlook View Control, but all I can find are posts about Access 2007 where the view control is inside a frame. I'm using Access 2010 and I don't see why I should have to use a frame if there is a separate OVC in the ActiveX list of controls. Can...
  3. B

    Outlook view control and creating appointments over several days

    This is quite a bit later, but you guys mention that you use the Outlook View Control. I'm using Access 2010 and I am digging around everywhere trying to find information, but there is almost nothing, and the link I see everywhere for Microsoft documentation leads me to a dead end. Do you have...
  4. B

    Better approach than DSUM for running subtotals on query field

    Right, but I don't know how to rework it with your suggestion.
  5. B

    Better approach than DSUM for running subtotals on query field

    I am having the same problem with this query. Could you show me what you mean? I have a single query based on a linked table from an SQL server. I am pulling several fields, and then creating a calculated field with a running balance [FiscalBalance]. The query by itself actually comes up...
  6. B

    Outlook Email is minimized!!

    Sorry for my long delay in responding. I am off and on with these Access projects right now (sometimes VERY off for a while). There isn't anything that involves user interaction in the call method, except for the fact that the code is in the OnClick event of a textbox on a form. Is that the issue?
  7. B

    Disabled ribbon randomly shows up

    Sorry I never responded to this. My project work in Access is such that I am off and on with sometimes long delays in between. I don't understand your last sentence. How can I force the reloading, and when/where would I trigger that?
  8. B

    Save Outlook Email as link in Access tbl

    Hey TallMan, did you find your answer through these links? I am interested in the same thing.
  9. B

    Disabled ribbon randomly shows up

    The only callback I have for the ribbon is for a ribbon named "Report" that is in the Ribbon Name for the one report I have in the database. I had no callbacks for the datasheet subforms at all. After I had the problem, I added my Main customized ribbon name to the Ribbon Name property of those...
  10. B

    Disabled ribbon randomly shows up

    I can't post the database because the information in it is confidential, but I actually discovered something after I posted it. When a subform is in datasheet view and it is current, it seems that this was actually overriding my XML code for the ribbon and showing the Datasheet group tools in...
  11. B

    Outlook Email is minimized!!

    Re: Outlook Email opens behind Access I just amended my title for this because I realized that the email is opening, but it opens behind Access. I would like for it to open on top of Access and I can't figure that out. Here is the code I am using. Public Function SendEmailDisplayOutlook(MsgTo...
  12. B

    Disabled ribbon randomly shows up

    I have disabled the Ribbon using XML code in the USysRibbon table. Everything has worked fine, except that now when I click on two different tabs that exist on my form, the Form Tools Ribbon pops up with options to go to Layout, Design View, etc., and other options, too. I have two subforms on...
  13. B

    Outlook Email is minimized!!

    Outlook Email opens behind Access I can successfully create an email with VBA code and it works great. The problem is that email only appears down below - minimized in the Taskbar. I have searched and searched but cannot find an answer to this. The SendObject command will open the email up...
  14. B

    Return the value of one field in a query based on other query fields and calculated c

    I thought I would try dumping the data from my totals query into a table to see if I could run a new query faster off of that to find the dates where the total is $1000, but when I ran the query below, it took over 10 minutes and nothing happened. SELECT dbo_FC_FundLedgerUnion_View.AccountID...
  15. B

    Return the value of one field in a query based on other query fields and calculated c

    Ok. Thanks for that tip. Now I have a new question. I modified that query and named it qryFundLedgerRunningTotals. But now I want a new query that will give me the GiftReceivedDt for each Fiscal Year where the Fiscal Balance reached $1000 or more. Here is what I have, but Access is taking so...
Top Bottom