Search results

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

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

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

I have a table called FundLedger. The primary key field is FundLedgerUID. Other fields I am using are AccountID, GiftReceivedDt, and DeductibleDonationAmt. I am trying to write a query that will give me the FundLedgerUID for the earliest GiftReceivedDt for each AccountID. The reason I have to...

I have a query with 4 fields - Account #, FiscalYear, GiftReceivedDt, and Total. This is a list of donations that people have given to the college where I work. Each row has the account # of the giver, the fiscal year in which it was given, the exact date it was entered, and the amount given. I...

I am a musician by trade, but I learned to use Access at an Office job by necessity and got very good at relational database design and thinking - tables, queries, forms, reports, and macros. Now I have some side work for my current employer (a small college) mining our current database using...