Search results

  1. T

    Need Help on VBA code

    Hi, I am a novice in access. I would like to a.)import data from an excel worksheet which the file named is not fixed but the file directory is.(c:\import) b.) After importing the file to a temp table named "Sheet 1". I want to append into the main Table " Table MAIN" and then I will...
  2. T

    Display combo box search in a subform

    Hi , I am a novice in access. I had a form which allows the user to do search based on the combo box which when the user click the a search button , it will link to a query which will capture what the user had selected from the combo box earlier. I wanted the query search to be display in...
  3. T

    Using DCOUNT Function

    Hi, I wanted to generate a report counting the no of orders that was sent by Truck no 5.The truck no source comes from a combo box. Combo Box list Delivery Date Truck 5 01/02/2010 Truck 6 01/03/2010 Truck 5 22/02/2010 Truck 7...
  4. T

    How to print a lengthy memo field in form view

    Hi, I am a beginner access user. I have a memo field which the data is very lengthy. When I tried to print from the form view. It also shows me whatever that the computer screen can captured. Is there any methods or functions that I can print this memo field from the form or I can only print...
  5. T

    Display date in Monthname format on the report Header

    Hi, I would like to ask whether how should I change a date entry to be display on the report header of name of the month. Eg: I am prompt to enter date range between 01/05 and 31/08 The header will appear Invoices submitted between May and Aug 2010. Thanks
  6. T

    Highlighting certain words in a form

    Hi, I was wondering is that anyway to highlight certain names (Eg: Searching the field memo for names starting with "LIM") in a memo field in a form and pasteing the highlight names to another form or table. Thanks.
  7. T

    Input mask in a report

    Hi, I have a field which has input mask but when I print preview in a report. Its does not appear the whole field.
Back
Top Bottom