Search results

Thank You soooooo much! its works perfectly :D just for learning purposes, if I were to change the condition such that the startdate should not be null, how would I do that?

hey thanks for ur help. I read the link and changed the code accordingly as such: Private Sub InstallationFax_Click() Dim strReportName As String Dim strCriteria As String Dim LDate As String LDate = Format(Date, "dd-mmm-yy") strReportName = "E1CableFax" strCriteria = "[SiteID]='"...

SiteID is of text datatype and StartDate is of date/time datatype. what do u mean that they require delimiters?

Hello! I have a search form where user can search for details about a site. The site details would be displayed in a sub form. I have a button which would open up a report containing some of the details abt the site. I am facing a small problem here. The form has 2 conditions to make. One is...

Hey sorry for the late reply. Thanks I get a clearer picture now. It really helped! :D

Hey thanks for ur reply. I finally managed to get smthg. This is my updated code: Private Sub DisplayDrawing_Click() Dim fso Dim folder As String folder = "d:\Autocad\" & Combo31.Value Set fso = CreateObject("Scripting.FileSystemObject") If fso.FolderExists(folder) Then 'MsgBox folder & "...

Hi, I have search form. When I click on a button for a particular productID that I had searched earlier, the folder containing more details abt the product will open up. The code is such: Private Sub DisplayDrawing_Click() DisplayDrawing.HyperlinkAddress = "d:\Autocad\" & Combo31.Value End...

sorry actually its not opening images.. its more like opening multiple pdf files. is this possible?

Hello. I am currently working on a project involving access 2002. I have a search form. I need to put a button on the search form such that when the user clicks on that button a image will be displayed. These images can actually be found in the D drive of the computer. The user can only search...

Thank u very much for ur help. It helped!:)

Hello everyone.I have search form that is created based on a query. The query has 2 tables called maintable and info of contacts. In the search form when i search for products, it will say who is the contact person for that product is. I have designed it in such a way that I would allow the user...

Hey! Thanks for ur reply and help! really appreciate it

Hello.I have a search form.It contains a subform which will display all the details of the product that the user will be searching. I am using a combo box for the user to enter the product they have to search. However, when I want just the record that is displayed, it does not simple print that...

Hey! Thanks for ur reply. Ya I agree with u on that part. I can just simply just use one file. I plan to change that part later when the rest of the code is working properly. The main problem now is that the data does not transfer to the excel spreadsheet and shows me an error 'Object required'...

Hey! Thanks for all your help. I really appreciate it. However, I am still facing a problem. Now only part of the code works. It works until Recon is deleted. However, it says that object is required. I have just pasted my edited code below. Private Sub Command22_Click() On Error GoTo...

Hey really thanks for ur help! the link u provided helped me understand loads!! Thanks!! However I m still getting error in my code. Public Function ExportToPreformattedExcelworkbook() Dim dbsNorthwind As DAO.Database Dim rstProducts As DAO.Recordset Set dbsNorthwind = CurrentDb Set...

Hello! Thank you for replying me. I tried using the code that u sent me. However, I realised that I need a recordset in order to populate the workbook, but I am using just a query! Does that mean I have to create a recordset first? Can I just use query to populate the workbook? Sorry I m rather...

Hey I tried the method u said. It works. However, I still need some more clarification. The query is used to generate monthly reports. Therefore I export the query every month into excel. The excel sheet is saved by the month's name. Thus, if I were to follow ur method, then this is not...

Hi, Thanks for ur reply once again. I have tried as what you suggested. However, the link table does not get updated even though I run the update query. Moreover, I am not able to open my preformatted excel file also. Do you have any idea of what I might be doing wrong? Is there an more...

Hey thanks for replying me. I would like the follow the suggestion that you gave which is to link a preformmatted Excel document into Access and update it rather than using the query export. Would you be able to explain how I would be able to do it? Sorry I do not know how to do this. Thanks :)