Recent content by lovedieer

  1. L

    database not working after go to window 7

    You are absolutely right. I forgot to mention i also did this change. Thanks.
  2. L

    database not working after go to window 7

    I think my problem is the database was based on 32 bit system and my new system is 64 bit system. some code do not really supported by the new system. thank you for everybody to give me the response.
  3. L

    database not working after go to window 7

    Re: update solved. database not working after go to window 7 I did several research yesterday, and found some solution, probably it will give a clue when anybody has the issues 1) try to decompile the database with the below steps: (source...
  4. L

    database not working after go to window 7

    Ok. I think i am not clear on my question. I mean the database are working well on window xp and window 8 system, but it's only not working on window 7. Actually my database was developped based on a access 2007 template (projects template), the code has compile error was not written by me, it's...
  5. L

    database not working after go to window 7

    I have a database build with access 2007 with window xp and it works well in my office, it also worked well with window 8 on my home computer. but recently my office computer was updated to window 7 and office 2010, and my database were not working since then. it keep saying there are compile...
  6. L

    Compile error: method or data memember not found

    Thanks. This is very helpful.
  7. L

    Compile error: method or data memember not found

    Thank you very much. it's working now. But I got a new problem, after i change the records in my form, some variable changes can be caputured in my audit trail table, but some cannot be captured. for example, I have two variables, one is txtProjectName, one is RequestDate, the change...
  8. L

    Compile error: method or data memember not found

    I try to make a audittrail function to monitor users edit the records. I used a template in the website and the code is Private Sub ProjectName_BeforeUpdate(Cancel As Integer) WriteAuditUpdate txtTableName, Me.ID, "ProjectName", Me.ProjectName.OldValue, Me.ProjectName.Value End Sub...
  9. L

    attach parameter to table name

    thank you for the post.
  10. L

    attach parameter to table name

    I am trying to set up a create table query using parameter called Year. For each year I input , I need to create a new table with the suffix of the year. for example, if i input year 2011, i want to create a table called budget_2011, if i input year 2012, i want to create a table called...
  11. L

    get information from other columns

    Solved. Thanks.
  12. L

    get information from other columns

    I am working on a Access form which have multiple address column (e.g. participant address, contact address). the participant address and contact address are some time the same. In this case, I want to create a button "Same as above" which auto copy the participant address to contact address...
  13. L

    add a where statement on my code

    I got another question (please forgive my poor knowldge on coding). After the region is updated, only Agency was cascaded in my code. If I also want to cascade several other information which have the same level as agency. How do I modify the code Thanks again.
  14. L

    add a where statement on my code

    Thanks. It's work.
  15. L

    add a where statement on my code

    I am new for VBA code. I copied a cascade listing code from internet and revise to fit my program. If I select a region, then the Agency under that region will show up. I still need an extra where statement : Note = "SC". I tried several time and always get error, can somebody help me add the...
Back
Top Bottom