Search results

  1. D

    query Multiple parameters, help pls!

    I have this code of a command button, which would allow me to generate the result of the SQL. I think the code is wrong... Can someone help? I guess something wrong with the bracket... strSQL = " SELECT NewsClips.RecordNumber, NewsClips.IssueDate, NewsClips.Title_Eng, NewsClips.Titile_Chi...
  2. D

    If IsNothing - Help Please

    I am working on a query form, which allow users to set filter parameters. The parameters are: KeywordsEN, KeywordsCN, NewsSource, DateFrom, and Date To. If nothing in the field, the filter will skept this filter option. Below is my code, which is adapted from one of early posting (very very...
  3. D

    Filter query results by date range in form

    I have a query form that allows user to search by two criteria (in which, user can select "And" or "Or" clause for the two criteria). I also allow user to filter the results by date range. On the form, I have two command button, one will prompt the results in a query table, and the other will...
  4. D

    Problem with querying date range in query form

    I am working on a query form, in which user can enter three parameters: date range (datefrom field, and dateto field), 1st selection of category (a drop-down menu, multi-selection enhanced), 2nd selection of category (a drop-down menu, multi-selection enhanced. By clicking command button, user...
  5. D

    same criteria for querying two nearly identify tables

    I have two tables, which have same fields. The tables are used for keeping record of news clippings, that are clipped in two different offices. I understand that the best way to manage the database will be combining them into the same table. Yet, it's not an option for the time for some...
  6. D

    union query with List Box

    I want query two tablews with a list box. I have written a code, which work. Pl help! Two tables: Tbl_ResearchLog and Tbl_AdvocacyLog_NY Query Form (with an unbound list box by Category, and an command button leading to a pre-set SQL Query): FormQryCate In the SQL view of the query, the...
  7. D

    populating multi-select items to a text field

    I'm new to access. Hope someone can offer some help! I have created a simple database to better organise some day-to-day office data management. For instance, I have a form (just) to record event attended by staff. The data would then be output as a brief report on overall office activities...
Back
Top Bottom