Recent content by murthyspd

Hi I have a list view on my MS access form. I want to add items to it, but I do not see ListItem property when i type Set LstItem = listview4. Is there any other setting I need to do ? Regards Murthy

Here's the code : Option Explicit Dim rsChangeRequest As ADODB.Recordset Dim strSQL As String ---------------------------------------------------------------------------------------- Private Sub Form_Load() Dim strSQL As String Dim rs As ADODB.Recordset Set rsSharePoint =...

It's global to the module. I have a question though. If I close rsChangeRequest recordset, do I need to Set it again like this : Set rsChangeRequest = New ADODB.Recordset Regards Murthy

Hi I am facing a problem with following code Private Sub cmdMoveNext_Click() rsChangeRequest.MoveNext If rsChangeRequest.EOF Then rsChangeRequest.MoveLast End If end sub It gives a run time error -2147467259 (80004005) on...

Thank you Hi Many thanks to all of you. I tried installing from both VBScroll and microsoft. Both work.

Hi A silly question, but not able to find correct setting. I am not able to use mouse scroll in the Access VBA Editor. Everytime I have to pull the scroll bar up and down to scroll. Is it something to do with settings ?

Thanks for the answer. Suppose I create a query in MS Access for the SQL that I have given, what should be my CommandType ?

Hi, I am passing a parameter to a query in MS Access using. I am doing this way Set rsFetch = New ADODB.Recordset Set cmdDetails = New ADODB.Command With cmdDetails .ActiveConnection = con .CommandType = adCmdText .CommandText = "SELECT...

Hi Listcount will give me the number of items in the list. I wanted count of items selected. So if I select 2 items out of 5, i should get 2 as the result.

Hi, I have written a code in MS access VBA to contact SQL Server which is remote. There is a stored procedure in SQL Server that gets executed. I wanted to create a table in MS Access with the output of this stored procedure. The stored procedure does not create a table. The reason is this ...

Hi I have a ListView control on a MS Access form. I allow users to select multiple rows. Can i get a count of rows selected without having to scan through the list view. Similar to list box ItemsSelected property ?

While saving changes to MS Access VBA, it showed the following error Microsoft Access had detected corruption in this file. To try to repair the corruption, first make a copy of the file. Then try Compact and Repair Database. If you are currently trying to repair this corruption, you will need...

Hi Thanks for the reply. I tried that SQL. It gives OrderNo once, whereas I want the SQL to return OrderNo twice. One for Bill_to = false and second for ship_to = false, ie. if I take count, it should be 2 and not 1.

Hi A table in Access has fields orderNo, bill_to and ship_to in the order. OrderNo is a string and other two fields are Boolean(yes/no). While entering an order, an employee may make mistakes in Bill_to/ship_to or both. His manager, when reviewing, will uncheck the bill_to/Ship_to fields...

By "front end", did you mean, splitting the database ? Will it resolve issues what I mentioned above or do I still need to give reference through all the machines.