Search results

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...

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...

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 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 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...

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...

Hi All, I am trying to create an access application. But I am stuck with some doubts. I have one main form with tab control, a sub form and combo box. Tab control contains 5 tabs. When user select any tab the sub form should populate the records from the table according to the value of the...

Hi All, I want to know solutions for 2,3 doubts. 1) I have some excel files & access table to store the files. I used to link excel files maunally & write a query to change data to a common table. I want to know is it possible to link automatically the excel files & access table ? 2) Is it...

Dear All, I have created a Time Sheet application and I have put the application in our office server. All the employees is able to access the software except one person. In his laptop its showing an error. I took that error as PPT file and sending it an attachment. Please help me to solve...

Dear All, I have created a Time Sheet Application and I have put it in the server. I have used Microsoft Date & Time Picker Control to select date. In some computers they can't see the control because that control is not there in toolbox. Please give me a solution to how to colve the issue...

Hi All, I would like to ask 2 doubts. I have created a Time Sheet Application for my compnay. I have 2 requirements 1) I want to send reminder mail to employees who doesn't create Time Sheet for each month. Is there any tool to connect MS-Access with Microsoft Outlook? 2) I want to put the...

Hi All, I have created an access database using Office 2000. But now I'm using Office 2003 Version. When I tried to create an MDE file its shows error that "Can not Create an MDE file from a database saved in 2000 format. Convert the database to current version". What i have to do? Please...