Search results

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.

Hi I am using MS ListView SP2. While designing the application, I did it in my local drive. Since it is multi-user application, I have put it in a shared folder. The issue that it gives an error that there was an error loading ActiveX control on your form. Has it to do with reference? Do I...

Here is the code. cmbOP is a combo box from where an employee is chosen. Private Sub cmbOP_click() Set rsGetTarget = New ADODB.Recordset If cmbOP.Text <> "" Then ' rs.Open "SELECT * FROM tblEmployeeDetails WHERE Name='" & cmbOP.Text & "'", con, adOpenKeyset, adLockPessimistic...

I am using ADODB for assigining. There is no particular reason for not using bound control. Just wanted to use ADODB.

Hi The text box is unbound.

Hi I am assigning a value from a table to text box on the form through VBA. It gives the following error : Run time error 2115 The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing MS Access from saving the data in the field. I have no...