Search results

Thats true. Let me try

This is the code. WHen i select a value in the listbox i need to add it into the table along with other details Tried to send the file itself ,but cant do it Private Sub List203_DblClick(Cancel As Integer) Set rs = New ADODB.Recordset If Me.Text146.Value <> "" Then If Me.List203.Value <>...

Hi, Its a single form and doing data entry through it. I have considered 2 fields to make primary key and checking the whether we entered value for specific fields. Finally adding into Db using ADODB. recordset functions(rs.Addnew). For updation i am not using any code.

Hi, Its a bound form. What i meant is I can add new records to the table and also possible to update data. But i can not see the new records without closing the forms. While closing the forms i am getting the above errors Hope you got my point

Hi, I am updating a simple table directly from the form. I can add or update into the table, but when i close the form i am getting the following messages Msg1 - "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or...

Yes. Thanks for your support.

I'm using access 2003 version. I tried to open the application in shift mode, so that I can access the code. I compiled the application. Afterthat I could debug the application while running.

Thank you Preethi

Dear All, I am tring to debug an existing application that generates some errors. I have marked it for debugging. But when i run the application its not going to the coding window to check the values to variables. Events are generated for the controls & its marked in the property window also...

Dear All, I am debugging an application done by my collegue. It contains a lot of coding also. I opened the application in the design view & try to debug code that generates errors. But its a failure, because its not showing the debugging code while running the form. What may be the...

Thank you pbaldy... It worked fine.. Regards Preethi

Hi All, Wish you all a Happy New Year.... I want to show serial numbers to identify different items to raise a Purchase Order. But I don't know how to show auto numbering in reports. Please help me. Regards Preethi Renjith

Hi, Can please tell me which is that wizard? Is it the Forms wizard? I tried and could not find anything. Regards Preethi

Hi all, Is it possible to create menu with submenu's in Access forms? Regards Preethi

Hi All, I have created a time sheet application for our company. I have kept the Master Database in on of the folders in Server. There is a linked database of the same, which contains all the forms & reports call the "Time sheet". It contains a module with a procedure that allocates the ADODB...

Hi Thanks for your reply... But this is big project. Its already up in the server. The other parts are using ADO. So its difficult for me to change from ADO to DAO. Hope anyone else can help me. Regards Preethi

Hi, I didn't get your idea. If the recordset is showing no items , then what is the use of Recordset.Movefirst Regards Preethi

Hi, Thanks for your quick reply. I have writtern code to set both the recordset(rs) & connection(cn) objects. That doesn't have a problem. Also a lot of records are existing in the database starting with "XSSP". So i put this search option to find out the correct one. If I use the string...

Sorry for sending the same question twice. Actually my pc was showing network error while i send the questions. That's why i resend it. I gave the wildcards in the searchwrd as searchwrd="XSSP*" but it is not working. Regards Preethi

Hi All, I was trying to use the query given below in VBA. But its not working properly. Dim searchwrd As String searchwrd = InputBox("Enter the text to be searched") str = "SELECT * FROM tblPurchaseOrder WHERE YMEOrderRef Like '" & searchwrd & "'" rs.Open str, cn, adOpenDynamic...