Search results for query: *

Hello, My 2007 Access db(created in version 2003)now shows the custom toolbar in Add-In ribbon. Where does the source file for these objects reside? If I select Add-Ins under Access Options, all I see is one Inactive COM add in named ACECNF.dll; not a clue as to where the add in objects reside...

Hello, Trying to get text boxes in Access 2003 to justify like MS Word. However, it always truncates a sliver of the right-most lettering. Thanks for the input.

Hello, Using VBA to draw a circle, I am trying to make the circle thicker, 1pt width. Right now it draws a hairline thickness and the printer I have spots out in certain places. Here's a portion of the code ...I tried something like Me.BorderWidth = 1, but does not work. Dim ctl As Control...

Hello, Within a label, I'm trying to return 1/2 the vertical space such that the spacing between printed lines is less. I know I can create multiple labels and bump them up etc, but I've got like 75 to do-it's a text-heavy report. Many thanks.......Mickey

Hello, Trying to avoid creating a mulitude of labels that adhere to the dimensions of a word document. The font is Callibri 7.5 in Word(Access font size only shows 7 or 8) but the kicker is the carriage returns are more narrow in Word. Essentially, when I want a new line i hold ctl button ...

Hello, If a record in underlying table is null, the associated radio button on report shows a grey opaque-like fill. Is there anyway to make this white, ie transparent? Many Thanks.......Mickey

Hello, I'm having trouble trying to get the check mark inside a radio button centered on repors. Any suggestions? I'm using Access version 2002. Many thanks.....Mickey

Hello, I'm trying to show 2 sub-reports within a main report. Each sub report has an embedded image in Picture property. When I preview the subs themselves in desing mode, I can see the image, however when part of the main report, all I see are the objects/data but no embedded image. Any...

Hello, I'm trying to get two unbound radio buttons to enable(i.e. fill in) upon retrieval of a report according to boolean value of a field in a particular record of report's bound table. Since this is a report, I'm not sure how this works Thanks.....Mickey

Hello, Using version 2002 and trying to print a report that has a picture spanning 53CM long - which should equate to 2 pages. However, only the first page appears when I print preview or print. If I crop the original image to 26cm and re-embed, then it works, but I cannot get the entire image...

Hello, I am looking to combine the following two formulae into one.. =DATE(YEAR(A1),MONTH(A1),1) 'This yields date - 10/1/2009 =WEEKDAY(B1)'This gives me an integer - 5 But I cannot figure out how to combine the logic into one formula. Any help is greatly appreciated. -Mick

Hello, I would like to expand the first column of a dialog box?open to be precise, using keyboard shortcut. I thought there was a way to incrementally expand/collapse the column using a combination of alt/ctl & '+' '-' keys. Many thanks......Mickey

Hello. I cannot find a keyboard shortcut that takes me to the previous position within a workbook. Does such a shortcut exist? I do alot of back and forth navigating in a workbook that has over 100 tabs and it would be nice to move to previous position. Thanks....mickey

Hello, I am trying to assignt the following formula to a cell, but keep getting above error on the last line...Cells(i, 5).Formula = strFormula. I've tried with and without Formula property and it does not work. Hard coding values or a simple "=a1+b1" works, but for some reason does not like...

Hello, I am aware that MS has discontinued the Data Access Page functionality in version 2K7, but I need some direction to construct a company-internal(intanet?) web page that pulls data from Access 2K7 db. The data is ultimately sourced from Windows Active Directory, but maintained/edited in...

Hello, I am using Excel 2007 and cannot find the 'Edit MS Query' option in the context menu of a pivot table. How can I access this through the GUI? With VBA I see it clearly in the Immediate Window... ?ActiveSheet.PivotTables(1).PivotCache.CommandText SELECT tblFinReporting.Type FROM...

Hello, The following code resides in an Add-In on Excel 2007/Windows XP. I simply want to import .bas modules in the current workbook, via custom menu event driven functionality(included below the ImportModules() subroutine). If I step through this code, it works fine, but triggered from custom...

I receive error 1004 Paste Method Failed when trying to run a routine from an Add-In, however on a local file it runs fine. Here's where it breaks. Set ExclApp = New Excel.Application ExclApp.Visible = False Set xlWkBook = ExclApp.Workbooks.Add(xlWorksheet) xlWkBook.Sheets.Add...

Hello, In an .xla file, I am trying to pass an argument to a subroutine via .OnAction property of CommandBars(1).Controls.Add. This is what I have and it runs fine With newMenu.Controls.Add(Type:=msoControlButton, ID:=1) .Caption = "Transpose Working Forecast" .OnAction =...

Hello, In the Axis Options window, I have Major Unit set to fixed by Month = 1. What I get is 2/1/09, 3/1/09 etc... What I'd like to see is the last day of prior month, ie 1/31/09, 2/28/09. Is there a property setting I can tweak to accomplish this? Thanks so much.........Mickey