Search results

Hi friends, I have added a listbox on a form to give criteria to the various queries of my database. I have decided to move to a listbox since before I was using a combo but needed the multiselect function since for some queries I wanted to select more that one record at the time. The source...

restricting criteria in queries Thanks for your reply, unfortunatly I cannot remove the criteria from my combo since the same is used for all the queries of my database. The main difference is that I need to save each user's recordset into two different tables using two append queries. One of...

Hi Fiends, I have a form named TOOLS on which I have added a combo box named cboInitials that is used as criteria to a a query named SERSWORK. This query showsup in a field with pecific expression: Field: Initials: [forms]![TOOLS]![cboInitials] In the combo I have stored 10 records that...

Hi Friends, I have a form (frm1) on which I have added three textboxes (txt1,txt2 and txt3) to lookup data from a query named QUERY1. This is a regular query with a Group By function. The field name of my query is named CODES. The Group by function is necessary since my query has three...

Hello, I have form to make searches using text boxes. I click on a command button to run the queries. One of these queries, named query1 uses this criteria: Like "*" & [forms]![frmintercept]![txtinter2] & "*" The result of my query is displayed with a form named frm1. On this form I have added...

Hello, I have form to make searches using text boxes. I click on a command button to run the queries. One of these queries, named query1 uses this criteria: Like "*" & [forms]![frmintercept]![txtinter2] & "*" The result of my query is displayed with a form named frm1. On this form I have added...

Hello, I have form to make searches using text boxes. I click on a command button to run the queries. One of these queries, named query1 uses this criteria: Like "*" & [forms]![frmintercept]![txtinter2] & "*" The result of my query is displayed with a form named frm1. On this form I have added...

Thanks for your help, but I don't think that I will be able to write such a code, it outside my expertise. Is there any change you can help me? Thanks

Hi friends, I am back for help. In my database (MS ACCESS 97) I have a form named frmQueries on to which I have added a TAB CONTROL which has 5 pages. The first page is named ALPHA. On this page I have added various text boxes into which the user can type the criteria to search. To run the...

Hi friends, I am back for help. In my database (MS ACCESS 97) I have a form named frmQueries on to which I have added a TAB CONTROL which has 5 pages. The first page is named ALPHA. On this page I have added various text boxes into which the user can type the criteria to search. To run the...

Hi friends, I am back for help. In my database (MS ACCESS 97) I have a form named frmQueries on to which I have added a TAB CONTROL which has 5 pages. The first page is named ALPHA. On this page I have added various text boxes into which the user can type the criteria to search. To run the...

Thanks, It works! Great Job.

Thanks, I appreciate your help. By the way I still cannot get it working. I will try be be more clear with my explanation. I have a table named FORMS which lists the names of my database's 10 forms. I then have a search form names frmQueries on which I have added a TAB CONTROL. On a page named...

Hi friends, I am creating a MS ACCESS database and would like to be able to open all my forms by using a listbox. I have created a table (named TBLFORMS)in which the are stored all the names of the forms. I have then created a list box (named LSTFORMS)which reads its source from this table. This...

I am designing an Access 97 database to calculate statistical data on monthly basis. I have created a form to add data to a table named TABLE1 In this table there are the following fields: DATE LASTMONTH NEWWORK CLEAREDWORK PENDINGWORK The DATE field is used to add the month for which the...

I am designing an Access 97 database to calculate statistical data on monthly basis. I have created a form to add data to a table named TABLE1 In this table there are the following fields: DATE LASTMONTH NEWWORK CLEAREDWORK PENDINGWORK The DATE field is used to add the month for which the...

Hi I would like to know how to create a combo box which on the OnChange event changes automatically all records. I have a form which is bases on a table named TBL1 with the following fields: DATEOFBIRTH LASTNAME FIRSTNAME I have associated the ComboBox to the field DATEOFBIRTH. Is there a way...

Hi, I am creating a database for my Office used to store data referred to the work we handle every month. It has a statistical purpose. I have created a form (named FORM1)to add data to a table name TABLE1. This table has the following fields (number property): DATE PREVIOUS PENDING NEW CASES...