Search results

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 Mr.Boblarson Thank you for your reply. It worked successfully. Thanks & Regards Preethi

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

Thanks Thanks It worked. As I'm new to Access I didn't check for that option. Regards Preethi

Thanks for the fast reply. In my office all the PC's are updated to 2003 version. So to get a 2000 version is difficult. So what i'll do? Regards Preethi

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