Recent Content by apr pillai

  1. apr pillai
    Post

    Signature Links No More Visible to Guests

    I get lot of spam comments on my Website and I can undertstand the gravity of this issue. I remove them without even reviewing. You may take...
    Post by: apr pillai, Oct 24, 2011 in forum: Go4Expert Announcements
  2. apr pillai
    Post

    Multiple Data Entry in Access

    Copy and Paste the following Code into the Form Module with appropriate changes to refer the Controls correctly: Private Sub...
    Post by: apr pillai, Aug 18, 2011 in forum: MS Access
  3. apr pillai
    Post

    Using Subreport to bring in four fields into Main Report

    Both the reports in question copied and modified with the suffix 2. rptCCE Employee Development Report - Directors2 rptDegreeByDirector2...
    Post by: apr pillai, Jun 14, 2011 in forum: MS Access
  4. apr pillai
    Post

    copying data 4m an unbound textbox to field of a table

    The Products appearing on the Sub-Form are related to the Supplier record on the main form. The products value summary is calculated in the...
    Post by: apr pillai, Feb 24, 2011 in forum: MS Access
  5. apr pillai
    Post

    Speeding up an Acces Database

    Access2007: Click the Microsoft Office Button [IMG], point to Manage, and then, under Manage this database, click Compact and Repair Database...
    Post by: apr pillai, Feb 21, 2011 in forum: MS Access
  6. apr pillai
    Post

    Speeding up an Acces Database

    Run Repairing/Compacting untility at least once in a week. Take a Backup of the database before you run the above utility. You must have...
    Post by: apr pillai, Feb 21, 2011 in forum: MS Access
  7. apr pillai
    Post

    Using a Query to split 1 record in to 3 records

    Create a UNION Query with the following sample SQL: SELECT Table1.Field1 FROM Table1 UNION Table1.Field2 FROM Table1 UNION Table1.Field3 FROM Table1
    Post by: apr pillai, Feb 21, 2011 in forum: MS Access
  8. apr pillai
    Post

    query question

    Modify the SQL as given below: SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(POPDATA.CITYNUM) AS COUNT, DCOUNT("*","POPDATA") AS TOTAL...
    Post by: apr pillai, Feb 21, 2011 in forum: MS Access
  9. apr pillai
    Post

    re-auto numbers every year by access

    You may use the following expression to build the yearly changing number: x = "IAZR-" & UCASE(FORMAT(DATE(),"dd-mmm-yy")) &...
    Post by: apr pillai, Feb 21, 2011 in forum: MS Access
  10. apr pillai
    Post

    Copy/Paste from Excel

    Since, your excel file is also linked to the Access database you may use and Append Query, using Excel Table as source and the Access Table as...
    Post by: apr pillai, Feb 21, 2011 in forum: MS Access
  11. apr pillai
    Post

    Module that caculates the difference between times

    Open the Form in Design View Click on the [End Time] Field Click on the Property Sheet icon on the Toolbar to display the Property Sheet of the...
    Post by: apr pillai, Dec 19, 2010 in forum: MS Access
  12. apr pillai
    Post

    Day function to remove weekend dates?

    Correction: ? WeekDay(Cdate("18/12/2010"))
    Post by: apr pillai, Dec 18, 2010 in forum: MS Access
  13. apr pillai
    Post

    Day function to remove weekend dates?

    Use the WeekDay() Function to find out the weekend day. ? WeekDate(Cdate("18/12/2010") Result: 7 if the result is seven then it is weekend day....
    Post by: apr pillai, Dec 18, 2010 in forum: MS Access
  14. apr pillai
    Post

    Read memo field from database ( MS-Access)

    The sample VBA Code below reads and prints (in the Debug window) the contents of a Memo Field (Notes) from the Employees Table of MS-Access sample...
    Post by: apr pillai, Dec 18, 2010 in forum: MS Access
  15. apr pillai
    Post

    Archaeological database - Need help with update query: Replace__with___where____=____

    Re: Archaeological database - Need help with update query: Replace__with___where____= Instead of running an Update Query every time when you find...
    Post by: apr pillai, Dec 17, 2010 in forum: MS Access
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice