Search results

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

Hallo Everyone, I have a problem in linking the forms. I have a form called FORM1 and i have 2 comboboxes there. Now I have also a listbox in the same form and in this case I need to update the values in connection with the values that are given in the combo boxes. Can anyone say me how...

hallo everyone, can anyone say what is wrong with the following code. Private Sub add_country_and_supplier_Click() On Error GoTo Err_add_country_and_supplier_Click Dim RFQ_ID As Integer Dim countryid As Integer Dim leader As Integer Dim supplier As Integer Dim decision As Integer Dim curren...

Hallo Everyone, In the following code i extract a column from one table and and i am inserting data to the other value. the two msgbox used display the right value but when i try to insert it via insert query the value is not getting updated. Private Sub Command0_Click() Dim db As...

hallo everyone, i think that no one has understood my question. eg : Table2 has the following rows 1 - 20 2 - 30 3 - 40 then Table1 must have the following rows generated automatically 1 - 10 - 20 1 - 10 - 30 1 - 10 - 40 thanks.

Hallo everyone, I have two tables in the database table1(col1,col3,col2) and table2(col1, col2). First of all i will have to select col2 from database and for each and every value of col2 i need o make an insert query in the table1(..,..,col2). It will be helpful for me if anyone...