Answer Questions

• SamuraiDan Save/Load pivottable or toggle auto pt refresh when fields added?

  Using Excel 2000 and OLAP (AS2005), I'm looking for a way to possible Save/Load pivottable view. I see that OWC has something like this, but I'd need to rewrite a lot of my code and lose some of excel's extended functionality (ie, conditional formatting. show the color red if a value is negative) or another solution would be to toggle the automatic pt refresh that happens when fields added. What I mean by this is when you drag a field onto the pivottable, the pivottable is automatically refreshed. I don't want this to happen when each field is dragged onto the pivot table, but rather call a refresh after I've added all my desired pivot fields. ...Show All

• Chris Honcoop IIf function within MS Access

  I am trying to do an IIf function within a form in access, but I don't think the syntax is correct. When I view it in form view it just displays the actual formula and not the answer. Any suggestions =IIf([txtRawMaterial]= "MA"," Sum([Blocks])*50","Sum([Blocks])*55.115") Thanks! Hi I assume that you have created a text box for you field, is the formula in the Control Source in the properties, or have you typed it as text in the box If the formual is not in the Control Source try typing it in there. ...Show All

• SteveMargolis MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Hi to all! At me a problem with installation Microsoft Office Document Image Writer under Windows 64-edition SP1 with Office 2003 Pro full instalation. On a step 3 at me in the list is not present Document image printer writer port. Somebody faced a similar problem ...Show All

• Ray Dyce Disable events in userform

  Is there a way to disable Userform events within Userform code I am trying to dynamically set scrollbar.max without triggering the Scrollbar_Change event procedure. Hello Joe, I was a bit curious and tried the following: Private Sub CommandButton1_Click() MsgBox ("Command Click") UserForm1.ScrollBar1.Width = 20 UserForm1.ScrollBar1.Max = 100 End Sub Private Sub ScrollBar1_Change() MsgBox ("In Scroll Bar Change") End Sub Private Sub UserForm_Initialize() MsgBox ("In Initialise") UserForm1.ScrollBar1.Max = 15 End Sub The only time the ScrollBar_Change event is triggered is if I clicked on the scroll bar, or the up/down arrows of the scroll bar. The command butto ...Show All

• arro239 Excel COMBOBOX data sources

  Is it possible to use access tables as datasources for excel comboboxes or for in-cell list boxes I don't think it is but I had to ask. To clarify. some cells in my sheets have listbox attributes. Normally the source for this is a field in the same sheet. With a combo box, the source can be a different sheet in the Work book. Is it possible to use an Access table as a data source for either of the aforementioned controls Niall Hello Niall, It is possible to read an Access table using ADO in Excel. I suppose then you could read the records of a table and use them for your combobox. Chas ...Show All

• jerrykur Hide/unhide

  I have a button that when the user presses the button the program will search an ordered column for values equal to 0 and hide the rows that has values equal to zero. If the rows already are hidden then they shall be revealed by pressing the button. My code is: Sub showHideButton_Klicka() Dim relativCell As Range Dim i As Integer, j As Integer, k As Integer Dim blnFirstFound As Boolean, blnLastFound As Boolean, blnIsHidden As Boolean Set relativCell = Worksheets("Berakning").Cells.Find("Rel.", LookIn:=xlValues) 'hittar forsta och sista cell med varde 0 Do Until IsEmpty(relativCell.Offset(i, 0)) = True Or blnLastFound = True If blnFirstFound = False Then If relativCell.Offset(i, 0) = 0 Then blnFirstFound = True k = i ...Show All

• pu132 SheetFollowHyperlink event

  Hi, I have code for the SheetFollowHyperlink event in the ThisWorkbook object. Code: Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink) ActiveWindow.ScrollRow = ActiveCell.Row With ActiveWindow .DisplayHeadings = False .DisplayGridlines = False .DisplayWorkbookTabs = False End With End Sub For some reason this works on some computers but not others. I.e., on some computers, whenever I click on a link, it correctly moves the target cell to the top of the screen (the first visible row). On other computers it displays teh target cell at the bottom of the screen (the last visible row). Could anyone explain/help Thank you, Kriti ...Show All

• Grahame Edwards ADO trouble

  here goes, I have created a database with username and password that excel uses to loggin user with different sign in provileges. in this database i have two tables, [USER with all usernames and password] and [GROUP containing the different user levels]. The USER table contains 4 different recordsets columns, ID, this is an autonumber LOGIN_NAME, this is the loggin name (e.g mine is MPTL) USER_NAME, this is the full name of the user PASSWORD, the password is encrypted for security GROUP_ID, this is the user level (1 is System Administrator and 2 is System User) The GROUP table contains 3 recordset columns ID, this is an autonumber Name, this is the user level (e.g System Administrator) and BITWISE_I ...Show All

• Landon Parks Assign an array to .values and .Xvalues in an excel chart

  Hi, I'm having trouble with assigning arrays to a chart. Below is how I done. Anyone nowing how to make this work     Set MyDispl = Application.InputBox(Prompt:="Select displ.", Type:=8)     Set MyForce = Application.InputBox(Prompt:="Select force.", Type:=8)     Do '''Collects Displ data             plot_disp(i) = MyDispl.Offset(i, 0)             i = i + 1     Loop Until IsEmpty(plot_disp(i))           Do '''Collects force data                ...Show All

• one_pom Sending e-mail from within VBA

  We have an application that makes heavy use of the capability to send out email. The application is written in Access, and we use the local Outlook client to send mail through the client's Exchange server. This has worked fine so far. However we now have a need to send email from the same machine, but make it look like it came from a different account (i.e. email sender). In realtime Outlook, you can define multiple accounts in your Outlook profile and can easily switch between them, so that the From address reflects the underlying account set up. After hours of searching, it seems that from vba you can control almost everything about an e-mail EXCEPT make it send from a different account. Any Ideas Thanks, -Rob ...Show All

• Poledog What language was Microsoft Word developed in?

  Just out of curiosity, does any one know what language Microsoft Word was developed in Thanks, msv6 Cool. Thanks a bunch! Hi, I'd say it was written in Visual C++ (MFC) but that's a guess. I'm saying that because Visual C++ (MFC) is very much geared towards the document/view architecture ala the Word Document and the Print Layout view. ...Show All

• Ogulcank pos peripherals from vba

  I want to use point of service peripherals from vba in ms access, as I am creating a point of sale database. I downloaded pos for .net sdk. I then tried to reference its main library (microsoft.pointofservice.dll) from vba (by going tools>references), but it wouldn't let me, it said it couldn't create a reference to the file, which is a dll. How can I link to the pos peripherals from vba I don't have a C++ compiler, so I can't write a wrapper, right Where could I find an unmanaged version Hi, The .Net DLL is a managed DLL. So you can't directly link it to VBA. What you can to is try to find a ...Show All

• Puca Can't open regedit

  Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks First do a search to see if your copy even has it. Click search, type regedit.exe. If it shows up then click run, type in REGEDIT I had this same problem til one day I used caps. So, in the run box just type REGEDIT No period, no exe. Odd, but it worked for me. The dutch version would be the same globally. I am wondering if you click start- then run- then type in regedit if you are using capital letters instead of lower case. For exam ...Show All

• Nicw Live Communicator TAB not shown

  I have the same problem with my AD. The LCS is installed on a AD server but the tab is not shown in user's properties tabs. I've already done all tests you did before but with the same result. Did anyone solve this problem thanks!! you should install lcs administrator tools--on the lcs installer cd. ...Show All

• Trevor Kennedy Prepare a list in excel for printing

  Hi, I have a two column list in excel with about six thousand entries. I want to be able to print it out in four columns. I am trying to write a macro that would go down the list for 47 rows and print it into the first column and then go down another 47 rows and print it into the next column etc. After the first four columns are done I want to offset the printable list down about five rows and do it all over again. I just can't seem to understand the range and offset routines to help me do this. Can anyone give me a quick looping macro Would appreciate it. Thanks (and an email to me at nsheff@aol.com would help) Hello nsheff, The following should do it. Your original data needs to be in two ...Show All