Search results

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

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

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

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

I have 25 different backend data from different states for a survey data and each state have exactly the same data structure. The only thing is their primary key ( surveycode ) is 11000xxxxx, 12000xxxxx , 13000xxxxx....25000xxxxx for different state. I want to comebine these 25 backend in one...

I am working on a database with survey question. The form include main form with demographich info and a subform with survey questions. My logic is : for all questions, the default answer is Yes, it can be changed to No or Null. However, if you change a question with No answer, you cannot go...

I have a search form (continue) contain basic information which allow people to filter to a specific record. I have another data entry form (single form) has all the detailed information. These two forms have the same data source. the PK for the table is ParticipantID I add a macro (I do not...

I Made a form with one button to open an another form, however, when I click the blank space close to the button, it also open that form. I remember there's some idea to control this and I did it before, but I just forget how to do it.

I have a query which included person's ID, name, DOB, and the answer (Yes/No/Null) for a question. I want to count the Yes Number , Total Number of Respond, and the percentage (Yes Number/ Total Reponded number), How can I do it. Thanks.

I am working on a survey database. I build three tables: Demographic, Questions and Response. As their name, the demographic include all indiviudal's personal information, the question table include 20 survey questions, and Response table include the responses, comments and other information...

I am totally a first time user for Access. I need to build a review database for several nursing homes. Project description: My company will do review for persons live in nursing home. The data review manager need to enter each person's Demographic information such as: Name, ssn, address...