Search results

  1. R

    Question Auto run an Excel macro for all files in a folder

    Hi all, I have a a macro in a separate excel file and want it to automatically run on all excel files in a certain folder (c:\temp). As I have so many files that need to be excecuted with the same command, if I have to manually open each file and run the macro, it will be very time consuming...
  2. R

    Question Inserting Picture in Excel

    Hi All, I have a list of picture file names on column A and would like to have a cript to insert all the pictures to the respective rows of column B. ie. A1=c:\pic1 ==> pic1 will be inserted to B1 A2=c:\pic2 ==> pic2 will be inserted to B2 Thank you very much for any advice! Robert
  3. R

    Quota control in a form

    Hi all, May I seek your advice on how to create a summary in a form to show the total number of quota achieved & stop data entry if the quota is fulfilled: Ie. Out of 1000 students in my data base, I just need to interview 150 male student & 110 female student (filed status="done" means...
  4. R

    Import excel to subdata table

    Hi all, I currently have 2 link tables in Access (1/ MAIN table without subdata - all student info ie. name, age, gender... & 2/ CLASS table with subdata - link to MAIN table, these 2 tables came from 1 excel database - Part1). Now I have another list from Excel (identical structure - Part2)...
  5. R

    Search & mark the rest if a member is selected

    Hi all, I'm stuck, appreciate your guidance! I'm doing a project of interviewing Only ONE student in each class of a school. I have a file with the list of all 1000 students (name, gender, email... class) and 10 questions: Q1-Q10. These 1000 students belong to 20 different classes. I don't...
  6. R

    Jump & Block a entry on a field

    Hi listers, I'm very new to Access but assigned to create an entry form with some logics on entry. Would much appreciate if any one could do me a favor to tell me how to: 1/ Jump to a certain field if some other field(s) meet a criteria ie. if age>=45 & sex=2 (female) ==> Jump to Q3 2/ Block...
  7. R

    Validating/ routing entry data

    Dear experts, I'm quite new to Access but find it very interesting to learn more. I used to create data entry in other softwares but now like to use Acesss instead since it has many advantages i.e can be used for web survey. My question is how to create the routing/ jump & how to check the...
Back
Top Bottom