Answer Questions

• LJry VB Postgres connection problem

  Hi I am using postgres 7.4.0. I have developed an application,  I am having a debtor table in which around 55 lacs of records are there. I have debtorid as a primary key. I am using like query to filter a data and display the data in the grid. Where as when I am debugging an application it took comparatively less time to execute it and to display data. Where as after compiling it and creat ...Show All

• BryanKinkel Property to evaluate heading value of Access Chart

  Not sure if I have all the right lingo down, since this issue is somewhat difficult to explain in words. But I am having an issue finding the Property or Method that will let me look at the value of the column header of the SeriesCollection when manipulating a graph through VBA. I have a stacked bar graph and I need to set each series backgound color based on the column heading value.  The heading value I am referring to is the colum ...Show All

• Atriplex create command button that holds a procedure to another workbook

  I have a code to create a chart and put it in new workbook (then i "save as" AdvanceReport.xls). Assume that the current workbook i'm working on is oldWb, and the new workbook as newWb. The first sheet in the newWb contains the data and additional information about all charts. I need to add command button that holds a macro to copy all chart from excel to word in newWb's first sheet. I made the code already,that is: The code to create c ...Show All

• babysox76 VBA Mail Merge Question

  This past week, I wrote a bit of VBA code to help me automate mail merges with Word and Excel. It works really well, but I ran into a piece of behavior that Word exhibits that I would like to change. I was hoping someone can tell me how to do it, or at least point me in the right direction. I have 10 Word documents. The documents never change. For each document, I wrote a query that pulls the mailing information fr ...Show All

• Joel Pobar Publishing Scorecard in BSM

  Hi all, I installed business scorecard server and builder in the same sharepoint server and installation went well. I did a sample scorecard and published it. I clicked "Publish All" and it went through. Where do I see the published scorecard I'm sorry but I'm really new to BSM. Please help. Thanks in advance. Regards, Kenny Extra info from the support engineer... I also have a series of screen shot ...Show All

• tangy Access and DWGs

  Hi, Is there anyway to display DWG files in MS Access I can get it to show DWFs. Thanks Lewis Per one of our support engineers: Can I know how you display DWFs As I know, DWG is an AutoCAD file type, which is a file type generated by third-party manufacturers (which is out of Microsoft control). Therefore, the built-in controls, e.g. Image control, Bound Object Frame, etc.. cannot render it correctly.   To display DWG file ...Show All

• SonalMS Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?

  In a Excel PivotTable, I want to programically hide or show some PivotItems of a PivotField.  To hide, it works fine (just set mPivotField.PivotItems("xxx").visible = False).  However, to show, it does not work: mPivotField.PivotItems("xxx").visible = True.  Program breaks with an error 1004, macro error. When try to record a macro for setting a non-visible PivotItem to visible, macros recorded is to use ...PivotItem("xxx").visi ...Show All

• Omar.Rojas Overflow problem

  I am getting an overflow problem with this code it is occuring in the line: newgrad = (.Range("C13").Value - Cells(30 + oneD, 2).Value) / (.Range("C12").Value / 2 - .Cells(30 + oneD, 1).Value) My values for the following cells are: C12 = 50 C13 = 1 C17 = 4 C18 = 101 Option Explicit Public ninterval As Single Private Sub CommandButton1_Click() Dim oneD, rbedradius, xinterval, mbedslope, newgra ...Show All

• Anmol ScrollBars for Userforms

  hi, I want to enable scrollbars for the userforms created during design time. I am adding certain no of controls based on an input during runtime to the userform which was created during design time. I want to have the size of the userform fixed and if the controls are more then enable the scrollbars so that we can scroll and view the controls during runtime. Is there any way to do this regards, sk80. ...Show All

• Blipwort Error when update a row using ADO

  Hi Guys. I have a problem. i am using VBA of Excell 2003 and ADO to access rows in a worksheet. When i execute this SQL statement: "UPDATE [Dados Gerais$] SET [Planejamento JUL/06 (P)]=30 WHERE [Grupo do Servico]='ALVENARIA' AND [UnidadedeMedicao]='PISO 11o PAVIMENTO'" , excel return this error: "cannot update '(expression)'; field not updateable" anyone can help me ...Show All

• t4ure4n How to open Access files and export them to Excel

  I need to open multiple Access files and export several colums to Excel. The problem is that the file extension is not a typical access one and that I need to choose a table from several tables for each file. Then I need to merge into one excel document. Any help would be appreciated, thanks. What language What is the file's extenstion and its VB.NET right Do you know much about ADO or ...Show All

• M M Mason fast search

  hi all i have used workspace in msaccess 2000 project in order to get an atomic transaction so it can rollback at any problem the workspace allow me to open the record set for once but i need to open the record set with multiple conditions so what i did i opened a generic record set set rs = db.openRecordset("t1",2,dbseechanges) then i used a filter to determine the conditions dim x as recordset rs.filter ='c = ...Show All

• Greg Jankowski RunTime Error 7 - Out of Memory

  not sure what to make of this or how to fix it - I'm no expert in VBA and I didn't write this code.. just trying to support someone using it. here is the code.. it is failing on the last line of the code with the error: RunTime Error 7 - Out of memory Can ANYONE help or point me in the right direction Dim strMessageBody As String Dim strAttachment As String Dim dtStartDate As Date Dim dtEndDate As Date Dim globalRowCount ...Show All

• John Garland Access/VBA add the value to ListBox every column

  Use a list box to display SSN, Hours, FullName, 3 columns get value from a recordset, List0 is ListBox created in Form of Access. use List0.AddItem myRs(0) & " " & myRs(1) & " " & myRs(2), all records are added into one column, i hope myRs(0) into Fullname, myRs(1) into SSN, myRs(2) into Hours seperately. and add SSN, Hours,FullName to the head for every column of listbox. How to implement it I shou ...Show All

• Lou_b VBA books

  Can anyone direct me to a good book on using and implimenting VBA in MS applications I have been using MS apps for many years but never dug into VBA at all. I have been taking courses preparing me for the MOS certification exams and was introduced to VBA and would like to learn more but can't afford any more instructor led courses. Any help would be greatly appreciated. Thank you Jerry Here's a free ...Show All