Search results

Dear All On a parameter query I have put three Text box references from a form on three different fields (CUSTOMER, LOT NO, MODEL). I want to have a search facility working like the following sentence CUSTOMER and/or LOT NO and/or MODEL What I have done is that I have put all the...

Thank you very much for your reply. Here is the attached sample databse. Just click on OK on log on dialogue box when opened Have a look and please let me know what can be done. Thanks

Dear All It is a very serious problem for me and I will have to do it somehow, no way around because customer needs to have the report in this format. 1. I have a subreport placed on the footer of main report. 2. Main report is based on a crosstab query which is further based on a select...

In my database I have a table with field name CONCERN CODES, where we put codes for various concerns. I need to create a graph showing only top ten CONCERN CODES. How can I do that? Please help. Thanks

Thank you very much for your reply earlier. I am trying now to follow your advice. I have added the code but on the following statement it prompts as "Compile error, can't find object or liberary". dim qdf1 as dao.querydef As I do not have enough knowledge of VB codes, can you suggest any...

How to avoid such incident in future Now as the problem is sorted I was thinking how could this have happened. I remember yesterday when I closed it down it prompted that some other user has made some changes do you want to override the changed or cancel or there was another option and I...

Thank you Thank you very much for your very quick reply. But thanks God it is been sorted. I went to tools-database utilities-compact and repair database and it worked. I was so worried. Thanks for your suggestion anyway.

Dear All It is really emergency. I have just arrrived in office and found that database is not working. Whenever I try to open a form or report it says 'Invalid argument (error 3001). Can somebody help me out of it. Thanks

Dear All In our database, we have a form based on a query to input data. My question is how can I export the current record data on screen to excel. I already have a command button on screen that exports data to excel but not particularly the one on screen but it is based on a parameter query...

Dear All I am trying to produce a report based on a crosstab query. In the crosstab query I have take a date field as column heading with the format "yyyymm" and couple of fields as row headings. Crosstab query is further based on a select query that has a criteria defined in a field to...

Thanks Thank you very much for your help.

Thank you very much again for your reply. I have tried and it works fine. Now there is another related question. As this data is being exported to one excel file that is linked to another file. The linked file is the one I want to open when I click on command button. As I am very new to...

Thank you very much for your reply. I will try it and come back to you soon. Thanks

Hello All In my database I want certain data to be exported to excel spreadsheet. That spreadsheet is then further linked to another excel file. So basically each time when the query is run new set of data updates in to the linked sheet. I want to use macro for this purpose. I have tried...

A little more advice Thank you very much for your reply. This is all very useful information for me. Just a little more advice please When you say separate local FE for each user does it mean that after splitting process completes, I would ask users to copy FE database from our global network...

Dear All There are 4 users of my database and now I am thinking of splitting it in front end and back end. I am still not 100% sure how would it be beneficial? Can somebody answer my following questions please? 1. In split database, if I want to make any design changes in a form or report...

Sometimes on my database when I press a command button or a hyperlink it gives me error message somewhat similar to this 'This action will start the code in brake mode' It gives options YES Or NO. I click on No and it goes to its destination hyperlink. Not happen very often. Any suggestions...

That was really quick. Thank you. I will try it now. Thanks again.

Dear All I have a form in my database based on a query. To search for particular records on that form I have put a combo box with following event procedure Private Sub Combo245_AfterUpdate() Dim vName As String vName = Combo245 If Not vName = Empty Then PART_NO.SetFocus DoCmd.FindRecord...

I am having same problem Sorry it is not an answer just a comment. I am also having same problem and have put similar question as well. I will also be looking for some suggestions. Best of luck