Recent content by lovedieer

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

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.

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...

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...

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...

Thanks. This is very helpful.

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...

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...

thank you for the post.

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...

Solved. Thanks.

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...

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.

Thanks. It's work.

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...