Answer Questions

• Predator14567 Merry Christmas and Happy New Year

  This is the forum I've maybe spend the most time in, although not so much recently but that can't be helped. To everyone who posts here often enough to know my name, and to anyone else to happens to read this... have a great Christmas and New Year... and even if you don't celebrate them I hope you enjoy the holidays. I am new here and have only posted a few posts, but I do know your names, Derek and ADG, :) because going through this forum is one of the first things I do everyday. Wish everybody have a merry Christmas and a happy New Year! A late merry christmas back to you Derek, and to all the other experts in this forum such as ADG, duckthing etc who have exponentially increased my knowledg ...Show All

• Rups11 List box issues

  I am creating a word template that contains two list boxes. The user will be able to select multiple items and send the items to the other list box via a command button. However when ever I save and close the document and open the same document, the contents of the second list box are empty I have attached the code I have for you all to look at. Thanks for the help in advance. Private Sub Document_New() PopulateListBox 'Clears out second list for a new document lstbox2.Clear End Sub Private Sub Document_Open() PopulateListBoxes End Sub Private Sub cmdMovetoRight_Click() Dim i As Integer If lstbox1.ListIndex = -1 Then Exit Sub For i = lstbox1.ListCount - 1 To 0 Step -1 If lstb ...Show All

• robinjam Empower program software keys

  I recently signed up to the empower program and received the software yesteday. I expect that my membership id has been activated but msdn does not recognise it and so I cannot access the keys to install the software. I have type in my name, email address and membership id and am getting the " The subscription information you have entered is not valid." error message. Has anyone got an idea as to what I might be doing wrong here Can you please help as I would llike to install this software asap and get cracking Thanks First of all, go to http://msdn.microsoft.com/subscriptions, login and click the "Associate your subscription with your Passport" link und ...Show All

• jonam Power-on 1, Start 2, Keep 3

  Does anyone know how to power on 1 computer, automatically start-up all E-net connected systems, while simultaneously controlling, yet keeping all peripherals & applications accesible to clients I don't know what on earth you're talking about but it doesn't sound like a development issue. Can you give some more background and describe the problem you are trying to solve a bit more -Michel ...Show All

• Jamie Wood datagrid control in access

  hello, i am developing an access application using forms and i don't have the datagrid control. i tried downloading msdtagrd.ocx and install it but the control doesn't seem to be working properly. is there a control i can use that has a menual on how exactly i use it (either in the code and on the form). thanks refael If you want to create a datagrid control similar to .NET then create a form that contains the bound fields you want in the datagrid, then you need to set the forms DefaultView to DataSheet, and place it on a form as a sub form. An alternative is to use the list control but this is read only. I don't know of any tutorial. It's only complicated because you've came up with an approach that Acc ...Show All

• Vipul211890 Sort table based on array

  I have table and an array, both have the same length. I want to sort the array and the table based on the array. The array is never seen to the user so I cannot paste it next to the table. I have to deal with the array. Is it possible If so, any ideas on how to do it Any help appreciated! Thanks very much! How do you want to sort them ...Show All

• NetDragonKing converting text to Hours Minutes and Seconds

  have a database which has three fields for Hours Minutes and seconds these are just numbers and have no relation to time. I need in a report,code that will convert the numbers to time and add the seconds to minutes and add the minutes to hours. Thanks Bartley Hi Bartley you can use functions in your report. You can add a user function to a module and use it in reports, queries, forms etc. I suggest you use the example Derek posted converting it to a function which takes three parameters. Then on you report place an unbound field, which you can then use the build option to select your function, and to put in each of your three fileds as parameters. Regards ADG Thanks f ...Show All

• awsiv about macro....

  hi all. if any1 can help me... i hav simple form having 1 command button...on click event of it i hac call 1 function.... the code is as shown below.... *****code******* Function Macro2() On Error GoTo Macro2_Err ' all data DoCmd.TransferSpreadsheet acImport, 8, "tableimport", "D:\hetal\vb\tempxl.xls", True, "" Macro2_Exit: Exit Function Macro2_Err: MsgBox Error$ Resume Macro2_Exit End Function Private Sub cmd1_Click() Call Macro2 End Sub ******* after running and clickin on button.. i m getting error like...." Object required".... so... how to add macro object on form... error is for line... DoCmd.tran... line of above code... plz help me... ...Show All

• Kevin Holand Outputting to a Listbox

  Hi; I have a list of data, and need for values outside a lower and upper bound to be flagged up to the user. I was thinking of outputting to a listbox, but cant get the code to work. I was wondering if anyone had any ideas for possible code, or a better way of outputting to the user. Ryan do you have any code for working out the confidence interval for the mean for a specified alpha My list is in H2:H" & FinalRow & " where FinalRow is defined as FinalRow = Range("A65536").End(xlUp).Row The only problem, my list has empty slots. As in i only want cells with values in to be outputted to the listbox. This will output the cells that contain values. It will also store the ...Show All

• gisgeezer How to change part of an array value in Excel

  Hi , Pls any body can tell me How to change part of an array value .If i try to change array value "Microsoft Excel" popups a dialog stating "You cannot change part of an array." Somebody have mention to use "Ctrl+Shift+Enter" but this will change entire array value.So I need a change a specific cell value. Code: Function parseArrayData(arrayData As String) As Variant parseArrayData = Evaluate(arrayData) End Function Regards, Gnanaprakash Per an Excel expert: You can't. To elaborate, you have to break the array. For instance – if you type: =SUM(IF($A$2:$A$25=D2,$B$2:$B$25)) in a single cell and control shift enter, and then copy the cells down, you can ...Show All

• Bit Bucket Using VBA macro to locate next free column on worksheet

  I need a macro that locates the next free column (i.e. has no data in cells) and then places the cursor in a cell on a designated row. Would like search to start from column B and to place the cursor on row 4 on the free column. <> My VBA code thus far: Function NewColNumber(Range1 As Range) As Integer Dim j As Integer For j = 1 To Range1.Columns.Count If Range1.Columns(j) = "" Then NewColNumber = Range1.Columns(j).Column Exit Function End If Next End Function Sub SaveCOLComments() On Error GoTo Err_Part Dim Range1 As Range Dim intNewColNumber As Integer ' ...Show All

• Ravencraft SaveAs help

  I am trying to write a macro that saves a file with the name of a person. The name of the person is always in the same cell location, Column A. I am currently using this line to do the save: ActiveWorkbook.SaveAs Filename:="O:\Lead Report\temp\" & Sheet.Range("A2") & ".xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False I get the error: "Runtime error (424) - Object Required" I do not know what this means. The Workbook I am trying to save is generated from a drill down into a Pivot table that is then Moved to the new workbook. Any suggestions would be appreciated. Thanks! ...Show All

• Jake.K Password question

  Quick question regarding passwords in VBA I have created a form that requires the user to enter a password. It works fine but I dont want it to display the actual characters that the user is typing, I want it to display bullets. Any suggestions Thanks a lot! if its a text box on a form just set the ipnut mask on the text box to 'password' Thanks a lot for the help and quick response I have a feeling you're going to get a reply from one of the moderators re: VBA... Something along the lines of "This forum is for VB .NET" and pointing you to the VBA forums... If you are actually working in .NET, just set th ...Show All

• Rei Miyasaka finding index in an array

  Hi all, I want to find out which index in the array that corresponds to the maximum value in a array. ff = Application.WorksheetFunction.Max(Hist) finds the value to which I would like to find the index for. Hist is an array containing several thousands of numbers. So I would like to avoid looping through the array to save time. Any ideas out there Grateful for help \Jonas Hi, You don't show the details of the array Hist but if you can use the Max function maybe you can make use of the Match one to. Sub Test() Dim vntMaxValue As Variant Dim lngMaxIndex As Long Dim Hist(1 To 5000) As Double Dim lngIndex As Long For lngIndex = 1 To 5000 Hist(lngIndex) = Rnd() * 10 Cells(lngIndex, 1 ...Show All

• WV John Application.FileSearch in Excel 2007

  There is an issue which I am facing after I installed Office 2007. I had written a small VBA which would search for a file and if found will rename the file. I used Application.FileSearch then. Now I am tying to do it again but unfortunately there is an error prompted stating that 'the object does not exist' Set fSearch = Application.FileSearch defPath = "H:\SourceSafe_1_Feb-28_Feb_2006\SecondSet" Set rg = Range("MyFiles") fSearch.LookIn = defPath I have been frantically looking for changes in the VBA object model especially for Excel but cant seem to find them. please look this niceFine link; it's the most I like in MSDN Scripting Runtime Library FileSystemObject Samp ...Show All