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

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

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

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

hi, is it possible to have an insert query to fill some of the parameters by select query from other table and rest of the parameters by passing the value. ex: insert into table1(a,b,c) values (10,select b fom table2 where.... , 35); i tried with the above syntax but was unable to...

hai everyone, i have a table with 5 columns (all of them are text) and i need to check that the combination (combined value) of 3 columns does not get repeated. how is this possible aravind.s

hi everyone, i have a query which returns n number of rows. my problem is that i need to display the values in text box which is created automatically according to the number of rows returned in the same page(form). for example if my query returns 1 row then 1...

Hallo everyone, I have a table with one of its column value as "B" or "D" or "E". Now i am in need to display the rows using the select statement with the following conditions. 1. First display the rows with value "D" 2. then display the rows with value "E" 3. then display the...