Recent content by maravinds

Hallo Everyone, I hereby attach a screenshot of one of the forms I have. the problem is that I need to display the current record (for which the subform is opened) to be highlighted or else only that record is seen. I have the data in the datasheet view. any suggestions will be also helpful...

hallo everyone, is there anyway to create a msgbox without OK button i.e., is there any way to display a window to show "data processing..." and then close it after the processing completes. thanks in advance. regards, aravind.s

hallo everyone, is it possible to create a synchronisation conflict? if yes? how?

hallo everyone, i have the following query and i am getting the following output SELECT Sum(tbl_RFQ_Details_AVOB.[AVOB RFQ]) AS [SumOfAVOB RFQ], tbl_Status.Status FROM tbl_Status LEFT JOIN tbl_RFQ_Details_AVOB ON tbl_Status.ID = tbl_RFQ_Details_AVOB.Status GROUP BY tbl_Status.Status...

Hallo Everyone, I have a report which gives the result from the conditions selected from a form. I get the correct result but I need to enhance the quality of the reports. In this case I need to change the report header dynamically. Is there any way to update the report header based on the...

Hallo Everyone, I have a small problem with the AuditTrail functionality. If I use the AuditTrail with the updates as Memotype field the changes are recorded fine. But I have a form based on a query which is the combination of more than 3 tables and as per the requirement i have the...

hai, with the following code when i try to insert the date in the table, the time is inserted and not the date. I have set the RFQ Date field to Short date. Dim db As DAO.Database Dim rs As DAO.Recordset Dim qdef As DAO.QueryDef Dim rs1 As DAO.Recordset Dim ddate As Date Dim strSQL As...

hai, first of all, thanks for the reply but using the TRAILAUDIT() the database size increases rapidly. So in this case i need to store only the changes in a separate file. it will be helpful if i get the alternate solution for this.. aravind.s

Hallo Everyone, I am working with the database that consists of more than 15 tables with more than 50000 records and the problem is that more than 10 people use the database. So in this case I am not sure whether who has the changed the data in it. So for this reason i need to create a...

Hallo Everyone, I have two tables(table1, table2) in the database. Relationship between table1 and table2 is one to many. The problem is that in table1, the primary key (reference to table2 for the relationship) is wrongly defined. now i need to change the primarykey values and by...

Hallo Everyone, I have a table that contains more than 15 columns of data. I need to generate a report for certain columns only. The problem is that the columns that i need differ from time to time. So I need to filter the columns in generating the report. It will be helpful if...

hai Smart, sorry i cannot understand it completely. can you explain a little bit more detail. aravind.s

Hallo Everyone, I have a combobox with the following values in a from Apple Aircraft Baby Ball Cat Zebra ... ... ... Moreover in this combobox i would like to type the letter "A" and after that i must be able to see options starting with A only.(Apple, Aircraft). Is it possible via a...

Hallo Everyone, I have a small problem in query selection. I have a query that selects values based on a criteria. [value from a combobox]. The problem is that i need to select all the rows if the value of the combobox is empty. aravind.s

Hai, thanks!!! that worked for me but there is one more small problem. in the initial stage if both of the combo boxes are empty i need to display all the values and then if any value is selected i need to filter accordingly. so in short the default value of the combobox must be all. How can...